导出数据库时的报错日志:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user YPST_SCM_DEV
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user YPST_SCM_DEV
About to export YPST_SCM_DEV's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export YPST_SCM_DEV's tables via Conventional Path ...
. . exporting table AF_JOB 8 rows exported
. . exporting table AF_JOB_PARAM 45 rows exported
. . exporting table AF_TIMER_DEFINE 8 rows exported
. . exporting table AF_TIMER_LOG 0 rows exported
. . exporting table CD_BILL_NO_RULE 272 rows exported
. . exporting table CD_COLOR_CONTROL 0 rows exported
. . exporting table CD_WH_QC_ITEM_DETAIL
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table CD_WH_QC_ITEM_HEADER
EXP-00003: no storage definition found for segment(0, 0)
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EB_CURRENCY
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EB_CUSTOMER
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EB_FEE_HEAD
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EF_BILL
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EF_ORDER_FEE
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EF_RECEIVE_BILL
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_EF_WRITEOFF_DETAIL
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_ES_DEPARTMENT
EXP-00003: no storage definition found for segment(0, 0)
. . exporting table EDI_ES_USER
EXP-00003: no storage definition found for segment(0, 0)
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
数据库的版本:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE11.2.0.3.0Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
原因:
11G中有个新特性,当表无数据时,不分配segment,以节省空间。导致在用EXP 导出时,空表不能导出。
解决方法:
set heading off;
set echo off;
set feedback off;
set termout on;
spool D:\allocate.sql;
Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
spool off;
--执行D:\allocate.sql,命令如下:
@ D:\allocate.sql;
PS:本人是菜鸟,有错误误导新人的话,还望大神指正。