OraFAQ Forum: Server Utilities » want to perform impdp command for specific function

Home » RDBMS Server » Server Utilities » want to perform impdp command for specific function (10g 10.2.0.5 on linux )

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

want to perform impdp command for specific function [message #588533]

Wed, 26 June 2013 06:44

sam524
Messages: 77
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

Report message to a moderator

Re: want to perform impdp command for specific function [message #588539 is a reply to message #588533]

Wed, 26 June 2013 06:54

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Re: want to perform impdp command for specific function [message #588540 is a reply to message #588539]

Wed, 26 June 2013 07:02

Littlefoot
Messages: 21823
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')\"
                 ^                     ^
                 |                     |

Report message to a moderator

Re: want to perform impdp command for specific function [message #588542 is a reply to message #588540]

Wed, 26 June 2013 07:10

sam524
Messages: 77
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

Report message to a moderator

Re: want to perform impdp command for specific function [message #588543 is a reply to message #588542]

Wed, 26 June 2013 07:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Compare what I posted with what you wrote.

Report message to a moderator

Previous Topic:	Import from 11g to 10g results in strange errors
Next Topic:	"kfed read" online log outdated, while asmcmd cp is right

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 19:56:34 CST 2025