Oracle Adventures

  • Home
  • About
  • Privacy Policy
  • About
  • Privacy Policy

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: SYS@TEST> create table test (id number, ddate date); Table created. Elapsed: 00:00:00.02 SYS@TEST> select dbms_metadata.get_ddl(‘TABLE’,’TEST’) FROM…

Read More

22/06/2016mardaffImport&Export, Oracledbms_metadata, get_ddl, session_transform, STORAGE
ora-base.com
Cleantalk Pixel