Oracle Database Discussions

Dear all,

I am trying to import a data dump generated from an Oracle Enterprise Manager 10.2.0.4.0 on a unix server with the following command:
expdp mc/XXX DIRECTORY=EXPORT_DIR DUMPFILE=SLTN-MCEXPORT-2010-07-22.dmp SCHEMAS=MC LOGFILE=SLTN-MCEXPORT-2010-07-22.log

I want to import it in oracle XE 10g (10.2.0.1.0) on a windows server. Therefore I do the following:

impdp mc/xxx DIRECTORY=EXPORT_DIR DUMPFILE= SLTN-MCEXPORT-2010-07-22.dmp SCHEMAS=MC LOGFILE=SLTN-MCIMPORT-2010-07-22.log

I have had to create the TABLESPACE MC_DATA manually: CREATE TABLESPACE “MC_DATA” DATAFILE ‘D:\OracleHisRuns\Dumps\SLTN-MCEXPORT-2010-07-22.dmp’;

Then one table fails MC.CURVEPOINTS

And finally we are disconnected from Oracle

Traitement du type d’objet SCHEMA_EXPORT/TABLE/INDEX/INDEX
UDI-00008 the operation generates error 3113 and error 3114.

and I can't recover. I have to install Oracle XE again.

Does anyone knows why this is happening? Is this a memory issue? Or is there a problem when the user, tablespace is created at my side?
Maybe the export and import between these both Oracle database versions are not compatible?

Any help would be greatly appreciated.

Many thanks in advance,
Thomas

please find the log I have:

D:\COSMOS_BATCH_RUNNER\Automation_oracle\Scripts\IMPORT DMP>impdp mc/mc DIRECTOR
Y=EXPORT_DIR DUMPFILE=SLTN-MCEXPORT-2010-07-22.dmp SCHEMAS=MC LOGFILE=SLTN-MCEXP
ORT-2010-07-22.log

Import: Release 10.2.0.1.0 - Production on Jeudi, 22 Juillet, 2010 17:35:36

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

