Home » Infrastructure » Linux » EXP-00011 (oracle 11gr1 red hat 4.1.2)
EXP-00011 [message #514181] Sat, 02 July 2011 05:47 Go to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
Hallo

I am exporting user from A database to B database.
on A user 180 objects are there.But when i import on B db it shows only 156 objects.
I checked db A all tables are there so I tried to export tables one by one but exp is unsuccessful and shows error
EXP-00011:abc table does not exists

but how it is possible because I connect with that user and it shows me that table but not not exporting.

Please can you tell me why this happen and how to export such kind of objects.

Regards//Neha
Re: EXP-00011 [message #514185 is a reply to message #514181] Sat, 02 July 2011 06:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Probably due to deferred segment creation.

http://www.orafaq.com/forum/mv/msg/160077/467586/42800/#msg_467586

You can disable it, export and import again.
or
use expdp.
or
or use DBMS_METADATA to extract the table DDL.


Edit:
Are you sure you are using 11gR1?
Please post your export/import sessions.

[Updated on: Sat, 02 July 2011 07:52]

Report message to a moderator

Re: EXP-00011 [message #514223 is a reply to message #514185] Sat, 02 July 2011 13:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, you are exporting a synonym (thinking it is a table):
SQL> show user
USER is "SCOTT"
SQL> create synonym syn_emp for emp;

Synonym created.

SQL> host exp scott/tiger file=test.dmp tables=syn_emp

Export: Release 10.2.0.1.0 - Production on Sub Srp 2 20:21:58 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

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

SQL>
Re: EXP-00011 [message #514234 is a reply to message #514223] Sat, 02 July 2011 14:17 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Excellent point.
With first response, I failed to notice that OP was using 11gR1 and hence the edit.

Previous Topic: Oracle 11g R1 Installation error
Next Topic: Practice Linux on the web
Goto Forum:
  


Current Time: Thu Mar 28 09:19:25 CDT 2024