Saturday, December 28, 2013

ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal

Error Description 

Import: Release 11.2.0.3.0 - Production on Thu Dec 26 13:48:26 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "CORP2012"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "CORP2012"."SYS_IMPORT_FULL_01":  CORP2012/******** directory=IMPDP dumpfile=26122013_1100-CORPORATE.DMP remap_schema= logfile= full=y
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"CORP2012" 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/TYPE/TYPE_SPEC
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."SPLIT_TBL"   OID 'ECD98FAC59A9469F8E458BDC2567F955' AS TABLE OF VARCHAR2 (32767)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."MONTHWISESALES_OBJ_TYPE"   OID '8C344D8083BC496499E0FB3822C37F9F' IS OBJECT
(
ITEMNUMBER VARCHAR2(20),ITEM1  VARCHAR2(150),ITEMGROUP VARCHAR2(150),FMAXSALES NUMBER(15,2),
SMAXSALES NUMBER(15,2) ,THIRTYSALES NUMBER(15,2),JAN NUMBER(15,2),FEB NUMBER(15,2),MAR NUMBER(15,2),APR NUMBER(15,2),
MAY NUMBER(15,2),JUN NUMBER(15,2),JUL NUMBER(15,2),AUG NUMBER(15,2),SEP NUMBER(15
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."STOCKDTL_OBJ_TYPE"   OID '4E3C080CC3F94EB9947FEE8769738BD3' IS OBJECT
(
ITEMNUMBER VARCHAR2(20),ITEM1  VARCHAR2(150),ITEMGROUP VARCHAR2(150),PENDINGPR NUMBER(15,2),poqty number(15,2),
CLSTOCK NUMBER(15,2),PORTQTY NUMBER(15,2),ONWAY NUMBER(15,2)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."BDFTREETYPE"   OID '9C2BA68B02FA4BFCBFD19561C64A3C2C' AS OBJECT (
PARENTNO NUMBER,
CHILDNO NUMBER,
SID NUMBER,
SC_CODE VARCHAR2 (500),
SD_CODE VARCHAR2 (500),
SRD_CODE VARCHAR2 (500),
NIIN_NO VARCHAR2 (100),
ITEMNAME VARCHAR2 (500),
WUC_CODE VARCHAR2 (100),
WUC_DESC VARCHAR2 (500),
SERIALNO VARCHAR2 (100),
DOCID VARCHAR2 (100),
TREEDESCRIPTION VARCHAR2 (1000),
APPCODE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."SPLIT_TBL1"   OID 'DD944536D2EB453B8A965D8502B03C14' AS TABLE OF CLOB
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."FUNDFLOW_OBJ_TYPE"   OID '044C10C96FAD403FB31DBB9B72B02838' IS OBJECT
(
ACCOUNT VARCHAR2(100),INAMOUNT NUMBER(15,2),OUTAMOUNT NUMBER(15,2))
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."MONTHWISESALES_TABTYPE"   OID '260BF5B33A7D481CA814B61766ED47DA' AS TABLE OF MONTHWISESALES_OBJ_TYPE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."STOCKDTL_TABTYPE"   OID '2DD34594CE534F01AC4E0E1EE3396186' AS TABLE OF STOCKDTL_OBJ_TYPE
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."BDFARRAYTYPE"   OID '9645FBF504544A508531FA40C217F950' AS TABLE OF BDFTREETYPE;
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "CORP2012"."FUNDFLOW_TABTYPE"   OID '4FA8101A71344FE5A3394AEB14D79F24' AS TABLE OF FUNDFLOW_OBJ_TYPE


Solution

CORP2012/******** directory=IMPDP dumpfile=26122013_1100-CORPORATE.DMP logfile=CORP2012_28122013.log REMAP_SCHEMA=CORPORATE:CORP2012 TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n 



No comments: