Home » RDBMS Server » Server Utilities » want to perform impdp command for specific function (10g 10.2.0.5 on linux )
want to perform impdp command for specific function [message #588533] Wed, 26 June 2013 06:44 Go to next message
sam524
Messages: 71
Registered: July 2012
Location: sydney
Member
Dear All,

Below is my import command for importing specific function from export file but iam getting below errors

impdp system/PASSWORD schemas=TNC6 directory=dumpdir dumpfile=FULL01-02-2011.dmp logfile=IMP.log include=FUNCTION:"IN ('TNC_IS_NUMBER')"

ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00936: missing expression

kindly help thanksalot in advance
Re: want to perform impdp command for specific function [message #588539 is a reply to message #588533] Wed, 26 June 2013 06:54 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Why not use DBMS_METADATA.GET_DDL for that?

http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_metada.htm#autoId15
Re: want to perform impdp command for specific function [message #588540 is a reply to message #588539] Wed, 26 June 2013 07:02 Go to previous messageGo to next message
Littlefoot
Messages: 19508
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Backslash might be a problem. Try with
impdp system/PASSWORD schemas=TNC6 directory=dumpdir dumpfile=FULL01-02-2011.dmp logfile=IMP.log include=FUNCTION:\"IN ('TNC_IS_NUMBER')\"

Note
include=FUNCTION:\"IN ('TNC_IS_NUMBER')\"
                 ^                     ^
                 |                     |
Re: want to perform impdp command for specific function [message #588542 is a reply to message #588540] Wed, 26 June 2013 07:10 Go to previous messageGo to next message
sam524
Messages: 71
Registered: July 2012
Location: sydney
Member
yes thanks for your replies guys,

i did perfrom as little foot

impdpdp system/PASSWORD DIRECTORY=dumpdir DUMPFILE=FULL01-02-2011.dmp LOGFILE=IMP.log SCHEMAS=TNC6 INCLUDE=FUNCTION:\"IN \(\'TNC_IS_NUMBER\')\"

Iam getting below error kindly help

LRM-00116: syntax error at ')' following '(\ÆTNC_IS_NUMBER'

kindly help
Re: want to perform impdp command for specific function [message #588543 is a reply to message #588542] Wed, 26 June 2013 07:12 Go to previous message
Littlefoot
Messages: 19508
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Compare what I posted with what you wrote.
Previous Topic: IMPDP ERROR ORA-31693: on ORACLE VIRTUAL COLUMN with Not null
Next Topic: "kfed read" online log outdated, while asmcmd cp is right
Goto Forum:
  


Current Time: Wed Aug 27 08:27:58 CDT 2014

Total time taken to generate the page: 0.09363 seconds