OraFAQ Forum: Server Utilities » exp failed in 11.2.0.3

Home » RDBMS Server » Server Utilities » exp failed in 11.2.0.3 (Oracle, 11.2.0.3, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp failed in 11.2.0.3 [message #599227]

Wed, 23 October 2013 02:22

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

Report message to a moderator

Re: exp failed in 11.2.0.3 [message #599228 is a reply to message #599227]

Wed, 23 October 2013 02:22

sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore

Junior Member

Please let me know if need any more information. Thanks..

Report message to a moderator

Re: exp failed in 11.2.0.3 [message #599229 is a reply to message #599227]

Wed, 23 October 2013 02:32

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: exp failed in 11.2.0.3 [message #599233 is a reply to message #599229]

Wed, 23 October 2013 02:45

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.

Report message to a moderator