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
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
- 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
- 16,539 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.