Archive
Posts Tagged ‘get ddl’
Generate DDL commands of existing objects
With dbms_metadata it’s easy to generate DDL commands of existing objects.
TABLES
SET LONG 20000 PAGESIZE 0 HEADING off select dbms_metadata.get_ddl('TABLE','EMP','SCOTT') from dual;
Rate this:
Categories: administration
Tags: dbms_metadata, get ddl
mygraeff.com
Join 3 other subscribers
11.2
10046
10053
ADR
AWR
baseline
clone
dbms_metadata
dbms_redefinition
duplicate
execution plan
get ddl
image
init.ora
instance caging
make
monitor
online
optimizer
option
oracle_home
rebuild index
runInstaller
stored_outline
trace
Archives
Blogroll
Stats
- 17,538 hits
Top Posts & Pages
CAUTION
use all of the scripts first on your test environment !
NEVER EVER USES THEM UNTESTED ON YOUR PRODUCTION ENVIRONMENT !!!
Some of the mentioned features require an extra licenceable option.