ConnectΘ α : Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Table maεtre "MC"."SYS_IMPORT_SCHEMA_01" chargΘe/dΘchargΘe avec succΦs
DΘmarrage de "MC"."SYS_IMPORT_SCHEMA_01" : mc/******** DIRECTORY=EXPORT_DIR DUMP
FILE=SLTN-MCEXPORT-2010-07-22.dmp SCHEMAS=MC LOGFILE=SLTN-MCEXPORT-2010-07-22.lo
g
Traitement du type d'objet SCHEMA_EXPORT/USER
ORA-31684: Le type d'objet USER:"MC" existe dΘjα
Traitement du type d'objet SCHEMA_EXPORT/SYSTEM_GRANT
Traitement du type d'objet SCHEMA_EXPORT/ROLE_GRANT
Traitement du type d'objet SCHEMA_EXPORT/DEFAULT_ROLE
Traitement du type d'objet SCHEMA_EXPORT/TABLESPACE_QUOTA
Traitement du type d'objet SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Traitement du type d'objet SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Traitement du type d'objet SCHEMA_EXPORT/TABLE/TABLE
Traitement du type d'objet SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Echec du chargement/dΘchargement de l'objet de donnΘes de table "MC".
"CURVE_POINTS" ; l'objet est ignorΘ en raison de l'erreur :
ORA-02354: erreur lors de l'export/import de donnΘes
ORA-02368: file is not valid for this load operation
. . import : "MC"."BLOCKORDER_INTERVAL_RESULTS" 46.54 MB 2280571 lignes

. . import : "MC"."BLOCKORDER_INTERVALS" 19.54 MB 1359850 lignes

. . import : "MC"."BLOCKORDER_HEADERS" 6.162 MB 149683 lignes

. . import : "MC"."BLOCKORDER_RESULTS" 6.205 MB 246805 lignes

. . import : "MC"."PRELIMINARY_RESULTS" 4.247 MB 58248 lignes

. . import : "MC"."ALGORITHM_EVENT_LOG" 1.689 MB 20388 lignes

. . import : "MC"."CURVE_HEADERS" 1.816 MB 73568 lignes

. . import : "MC"."LINE_RESULTS" 1.937 MB 58248 lignes

. . import : "MC"."OS_HISTORYSTEP" 2.155 MB 21460 lignes

. . import : "MC"."SESSION_ALGORITHMPARAMETERS" 1.741 MB 57656 lignes

. . import : "MC"."LINE_CAPACITIES" 1.311 MB 46883 lignes

. . import : "MC"."MSG_TRANSMISSION_LOGS" 1.143 MB 6464 lignes

. . import : "MC"."FINAL_PRICE_POSITIONS" 396.4 KB 16428 lignes

. . import : "MC"."OS_CURRENTSTEP" 348.4 KB 7456 lignes

. . import : "MC"."REPORTATCVALUES" 254.5 KB 12000 lignes

. . import : "MC"."BUSINESS_STEP_SESSION_REPORTS" 220.7 KB 2852 lignes

. . import : "MC"."PTDF_MATRIX_FACTORS" 239.6 KB 12612 lignes

. . import : "MC"."SESSION_BIDDINGAREAS" 207 KB 2648 lignes

. . import : "MC"."ALGORITHM_DETAILED_LOG" 52.85 KB 526 lignes

. . import : "MC"."ALGORITHM_SOLUTION_LOG" 55.23 KB 607 lignes

. . import : "MC"."AUDIT_LOGS" 69.25 KB 1516 lignes

. . import : "MC"."BUSINESS_STEP_REPORT_COMMENTS" 62.46 KB 2821 lignes

. . import : "MC"."OS_WFENTRY" 45.38 KB 1020 lignes

. . import : "MC"."PTDF_MATRIX_CONSTRAINTS" 59.75 KB 3153 lignes

. . import : "MC"."SESSIONS" 61.64 KB 679 lignes

. . import : "MC"."SESSION_LINES" 77.58 KB 2648 lignes

. . import : "MC"."ALGORITHM_PARAMETERS" 7.937 KB 84 lignes

. . import : "MC"."ALGORITHM_SESSION_LOG" 19.20 KB 317 lignes

. . import : "MC"."BALANCING_AREAS" 6.320 KB 1 lignes

. . import : "MC"."BIDDING_AREAS" 10.03 KB 4 lignes

. . import : "MC"."LINES" 7.140 KB 4 lignes

. . import : "MC"."LINE_CAPACITIES_STATIC" 7.601 KB 96 lignes

. . import : "MC"."MAPPING_CONSTRAINTID_ROWID" 11.17 KB 171 lignes

. . import : "MC"."OUTPUTCHECKS" 37.96 KB 419 lignes

. . import : "MC"."PARTY" 6.257 KB 9 lignes

. . import : "MC"."PERIPHERAL_SYSTEMS" 8.851 KB 9 lignes

. . import : "MC"."PTDF_MATRIX_HEADERS" 7.195 KB 72 lignes

. . import : "MC"."SESSION_BALANCINGAREAS" 32.71 KB 662 lignes

. . import : "MC"."SESSION_REPORTS" 29.89 KB 135 lignes

. . import : "MC"."SESSION_REPORT_COMMENTS" 7.007 KB 128 lignes

. . import : "MC"."SYSTEM_PARAMETERS" 6.5 KB 27 lignes

. . import : "MC"."USERS" 11.71 KB 33 lignes

. . import : "MC"."USER_SCRATCH_CARD_DETAILS" 11.51 KB 11 lignes

. . import : "MC"."BLOCKORDER_EXCLUSIVEGROUPS" 0 KB 0 lignes

. . import : "MC"."BLOCKORDER_LINKS" 0 KB 0 lignes

. . import : "MC"."MATRIXROWRESULTS" 0 KB 0 lignes

. . import : "MC"."MSG_TRANSMISSION_ERROR_LOGS" 0 KB 0 lignes

Traitement du type d'objet SCHEMA_EXPORT/TABLE/INDEX/INDEX

UDI-00008: l'opΘration a gΘnΘrΘ l'erreur ORACLE 3113
ORA-03113: fin de fichier sur canal de communication


UDI-00008: l'opΘration a gΘnΘrΘ l'erreur ORACLE 3114
ORA-03114: pas connectΘ α ORACLE

D:\COSMOS_BATCH_RUNNER\Automation_oracle\Scripts\IMPORT DMP>