C:\>exp businessdata/businessdata file=dropcol.dmp tables=ACSTRULE,ARREARSCFG,ARREARS_REPORT_ACCT,CREATE_INVOICE_ACTION,FINANCIAL_ACCOUNT,FINANCIAL_ACCOUNT_HIS,INVOICE,INVOICE_HISTORY,LIST_FEE_AMOUNT_PER_DUNNING,RULCOCAP,STEVREAC
Export: Release 11.2.0.1.0 - Production on Mon Dec 5 19:59:39 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table ACSTRULE 1 rows exported
. . exporting table ARREARSCFG 2 rows exported
EXP-00011: BUSINESSDATA.ARREARS_REPORT_ACCT does not exist
. . exporting table CREATE_INVOICE_ACTION 2 rows exported
. . exporting table FINANCIAL_ACCOUNT 14639 rows exported
. . exporting table FINANCIAL_ACCOUNT_HIS 14718 rows exported
. . exporting table INVOICE 11526 rows exported
. . exporting table INVOICE_HISTORY 5 rows exported
EXP-00011: BUSINESSDATA.LIST_FEE_AMOUNT_PER_DUNNING does not exist
. . exporting table RULCOCAP 1 rows exported
EXP-00011: BUSINESSDATA.STEVREAC does not exist
Export terminated successfully with warnings.
奇怪,查了半天表名也没写错。
怎么就出EXP-00011错误了呢?
在网上查了一下,原来是:
SQL> show parameter DEFERRED_SEGMENT_CREATION
NAME TYPE VALUE
------------------------------------ -------------------- --------------------
deferred_segment_creation boolean TRUE
参数的问题。
因为表里没有记录,所以没有段空间的记录,可以手工分配一个空间给这些表:
SQL> alter table BUSINESSDATA.STEVREAC allocate extent(size 64k);
Table altered.
SQL> alter table BUSINESSDATA.ARREARS_REPORT_ACCT allocate extent(size 64k);
Table altered.
SQL> alter table BUSINESSDATA.LIST_FEE_AMOUNT_PER_DUNNING allocate extent(size
64k);
Table altered.
再执行导出就可以了。
About to export specified tables via Conventional Path ...
. . exporting table ACSTRULE 1 rows exported
. . exporting table ARREARSCFG 2 rows exported
. . exporting table ARREARS_REPORT_ACCT 0 rows exported
. . exporting table CREATE_INVOICE_ACTION 2 rows exported
. . exporting table FINANCIAL_ACCOUNT 14639 rows exported
. . exporting table FINANCIAL_ACCOUNT_HIS 14718 rows exported
. . exporting table INVOICE 11526 rows exported
. . exporting table INVOICE_HISTORY 5 rows exported
. . exporting table LIST_FEE_AMOUNT_PER_DUNNING 0 rows exported
. . exporting table RULCOCAP 1 rows exported
. . exporting table STEVREAC 0 rows exported
Export terminated successfully without warnings.
分享到:
相关推荐
执行EXP导出时,部分表提示 EXP-00011:表不存在错误,但是查询user_all_tables视图,此表确实是存在的,并且执行select语句也能成功,不过表为空表,查看权限等也没有问题。后来通过查询资料,发现问题是由Deferred ...
oracle 11g R2 新增的特性,exp无法导出空表,可以通过expdp命令导出,具体在附件里。
oracle数据导出身份证明-用户名和口令-错误的解决方法
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
在Linux上安装oracle数据库,... 在oracle linux 6_64bit上,提供了oracle-rdbms-server-11gR2-preinstall包,可以自动化的将需要安装的rpm包,需要调整的内核参数自动化的处理,对DBA安装数据库确实节省了不少的时间。
rhel 6中搭建oracle 11gr2 rac环境。
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册
Oracle11gR2官网下载地址,Oracle11gR2
Oracle11g使用exp导出空表,解决备份无法导出空表的问题
ORACLE9i exp遇见EXP-00008 ORA-00942 EXP-00024错误的解决方法,详细描述了问题处理的过程和步骤,共享在此,希望能有所帮助
Oracle11gR2 (p10404530_112030_Linux-x86-64_7of7.zip) Oracle11gR2 (p10404530_112030_Linux-x86-64_6of7.zip) Oracle11gR2 (p10404530_112030_Linux-x86-64_5of7.zip) Oracle11gR2 (p10404530_112030_Linux-...
Oracle11gR2 CentOS7 静默安装,开机自启动,等等
oracle linux 6.4上安装部署 oracle RAC 11G R2,oracle linux上安装oracle是最简便的。
Linux oracle 11gR2安装数目及依赖包,分享给大家。Linux oracle 11gR2依赖包全套
oracle linux 11gR2 x86-64 instant client with sqplus sqlldr imp exp
oracle11g默认对空表不分配segment,故使用exp导出Oracle11g数据库时,空表不会导出。此资源提供将空表导出的的两种方法。
Oracle11gR2 (p10404530_112030_Linux-x86-64_2of7.zip)文件分割成 2个压缩包: https://download.csdn.net/download/weixin_43800734/72501554 https://download.csdn.net/download/weixin_43800734/72510520 ...
oracle11g的bin包,包含exp.exe和IMP.EXE.exp.exe文件,可用于plsql导入导出
oracle11gr2版本 jdbc驱动