Another Oracle blog

  • Home
  • About
  • About

Tag Archives: dbms_metadata

Home / Posts Tagged: dbms_metadata

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…

Read More

June 22, 2016mardaffImport&Export, Oracledbms_metadata, get_ddl, session_transform, STORAGE
ora-base.com