OraFAQ Forum: Server Utilities » Exclude View in IMPDP using Network Link Giving error.

Home » RDBMS Server » Server Utilities » Exclude View in IMPDP using Network Link Giving error. (Oracle 10.2 on HP-UX)

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

Exclude View in IMPDP using Network Link Giving error. [message #489287]

Fri, 14 January 2011 05:22

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Hi,

I am using below command to import a schema using network link. Command is :
impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=view: "= 'XYZ.VW_ACCEPTDETAILS'"

This command is giving below error
LRM-00116: syntax error at 'view:' following '='

When I have tried Like in place of '=' sign i.e. EXCLUDE = VIEW:"LIKE '%VW_ACCEPTDETAILS%'" , it gives me below error:
UDI-00014: invalid value for parameter, 'exclude'

Please help.

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #489293 is a reply to message #489287]

Fri, 14 January 2011 06:15

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exclude=view:XYZ.VW_ACCEPTDETAILS

Regards
Michel

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #489298 is a reply to message #489293]

Fri, 14 January 2011 06:32

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

No Success Mich,
When I have executed
impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=view:XYZ.VW_ACCEPTDETAILS

I have got below error:

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 14 January, 2011 12:28:43

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator
ORA-06512: at "SYS.KUPM$MCP", line 2687

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #489303 is a reply to message #489298]

Fri, 14 January 2011 06:45

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I think the schema name must not be given.
exclude=VIEW:VW_ACCEPTDETAILS
or
exclude=VIEW:"='VW_ACCEPTDETAILS'"

Regards
Michel

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #489325 is a reply to message #489303]

Fri, 14 January 2011 08:20

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Below are the results with the along with commands.

impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=VIEW:VW_ACCEPTDETAILS

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 14 January, 2011 13:24:44

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator
ORA-06512: at "SYS.KUPM$MCP", line 2687

impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=VIEW:"='VW_ACCEPTDETAILS'"
LRM-00116: syntax error at 'VIEW:' following '='

Sad

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #686790 is a reply to message #489325]

Fri, 06 January 2023 11:20

jfmt83
Messages: 1
Registered: January 2023

Junior Member

try

impdp userid='xx/xxx@Oxxxx as sysdba' SCHEMAS=EFINAC DIRECTORY=PATHIMPORT REMAP_TABLESPACE=(USERS:TBS_DATA_EFINAC,TSP_DATA_FINACADM01:TBS_DATA_EFINAC,TSP_INDEX_FINACADM02:TBS_IDX_EFINAC) DUMPFILE=EFINAC_20230103.DMP logfile=imp_EFINAC_20230103.log job_name=IMPORT_EFINAC EXCLUDE=VIEW:\"IN $\'ACCOUNTING_ENTRIES_V\'$\"

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #686791 is a reply to message #686790]

Fri, 06 January 2023 12:22

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

userid='xx/xxx@Oxxxx as sysdba'

Don't do that!
Read SYS/SYSDBA is special.

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #687759 is a reply to message #686791]

Sat, 27 May 2023 13:03

Solomon Yakobson
Messages: 3280
Registered: January 2010
Location: Connecticut, USA

Senior Member

Issue has nothing to do with sysdba. There is a difference when using any datapump parameter on command line vs in par file. In par file it is

exclude=VIEW:"='VW_ACCEPTDETAILS'"

On command line we need to take into account that command is first parsed by CLI (command line interpreter) if windows or shell if UNIX/LINUX. Therefore on command line we have to use:

exclude=view:\""='VW_ACCEPTDETAILS'"\"

SY.

Report message to a moderator

Re: Exclude View in IMPDP using Network Link Giving error. [message #687760 is a reply to message #687759]

Sat, 27 May 2023 13:57

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

My remark about SYSDBA was NOT about original question (from abhi_sri in 2011) but about the last previous answer (from jfmt83 n 2023).

But you are right, it seems the original question was forgotten and question not answered.
I'd think:
exclude=VIEW:\"=\'VW_ACCEPTDETAILS\'\"

Report message to a moderator

Previous Topic:	sqlldr
Next Topic:	sqlldr from Instantclient-21.9 on Win64: missing oranl.dll

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 11:11:48 CDT 2024