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 previous message
arin.oradba
Messages: 33
Registered: January 2016
Location: Kolkata
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how get 12c backup
Next Topic: Backup Some table
Goto Forum:
  


Current Time: Thu Mar 28 14:29:13 CDT 2024