SQL>set heading off SQL>set feedback off SQL>set echo off SQL>spool c:\temp.sql --把相应的用户名加上去 SQL>select 'create table ' || table_name || 'as select * from '|| table_name || ';' SQL>spool off SQL>set heading on SQL>set feedback on SQL>set echo on SQL>startup c:\temp.sql
SQL>set heading off SQL>set feedback off SQL>set echo off SQL>spool c:\temp.sql SQL>select 'create table ' || table_name || 'as select * from '|| table_name || ';' from user_tables;--把相应的用户名加上去 SQL>spool off SQL>set heading on SQL>set feedback on SQL>set echo on SQL>startup c:\temp.sql
SQL>set feedback off
SQL>set echo off
SQL>spool c:\temp.sql
--把相应的用户名加上去
SQL>select 'create table ' || table_name || 'as select * from '|| table_name || ';'
SQL>spool off
SQL>set heading on
SQL>set feedback on
SQL>set echo on
SQL>startup c:\temp.sql
SQL>set heading off
SQL>set feedback off
SQL>set echo off
SQL>spool c:\temp.sql
SQL>select 'create table ' || table_name || 'as select * from '|| table_name || ';' from user_tables;--把相应的用户名加上去
SQL>spool off
SQL>set heading on
SQL>set feedback on
SQL>set echo on
SQL>startup c:\temp.sql