1. DBMS_METADATA
This example extracts DDLs of every table and index from scott, run it in sqlplus:
set pagesize 0 ---Does not display column names.
set long 90000 ---9000 bytes of cache in local machine for LONG datatype
set feedback off --Does not display messages like "PL/SQL procedure successfully completed"
set echo off --START command does not list each command in a script. as --the command is executed.
spool scott_schema.sql --Spool to a file
connect scott/tiger@orcl; --Connecting as scott
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_TABLES u;
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name) FROM USER_INDEXES u;
spool off; --Turn off spool来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/638844/viewspace-768902/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/638844/viewspace-768902/