EXP-00011 Table or View Does not exist in 11gR2

EXP-00011 Table or View Does not exist in 11gR2

connect scott/tiger
create table table1 (no number, value varchar2(20));

create table table2 (no number, value varchar2(20));
insert into table2 values (1, ‘’);
commit;

exp scott/tiger file=have_fun.dmp table1, table2

Export: Release 11.2.0.1.0 – Production on Wed Jan 19 10:38:10 2011

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
About to export specified tables via Conventional Path …

EXP-00011: SCOTT.table1 does not exist

. . exporting table                  table2             1 rows exported
Export terminated successfully with warnings.

Oracle has introduced new feature called deferred segment creation.

In Oracle Database 11g Release 2, when creating a non-partitioned heap-organized table in a locally managed tablespace,
table segment creation is deferred until the first row is inserted.  This is set via setting the initialization parameter DEFERRED_SEGMENT_CREATION TRUE,
which is default when you create DB.  Having said that unless you insert first record object is not visible to our traditional exp tool.

Solutions :

Option – 1: Add dummy entry into table1 and let oracle to allocate first extent one-time.

Option – 2: Create a table with segment creation immediate option.

create table table1 (no number, value varchar2(20)) segment creation immediate;

Option 3: set initialize parameter DEFERRED_SEGMENT_CREATION=FALSE.It requires bounce.