Home » RDBMS Server » Server Utilities » exp failed in 11.2.0.3 (Oracle, 11.2.0.3, Linux)
exp failed in 11.2.0.3 [message #599227] Wed, 23 October 2013 02:22 Go to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Dear All,

Iam from application team and been given only exp access to take schema backup and am facing below error. Kindly assist me to resolve the issue.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: table data (rows) will not be exported
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user NPIWF
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user NPIWF
About to export NPIWF's objects ...
. exporting database links
EXP-00106: Invalid Database Link Passwords
EXP-00000: Export terminated unsuccessfully

DB version: 11.2.0.3
exp version: 11.2.0.1
Re: exp failed in 11.2.0.3 [message #599228 is a reply to message #599227] Wed, 23 October 2013 02:22 Go to previous messageGo to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Please let me know if need any more information. Thanks..
icon3.gif  Re: exp failed in 11.2.0.3 [message #599229 is a reply to message #599227] Wed, 23 October 2013 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should use data pump instead of old exp.
Otherwise the only solutions are to drop the database link or to patch your client to 11.2.0.3.

Re: exp failed in 11.2.0.3 [message #599233 is a reply to message #599229] Wed, 23 October 2013 02:45 Go to previous messageGo to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Thanks very much Michel.
Also am facing below error in an another database.

About to export PLMQV's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PLMQV's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully

Could you please let me know how it can be avoided?
Thank you.
Re: exp failed in 11.2.0.3 [message #599234 is a reply to message #599233] Wed, 23 October 2013 02:46 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
https://forums.oracle.com/message/10748186
icon2.gif  Re: exp failed in 11.2.0.3 [message #599245 is a reply to message #599233] Wed, 23 October 2013 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Better upgrade your client.

Re: exp failed in 11.2.0.3 [message #599250 is a reply to message #599245] Wed, 23 October 2013 05:08 Go to previous message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Sure will do Michel. Thanks very much.
Previous Topic: Can data pump utility can do imp while exp?
Next Topic: IMPDP ---- big table's data can't be imported .hope for resolve!!
Goto Forum:
  


Current Time: Thu Mar 28 16:16:39 CDT 2024