OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » issue wit impdp (Oracle Server, 12.1.0.2.0 , Linux x86 64)

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

issue wit impdp [message #659781]

Mon, 30 January 2017 09:47

samiraly
Messages: 57
Registered: June 2009

Member

i have a expdp export where schema ISBR_ADMIN exported , below is the logfile from the exprt process

;;;
Export: Release 12.1.0.2.0 - Production on Wed Jan 25 12:10:23 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" directory=DATA_PUMP_DIR dumpfile=ISBR_ADMIN.DMP LOGFILE=isbr_admin-expdp.log schemas=ISBR_ADMIN
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 151.3 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
. . exported "ISBR_ADMIN"."ISBR_POWERCARD" 119.6 MB 723 rows
. . exported "ISBR_ADMIN"."ISBR_MFT" 2.113 MB 54 rows
. . exported "ISBR_ADMIN"."ISBR_SERVICE_MANAGEMENT" 1.161 MB 17 rows
. . exported "ISBR_ADMIN"."ISBR_DPS" 256.2 KB 199 rows
. . exported "ISBR_ADMIN"."ISBR_FILE_MANAGER" 226.9 KB 222 rows
. . exported "ISBR_ADMIN"."ISBR_KPI" 144.2 KB 9 rows
. . exported "ISBR_ADMIN"."FILE_STATUS" 638.2 KB 18942 rows
. . exported "ISBR_ADMIN"."DATAFILES" 262.6 KB 3700 rows
. . exported "ISBR_ADMIN"."ISBR_HYPERCARE" 10.47 KB 2 rows
. . exported "ISBR_ADMIN"."ISBR_SERVICE_MGMT_TYPE" 5.804 KB 7 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/data/oracle/app/oracle/product/12.1.0/dbhome_1/rdbms/log/ISBR_ADMIN.DMP
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Jan 25 12:12:10 2017 elapsed 0 00:01:46

- as you can see every thing was fine and normal
- when i tried to import schema isbr_admin again in another 12c DB no objects imported

impdp  \"/ as sysdba\"  directory =DATA_PUMP_DIR schemas=ISBR_ADMIN dumpfile=ISBR_ADMIN.DMP logfile=isbr-impdp.log

below is the listing from import dump file

;;;
Import: Release 12.1.0.2.0 - Production on Mon Jan 30 16:34:29 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01":  "/******** AS SYSDBA" directory=DATA_PUMP_DIR schemas=ISBR_ADMIN dumpfile=ISBR_ADMIN.DMP logfile=isbr-impdp.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"ISBR_ADMIN" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Job "SYS"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at Mon Jan 30 16:34:43 2017 elapsed 0 00:00:08

after that no objects imported schema isbr_admin still empty

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show user
USER is "ISBR_ADMIN"
SQL> select count(*) from user_objects;

  COUNT(*)
----------
	 0

SQL>

please help , thanks in advance .

Report message to a moderator

[Message index]

		issue wit impdp By: samiraly on Mon, 30 January 2017 09:47
		Re: issue wit impdp By: BlackSwan on Mon, 30 January 2017 09:50
		Re: issue wit impdp By: Roachcoach on Mon, 30 January 2017 09:54
		Re: issue wit impdp By: samiraly on Mon, 30 January 2017 10:18
		Re: issue wit impdp By: samiraly on Mon, 30 January 2017 10:24
		Re: issue wit impdp By: Michel Cadot on Mon, 30 January 2017 11:32
		Re: issue wit impdp By: Michel Cadot on Mon, 30 January 2017 11:34
		Re: issue wit impdp By: samiraly on Mon, 30 January 2017 15:39
		Re: issue wit impdp By: BlackSwan on Mon, 30 January 2017 15:57
		Re: issue wit impdp By: Michel Cadot on Tue, 31 January 2017 00:28
		Re: issue wit impdp By: samiraly on Tue, 31 January 2017 03:30
		Re: issue wit impdp By: samiraly on Wed, 01 February 2017 00:49
		Re: issue wit impdp By: joy_division on Wed, 01 February 2017 08:08

Previous Topic:	SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
Next Topic:	datapump export import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:49:38 CDT 2024