so I am trying to create a copy of a table using dbms_metadata
. I know you can get the DDL of a table by executing DBMS_METADATA.get_DDL('Table','TABLENAME')
so my question now is how can I use this to create a new identical table?
I know you can easily create a copy of a table with create table t1 select * from table2;
etc. So how can I make use of dbms_metadata to create a new identical table? Any advice would be greatly appreciated. Thanks!
Aucun commentaire:
Enregistrer un commentaire