DDL Extract for tables
DDL Extract for tables
ALL Tables from user
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool export_tables_ddl.sql
select dbms_metadata.get_ddl(‘TABLE’,table_name,’TESTUSER’) from user_tables;
spool off
*table_name — Don’t mention anything
A table
select dbms_metadata.get_ddl(‘TABLE’,’EMPLOYEE’) from dual
*EMPLOYEE – table name
Advertisements
No comments yet
