Home » RDBMS Server » Server Utilities » EXP-00011: SCOTT.BONUS does not exist
EXP-00011: SCOTT.BONUS does not exist [message #568239] Wed, 10 October 2012 05:48 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
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....
Re: EXP-00011: SCOTT.BONUS does not exist [message #568244 is a reply to message #568239] Wed, 10 October 2012 06:04 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
select  table_name, segment_created from user_tables where table_name='BONUS' 


See Metalink ID 1178343.1
Original Export Raises EXP-11 Table Does Not Exist or Table is Ignored [ID 960216.1]

http://oracletube.wordpress.com/2011/01/20/oracle-11gr2-exp-00011-occurs-even-object-exist-in-schema/


Sriram Sanka

Edit:Removed owner column from the command!

[Updated on: Wed, 10 October 2012 06:29]

Report message to a moderator

Re: EXP-00011: SCOTT.BONUS does not exist [message #568250 is a reply to message #568244] Wed, 10 October 2012 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And to avoid this problem, use Data Pump instead of the old exp tool.

Regards
Michel
Re: EXP-00011: SCOTT.BONUS does not exist [message #568252 is a reply to message #568244] Wed, 10 October 2012 06:26 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your kind reply,

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> select owner, table_name, segment_created from user_tables where table_name
='BONUS';
select owner, table_name, segment_created from user_tables where table_name='BON
US'
       *
ERROR at line 1:
ORA-00904: "OWNER": invalid identifier


SQL> select * from user_tables where table_name='BONUS';

no rows selected

SQL> conn scott/tiger@testdb
Connected.


SQL> set line 150
SQL> select * from user_tables where table_name='BONUS';

TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME
             IOT_NAME                       STATUS     PCT_FREE
------------------------------ ------------------------------ ------------------
------------ ------------------------------ -------- ----------
  PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTE
NTS PCT_INCREASE  FREELISTS FREELIST_GROUPS LOG B   NUM_ROWS
---------- ---------- ---------- -------------- ----------- ----------- --------
--- ------------ ---------- --------------- --- - ----------
    BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLO
CKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO
---------- ------------ ---------- ---------- ----------- ----------------------
--- ------------------- ---------- ---------- ----- --------
SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ FLASH_C CELL_FL ROW_MOVE
GLO USE DURATION        SKIP_COR MON CLUSTER_OWNER
----------- --------- --- ------------ - - --- ------- ------- ------- --------
--- --- --------------- -------- --- ------------------------------
DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
-------- -------- ------------ --- --- --- -------
BONUS                          USERS
                                            VALID            10
                    1        255
                                            YES N          0
         0            0          0          0           0
  0                   0          1          1     N ENABLED

TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME
             IOT_NAME                       STATUS     PCT_FREE
------------------------------ ------------------------------ ------------------
------------ ------------------------------ -------- ----------
  PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTE
NTS PCT_INCREASE  FREELISTS FREELIST_GROUPS LOG B   NUM_ROWS
---------- ---------- ---------- -------------- ----------- ----------- --------
--- ------------ ---------- --------------- --- - ----------
    BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLO
CKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO
---------- ------------ ---------- ---------- ----------- ----------------------
--- ------------------- ---------- ---------- ----- --------
SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ FLASH_C CELL_FL ROW_MOVE
GLO USE DURATION        SKIP_COR MON CLUSTER_OWNER
----------- --------- --- ------------ - - --- ------- ------- ------- --------
--- --- --------------- -------- --- ------------------------------
DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
-------- -------- ------------ --- --- --- -------
          0 09-OCT-12 NO               N N NO  DEFAULT DEFAULT DEFAULT DISABLED
YES NO                  DISABLED YES
DISABLED DISABLED              NO  NO  NO  DEFAULT


SQL>


thanks.....
Re: EXP-00011: SCOTT.BONUS does not exist [message #568253 is a reply to message #568252] Wed, 10 October 2012 06:33 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Read the Documents provided. and also Use Expdp not exp.It is not supported with V 11.

Sriram Sanka
Re: EXP-00011: SCOTT.BONUS does not exist [message #568281 is a reply to message #568253] Wed, 10 October 2012 08:43 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
is there any way for exp?

and what is the use to set :-

sql>alter system set deferred_segment_creation=false;

thanks.....
Re: EXP-00011: SCOTT.BONUS does not exist [message #568284 is a reply to message #568281] Wed, 10 October 2012 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It will work ONLY for new tables not for the current ones.
For these one you can use ALTER TABLE SEGMENT CREATION IMMEDIATE and ALTER TABLE ALLOCATE EXTENT.

Regards
Michel

[Updated on: Wed, 10 October 2012 08:55]

Report message to a moderator

Re: EXP-00011: SCOTT.BONUS does not exist [message #568286 is a reply to message #568284] Wed, 10 October 2012 09:07 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
valuable info sir,

thanks alot.......

now i have a solid reason to avoid use of old exp/imp in future.

thanks again.....
Previous Topic: EXPORT and IMPORT from client machine
Next Topic: REMAP_DATAFILES parameter
Goto Forum:
  


Current Time: Thu Mar 28 18:19:37 CDT 2024