exp and imp is not fully supported in oracle 11g, try to use expdp and impdp
just an example is
"Deferred segment creation in oracle 11g is the "exp" utility doesn't
support it properly. Tables with no segments don't get exported as
expected. One solution is to turn off the functionality before creating
any objects using the following command.
ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;
Alternatively, you can force the allocation of extents on any table with no rows using the following command.
ALTER TABLE tablename ALLOCATE EXTENT;
workaround or live example
==========================
SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 26 13:02:41 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL>
SQL> $exp system/system@orcl_3 file='d:/scott.dmp'
tables=scott.emp,scott.dept,scott.bonus
Export: Release 11.2.0.1.0 - Production on Wed Dec 26 13:03:44 2012
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 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
About to export specified tables via Conventional Path ...
Current user changed to SCOTT
. . exporting table EMP 14 rows
exported
. . exporting table DEPT 4 rows
exported
EXP-00011: SCOTT.BONUS does not exist
Export terminated successfully with warnings.
SQL>
SQL>
SQL>
SQL> conn scott/tiger@orcl_3
Connected.
SQL>
SQL>
SQL>
SQL>
SQL> ALTER TABLE bonus ALLOCATE EXTENT;
Table altered.
SQL>
SQL>
SQL>
SQL> $exp system/system@orcl_3 file='d:/scott.dmp'
tables=scott.emp,scott.dept,scott.bonus
Export: Release 11.2.0.1.0 - Production on Wed Dec 26 13:10:06 2012
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 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
About to export specified tables via Conventional Path ...
Current user changed to SCOTT
. . exporting table EMP 14 rows
exported
. . exporting table DEPT 4 rows
exported
. . exporting table BONUS 0 rows
exported
Export terminated successfully without warnings.
SQL>
No comments:
Post a Comment