Oracle Database Errors or Warnings from Error ORA-39803 to ORA-39903

SQLServerF1

ORA-39803: Data saves are not allowed on tables with partitioning referential constraints.
Cause: Data saves (and the sqlldr ROWS parameter) are not allowed when loading both the parent and child tables of a partitioning referential constraint.
Action: Do not attempt data saves when loading both the parent and child tables of a partitioning referential constraint.
ORA-39804: The load was aborted due to an error loading parent string while also loading child string.
Cause: An error occurred while loading the child and parent table of a partitioning referential constraint. The load was aborted to ensure the partitioning referential constraint was not violated.
Action: Fix the error that caused the load to abort and retry.
ORA-39805: Parallel loads are not allowed when loading child and parent.
Cause: A parallel load was requested when loading the child and parent of a partitioning referential constraint. This is not allowed.
Action: Remove the parallel option.

ORA-39806: The attempt to lock string parent table string string string failed.
Cause: While loading the child table of a partitioning referential constraint, the parent table must be locked in SHARE mode.
Action: Determine why the parent table could not be locked and retry.
ORA-39807: Partial data save on child string was ignored.
Cause: An attempt was made to partially save data when loading both the child and parent of a partitioning referential constraint or when loading a table with a domain index.
Action: Fix the error that caused the partial load and retry.
ORA-39808: The SINGLEROW option must be specified for parent table string.
Cause: The SINGLEROW option was not specified when loading both the parent and child table of a partitioning referential constraint.
Action: Ensure the SINGLEROW option is specified for the parent when loading the parent and child of a partitioning referential constraint.

ORA-39809: Data saves are not allowed on tables with domain indexes.
Cause: Data saves (and the sqlldr ROWS parameter) could not be allowed when loading a table with domain indexes.
Action: Do not attempt data saves when loading a table with domain indexes.
ORA-39901: Partitioned table string.string is partially contained in the transportable set.
Cause: Informational message to describe a failure during transportable containment checking.
Action: Check table partitions by querying SYS.DBA_TAB_PARTITIONS.
ORA-39902: Subartitioned table string.string is partially contained in the transportable set.
Cause: Informational message to describe a failure during transportable containment checking.
Action: Check table subpartitions by querying SYS.DBA_TAB_SUBPARTITIONS.
ORA-39903: IOT Partition string.string is partially contained in the transportable set.
Cause: Informational message to describe a failure during transportable containment checking.
Action: Check table partitions by querying SYS.DBA_IND_PARTITIONS.

Above are list of Oracle Database Errors or Warnings from Error ORA-39803 to ORA-39903 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *