SQL> spool e:\aa.sql Started spooling to e:\aa.sqlSQL> set head off; SQL> select * from a; 1 a 2 ba 3 ca 4 daSQL> spool off; Stopped spooling to e:\aa.sqlSQL> 查看aa.sql,其实就是文本信息可以使用sqlldr倒入数据库
SQL> spool c:\a.sqlSQL> select * from a;SQL> spool off;
C:\Documents and Settings\Administrator.LSP>exp jsuninet/jsuninet@ora8 file=abc. dmp log =abc.log tables="TCMMBCFG"Export: Release 9.2.0.1.0 - Production on 星期三 3月 24 18:13:50 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production EXP-00056: 遇到 ORACLE 错误 942 ORA-00942: table or view does not exist EXP-00000: 导出终止失败C:\Documents and Settings\Administrator.LSP>
Started spooling to e:\aa.sqlSQL> set head off;
SQL> select * from a;
1 a
2 ba
3 ca
4 daSQL> spool off;
Stopped spooling to e:\aa.sqlSQL>
查看aa.sql,其实就是文本信息可以使用sqlldr倒入数据库
第二问不太明白
cat out.dat|egrep -v SQL > out.sql
就可以了。
dmp log =abc.log tables="TCMMBCFG"Export: Release 9.2.0.1.0 - Production on 星期三 3月 24 18:13:50 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
EXP-00056: 遇到 ORACLE 错误 942
ORA-00942: table or view does not exist
EXP-00000: 导出终止失败C:\Documents and Settings\Administrator.LSP>