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 

How to increase no. of sessions in oracle database?

If you want to increase sessions parameter you should consider increasing processes and transactions parameter as well.

Here is the formula you can use to determine their values.

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

E.g.
processes=500
sessions=555
transactions=610

Commands:-
sqlplus "/as sysdba"
or
sqlplus '/as sysdba'


sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions
sql> alter system set processes=500 SCOPE=SPFILE; 
sql> alter system set sessions=555 SCOPE=SPFILE; 
sql> alter system set transactions=610 SCOPE=SPFILE; 

and Restart the database.

Below parameters values also must be changed.....

sql>alter system set open_cursors=1500 scope=both;
sql>alter system set processes=3000 scope=spfile;
sql>alter system set job_queue_processes=4 scope=both;
sql>alter system set undo_retention=10800 scope=both;
sql>alter system set max_shared_servers=50 scope=both;
sql>alter system set db_files=2000 scope=spfile; 
sql>alter system set sessions=3305 SCOPE=SPFILE;  
sql>alter system set transactions=3635 SCOPE=SPFILE;