Home » RDBMS Server » Server Utilities » Oracle-10g /Linux-AS (what all are the possible datapump error message (starting part only))
Oracle-10g /Linux-AS [message #433125] Mon, 30 November 2009 05:07 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
I am developing Unix shell script for expdp/impdp, to `grep` the error messages, I wanted to know what all are the possible datapump error messages(starting part only)

ORA-
LRM-
UDE-

any other ...?

Thanks
sbmk
Re: Oracle-10g /Linux-AS [message #433175 is a reply to message #433125] Mon, 30 November 2009 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
TNS- errors
Re: Oracle-10g /Linux-AS [message #433187 is a reply to message #433175] Mon, 30 November 2009 09:48 Go to previous message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You might also want to check the Unix *error level* for the expdp/impdp commands. Something might be broken before the command even starts. For exapmle:

starfury ~ # expdp
bash: expdp: command not found
starfury ~ # echo $?
127
bash: /usr/bin/expdp: Permission denied
starfury ~ # echo $?
126
starfury ~ # 


(Possible path / permission / linker / etc... problems)







Previous Topic: is it possible to use impdp for a table without using REMAP_TABLESPACE
Next Topic: SQL*LDR row split/pivot/mutliple records per row
Goto Forum:
  


Current Time: Mon Dec 23 12:55:13 CST 2024