1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

SQL*Loader-00470: table string does not have system
generated OID

Question Posted / guest

Answer Posted / guest

Cause: You specified an OID clause for a table but the table
is either not an object table or the table is an object
table but the OIDs for the rows are not system generated.

Action: Verify that the you are loading the correct table.
If you are, then you must not specify the OID clause for
this table. You should use the OID clause only when the
table is an object table, has system generated OIDs and when
you want to specify OIDs to be assigned to each row of the
table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-16627: No standby databases support the overall protection mode.

3552

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2299

IMG-02003: 2FF03 - incorrect color histogram feature specification

1199

ORA-26028: index string.string initially in unusable state

3398

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1748




ORA-26084: direct path context already finished

1482

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2620

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2287

ORA-26027: unique index string.string partition string initially in unusable state

6155

ORA-26030: index string.string had string partitions made unusable due to:

1558

IMP-00070: Lob definitions in dump file are inconsistent with database.

1286

ORA-16626: failed to enable specified object

1769

RMAN-05017: no copy of datafile number found to recover

1881

ORA-26094: stream format error: input column overflow

2248

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2313