Script to regenarate or reverse engineer the Schema - so that you get the scripts to re create these objects
set pagesize 0
set long 90000
set feedback off
set echo off
Define ownernm='&owner'
accept pwd prompt "Enter Password for user &ownernm : " hide
spool schema.sql
connect &ownernm/&pwd
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;
SELECT DBMS_METADATA.GET_DDL('VIEW',u.view_name)
FROM USER_VIEWS u;
spool off;
set long 90000
set feedback off
set echo off
Define ownernm='&owner'
accept pwd prompt "Enter Password for user &ownernm : " hide
spool schema.sql
connect &ownernm/&pwd
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;
SELECT DBMS_METADATA.GET_DDL('VIEW',u.view_name)
FROM USER_VIEWS u;
spool off;
Comments