| Avnish |
Posted: Mar 03, 2008 06:35:30 AM |
Total Post: 146
Joined: Dec, 2007
|
Hi,
please help regarding import problems. i m importing one of my users data when i got theses errors:
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "DSCRPNCY_NST" TIMESTAMP '2008-02-18:14:31:27' OID '5D828CDF418"
"742FD952E881886D142F2' IS TABLE OF VARCHAR2(100) "
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
and second one is like :
IMP-00063: Warning: Skipping table "user"."table1" because object type "user"."table2" cannot be created or has different identifier
how can solve these problems & what is the problem indicating these Ora errrors:
Thanks in advance |
|
|
 Mohammed Taj |
| Posted: Mar 03, 2008 06:50:03 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Can you give us ORACLE VERSION WITH OS information.
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 03, 2008 04:34:15 PM | |
|
Total Post: 133
Joined: Nov, 2007
|
Every type have an object identifier you can know it from this query
SELECT TYPE_OID FROM DBA_TYPES WHERE TYPE_NAME = 'CUST_ADDRESS_TYP';
TYPE_OID
--------------------------------
6F9BC33653681B7CE03400400B40A607Or,
it seeem that your object identifier for your imported type had been taken by existing type
or
the object type already existed, with a different object identifier, then drop the object type and retry the import.
|
|
|
|
|
| Avnish |
| Posted: Mar 05, 2008 12:36:37 AM | |
|
Total Post: 146
Joined: Dec, 2007
|
hi,
sry for late response.
My OS is windows server 2003 standard edition
Oracle 10g ver 10.2.0.1.0
|
|
|
|
|
| Avnish |
| Posted: Mar 05, 2008 12:38:57 AM | |
|
Total Post: 146
Joined: Dec, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
