如何用SQLPLUS導出建表的腳本?
spool 你想要導入的目錄/schema.sql
conn user/password;
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_TABLES u;
spool off;
如何用SQLPLUS導出建表的腳本?
spool 你想要導入的目錄/schema.sql
conn user/password;
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_TABLES u;
spool off;