Another Oracle blog

  • Home
  • About
  • About

Tag Archives: session_transform

Home / Posts Tagged: session_transform

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