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