Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / 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

More Oracle Errors Interview Questions

KUP-04089: column transform string is not the name of a table column

1 Answers  


QSM-02077: mv log is newer than last full refresh

1 Answers  


ORA-12992: cannot drop parent key column

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


ORA-00480: LCK* process terminated with error

1 Answers  






ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


ORA-08194: Flashback Table operation is not allowed on materialized views

1 Answers  


PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)

1 Answers  


ORA-09792: sllfop: cannot allocate read buffer.

1 Answers  


DRG-11605: URL store: document specified by string not found

1 Answers  


LSX-00229: item type is not a valid type for a list simple type

1 Answers  


NNO-00306: server shutdown countdown aborted

1 Answers  






Categories