Friday 1 August 2014

EXP-00011

As salamo alaikum

i try to export a table from scott user named salgrade. i encountered error below
Exp-00011 scott.salgrade; does not exist. platform windows7 (64 bits) oracle 11.2.0.
solution - connect with sysdba
c:\  windows\system32>sqlplus / as sysdba
sql> show parameter deferred;
outout 
Name                                                      Type                   Value
----------------------------------------------------------------------------------
 deferred_segment_creation                        boolean                  True

sql> alter system set deferred_segmet_creation=false;
sql> shut immediate
sql>startup
sql> show parameter deffered;

outout 
Name                                                      Type                   Value
----------------------------------------------------------------------------------
 deferred_segment_creation                        boolean                  False

sql> exist
c:\windows\system32> 
now here you put your command to export the table scott.salgrade.

in oracle10g+, this type of error is occured.

Thanking you
Mohammad Shahnawaz
Passion for Oracle

No comments:

Post a Comment