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
Archives
Blogroll
- amon – great performance tool for oracle databases, only putty session needed
- arepto cli-tool to analyze performance details about SQL cursors great tool to collect informations and diagnostics on sql statements
- dominic giles – tools collection
- Oracle DB/EM Troubleshooting
- Oracle optimizer blog
- otn – dba community – GERMAN
- Richard Foote
- unix commands collection of commands for unix/linux OS
Stats
- 13,251 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.