Hi,
I am having problems while doing an import into an 11g database using an export from a 10g database. I searched the forums and google for this error and don't see one similar to mine. Any help is appreciated. This is the error I get :
oracle@<progdev>:/oravol02/backup/refresh $impdp TEST_DB/***** parfile=test_db.par DUMPFILE=Progressive_%U.dmp
Import: Release 11.1.0.7.0 - 64bit Production on Wednesday, 24 March, 2010 12:58
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "TEST_DB"."TEST_DB_REFRESH" successfully loaded/unloaded
Starting "TEST_DB"."TEST_DB_REFRESH": TEST_DB/******** parfile=TEST_DB.
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"TEST_DB" 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
Processing object type SCHEMA_EXPORT/LIBRARY/LIBRARY
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "TEST_DB"."SALES010110" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31693: Table data object "TEST_DB"."SALES" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
. . imported "TEST_DB"."MEMBERS" 22.89 MB 82921 rows
. . imported "TEST_DB"."MEMBER_ALL" 23.45 MB 85093 rows
. . imported "TEST_DB"."TN_TRANSACTION" 355.4 MB 6448 rows
. . imported "TEST_DB"."TN_BUCKETS" 517.5 MB 9284 rows
. . imported "TEST_DB"."TN_POBUK" 3.210 MB 160013 rows
My par_file is as follows :
DIRECTORY=REFRESH_DIR
remap_schema=prod_db:test_db
PARALLEL=6
EXCLUDE=grant
job_name=TEST_DB_REFRESH
logfile=imp_TEST_DB.log
REMAP_TABLESPACE=prod_data_01:TEST_DB_DATA,prod_data_02:TEST_DB_DATA,prod_data_03:TEST_DB_DATA,prod_data_04:TEST_DB_DATA,PRODDB_INDEX_01:TEST_DB_DATA,PRODDB_INDEX_02:TEST_DB_DATA,PRODDB_INDEX_03:TEST_DB_DATA,PRODDB_INDEX_04:TEST_DB_DATA,PRODDB_LOBIDX_01:TEST_DB_DATA,PRODDB_LOB_01:TEST_DB_DATA,DATAM02:TEST_DB_DATA