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>

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>

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.

select  table_name, segment_created from user_tables where table_name='BONUS' 

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>