ORA-19376: no privileges on tablespace provided or tablespace is offline Database version: Oracle 11g Release 2 (11.2) Cause: The user tried to create a staging table on a tablespace on which he does not have any space allocated, or it is offline Solution: Allocate space on the tablespace, bring it online, and retry  Read More →

ORA-19375: no CREATE TABLE privilege on schema “string” Database version: Oracle 11g Release 2 (11.2) Cause: The user tried to create a staging table when he is missing the CREATE TABLE privilege on the specified schema. Solution: Grant the privilege to the user and retry  Read More →

ORA-19374: invalid staging table Database version: Oracle 11g Release 2 (11.2) Cause: The user specified an invalid staging table to one of the pack, unpack, or remap stgtab routines, or the user does not have the correct privileges on the staging table Solution: Provide a correct staging table or grant the appropriate privileges  Read More →

ORA-19373: invalid staging table or tablespace Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to create a staging table and specified an invalid staging table (or one that already exists) or tablespace Solution: Check the arguments and try again.  Read More →

ORA-19372: invalid update condition Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to call load_sqlset with an invalid update condition. Solution: Check the update condition (e.g., NEW.COL1_NAME >= OLD.COL2_NAME) and retry the operation.  Read More →

ORA-19371: invalid update option Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to call load_sqlset with an update option that is different than REPLACE and ACCUMULATE. Solution: Adjust the update option and retry the operation.  Read More →

ORA-19361: ONLINE option not allowed with this type of index Database version: Oracle 11g Release 2 (11.2) Cause: The ONLINE option was specified to validate the structure of a system-generated metadata index Solution: The ONLINE option can not be used with system-generated metadata indexes such as an LOB index, an IOT Top index, an Index on Clusters etc., Run query without using the ONLINE... 

ORA-19336: Missing XML root element Database version: Oracle 11g Release 2 (11.2) Cause: The XML being generated does not have an enclosing root element. Solution: The XML generated must have a root element  Read More →

ORA-19335: Invalid format type object Database version: Oracle 11g Release 2 (11.2) Cause: An invalid format type object was specified for the XML function Solution: Specify a valid format type object  Read More →

ORA-19334: Invalid column specification for CREATE_DBURI operator Database version: Oracle 11g Release 2 (11.2) Cause: All columns must be valid and pointing to the same table or view Solution: Specify valid list of columns that are from the same table or view.  Read More →

ORA-19333: Invalid flags for the CREATE_DBURI operator Database version: Oracle 11g Release 2 (11.2) Cause: The flags argument given to the DBURI operator is invalid Solution: Specify a valid flag value (TEXT) for the DBURI operator  Read More →

ORA-19332: Invalid column in the CREATE_DBURI operator Database version: Oracle 11g Release 2 (11.2) Cause: The argument to the CREATE_DBURI operator can only be a column. Solution: Specify a valid column name for the operator  Read More →