Extract DDL without some parameters
This is something useful, especially for moving data between systems with very different storage configuration, or if you just want to have smaller output for your DDL command. Below you’ll find some examples that I was able to find: [email protected]> create table test (id number, ddate date); Table created. Elapsed: 00:00:00.02 [email protected]> select dbms_metadata.get_ddl(‘TABLE’,’TEST’) FROM…
