Original Export Raises EXP-11 Table Does Not Exist or Table is Ignored (Doc ID 960216.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Apr-2013***

Symptoms

You recently created a new table in user's schema. You started the original export utility to extract the schema (or the newly created table). The user export doesn't export the table and the table export reports table doesn't exist.

The next example demonstrates this:

connect test/test
create table a_tab (id number, text varchar2(10));
create table b_tab (id number, text varchar2(10));
insert into b_tab values (1, 'Text 1');
commit;


Schema export started with command line:

#> exp test/password file=test.dmp owner=test


reports:

Export: Release 11.2.0.1.0 - Production on Wed Oct 28 14:20:39 2009

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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
. . exporting table           B_TAB          1 row exported
. 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^[[A
. exporting statistics
Export terminated successfully without warnings.


=> Table A_TAB is ignored.

The table export started with: 

#> exp test/password file=a_tab.dmp tables=a_tab


ends with:

Export: Release 11.2.0.1.0 - Production on Wed Oct 28 14:25:50 2009

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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00011: TEST.A_TAB does not exist
Export terminated successfully with warnings.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms