Home » RDBMS Server » Server Utilities » import problem (import problem)
import problem [message #538495] |
Fri, 06 January 2012 10:00 |
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Dec 23 06:56:02 CST 2024
|