Home » RDBMS Server » Server Utilities » import problem (import problem)
import problem [message #538495] Fri, 06 January 2012 10:00 Go to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
import problem.

dear Sir ,
I have user hemant under database instance ORCL .I took backup of this schema hemant using expdp and then I created another user DON
with different tablespace than DON as below.



====================================================

SQL> CREATE TABLESPACE html DATAFILE 'C:\oracle\undotbs_1a.dbf' SIZE 100M AUTOEX
TEND ON;

Tablespace created.

SQL> create user don identified by don default tablespace html temporary tablesp
ace temp;

User created.

SQL> grant dba to don;
==================================

and then I tried to import entire user Hemant into DON user but I am getting error ,Kindly suggest .

==============================

C:\Documents and Settings\Hemant>impdp

Import: Release 10.1.0.2.0 - Production on Friday, 06 January, 2012 21:19

Copyright (c) 2003, Oracle. All rights reserved.

Username: don
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "DON"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DON"."SYS_IMPORT_FULL_01": don/********
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"HEMANT" 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/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-31684: Object type TABLE:"HEMANT"."ABM_CV_FLOOR_FACTOR_NEW" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_CV_FLOOR_MASTER" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_PROPERTY1" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_PROPERTY_TYPE" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_STREET" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_SYSTEM_LOOKUP" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_SYSTEM_LOOKUP_VALUE" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-31684: Object type TABLE:"HEMANT"."ABM_USER" already exists
ORA-31684: Object type TABLE:"HEMANT"."HH" already exists
ORA-31684: Object type TABLE:"HEMANT"."EMP" already exists
ORA-31684: Object type TABLE:"HEMANT"."DEPT" already exists
ORA-31684: Object type TABLE:"HEMANT"."BONUS" already exists
ORA-31684: Object type TABLE:"HEMANT"."SALGRADE" already exists
ORA-31684: Object type TABLE:"HEMANT"."DUMMY" already exists
ORA-31684: Object type TABLE:"HEMANT"."NM" already exists
ORA-31684: Object type TABLE:"HEMANT"."GRAPHICS_TABLE" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_FLRID" skipped, base object
type TABLE:"HEMANT"."ABM_CV_FLOOR_FACTOR_NEW" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_FLOORID" skipped, base objec
t type TABLE:"HEMANT"."ABM_CV_FLOOR_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLOOR_CD" skipped, base ob
ject type TABLE:"HEMANT"."ABM_CV_FLOOR_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_SDRR_ZONE" skipped, base ob
ject type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_LOOKUP" skipped, base objec
t type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_SDDR_ID" skipped, base objec
t type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_UR_CTGRY_LOOKUP_ID" skippe
d, base object type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_FLAT_ID" skipped, base objec
t type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."IDX_FLAT_PROPERTY_ID" skipped,
base object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLAT_FLOOR_ID" skipped, ba
se object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_TCM" skipped, base object t
ype TABLE:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_TH" skipped, base object ty
pe TABLE:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_TCD_ID" skipped, base object
type TABLE:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_TC" skipped, base object ty
pe TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_CITY_SUB" skipped, base obj
ect type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_USER_CAT" skipped, base obj
ect type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."CVS_MET_UM" skipped, base objec
t type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."PK_TCM_ID" skipped, base object
type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_FLRID" skipped, base ob
ject type TABLE:"HEMANT"."ABM_CV_FLOOR_FACTOR_NEW" already exists
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_FLOORID" skipped, base
object type TABLE:"HEMANT"."ABM_CV_FLOOR_MASTER" already exists
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_SDDR_ID" skipped, base
object type TABLE:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_FLAT_ID" skipped, base
object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_TCD_ID" skipped, base o
bject type TABLE:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-39111: Dependent object type CONSTRAINT:"HEMANT"."PK_TCM_ID" skipped, base o
bject type TABLE:"HEMANT"."ABM_TAXCODE_MASTER" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_FLRID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_FLOORID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLOOR_CD" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_SDRR_ZONE" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_LOOKUP" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_SDDR_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_UR_CTGRY_LOOKUP_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_FLAT_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."IDX_FLAT_PROPERTY_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLAT_FLOOR_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_TCM" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_TH" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_TCD_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_TC" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_CITY_SUB" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_USER_CAT" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."CVS_MET_UM" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."PK_TCM_ID" already exists
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."NM" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."DEPT" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."EMP" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."BONUS" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."SALGRADE" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."DUMMY" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."GRAPHICS_TABLE" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_CV_FLOOR_FACTOR_NEW" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_CV_FLOOR_MASTER" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_CV_SDRR_NEW" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_PROPERTY1" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_PROPERTY_TYPE" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_STREET" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_SYSTEM_LOOKUP" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_SYSTEM_LOOKUP_VALUE" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_TAXCODE_DETAILS" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_TAXCODE_MASTER" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."ABM_USER" already exists
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABL
E:"HEMANT"."HH" already exists
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type TABLE:"HEMANT
"."ABM_FLAT" already exists
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
ORA-31684: Object type FUNCTION:"HEMANT"."FN_EASY" already exists
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
ORA-31684: Object type PROCEDURE:"HEMANT"."COUNT_TABLE" already exists
ORA-31684: Object type PROCEDURE:"HEMANT"."DROP_TABLE" already exists
ORA-31684: Object type PROCEDURE:"HEMANT"."H" already exists
ORA-31684: Object type PROCEDURE:"HEMANT"."UPDATE_ALL" already exists
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39111: Dependent object type TRIGGER:"HEMANT"."AFT_INS_FLAT" skipped, base o
bject type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type TRIGGER:"HEMANT"."AFT_UPD_FLAT" skipped, base o
bject type TABLE:"HEMANT"."ABM_FLAT" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/SE_TBL_FBM_INDEX_INDEX/INDEX
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLAT_USAGE_ID" skipped, ba
se object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLAT_AGE_ID" skipped, base
object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLAT_CONSTRUCTION_ID" skip
ped, base object type TABLE:"HEMANT"."ABM_FLAT" already exists
ORA-39111: Dependent object type INDEX:"HEMANT"."INDX_FLAT_SCHM_BLDG_FACTOR_ID"
skipped, base object type TABLE:"HEMANT"."ABM_FLAT" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/SE_TBL_FBM_IND_STATS
/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLAT_USAGE_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLAT_AGE_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLAT_CONSTRUCTION_ID" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDE
X:"HEMANT"."INDX_FLAT_SCHM_BLDG_FACTOR_ID" already exists
Job "DON"."SYS_IMPORT_FULL_01" completed with 119 error(s) at 21:20
=============================================

Please Help Me to get out of this issue.
Thanks in advance.

Re: import problem [message #538498 is a reply to message #538495] Fri, 06 January 2012 10:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use SCHEMAS option to specify the target schema (DON).
Else by default import will be done to source schema (HEMANT)
Re: import problem [message #538501 is a reply to message #538495] Fri, 06 January 2012 10:33 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
In short my question is "How to move a schema to another schema in a same database?"
Re: import problem [message #538502 is a reply to message #538501] Fri, 06 January 2012 10:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
impdp help=yes

REMAP_SCHEMA
Objects from one schema are loaded into another schema.

Re: import problem [message #538508 is a reply to message #538501] Fri, 06 January 2012 10:47 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
I want same copy of schema hemant as DON user.
Re: import problem [message #538509 is a reply to message #538508] Fri, 06 January 2012 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So do as BlackSwan told you.

Regards
Michel
Re: import problem [message #538510 is a reply to message #538508] Fri, 06 January 2012 10:56 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
but I am facing another issue as below.
============================================
C:\Documents and Settings\Hemant>impdp don/don table_exists_action=replace schem
as=DON

Import: Release 10.1.0.2.0 - Production on Friday, 06 January, 2012 22:27

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-31655: no data or metadata objects selected for job
ORA-39039: Schema expression "IN ('DON')" contains no valid schemas.
Master table "DON"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "DON"."SYS_IMPORT_SCHEMA_01": don/******** table_exists_action=replace
schemas=DON
Job "DON"."SYS_IMPORT_SCHEMA_01" successfully completed at 22:27


C:\Documents and Settings\Hemant>impdp don/don schemas=DON

Import: Release 10.1.0.2.0 - Production on Friday, 06 January, 2012 22:28

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-31655: no data or metadata objects selected for job
ORA-39039: Schema expression "IN ('DON')" contains no valid schemas.
Master table "DON"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "DON"."SYS_IMPORT_SCHEMA_01": don/******** schemas=DON
Job "DON"."SYS_IMPORT_SCHEMA_01" successfully completed at 22:28
=================================================
Re: import problem [message #538512 is a reply to message #538510] Fri, 06 January 2012 11:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#sthref272
Re: import problem [message #538513 is a reply to message #538510] Fri, 06 January 2012 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, you exported hemant not DON!
Please:
1/ Take care of what is saying, if you don't understand the first read it again and again until you understand it
2/ If in the end you don't understand, at least read the documentation.

Regards
Michel
Re: import problem [message #538514 is a reply to message #538510] Fri, 06 January 2012 11:22 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
Thanks a lot sir , you solved my problem ,but at the end I got 4 erros.
================
C:\Documents and Settings\Hemant>impdp don/don REMAP_SCHEMA=hemant:don

Import: Release 10.1.0.2.0 - Production on Friday, 06 January, 2012 22:52

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "DON"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DON"."SYS_IMPORT_FULL_01": don/******** REMAP_SCHEMA=hemant:don
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"DON" 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/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "DON"."ABM_PROPERTY1" 78.26 MB 381686 rows
. . imported "DON"."ABM_FLAT" 26.38 MB 88019 rows
. . imported "DON"."ABM_CV_SDRR_NEW" 149.3 KB 3570 rows
. . imported "DON"."ABM_STREET" 96.45 KB 1135 rows
. . imported "DON"."ABM_CV_FLOOR_FACTOR_NEW" 25.07 KB 217 rows
. . imported "DON"."ABM_CV_FLOOR_MASTER" 19.96 KB 216 rows
. . imported "DON"."ABM_PROPERTY_TYPE" 7.078 KB 34 rows
. . imported "DON"."ABM_SYSTEM_LOOKUP" 8.5 KB 2 rows
. . imported "DON"."ABM_SYSTEM_LOOKUP_VALUE" 8.843 KB 3 rows
. . imported "DON"."ABM_TAXCODE_DETAILS" 38.45 KB 560 rows
. . imported "DON"."ABM_TAXCODE_MASTER" 12.34 KB 56 rows
. . imported "DON"."ABM_USER" 16.42 KB 6 rows
. . imported "DON"."DEPT" 5.656 KB 4 rows
. . imported "DON"."DUMMY" 4.921 KB 1 rows
. . imported "DON"."EMP" 7.820 KB 14 rows
. . imported "DON"."GRAPHICS_TABLE" 5.914 KB 1 rows
. . imported "DON"."NM" 4.937 KB 3 rows
. . imported "DON"."SALGRADE" 5.585 KB 5 rows
. . imported "DON"."BONUS" 0 KB 0 rows
. . imported "DON"."HH" 0 KB 0 rows
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/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39082: Object type TRIGGER:"DON"."AFT_INS_FLAT" created with compilation war
nings
ORA-39082: Object type TRIGGER:"DON"."AFT_INS_FLAT" created with compilation war
nings
ORA-39082: Object type TRIGGER:"DON"."AFT_UPD_FLAT" created with compilation war
nings
Processing object type SCHEMA_EXPORT/TABLE/INDEX/SE_TBL_FBM_INDEX_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/SE_TBL_FBM_IND_STATS
/INDEX_STATISTICS
Job "DON"."SYS_IMPORT_FULL_01" completed with 4 error(s) at 22:53
=======================================
Re: import problem [message #538515 is a reply to message #538514] Fri, 06 January 2012 11:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>,but at the end I got 4 erros.

I agree, but without you providing more details no additional assistance is possible.
Re: import problem [message #538527 is a reply to message #538514] Fri, 06 January 2012 12:38 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute
show error trigger DON.AFT_INS_FLAT
and fix them.

Regards
Michel
Previous Topic: Schema export in command prompt mode
Next Topic: Sqlloader issue
Goto Forum:
  


Current Time: Thu Mar 28 12:09:44 CDT 2024