ORA-39120: Table string can't be truncated, data will be
skipped. Failing error is: string



ORA-39120: Table string can't be truncated, data will be skipped. Failing error is: string..

Answer / guest

Cause: Table data was about to be loaded into a table that
already existed and the table_exists_action parameter is
truncate, but the table could not be truncated.

Action: Determine actual cause by looking at base error.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16555: The Data Guard database is not active.

1 Answers  


ORA-13357: extent type does not contain 2 points

1 Answers  


[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

0 Answers   HCL,


ORA-16540: invalid argument

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  






ORA-09927: Unable to set label of server

1 Answers  


ORA-16514: the request was not found

1 Answers  


ORA-25303: Buffered operation allowed only on the owner instance

1 Answers  


ORA-09932: Close of ORACLE password file failed.

1 Answers  


ORA-15132: block string of file string in diskgroup string could not be written

1 Answers  


TNS-12678: Authentication disabled but required

1 Answers  


ORA-16792: Some configurable property value is inconsistent with the database setting.

1 Answers  


Categories