Home » RDBMS Server » Server Utilities » Import with EXCLUDE syntax was not working (ORACLE 11g R2, RHEL6)
Import with EXCLUDE syntax was not working [message #654721] Thu, 11 August 2016 05:06 Go to next message
arin.oradba
Messages: 26
Registered: January 2016
Location: Kolkata
Junior Member
I had successfully done a several schema level imported from a full export dump file excluding a specific table. But No error occurred but also skipped the excluding syntax.

I have given the log below-

Please suggest anyone that what to do?

LOG:

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_02": userid="/******** AS SYSDBA" directory=dp_dir dumpfile=EXPDP_xxx.dmp logfile=imp_xxx.log SCHEMAS=A,B,C,D,E,F,G EXCLUDE=TABLE:"IN('B.XYZ')"
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "B"."XYZ" 100.1 GB 1265623160 rows
. . imported "C"."XYD" 26.05 GB 43501763 rows
. . imported "A"."XYZ" 15.26 GB 12419564 rows
. . imported "E"."XYZ" 13.63 GB 43921311 rows
. . imported "G"."XYZ" 12.90 GB 35975199 rows
. . imported "A"."XYZ" 10.17 GB 50174064 rows
. . imported "B"."XYZ" 9.726 GB 50165604 rows
Re: Import with EXCLUDE syntax was not working [message #654725 is a reply to message #654721] Thu, 11 August 2016 06:06 Go to previous messageGo to next message
BlackSwan
Messages: 25741
Registered: January 2009
Location: SoCal
Senior Member
submit Bug Report
Re: Import with EXCLUDE syntax was not working [message #654731 is a reply to message #654721] Thu, 11 August 2016 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65249
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I'm not sure you can give the schema, if so then you can only use
EXCLUDE=TABLE:"=IN ('XYZ')"

[Updated on: Thu, 11 August 2016 06:30]

Report message to a moderator

Re: Import with EXCLUDE syntax was not working [message #654787 is a reply to message #654731] Fri, 12 August 2016 12:14 Go to previous messageGo to next message
arin.oradba
Messages: 26
Registered: January 2016
Location: Kolkata
Junior Member
Sorry for delay and thanks for reply.

I had imported several schemas as a sys user. So that I had specified the specific table name with its owner.

My question is whether it should produce some error or successfully follow the command.

How can it was skipped the EXCLUDE command?

[Updated on: Fri, 12 August 2016 12:15]

Report message to a moderator

Re: Import with EXCLUDE syntax was not working [message #654788 is a reply to message #654787] Fri, 12 August 2016 12:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65249
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I had imported several schemas as a sys user.
Don't do that! SYS is not for this. Read SYS is special.
Now retry with another user.

Re: Import with EXCLUDE syntax was not working [message #654789 is a reply to message #654788] Fri, 12 August 2016 12:34 Go to previous message
BlackSwan
Messages: 25741
Registered: January 2009
Location: SoCal
Senior Member
>How can it was skipped the EXCLUDE command?
login as SCHEMA B
Previous Topic: how get 12c backup
Next Topic: Backup Some table
Goto Forum:
  


Current Time: Mon Dec 11 01:27:05 CST 2017

Total time taken to generate the page: 0.01212 seconds