hello experts,
EXP-00011: SCOTT.BONUS does not exist
as we know that scott always have 4 tables, but bonus is created as empty, so
C:\Users\Neetesh>exp system/Testdb@testdb file='d:/scott.dmp' tables=scott.emp,scott.dept,scott.bonus
Export: Release 11.2.0.1.0 - Production on Wed Oct 10 16:16:31 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.
C:\Users\Neetesh>
and i have set
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 10 16:14:09 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys@testdb as sysdba
Enter password:
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
SQL> show parameter deferred
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE
SQL> alter system set deferred_segment_creation=false;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL> conn sys@testdb as sysdba
Enter password:
Connected.
SQL> show parameter deferred
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean FALSE
SQL>
and then again raising the error after restarting the database.
C:\Users\Neetesh>exp system/Testdb@testdb file='d:/scott.dmp' tables=scott.emp,s
cott.dept,scott.bonus
Export: Release 11.2.0.1.0 - Production on Wed Oct 10 16:17:37 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.
then what should be done now....
] 
Blog
Search
Help
Members
Register
Login
Home
