Oracle Database Discussions

OS=Win2003
DB=10gR2
Version = 102.0.4

Hi,

I am running a impdp on a 30gb file and well it seems to have gone fine (much faster then it normally does to be honest), but towards the end it fails, and when researching this error, it seems to be very vague and I was wondering if someone can help me. Below is the log, but I have taken parts out of it that are not relevant.

Import: Release 10.2.0.4.0 - Production on Wednesday, 16 April, 2008 15:22:18

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."IMPGEMDEV041608" successfully loaded/unloaded
Starting "SYSTEM"."IMPGEMDEV041608": system/********@iworksdb directory=DATA_PUMP_DIR dumpfile=expdpgemdev.dmp job_name=impgemdev041608 TABLE_EXISTS_ACTION=APPEND SCHEMAS=GEMDEV LOGFILE=IMPIWORKS_BOON.log REMAP_SCHEMA=GEMDEV:IWORKS REMAP_TABLESPACE=IWORKS_INDEX:IWORKS_IDX REMAP_TABLESPACE=IWORKS_IOT:IWORKS_IDX REMAP_TABLESPACE=IWORKS_TABLES:IWORKS_TABLES EXCLUDE=GRANT exclude=statistics STREAMS_CONFIGURATION=N
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"IWORKS" 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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
ORA-31684: Object type TYPE:"IWORKS"."T_NUMBER_TAB" already exists
ORA-31684: Object type TYPE:"IWORKS"."T_VARCHAR2_TAB" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39152: Table "IWORKS"."SYS_TOKENTYPE" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
.
.
.
ORA-31684: Object type PACKAGE:"IWORKS"."CONT_FEE_DEF_UC" already exists
ORA-31684: Object type PACKAGE:"IWORKS"."COPAYCALCFLAG" already exists
.
.
.
ORA-31684: Object type VIEW:"IWORKS"."VWTREE" already exists
ORA-31684: Object type VIEW:"IWORKS"."V_ROUTE_DTL_GROUP" already exists
.
.
.
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-06550: line 2, column 11:
PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "VARCHAR2" to continue.
ORA-06550: line 3, column 12:
PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:

:= . ( @ % ;
The symbol ":=" was substituted for "VARCHAR2" to continue.
ORA-06550: line 4, column 19:
PLS-00103: Encountered the symbol "VARCHAR
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-06550: line 6, column 16:
PLS-00103: Encountered the symbol "RAYSQLACCESS9889405" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "* was inserted before "RAYSQLACCESS9889405" to continue.
ORA-06550: line 7, column 17:
PLS-00103: Encountered the symbol "SQL" when expectin
Job "SYSTEM"."IMPGEMDEV041608" completed with 2831 error(s) at 15:30:37

Any help will be much appreciated