当前位置:操作系统 > Unix/Linux >>

与exp导出有关的错误

与exp导出有关的错误
 
今天在用exp导出库中的数据时,遇到一些问题,特记录之。
[sql] 
$ exp system/oracle owner=system file=/oracle/full.dmp statistics=estimate  
  
Export: Release 10.2.0.5.0 - Production on Sun Apr 28 12:46:16 2013  
  
Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
  
  
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
Export done in US7ASCII character set and AL16UTF16 NCHAR character set  
server uses ZHS16GBK character set (possible charset conversion)  
  
About to export specified users ...  
. exporting pre-schema procedural objects and actions  
. exporting foreign function library names for user SYSTEM   
. exporting PUBLIC type synonyms  
. exporting private type synonyms  
. exporting object type definitions for user SYSTEM   
About to export SYSTEM's objects ...  
. exporting database links  
. exporting sequence numbers  
. exporting cluster definitions  
EXP-00056: ORACLE error 1157 encountered  
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file  
 
以上问题一般是因为数据库丢失临时表空间,或临时表空间太小。解决办法是增加临时表空间或增大临时表空间数据文件的大小。
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,