Home » RDBMS Server » Server Utilities » Exclude View in IMPDP using Network Link Giving error. (Oracle 10.2 on HP-UX)
Exclude View in IMPDP using Network Link Giving error. [message #489287] Fri, 14 January 2011 05:22 Go to next message
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.
Re: Exclude View in IMPDP using Network Link Giving error. [message #489293 is a reply to message #489287] Fri, 14 January 2011 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exclude=view:XYZ.VW_ACCEPTDETAILS

Regards
Michel


Re: Exclude View in IMPDP using Network Link Giving error. [message #489298 is a reply to message #489293] Fri, 14 January 2011 06:32 Go to previous messageGo to next message
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
Re: Exclude View in IMPDP using Network Link Giving error. [message #489303 is a reply to message #489298] Fri, 14 January 2011 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: Exclude View in IMPDP using Network Link Giving error. [message #489325 is a reply to message #489303] Fri, 14 January 2011 08:20 Go to previous messageGo to next message
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
Re: Exclude View in IMPDP using Network Link Giving error. [message #686790 is a reply to message #489325] Fri, 06 January 2023 11:20 Go to previous messageGo to next message
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\'\)\"

Re: Exclude View in IMPDP using Network Link Giving error. [message #686791 is a reply to message #686790] Fri, 06 January 2023 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.

Re: Exclude View in IMPDP using Network Link Giving error. [message #687759 is a reply to message #686791] Sat, 27 May 2023 13:03 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
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.
Re: Exclude View in IMPDP using Network Link Giving error. [message #687760 is a reply to message #687759] Sat, 27 May 2023 13:57 Go to previous message
Michel Cadot
Messages: 68625
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\'\"

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


Current Time: Thu Mar 28 12:33:55 CDT 2024