ORA-38001 to ORA-39975

89 ORA-38001 to ORA-39975

ORA-38001: RBO Disable constant predicate elimination optimization
ORA-38002: CBO enable restriction on type of join (NL only) for a query block with pushed predicate
ORA-38003: CBO Disable column stats for the dictionary objects in recursive SQL
ORA-38004: CBO (9.0.1 ONLY) Enable column stats for the dictionary objects in recursive SQL
ORA-38005: CBO disable fix for bug 2251373
ORA-38006: DBMS_STATS override commit threshold for (sub)partition level stats
ORA-38008: CBO disable costing overhead of inlist iteration
ORA-38009: CBO disable fix for bug 2109825
ORA-38010: CBO disable push predicate, driven by functional index into PV
ORA-38011: CBO disable truncation of bind when dealing with fixed char descend index expression
ORA-38012: CBO disable normalization of b-tree index selectivity
ORA-38013: CBO disable delayed ANY=>EXISTS conversion for colocated subquery of CTAS
ORA-38015: CBO enable unnesting of more than one subquery based on CVM
ORA-38016: CBO disable full functional index scan
ORA-38017: CBO disable push of join predicate for a table with RLS
ORA-38018: CBO disable full statistics load for evaluation of average row length
ORA-38020: CBO disable fix for bug 2324795
ORA-38021: CBO disable view merge with multi-referenced non-deterministic function
ORA-38022: CBO disable Distinct Sort Elimination at subquery unnest
ORA-38023: CBO disable fix for bug 2853398
ORA-38025: CBO enable generation of excessive semijoin subqueries
ORA-38026: CBO enable bitmap plan based on domain index, with no domain index driver
ORA-38027: CBO disable evaluation column gnd using inlist gnd
ORA-38028: DBMS_STATS disable small object optimization
ORA-38029: object statistics are locked: Cause: An attept was made to modify optimizer statistics of the object.; Action: Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS procedure on base table(s). Retry the operation if it is okay to update statistics.
ORA-38030: CBO enable strongly connected preds for intersect to join
ORA-38031: CBO disable the fix for bug 2663857
ORA-38032: CBO disable the fix for bug 3063008
ORA-38033: CBO disable costing of push join predicate in OJ view
ORA-38034: CBO disable the fix for bug 2871645
ORA-38036: NSO disable the fix for bug 3070157
ORA-38037: CBO disable the fix for bug 3405237
ORA-38038: CBO disable the fix for bug 3168961
ORA-38039: CBO enable view merge/ subquery ANY=>EXISTS conversion having view(subquery) predicates in front of outer query block (connecting) predicates
ORA-38040: DBMS_STATS minimum sample size in number of rows (0 = internal default)
ORA-38041: DBMS_STATS auto_sample_size overrides
ORA-38042: CBO disable usage of tjp when generating pruning subquery
ORA-38044: CBO disable expression folding at evaluation of a predicate selectivity
ORA-38047: CBO disable join back elimination of 1-row tables
ORA-38048: CBO enable the fix for bug 3400412
ORA-38049: CBO disable the fix for bug 3406977
ORA-38050: CBO disable the fix for bug 2943173
ORA-38051: CBO disable the fix for bug 3349903
ORA-38052: CBO disable the fix for bug 3317309
ORA-38053: DBMS_STATS override automatic sample size adjustment
ORA-38054: VOP enable the fix for bug 3537765
ORA-38055: CBO disable the fix for bug 3193835
ORA-38056: CBO disable peeking of form func(:b) bug 3668224
ORA-38057: CBO disable special numeric string normalization for bug 3567928
ORA-38058: CBO disable the fix for bug 3756797
ORA-38060: CBO enable the fix for bug 3517431(enable NL with view on right side)
ORA-38061: CBO disable unnest of a subquery with WITH subqueries
ORA-38063: CBO disable the fix for bug 3903100
ORA-38064: CBO disable the fix for bug 3488546
ORA-38065: CBO disable the fix for bug 3746511
ORA-38066: NSO regulate unnesting, semijoin elimination for IN and EXISTS subqueries with a view
ORA-38067: CBO enable peeking at replaced literal in equality(inequality) predicate
ORA-38068: CBO enable override of guess impact on index choice
ORA-38069: CBO disable duplicate predicate elimination
ORA-38073: CBO disable the fix for bug 4308414
ORA-38074: CBO disable the fix for bug 4275716
ORA-38075: CBO enables fix for bug 4235962
ORA-38076: CBO enables fix for bug 4258835
ORA-38077: CBO enables fix for bug 4488689
ORA-38078: CBO disables fix for bug 4708389
ORA-38079: SQL Diagnostic
ORA-38087: dbms_stats enable fix of bug 5842686
ORA-38090: CBO dump virtual columns in EXPLAIN PLAN
ORA-38091: CBO forces native full outer join
ORA-38094: dbms_stats enable fix of bug 6934892
ORA-38098: CBO reject various transformation even if chosen
ORA-38100: enable tracing of DML frequency tracking
ORA-38101: Invalid column in the INSERT VALUES Clause: string: Cause: INSERT VALUES clause refers to the destination table columns; Action: n/a
ORA-38102: Invalid column in the INSERT WHERE Clause: string: Cause: INSERT WHERE clause refers to the destination table columns; Action: n/a
ORA-38103: Invalid column in the UPDATE SET Clause: string: Cause: UPDATE SET clause refers to the source table columns in the LHS; Action: n/a
ORA-38104: Columns referenced in the ON Clause cannot be updated: string: Cause: LHS of UPDATE SET contains the columns referenced in the ON Clause; Action: n/a
ORA-38105: Delete not yet supported when Update row-migration is possible: Cause: When Update Row-Migration is possible, Delete in MERGE is not yet supported; Action: n/a
ORA-38106: MERGE not supported on join view or view with INSTEAD OF trigger.: Cause: The MERGE operation contained a join view or view with INSTEAD of trigger which is not supported.; Action: When using MERGE to modify a view, you must only specify a single table in the view, and the view cannot have an INSTEAD OF trigger.
ORA-38131: specified SQL handle string does not exist: Cause: The specified SQL handle did not exist in the repository.; Action: Specify correct SQL handle.
ORA-38132: specified SQL ID string does not exist: Cause: The SQL statement for SQL ID did not exist in the cursor cache.; Action: Specify correct SQL ID.
ORA-38133: invalid parameter name string specified: Cause: An invalid parameter name was specified.; Action: Verify the name of the parameter.
ORA-38134: invalid parameter value string specified: Cause: An invalid parameter value was specified.; Action: Verify the parameter value.
ORA-38135: invalid fixed status value specified: Cause: Specified fixed status value was neither YES or NO.; Action: Specify either 'YES' or 'NO'.
ORA-38136: invalid attribute name string specified: Cause: An invalid attribute name was specified.; Action: Verify the name of the attribute.
ORA-38137: invalid attribute value string specified: Cause: An invalid attribute value was specified.; Action: Verify the attribute value.
ORA-38138: plan name is missing or NULL: Cause: A valid plan name was not specified.; Action: Specify a valid plan name.
ORA-38139: concurrent DDL Error in load plans operation: Cause: A concurrent DDL operation was performed during a load plans operation.; Action: Try operation again.
ORA-38140: no SQL plan baselines were found: Cause: No SQL plan baselines were found during pack or unpack operation.; Action: Specify correct selection criterion.
ORA-38141: SQL plan baseline string does not exist: Cause: A SQL plan baseline name was specified that did not exist.; Action: Verify the name of the SQL plan baseline.
ORA-38142: SQL plan baseline named string already exists: Cause: A SQL plan baseline already exists with the name specified.; Action: Specify a different name or drop the existing SQL plan baseline.
ORA-38143: invalid enabled status value specified: Cause: Specified enabled status value was neither YES or NO.; Action: Specify either 'YES' or 'NO'.
ORA-38144: specified plan name string does not exist: Cause: The specified plan name did not exist in the repository.; Action: Specify correct plan name.
ORA-38145: neither SQL handle nor plan name specified: Cause: The SQL handle or plan name was not specified. The SQL handle or plan name is required.; Action: Specify either SQL handle or plan name or both.
ORA-38146: invalid verify value specified: Cause: Specified verify value was neither YES or NO.; Action: Specify either 'YES' or 'NO'.
ORA-38147: invalid commit value specified: Cause: Specified commit value was neither YES or NO.; Action: Specify either 'YES' or 'NO'.
ORA-38148: invalid time limit specified: Cause: Specified time limit value was not a positive integer.; Action: Specify a positive integer value.
ORA-38149: There is no recommended action for object string in task string.: Cause: The advisor did not generate a recommended action for the given object and task.; Action: Choose a different object and retry the operation.
ORA-38150: not enough room for filter length string; string characters remaining: Cause: An auto-capture filter was too large to fit in the remaining space. Each filter requires a number of characters equal to the size of its value plus one.; Action: Remove other filters to make room for the new filter.
ORA-38151: module name is too long: Cause: The provided module name was too long.; Action: Provide a valid module name.
ORA-38152: action name is too long: Cause: The provided action name was too long.; Action: Provide a valid action name.
ORA-38153: Software edition is incompatible with SQL plan management.: Cause: SQL plan management could be used only with Oracle Database Enterprise Edition.; Action: Ensure that Oracle is linked with the Enterprise Edition options.
ORA-38171: Insufficient privileges for SQL management object operation: Cause: A DDL operation was attempted on a SQL management object by a session without the proper privileges.; Action: Grant the appropriate privilege.
ORA-38172: No SQL management object satisfies specified filters: Cause: An attempt was made to perform an operation by specifying filters that did not target any SQL management objects.; Action: Try different filters.
ORA-38173: Invalid value string specified for SQL management object attribute string: Cause: An invalid attribute value was specified.; Action: Specify a valid attribute value.
ORA-38301: can not perform DDL/DML over objects in Recycle Bin: Cause: Tried to perform DDL or DML operation on Recycle Bin object.; Action: DDL or DML operations are not permitted on Recycle Bin objects.
ORA-38302: invalid PURGE option: Cause: Invalid purge option specified.; Action: Specify a valid purge option.
ORA-38303: invalid option for PURGE TABLESPACE: Cause: Either a token other than USER was found following the tablespace name or some text was found following USER user name.; Action: Place nothing or only USER user name after the tablespace name
ORA-38304: missing or invalid user name: Cause: A valid user name was expected.; Action: Specify a valid user name.
ORA-38305: object not in RECYCLE BIN: Cause: Trying to Flashback Drop an object which is not in RecycleBin.; Action: Only the objects in RecycleBin can be Flashback Dropped.
ORA-38306: this object is not recoverable standalone: Cause: Trying to flashback drop an object other than of type TABLE.; Action: Only tables are recoverable.
ORA-38307: object not in RECYCLE BIN: Cause: Trying to Purge the object which is not in RecycleBin.; Action: Only the objects in RecycleBin can be PURGEDED.
ORA-38308: invalid FLASHBACK DROP option: Cause: Invalid Flashback Drop option specified.; Action: Specify a valid Flashback Drop option.
ORA-38309: object not purgable: Cause: An attempt was made to purge an object that is either not purgable or else dependent upon some other object.; Action: Cannot purge this object.
ORA-38310: cannot purge tablespace for other users: Cause: An attempt was made to purge the tablespace for a different user by a user who does not have system DBA priviledges.; Action: Cannot purge the tablespace for some other user.
ORA-38311: cannot purge objects owned by other users: Cause: An attempt was made to purge an object which is owned by some other user.; Action: Cannot purge this object.
ORA-38312: original name is used by an existing object: Cause: An attempt was made to recover an object preserving the original name, but that name is taken up by some other object.; Action: use the RENAME clause to recover the object with a different name.
ORA-38320: policy does not exist: Cause: An attempt was made to delete a nonexistent policy.; Action: Correct the policy name.
ORA-38321: duplicate policy name specified: Cause: A policy name was specified that already existed under this schema.; Action: Correct the policy name.
ORA-38322: scope of policy not specified: Cause: An attempt was made to add a policy without the scope.; Action: Specify a scope when creating a policy.
ORA-38323: policy conflicts with policy string: Cause: An attempt was made to create a policy with the same action type and based on the same statistic as another policy on the object.; Action: Use a different action and/or statistic for the new policy, or delete the old policy.
ORA-38324: policy conflicts with policy string: Cause: An attempt was made to create a policy with the same action, scope and compression level as another policy on the object.; Action: Use a different action, scope and/or level for the new policy, or delete the old policy.
ORA-38325: policy conflicts with policy string: Cause: An attempt was made to create a compression policy that conflicts with another policy on the object.; Action: Change the policy so that policies with a higher compression level take effect after policies with a lower compression level, or delete the old policy.
ORA-38326: schema level policies are not supported: Cause: Attempt was made to create a schema level policy.; Action: Do not create a schema level policy.
ORA-38327: invalid argument value: Cause: The specified API argument values were of the wrong value range.; Action: Supply valid values for the API.
ORA-38328: inconsistent internal state: Cause: An inconsistency was detected in ILM related data in the dictionary.; Action: Contact Oracle Support Services.
ORA-38329: internal ILM error: Cause: An internal error occurred during execution of ILM related activity. Further information can be found in the alert log.; Action: Fix the problem and retry the operation.
ORA-38330: insufficient privilege for ILM operation: Cause: Sufficient privileges were not granted for the ILM operation.; Action: Retry operation with sufficient privileges granted. Consult documentation for privileges required to perform the ILM operation.
ORA-38331: row-level write activity tracking not enabled on the table: Cause: An attempt was made to create a modification time-based policy when row-level write tracking was not enabled on the object.; Action: Ensure that row-level write tracking is enabled on the table.
ORA-38332: valid time periods were not present on the table: Cause: An attempt was made to create a valid time-based policy when valid time periods were not present on the table.; Action: Add valid time periods to the table.
ORA-38333: row-level access activity tracking not enabled on the table: Cause: An attempt was made to create an access time-based policy when row-level access tracking was not enabled on the object.; Action: Ensure that row-level access tracking is enabled on the table.
ORA-38334: segment-level access activity tracking not enabled on the table: Cause: An attempt was made to create an access time-based policy when segment-level access tracking was not enabled on the object.; Action: Ensure that segment-level access tracking is enabled on the table.
ORA-38335: sysdba privilege is required: Cause: SYSDBA privilege is required for applying ILM policies on a tablespace.; Action: Grant user SYSDBA role before applying tablespace level ILM policies.
ORA-38336: invalid policy: Cause: A row level policy was used with a compression level other than OLTP.; Action: Use the OLTP compression level with row level compression policies.
ORA-38337: invalid policy: Cause: A custom policy is only allowed at the segment level.; Action: Change the scope of the policy to be of type segment.
ORA-38338: incorrect ILM policy scope: Cause: An attempt was made to create an Information Lifecycle Management (ILM) policy with incompatible scope.; Action: Ensure that the scope of the ILM policy is compatible.
ORA-38339: invalid action specified: Cause: An invalid action was specified in the policy definition.; Action: Specify a valid action in the policy definition.
ORA-38340: invalid policy: Cause: An attempt was made to create a custom policy at the tablespace level.; Action: Specify the policy directly on the desired objects.
ORA-38341: policy conflicts with policy string: Cause: An attempt was made to create more than one storage tiering policy directly on an object.; Action: Delete the conflicting policy before creating a new policy.
ORA-38342: heat map not enabled: Cause: An attempt was made to create an Information Lifcecycle Management (ILM) policy when heat map was not enabled.; Action: Enable heat map before creating a new ILM policy.
ORA-38343: ADO online mode not supported with supplemental logging enabled: Cause: An attempt was made to perform an automatic data optimization (ADO) operation with supplemental logging enabled.; Action: Disable supplemental logging or switch to ADO offline mode and retry.
ORA-38345: object not enabled for in-memory column store: Cause: An attempt was made to create a policy on an object that was not enabled for in-memory column store.; Action: Enable the object for in-memory column store and specify the policy.
ORA-38346: ILM operation not supported: Cause: An attempt was made to use an Information Lifecycle Mangement (ILM) operation that is not supported for the current SQL statement.; Action: Use the operation with a supported SQL statement.
ORA-38347: join group cannot be created: Cause: Join group cannot be created on the specified tables.; Action: Check to see that the database is not in standby mode and has read-write privileges, the specified tables for creating join group are ready for processing and the dictionary tables im_domain$, im_joingroup$ are also present. Then, retry the operation.
ORA-38348: join group cannot be dropped: Cause: The specified join group cannot be dropped.; Action: Check to see that the database is not in standby mode and has read-write privileges, and the dictionary tables im_domain$, im_joingroup$ are present. Then, retry the operation.
ORA-38349: join group cannot be altered: Cause: The specified join group cannot be altered.; Action: Check to see that the database is not in standby mode and has read-write privileges, the specified tables used in altering join group are ready for processing and the dictionary tables im_domain$, im_joingroup$ are also present. Then, retry the operation.
ORA-38350: join group not supported on given columns: Cause: One of the columns used for the join group was not supported because the column property field was non-zero.; Action: Retry the operation on the join group without including the unsupported column.
ORA-38351: join group (string) not supported on abstract data type columns: Cause: One of the columns used for the join group was of the abstract data type.; Action: Retry the operation on the join group without including columns of the abstract data type.
ORA-38352: cannot alter column present in a join group: Cause: The alter table operation caused one of the columns to become unsupported for a join group.; Action: Drop the column from the join group and retry the operation.
ORA-38353: This table type is not supported by the ROW ARCHIVAL clause.: Cause: An attempt was made to create or alter table to enable ROW ARCHIVAL, but ROW ARCHIVAL is not supported for these table types.; Action: None
ORA-38354: syntax error; operation on join group cannot be done: Cause: There was a syntax error found for either the create, alter, or drop in-memory join group.; Action: Use the correct syntax.
ORA-38388: cannot add ILM policy to a bitmap index: Cause: An attempt was made to add an Information Lifecycle Management (ILM) policy to a bitmap index, which was not supported.; Action: No action required.
ORA-38389: cannot add ILM policy to an index-organized table: Cause: An attempt was made to add an Information Lifecycle Management (ILM) policy to an index-organized table, which was not supported.; Action: No action required.
ORA-38390: ILM policy operations not supported for cluster tables: Cause: An attempt was made to add an Information Lifecycle Management (ILM) policy for a cluster table, which was not supported.; Action: No action required.
ORA-38391: disabling ILM filtering
ORA-38393: ILM internal out-of-space error: Cause: Information Lifecycle Management (ILM) internal operation encountered out-of-space error.; Action: None
ORA-38394: test event for table ILM operations: Cause: Internal testing event for table Information Lifecycle Management (ILM) operations.; Action: None
ORA-38395: debug event for table ILM operations: Cause: There was an internal debugging event for table Information Lifecycle Management (ILM) operations.; Action: None
ORA-38396: table is already enabled for the ILM feature: Cause: The table was already enabled for the specified Information Lifecycle Management (ILM) feature.; Action: No action required.
ORA-38397: table is not enabled for the ILM feature: Cause: An attempt was made to perform an Information Lifecycle Management (ILM) operation on a table on which the specified ILM feature is not enabled.; Action: No action required.
ORA-38398: DDL not allowed on the system ILM column: Cause: An attempt was made to drop, rename, or modify a system Information Lifecycle Management (ILM) column.; Action: No action required.
ORA-38399: cannot update the system ILM column: Cause: An attempt was made to update a system Information Lifecycle Management (ILM) column.; Action: No action required.
ORA-38400: cannot combine ILM operation with other operations: Cause: An attempt was made to combine Information Lifecycle Management (ILM) operation with other ALTER TABLE operations.; Action: Ensure that ILM is the sole operation specified in ALTER TABLE.
ORA-38401: synonym string not allowed: Cause: An attempt was made to use a synonym for a data type of an attribute or a table alias.; Action: Use the object name instead of the synonym.
ORA-38402: invalid name: empty string or spaces in the name: Cause: There were spaces in the name.; Action: Remove spaces in the name or use quotes around the name.
ORA-38403: attribute set name may not be longer than 22 characters: Cause: The attribute set name was longer than 22 characters.; Action: Choose a name that has 22 or fewer characters.
ORA-38404: schema extension not allowed for the attribute set name: Cause: There was a schema extension for the attribute set name. Attribute sets are always created in the current schema and thus schema extended names are not allowed.; Action: Create the attribute set from the appropriate schema.
ORA-38405: quotes not allowed in the attribute set name: Cause: The attribute set name contained quotes.; Action: Remove quotes in the attribute set name.
ORA-38406: attribute set string already exists: Cause: An attribute set with a matching name already exists in the current schema.; Action: Drop the existing attribute set or choose a different name.
ORA-38407: The ADT associated with the attribute set already exists.: Cause: The Abstract type (ADT) with the same name as the attribute set already exists in the current schema.; Action: Create the attribute set for the existing ADT or drop the ADT.
ORA-38408: The ADT "string" does not exist in the current schema.: Cause: An attempt was made to create the attribute set from a nonexistent ADT.; Action: Make sure that the ADT with the same name as the attribute set exists in the current schema.
ORA-38409: invalid name or option for the attribute set: string: Cause: An invalid name or option was used for the attribute set.; Action: Set serveroutput ON and repeat the operation for additional information.
ORA-38410: schema extension not allowed for the table name: Cause: An attempt was made to use a schema extended name for the table storing expressions.; Action: The table storing expressions and the corresponding attribute set should be created in the same schema.
ORA-38411: invalid datatype for the column storing expressions: Cause: An attempt was made to create an expression column from a column of invalid datatype.; Action: Create a VARCHAR2 or CHAR column to store expressions in a table.
ORA-38412: Expression set column string does not exist.: Cause: The column storing expressions does not exist.; Action: Pass a valid name for the column storing expressions.
ORA-38413: elementary attribute name may not be longer than 32 characters: Cause: An attempt was made to create an elementary attribute with a name longer than 32 characters.; Action: Use a shorter name for the elementary attribute.
ORA-38414: invalid datatype for the attribute string: Cause: The datatype specified for the attribute was invalid.; Action: If the datatype is an ADT, make sure that the ADT exists and the current user has execute permissions to it.
ORA-38415: invalid name or datatype for the attribute: string: Cause: An invalid name or datatype was used for the attribute.; Action: Set serveroutput ON and repeat the operation for additional information.
ORA-38416: A stored attribute may not be longer then 300 characters.: Cause: An attempt was made to create a stored or indexed attribute longer than 300 characters.; Action: A predicate with such attribute may not be indexed. It will be evaluated as sparse predicate.
ORA-38417: attribute set string does not exist: Cause: An attempt was made to use an attribute set that does not exist.; Action: Create the attribute set or choose an existing attribute set.
ORA-38418: ADT associated with the attribute set string does not exist: Cause: The ADT with the same name as the attribute set was not found in the current schema.; Action: Drop the attribute set and recreate it.
ORA-38419: invalid identifier in attribute : string: Cause: An identifier used in the stored/indexed attribute sub-expression was not defined or was invalid.; Action: Create all the required elementary attributes and user-defined functions and try again.
ORA-38420: invalid stored attribute sub-expression: string: Cause: The sub-expression used for the stored expression was invalid.; Action: Set serveroutput ON and repeat the operation for additional information.
ORA-38421: attribute string already exists: Cause: An attribute with a matching name (or form) already exists in the attribute set.; Action: Drop the existing attribute or choose a different name for the new attribute.
ORA-38422: invalid datatype for the attribute: string: Cause: An attempt was made to create an attribute with invalid datatype.; Action: If the data type of the attribute is an ADT, make sure that the type exists.
ORA-38423: Attribute set created from an ADT may not be extended.: Cause: An attempt was made to add an elementary attribute to an attribute set created from an ADT.; Action: Create a new attribute set and add all the required elementary attributes one at a time.
ORA-38424: no attribute set currently assigned to the expression set: Cause: An attempt was made to un-assign an attribute set from an expression set when there is no attribute set assigned to it.; Action: No action is required.
ORA-38425: attribute set used for an index object may not be unassigned: Cause: An attempt was made to un-assign an attribute set from an expression set when there is an Expression Filter index defined on the column.; Action: Drop the index before un-assigning the attribute set.
ORA-38426: attribute set assigned to an expression set may not be dropped: Cause: An attempt was made to drop an attribute set when it is still associated with an expression set.; Action: Un-assign the attribute set from the expression set before dropping it.
ORA-38427: attribute string does not exist: Cause: An attempt was made to use an attribute set that does not exist.; Action: Create the attribute set.
ORA-38428: too many attributes selected for indexing: Cause: An attempt was made to create an expression filter index with more than 490 indexed attributes.; Action: Remove some of the indexed attributes. Make sure that the default indexed attributes associated with the attribute set combined with the indexed attributes specified in the Create Index Parameters clause are less than or equal to 490.
ORA-38429: invalid datatype for a stored attribute: string: Cause: The (resulting) datatype for the attribute was not appropriate for storing.; Action: Choose a stored attribute that has a resulting datatype of NUMBER, VARCHAR2, CHAR or DATE.
ORA-38430: Operation "string" not supported in the current release.: Cause: An attempt was made to perform an unsupported operation.; Action: Do not use the operation.
ORA-38431: could not evaluate subexpression "string" for rowid "string": Cause: Either the expression was not a valid SQL-WHERE clause format or it had references to nonexistent schema objects.; Action: Correct the expression.
ORA-38432: EVALUATE operator only allowed on an expression column: Cause: An attempt was made to use the EVALUATE operator on a column not configured as a column storing expressions.; Action: Assign an attribute set to the column.
ORA-38433: index "string" could not be maintained due to "string": Cause: The error was caused by the recursive operation.; Action: Fix the error and retry.
ORA-38434: could not evaluate expression "string": Cause: Either the expression was not in a valid SQL-WHERE clause format or it had references to nonexistent schema objects or there is a missing attribute value.; Action: Set serveroutput ON for more details.
ORA-38435: missing elementary attribute value or invalid name-value pairs: Cause: The second argument to the EVALUATE operator had either a missing attribute or an invalid value for an attribute.; Action: Try again after fixing the error.
ORA-38436: attribute set used for an Expression set may not be modified.: Cause: An attempt was made to add an elementary attribute to an attribute set assigned to an expression set.; Action: Un-assign the attribute set and try again.
ORA-38437: The ADT "string" may not contain any user methods.: Cause: An attempt was made to create an attribute set from an ADT that has one or more user methods.; Action: Drop the ADT and recreate it with no user methods.
ORA-38438: getVarchar not possible due to "string" datatype in the attribute set: Cause: An attempt was made to use the getVarchar API when the attribute set has one or more non-scalar types.; Action: Use AnyData conversion to encode the data item.
ORA-38439: invalid operation "string": Cause: An attempt was made to use an invalid operation.; Action: Use one of the following operations : ADD, DROP
ORA-38440: attribute set string does not exist: Cause: An attempt was made to copy an attribute set that is not accessible from the current schema.; Action: Grant execute permissions on the corresponding ADT to the current user and try again.
ORA-38441: System could not derive the list of STORED and INDEXED attributes.: Cause: The attribute set was created without default index parameters.; Action: Specify the default index parameters for the attribute set or include a valid PARAMETERS clause for the CREATE INDEX command.
ORA-38442: The ADT "string" is not in a valid state.: Cause: An attempt was made to use an ADT that is not in a valid state.; Action: Check the INCOMPLETE field in the user_types catalog view to make sure that the ADT is in a valid state. Drop the invalid ADT and recreate the corresponding attribute set.
ORA-38443: An attribute set should be assigned to the expression set for statistics collection.: Cause: An attempt was made to collect statistics for an expression set with no attribute set assigned to it.; Action: Assign an attribute set to the expression set before collecting the statistics.
ORA-38444: statistics do not exist for the expression set: Cause: An attempt was made to clear the statistics that do not exist.; Action: No action was required.
ORA-38445: TOP clause not allowed with no statistics: Cause: An attempt was made to use the TOP parameters clause with no statistics available for the expression set.; Action: Collect statistics for the expression set and try again.
ORA-38446: Error with embedded ADT "string" in the attribute set.: Cause: The embedded ADT has errors.; Action: Set serveroutput ON for additional information.
ORA-38447: Type required for the embedded ADT attribute "string" is missing: Cause: Object type required for the embedded ADT was missing.; Action: Set serveroutput ON for additional information.
ORA-38448: Indexing predicates with "string" operator is not supported.: Cause: An unsupported operator was used in the exf$indexoper array.; Action: Choose the operators from this list : =, <, >, <=, >=, !=, is null, is not null, nvl, and between.
ORA-38449: table "string" does not exist or is not accessible: Cause: An attempt was made to create a table alias for a table that does not exist or is not accessible.; Action: Grant select privileges on the table to the current user.
ORA-38450: error computing a stored attribute for the expression set.: Cause: Either values for one of the attributes was incorrect or a stored attribute was invalid due to broken dependencies.; Action: Correct the input.
ORA-38451: index is in an inconsistent state: Cause: One or more secondary objects used to maintain the index did not exist; Action: Drop the index and recreate it.
ORA-38452: Expression Filter index name may not be longer than 25 characters: Cause: An attempt was made to use a name longer than 25 characters for the Expression Filter index.; Action: Choose a name that has 25 or fewer characters
ORA-38453: ExpFilter index should be created in the same schema as the base table.: Cause: An attempt was made to create the Expression Filter index in a schema other than that of the base table.; Action: Create the index in the same schema as the base table.
ORA-38454: attribute set not defined for the column being indexed: Cause: An attempt was made to create an Expression Filter index on a column with no attribute set association.; Action: Assign an attribute set to the expression set column begin indexed.
ORA-38455: Expression Filter index should be created by the owner.: Cause: An attempt was made to create the Expression Filter index by a user who is not the owner of the index.; Action: Create the index using owner's privileges.
ORA-38456: The attribute set "string" is in an inconsistent state.: Cause: The attribute set was in an inconsistent state due to broken dependencies.; Action: Set serveroutput ON for more details. The attribute set may not be reused after this error.
ORA-38457: The attribute "string" is not a valid XMLType attribute.: Cause: An attempt was made to use a non-XMLType attribute to configure XPath filtering.; Action: Use an attribute of sys.XMLType datatype to configure XPath filtering.
ORA-38458: invalid operation "string" for XPATH_FILTER_PARAMETERS: Cause: An attempt was made to use an invalid operation.; Action: Use one of the following operations : ADD, DROP.
ORA-38459: XML Tag "string" not found for the XMLType attribute "string": Cause: An Attempt was made to use a non-existent XML Tag.; Action: Correct the name of the XML Tag or the XMLType attribute.
ORA-38460: filtering based on datatype "string" not supported for XML Tags: Cause: An attempt was made to configure XPath filtering with an XML Tag of unsupported datatype.; Action: Leave the XML Tag out of filter parameters. It will be processed as sparse predicate
ORA-38461: XML Tag "string" already exists for the XMLType attribute "string": Cause: An attempt was made to create a duplicate XML Tag.; Action: Choose a different XML Tag.
ORA-38462: invalid attribute list: Cause: The input was missing an attribute list or had null values for the attribute names.; Action: Correct the input.
ORA-38463: invalid XML Tag list: Cause: The input was missing a tag list or had null values for the tag names.; Action: Correct the input.
ORA-38464: expression set is not empty.: Cause: An attempt was made to assign an attribute set to a non-empty expression set.; Action: Use FORCE = 'TRUE' to validate all the existing expressions.
ORA-38465: failed to create the privilege checking trigger due to: string: Cause: Creation of the trigger failed due to the error listed in the message.; Action: Set serveroutput ON for more information.
ORA-38466: user does not have privileges to CREATE/MODIFY expressions: Cause: An attempt was made to INSERT or UPDATE a column storing expression without appropriate permissions.; Action: Appropriate privileges on the expression set should be granted by the owner of the expression set.
ORA-38467: user cannot GRANT/REVOKE privileges to/from himself: Cause: An attempt was made to GRANT or REVOKE privileges to or from the current user.; Action: The the to_user or from_user field should be different from the user performing the operation.
ORA-38468: column "string" is not identified as a column storing expressions.: Cause: An attempt was made to grant permission on a nonexistent expression set.; Action: Make sure that the table and the column exist and an attribute set is associated with the column.
ORA-38469: invalid privilege for an expression set: string: Cause: An attempt was made to use an invalid privilege.; Action: See documentation for a valid privilege.
ORA-38470: cannot revoke a privilege that was not granted.: Cause: An attempt was made to revoke a privilege that had not been granted.; Action: Check catalog views to see if the user has the privilege.
ORA-38471: ROWIDs for table aliases cannot be null: Cause: An attempt was made to pass a null value for the table alias attribute in the data item, which is not permitted.; Action: Pass a valid rowid value for the table alias.
ORA-38472: VARCHAR representation of the data item is too long.: Cause: The VARCHAR representation of data item was too long.; Action: Use the EVALUATE operator with AnyData argument instead.
ORA-38473: cannot drop a type used for Expression Filter attribute set: Cause: An attempt was made to drop an ADT that was used to maintain an attribute set for the Expression Filter.; Action: Query USER_EXPFIL_ATTRIBUTE_SETS view to see the dependency.
ORA-38474: attribute set may not have attributes of TABLE COLLECTION type.: Cause: An attempt was made to create an attribute with a TABLE COLLECTION type.; Action: Use VARRAYs instead of table collection, if possible.
ORA-38475: The attribute set and the associated ADT are out of sync.: Cause: The ADT was directly modified by CREATE or ALTER operations.; Action: Drop the attribute set and recreate it from scratch.
ORA-38476: abstract type used for an Attribute set may not be modified.: Cause: An attempt was made to alter a type (ADT) that is used to maintain an attribute set of an Expression set.; Action: Do not modify the ADT directly. Use DBMS_EXPFIL APIs instead.
ORA-38477: attribute set cannot be derived from an evolved type or a subtype.: Cause: An attempt was made to create an attribute set from an evolved ADT or a subtype.; Action: The ADT used for the attribute set cannot be an evolved type or a subtype.
ORA-38478: creation of system trigger EXPFIL_DROPOBJ_MAINT failed: Cause: The creation of the system trigger EXPFIL_DROPOBJ_MAINT failed due to missing Expression Filter dictionary tables.; Action: Try a clean installation again. If this error is ignored, the Expression Filter dictionary could have some stale entries.
ORA-38479: creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed: Cause: The creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed due to missing Expression Filter dictionary tables.; Action: Try a clean installation again. If this error is ignored, the user will be able to evolve ADTs associated with the attribute set, thus causing spurious errors.
ORA-38480: creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.: Cause: The creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed due to errors in SYS.EXF$DBMS_EXPFIL_SYSPACK package.; Action: Try a clean installation again. If this error is ignored, a RENAME of the expression table may cause the EVALUATE queries to fail.
ORA-38481: ADT "string" is used for a dependent object.: Cause: An attempt was made to create an attribute set from an ADT which is used by one or more dependent objects.; Action: Use a new ADT instead.
ORA-38482: no elementary attributes defined in the attribute set: Cause: An attempt was made to use an empty attribute set.; Action: Create one or more elementary attributes for the attribute set.
ORA-38483: invalid FUNCTION/PACKAGE/TYPE name: "string": Cause: An attempt was made to use an invalid name format.; Action: The function/package/type name should be specified in the following format [owner.]object_name
ORA-38484: FUNCTION/PACKAGE/TYPE string does not exist: Cause: Attempt was made to use a object that does not exist.; Action: Query ALL_OBJECT view to ensure that the object exists.
ORA-38485: invalid object type for the user-defined function: Cause: An attempt was made to use an invalid object as a function.; Action: Valid object types are FUNCTION / PACKAGE / TYPE
ORA-38486: FUNCTION/PACKAGE/TYPE already exists for the attribute set: Cause: An attempt was made to add a duplicate function to the list.; Action: Use a different object name.
ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression: Cause: An attempt was made to use an un-approved function in the expression.; Action: Add the function to the corresponding attribute set
ORA-38488: attribute set already assigned to the column storing expressions: Cause: An attempt was made to reassign an attribute set to an expression column.; Action: Query USER_EXPFIL_EXPRESSION_SETS view to find the attribute set assigned the expression set
ORA-38489: predicate table creation failed due to: ORAstring: Cause: Predicate table creation failed due to the reported error.; Action: Set serveroutput ON for additional information
ORA-38490: invalid name: quotes do not match: Cause: The quotes in the name did not match.; Action: Correct the name to match the quotes.
ORA-38491: could not evaluate subexpression for rowid "string": Cause: Either the expression was not in a valid SQL-WHERE clause format or it had references to nonexistent schema objects.; Action: Correct the expression.
ORA-38492: invalid ALTER INDEX parameters clause "string": Cause: An invalid parameters clause was specified with the ALTER INDEX command.; Action: See documentation for a valid list of parameters.
ORA-38493: feature not enabled : Expression Filter index: Cause: An attempt was made to create an Expression Filter index in Standard Edition.; Action: Do not attempt to use this feature.
ORA-38494: column in the table alias and an attribute have matching names: Cause: One of the attributes in the set has the same name as the name of one of the columns in the table configured for table alias.; Action: If possible, use a different name for the attribute.
ORA-38495: data type for the stored attribute string is inconsistent.: Cause: The actual data type for the stored attribute configured for the Expression Filter index object did not match the data type recorded in the Expression Filter dictionary.; Action: Delete the attribute from the default index attributes and recreate it.
ORA-38496: Expression Filter index is not in a valid state: Cause: An attempt was made to REBUILD an Expression Filter index that was not valid.; Action: Use DEFAULT keyword in the parameters clause to rebuild the index from defaults or drop and recreate the index.
ORA-38497: Expression Filter index does not exist: Cause: Index with a matching name does not exist or the index was not created using ExpFilter indextype.; Action: Identify the correct index using the Expression Filter catalog views
ORA-38498: invalid stored attribute for the index object : string: Cause: The expression filter index object has a stored or indexed attribute that had broken dependencies.; Action: Make sure that all the identifiers used in the attribute are valid.
ORA-38499: expression set already configured for stored/indexed attributes: Cause: The expression set already had a list of stored and indexed attributes. Additional attributes cannot be specified in the CREATE INDEX parameters clause.; Action: Remove TOP, STOREATTRS and INDEXATTRS clauses from the parameters clause or clear the expression set statistics using DBMS_EXPFIL.INDEX_PARAMETERS API.
ORA-38500: string: Cause: There was a generic error; Action: See documentation for further information.
ORA-38501: sub-query not allowed in the expression: Cause: An attempt was made to use a sub-query in the expression.; Action: Do not use sub-queries in the expressions.
ORA-38502: invalid XML tag: string: Cause: An attempt was made to use an invalid XML tag for the index.; Action: Correct the XML tag and retry.
ORA-38503: index already defined using the parameters: Cause: An attempt was made to modify the index parameters after the index creation.; Action: Drop the index and retry.
ORA-38504: this operator not allowed with the configured attribute set: Cause: An attempt was made to use the operator binding with an attribute set containing more than one (table alias) attribute. This is not permitted.; Action: Use a different operator binding.
ORA-38505: invalid default value for the attribute: Cause: An attempt was made to use an invalid default value or a default that is larger than 100 characters.; Action: Specify a correct default value.
ORA-38506: invalid attribute type for text predicates: Cause: An attempt was made to use an invalid type for an attribute configured for text predicates.; Action: Use either a VARCHAR or a CLOB attribute instead.
ORA-38507: attributes of string data type should be indexed: Cause: An attempt was made to configure an attribute of spatial or text data type as stored predicate group.; Action: Configure them as indexed predicate groups instead.
ORA-38601: Not enough memory for frequent itemset counting: string: Cause: The memory size did not satisfy the minimum memory requirement.; Action: Consider setting workarea_size_policy='auto'. Or with workarea_size_policy='manual' mode, consider revising the data, increasing the support_threshold setting, and decreasing itemset_length_max setting.
ORA-38602: FI invalid input cursor: Cause: The input cursor did not return exactly two columns for transactional input format or the input cursor didn't have consistent data types for horizontal input format; Action: For transactional input format, specify that the input cursor returns exactly two columns: one for transaction-id, one for item-id. For horizontal input format, make sure the input cursor's columns have the same data types.
ORA-38603: FI including & excluding cursor can only return one column: Cause: The including & excluding cursor did not return exactly one column.; Action: Specify that the cursor return only one column: item-id.
ORA-38604: FI including & excluding cursor item-id type must match input cursor item-id type: Cause: The including & excluding cursor item-id type did not match input cursor item-id type; Action: Specify that the item-id type of the cursors match each other.
ORA-38605: Not enough memory for candidate generation: Cause: There was insufficient available memory for candidate generation.; Action: Consider revising the data, increasing the support_threshold setting, and decreasing itemset_length_max setting. And, in workarea_size_policy='auto' mode, set pga_aggregate_target to a reasonably larger value.
ORA-38606: FI support threshold not between [0, 1]: Cause: The user inputed a support threshold not in the range of [0, 1].; Action: The user should adjust the input value in the range of [0, 1].
ORA-38607: FI minimum and maximum itemset length not between [1, string]: Cause: The inputed minimum or maximum itemset length exceed the internal maximum itemset length or less than 1.; Action: The user should adjust the input value not larger than the internal maximum itemset length and not less than 1.
ORA-38608: FI itemset minimum-length(string) should not be greater than maximum length(string): Cause: The user inputed minimum length is more than maximum length.; Action: The user should adjust the input values to make the minimum length less than or equal to the maximum length.
ORA-38609: Not enough memory for tree counting, requires at least stringKB: Cause: The memory size did not satisfy the minimum memory requirement for tree counting.; Action: Consider setting workarea_size_policy='auto'. Or with workarea_size_policy='manual' mode, consider revising the data, increasing the support_threshold setting, and decreasing itemset_length_max setting.
ORA-38610: FI "string" name prefix is reserved for frequent itemset counting: Cause: An error occurred because DBMS_FREQUENT_ITEMSET and prefix ORA_FI are reserved for the DBMS_FREQUENT_ITEMSET package's internal use.; Action: Do not re-define functions with names starting with DBMS_FREQUENT_ITEMSET package or ORA_FI.
ORA-38611: FI input cursor's item type is not supported: Cause: The input cursor's item type is not number or character type; Action: Redefine the input cursor so that item type is number or character type.
ORA-38612: FI item length cannot exceed half of one database block.: Cause: The item's length was more than half of one database block.; Action: Redefine the data type of the item column so that its maximum length is less than half of one database block.
ORA-38613: FI Cursor is returning less than 2 columns.: Cause: Cursor parameter is returning less than 2 columns.; Action: Modify the Cursor argument to return 2 columns.
ORA-38620: DT expressions in input cursor do not have an alias name: Cause: Expressions in input cursor do not have an alias name.; Action: Add an alias name for the expression.
ORA-38621: Decision Tree maximum depth setting not between [2, 20]: Cause: The user specified a max tree depth not in the range of [2, 20].; Action: The user should adjust the input value to be in the range of [2, 20].
ORA-38622: Decision Tree not enough memory, requires at least stringKB: Cause: The memory size did not satisfy the minimum memory requirement for decision tree building.; Action: In workarea_size_policy='manual' mode, set _dtree_area_size to a reasonably larger value. Or, In workarea_size_policy='auto' mode, please raise pga_aggregate_target to a reasonably larger value.
ORA-38700: Limit of string flashback database logs has been exceeded.: Cause: The maximum number of flashback database log files was exceeded.; Action: DB_FLASHBACK_RETENTION_TARGET may be set to high. Modify it to a smaller value.
ORA-38701: Flashback database log string seq string thread string: "string": Cause: This message reports the filename for details of another message.; Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
ORA-38702: Cannot update flashback database log file header.: Cause: Could not write to the flashback database log file.; Action: Restore access to the file.
ORA-38703: Type string in header is not a flashback database log file.: Cause: A corrupt flashback database log file header was read.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38704: Checksum error in flashback database log file header.: Cause: The flashback database log file header contained a checksum that does not match the value calculated from the file header as read from disk. This means the file header was corrupt.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38705: Expected block size string does not match string in log header.: Cause: When the flashback log file header was read, the block size in the control file did not match the block size contained in the header.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.: Cause: An ALTER DATABASE FLASHBACK ON command failed. Other messages in the alert log describe the problem.; Action: Fix the problem and retry.
ORA-38707: Media recovery is not enabled.: Cause: An ALTER DATABASE FLASHBACK ON command failed because media recovery was not enabled.; Action: Turn on media recovery with an ALTER DATABASE ARCHIVELOG command and then retry the command.
ORA-38708: not enough space for first flashback database log file: Cause: An ALTER DATABASE FLASHBACK ON command failed because there was not enough space in the Recovery Area for the first flashback database log file.; Action: Make more space in the Recovery Area. For example, this can be done by increasing the value of DB_RECOVERY_FILE_DEST_SIZE.
ORA-38709: Recovery Area is not enabled.: Cause: An ALTER DATABASE FLASHBACK ON command failed because the Recovery Area was not enabled.; Action: Set DB_RECOVERY_FILE_DEST to a location and retry.
ORA-38710: Flashback log version string is incompatible with ORACLE version string.: Cause: The flashback database log file was rejected because it appeared to be written by an incompatible version of Oracle.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38711: Corrupt flashback log block header: block string: Cause: A corrupt Flashback Database log file block header was read. More information was dumped to the trace file.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38712: Corrupt flashback log record header: block string, offset string.: Cause: A corrupt flashback database log record header was read. Either the record type or length were incorrect. More information was dumped to the trace file.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38713: Flashback Database logging is already turned on.: Cause: An ALTER DATABASE FLASHBACK ON command had no effect because flashback database logging was already on.; Action: No action required.
ORA-38714: Instance recovery required.: Cause: An ALTER DATABASE FLASHBACK ON command failed because the database either crashed or was shutdown with the ABORT option.; Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.
ORA-38715: Invalid log number specified in the DUMP FLASHBACK command.: Cause: An invalid log number was used when dumping a flashback database log file.; Action: Specify a valid flashback database log number.
ORA-38716: Must supply an integer for the TYPE option.: Cause: An invalid value was specified for TYPE in the DUMP FLASHBACK command.; Action: Specify an integer value.
ORA-38717: Invalid DUMP FLASHBACK option.: Cause: An invalid option was specified in the DUMP FLASHBACK command. Currently the only options allowed are: DBA, TYPE, and LOGICAL.; Action: Retry the command with the correct options.
ORA-38718: Invalid thread number specified in the DUMP FLASHBACK command.: Cause: An invalid thread number was used in dumping the flashback database log files for a thread.; Action: Specify a valid thread number.
ORA-38719: Invalid DUMP FLASHBACK object.: Cause: An invalid object was specified in a DUMP FLASHBACK command. Currently the only objects allowed are: LOGFILE or THREAD.; Action: Retry the command with the correct options.
ORA-38720: Missing log file name or number.: Cause: A log file name or number was missing in a DUMP FLASHBACK LOGFILE command.; Action: Supply a valid log file name or number.
ORA-38721: Invalid file number.: Cause: An invalid file number was specified in the DBA clause of a DUMP FLASHBACK command.; Action: Supply a valid file number.
ORA-38722: ON or OFF expected.: Cause: The ALTER DATABASE FLASHBACK command was specified without the ON or OFF keyword.; Action: Retry the command with the ON or OFF keyword.
ORA-38723: Invalid SCN expression.: Cause: The SCN keyword was specified in a FLASHBACK DATABASE command but the SCN expression was invalid.; Action: Retry the command using a valid SCN number.
ORA-38724: Invalid option to the FLASHBACK DATABASE command.: Cause: An invalid option was specified to the FLASHBACK DATABASE command. Valid options are: SCN or TIMESTAMP.; Action: Correct the syntax and retry the command.
ORA-38725: specified name "string" does not match actual "string": Cause: The database name specified in a FLASHBACK DATABASE command did not match the name of the currently mounted database.; Action: Correct the database name spelling or DISMOUNT the mounted database and mount the correct database.
ORA-38726: Flashback database logging is not on.: Cause: A FLASHBACK DATABASE command was tried but flashback database logging has not been enabled.; Action: Flashback database logging must be enabled via the ALTER DATABASE FLASHBACK ON command before a FLASHBACK DATABASE command can be tried. If the database must be taken back in time then a restore and incomplete recovery must be performed.
ORA-38727: FLASHBACK DATABASE requires a current control file.: Cause: The control file being used is a backup control file.; Action: FLASHBACK DATABASE cannot be used with a backup control file. If the database must be taken back in time then a restore and an incomplete recovery must be performed.
ORA-38728: Cannot FLASHBACK DATABASE to the future.: Cause: An SCN or time stamp provided in a FLASHBACK DATABASE command was in the future.; Action: Supply a proper SCN or time stamp and retry the command.
ORA-38729: Not enough flashback database log data to do FLASHBACK.: Cause: There was not enough flashback database log data to do the FLASHBACK DATABASE.; Action: If the database must be taken back in time then a restore and incomplete recovery must be performed.
ORA-38730: Invalid SCN/TIMESTAMP expression.: Cause: The expression supplied in a FLASHBACK DATABASE command was invalid.; Action: Retry the command using a valid number or time stamp expression.
ORA-38731: Expected version string does not match string in log header.: Cause: The version of the flashback database log file header was corrupt.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38732: Expected file size string does not match string.: Cause: The file size indicated in the control file did not match the file size contained in the flashback log file header. The flashback database log file was corrupt.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38733: Physical size string less than needed string.: Cause: A flashback database log file shrank in size. This was likely to have been caused by operator or operating system error.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38734: Flashback log is inconsistent; belongs to another database.: Cause: The database ID in the flashback database log file did not match the database ID in the control file.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38735: Wrong log number string in flashback log file header.: Cause: The log file number in the flashback database log file did not match the control file.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38736: Wrong thread number string in flashback log file header.: Cause: The thread number in the flashback database log file did not match the control file.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38737: Expected sequence number string doesn't match string: Cause: The flashback database log is corrupted or is an old version.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38738: Flashback log file is not current copy.: Cause: A check of flashback database log file header at database open found that the flashback database log appeared to be an incorrectly restored backup. Flashback database log files cannot be backed up and restored.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38739: Flashback log file is more recent than control file.: Cause: The control file change sequence number in the flashback database log file was greater than the number in the control file. This implies that the wrong control file was being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.; Action: FLASHBACK DATABASE can only be used with the current control file. If it is not available, then a restore and an incomplete recovery must be performed instead.
ORA-38740: Usable blocks value string is not valid.: Cause: A flashback database log file header contained a usable blocks value greater than the file size. The flashback database log file file is corrupt.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38741: Formatted blocks value string is not valid.: Cause: The formatted blocks value in the flashback database log file was greater than the file size. The flashback database log file was corrupt.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38742: Flashback log file has incorrect log reset status.: Cause: The flashback database log file header had log reset data that was different than the control file. The log was probably an incorrectly restored backup. Flashback database logs cannot be backed up.; Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38743: Time/SCN is in the future of the database.: Cause: The Time/SCN provided in a FLASHBACK DATABASE command was in the future of the database.; Action: Retry the command with a correct Time/SCN or RECOVER the database.
ORA-38744: file string is not the same file seen at start of flashback: Cause: A different copy of the file was accessed the last time FLASHBACK DATABASE looked at the file header. A backup of the file was restored or the meaning of the file name changed during FLASHBACK DATABASE.; Action: Ensure the correct file is available, then retry FLASHBACK DATABASE.
ORA-38746: error occurred while restoring data block (file# string, block# string): Cause: An error occurred during a FLASHBACK DATABASE command. See other errors on error stack.; Action: Investigate why the error occurred. It may be that the flashback database log data is corrupt. If so, a restore and an incomplete recovery must be performed instead.
ORA-38747: corrupt before image (file# string, block# string): Cause: A corrupt data block before image was encountered during a FLASHBACK DATABASE command.; Action: The flashback log data is probably corrupt. If so, a restore and an incomplete recovery must be performed instead.
ORA-38748: cannot flashback data file string - file is in use or recovery: Cause: An attempt to do FLASHBACK DATABASE found that the file was not available for recovery. Either it was online and the database was open in some instance, or another process was currently doing media recovery or flashback on the file.; Action: Do not do FLASHBACK DATABASE.
ORA-38749: A media recovery has been started.: Cause: An attempt was made to start a FLASHBACK DATABASE in the same session as a media recovery.; Action: Complete or cancel the first media recovery session.
ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.: Cause: An attempt was made to use a dispatcher process for FLASHBACK DATABASE. Memory requirements disallow this recovery method.; Action: Connect to the instance via a dedicated server process to perform FLASHBACK DATABASE.
ORA-38751: Flashback database log: "string": Cause: This message reports the filename for details of another message.; Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
ORA-38752: file string does not exist: Cause: During an RMAN FLASHBACK DATABASE conversation, a file was listed which was not part of the database. The RMAN conversation was aborted.; Action: Retry the conversation with the appropriate file numbers.
ORA-38753: Cannot flashback data file string; no flashback log data.: Cause: An attempt to perform a FLASHBACK DATABASE failed because the file does not have enough flashback log data to cover the time to flash back. Either the file did not have flashback generation enabled for it, or had flashback generation turned off for it some time during the time span of the flashback.; Action: The file cannot be flashed back. The file must be taken offline or the tablespace dropped before continuing with the FLASHBACK DATABASE command.
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available: Cause: A FLASHBACK DATABASE command did not start. A redo log needed for the recovery part of FLASHBACK DATABASE could not be found or accessed.; Action: See trace files for details of the problem.
ORA-38755: Flashback is already turned on for this tablespace.: Cause: An attempt was made to turn on flashback database logging for a tablespace that already has flashback turned on.; Action: No action required.
ORA-38756: Flashback is already turned off for this tablespace.: Cause: An attempt was made to turn off flashback database logging for a tablespace that already has flashback off.; Action: No action required.
ORA-38757: Database must be mounted and not open to FLASHBACK.: Cause: An attempt to Flashback a database was made when the database was not mounted or was already open.; Action: Mount the database and retry the FLASHBACK command.
ORA-38758: cannot flashback data file string; restored since last recovery: Cause: An attempt to do FLASHBACK DATABASE found that the file was restored since the last standby recovery. The file cannot be flashed back.; Action: The file must be taken offline before continuing with the FLASHBACK DATABASE command.
ORA-38759: Database must be mounted by only one instance and not open.: Cause: An attempt to turn on or off Flashback Database logging was made when the database was open or mounted by more than one instance.; Action: Mount the database in only one instance and retry the command.
ORA-38760: This database instance failed to turn on flashback database: Cause: Database flashback is on but this instance failed to start generating flashback data. Look in alert log for more specific errors.; Action: Correct the error or turn off database flashback.
ORA-38761: redo log sequence string in thread string, incarnation string could not be accessed: Cause: A redo log needed for the recovery portion of FLASHBACK could not be read or opened. The FLASHBACK operation failed.; Action: Restore the log and retry the FLASHBACK command.
ORA-38762: redo logs needed for SCN string to SCN string: Cause: The FLASHBACK DATABASE operation failed. The recovery portion of FLASHBACK DATABASE needed redo from the first SCN to the second, but one or more of the redo logs in the range could not be read or opened.; Action: Check the FLASHBACK DATABASE command trace file for a description of the inaccessible redo logs, restore access to them, and retry the FLASHBACK DATABASE command.
ORA-38763: flashback not started; enabled threads have changed: Cause: A FLASHBACK DATABASE command did not start. The set of enabled threads changed during the time to flash back.; Action: The flashback cannot be performed. Perform a restore and an incomplete recovery instead.
ORA-38764: flashback not started; datafile string enabled threads are different: Cause: A FLASHBACK DATABASE command did not start. The datafile was restored from a backup taken when the enabled threads were different than at the time of the flashback.; Action: The flashback cannot be performed. Perform a restore and an incomplete recovery instead.
ORA-38765: Flashed back database cannot be opened read-only.: Cause: A complete recovery was performed after a database flashback but the database was not opened for read-write access, or a FLASHBACK DATABASE command failed.; Action: If a complete recovery was performed after a database flashback, open the database for read-write access. If a FLASHBACK DATABASE command failed, fix what caused the command to fail and retry the command, or recover and open the database for read-write access.
ORA-38766: cannot flashback data file string; file resized smaller: Cause: An attempt to do FLASHBACK DATABASE found that the file was shrunk during the time to flash back.; Action: The file cannot be flashed back. The file must be taken offline or the tablespace dropped before continuing with the FLASHBACK DATABASE command.
ORA-38767: flashback retention target parameter mismatch: Cause: The value of parameters DB_FLASHBACK_RETENTION_TARGET must be same in all instances. All databases must have same flashback retention target parameters.; Action: Check DB_FLASHBACK_RETENTION_TARGET values in all instances.
ORA-38768: resizing datafile string failed: Cause: An operating system error occurred when Flashback Database tried to shrink (resize) a datafile. Flashback shrinks a file in order to undo the effects of a file expand, for example, an autoextension of the file.; Action: Recover the database to return it to its previous state, or fix the cause of the operating system error and retry the Flashback. If that is not possible, then the file can be taken offline and the Flashback command retried. The file will have to be restored from a backup and rolled forward.
ORA-38769: FLASHBACK DATABASE failed after modifying data.: Cause: A FLASHBACK DATABASE command failed after modifying the the database. Look in the alert log for more information about the failure.; Action: Recover the database to return it to its previous state, or fix the cause of the error and retry the Flashback.
ORA-38770: FLASHBACK DATABASE failed during recovery.: Cause: A FLASHBACK DATABASE command successfully restored the database but failed during the recovery step. Look in the alert log for more information about the failure.; Action: Fix the error and then recover the database to the same SCN or timestamp used in the FLASHBACK DATABASE command.
ORA-38771: unnamed datafile(s) added to control file by flashback recovery: Cause: The recovery step of FLASHBACK DATABASE encountered the creation of a datafile that could not be added to the control file. An entry has been added to the control file for the new datafile, but with the file name UNNAMEDnnnn, where nnnn is the file number. Related error messages provide the file names that were originally used to create the files.; Action: Rename the file in the control file, or use the ALTER ALTER DATABASE CREATE DATAFILE command to create a file suitable for recovery. If the file is not going to be recovered, then take it offline with the FOR DROP option. The recovery step of Flashback can be resumed by entering a RECOVERY command with the same SCN or timestamp as used in the FLASHBACK DATABASE command. For example, RECOVER AUTOMTAIC DATABASE UNTIL CHANGE flashback-scn.
ORA-38772: cannot add datafile 'string' - file could not be created: Cause: The recovery step of FLASHBACK DATABASE encountered the creation of a datafile and could not recreate the file. The error from the creation attempt is displayed in another message. The control file file entry for the file is 'UNNAMEDnnnnn'.; Action: Use the ALTER DATABASE CREATE DATAFILE statement to create the file.
ORA-38773: cannot add data file 'string' - file already part of database: Cause: The recovery step of FLASHBACK database encountered the creation of a datafile and could not create the file because the file name is already in use in the database. The control file file entry for the file is 'UNNAMEDnnnnn'.; Action: Use the ALTER DATABASE CREATE DATAFILE statement to create the file with a different name.
ORA-38774: cannot disable media recovery - flashback database is enabled: Cause: An attempt was made to disable media recovery while flashback database was enabled.; Action: Use the ALTER DATABASE FLASHBACK OFF statement to disable flashback database, then disable media recovery.
ORA-38775: cannot disable recovery area - flashback database is enabled: Cause: An attempt was made to set DB_RECOVERY_FILE_DEST to null while flashback database was enabled. Flashback database requires DB_RECOVERY_FILE_DEST to be set.; Action: Use the ALTER DATABASE FLASHBACK OFF statement to disable flashback database, then disable the recovery area.
ORA-38776: cannot begin flashback generation - recovery area is disabled: Cause: During a database mount, the RVWR process discovered that the recovery area was disabled. DB_RECOVERY_FILE_DEST must have been set null or removed from the INIT.ORA file while the database was unmounted.; Action: Flashback database requires the recovery area to be enabled. Either enable the recovery area by setting the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters, or turn off flashback database with the ALTER DATABASE FLASHBACK OFF command.
ORA-38777: database must not be started in any other instance: Cause: A command was attempted that required the database to be mounted in this instance and not started in any other instance. ALTER DATABASE OPEN RESETLOGS requires that the database be started in only one instance if flashback database logging is enabled.; Action: Ensure that the no other instances are started. Then retry the command.
ORA-38778: Restore point 'string' already exists.: Cause: The restore point name of the CREATE RESTORE POINT command already exists. A restore point name must be unique.; Action: Either use a different name or delete the existing restore point with the same name.
ORA-38779: cannot create restore point - too many restore points.: Cause: The maximum number of restore points already have been created.; Action: Delete some existing restore point and retry the operation.
ORA-38780: Restore point 'string' does not exist.: Cause: The restore point name specified in the command did not exist.; Action: Look up restore points by query restore point tables.
ORA-38781: cannot disable media recovery - have guaranteed restore points: Cause: An attempt was made to disable media recovery while there is at least one guaranteed restore point.; Action: Drop all guaranteed restore points and then disable media recovery.
ORA-38782: cannot flashback database to non-guaranteed restore point 'string': Cause: An attempt was made to flashback database to a non-guaranteed restore point while flashback database is off. You can only flashback a database to guaranteed restore point when flashback database is not on.; Action: Consider picking a guaranteed restore point to flashback the database to, if there is one.
ORA-38783: Instance recovery required.: Cause: An attempt was made to create a restore point when the database is in mount mode but it was not shutdown cleanly before it was mounted. In order to create a restore point when the database is mounted, the database must be shutdown cleanly before it is mounted.; Action: Consider one of the following: 1. Create the restore point after opening the database. 2. Open the database, shut it down cleanly, mount the database, and retry creating the restore point.
ORA-38784: Cannot create restore point 'string'.: Cause: An attempt to create a restore point failed. See other errors on the error stack and in the alert log for the specific reason.; Action: Fix the problem and retry.
ORA-38785: Media recovery must be enabled for guaranteed restore point.: Cause: Media recovery is not enabled. Media recovery must be enabled in order to create a guaranteed restore point.; Action: Turn on media recovery with an ALTER DATABASE ARCHIVELOG statement and then retry the command.
ORA-38786: Recovery area is not enabled.: Cause: An attempt was made to perform a command that requires Flash recovery area to be enabled.; Action: Set DB_RECOVERY_FILE_DEST to an appropriate location and retry.
ORA-38787: Creating the first guaranteed restore point requires mount mode when flashback database is off.: Cause: While flashback database is not on, an attempt was made to create the first guaranteed restore point while the database is open.; Action: Mount the database and retry.
ORA-38788: More standby database recovery is needed: Cause: An attempt was made to create a restore point or a guaranteed while a physical standby database is not cleanly checkpointed.; Action: Perform more standby database recovery via managed standby database recovery. Cancel managed recovery and retry the command.
ORA-38789: File name is too long.: Cause: The file name provided in the command was longer than the maximum allowed.; Action: Use a shorter file name.
ORA-38790: BEFORE must be specified with RESETLOGS: Cause: The FLASHBACK DATABASE command included the RESETLOGS parameter but not the BEFORE parameter.; Action: Retry the command with TO BEFORE RESETLOGS.
ORA-38791: flashback did not start because file string was not in a valid incarnation: Cause: Flashback could not be started because a file was checkpointed or fuzzy at a point where the file can neither be restored nor recovered to our restore target. In order for a file to be brought to the restore target, the file has to be in one of the incarnations along the ancestral path from the current incarnation to the restore incarnation.; Action: Manually restore or recover the file to a point where it is in one of the incarnations along the ancestral path from the current incarnation to the restore incarnation.
ORA-38792: encountered unknown flashback record from release string: Cause: A Flashback Database logfile contains a record written by a future Oracle release and is unknown by this release.; Action: The given release of Oracle must be installed in order to use these flashback database log files.
ORA-38793: cannot FLASHBACK the database or pluggable database to a future SCN or time: Cause: The Flashback Pluggable Database target SCN or timestamp is greater than the current database or pluggable database SCN/timestamp and the database or pluggable database incarnation is not the last opened incarnation.; Action: If the target SCN or timestamp is in the current incarnation or a child incarnation whose branch point is after the current database or pluggable database SCN then RECOVER DATABASE or RECOVER PLUGGABLE DATABASE to the target SCN or time. If the target SCN or timestamp is in a child incarnation whose branch point is prior to the current database or pluggable database SCN then FLASHBACK DATABASE to before the branch point. Next, use RMAN to reset the database or pluggable database to the child incarnation. Finally, RECOVER DATABASE OR PLUGGABLE DATABASE to the target SCN time.
ORA-38794: Flashback target time not in current incarnation: Cause: The Flashback Database target timestamp is not in the database's current incarnation or any of its ancestors.; Action: Use a different target timestamp or use RMAN to reset the database to the appropriate incarnation.
ORA-38795: WARNING: FLASHBACK DATABASE succeeded but OPEN RESETLOGS would fail: Cause: FLASHBACK DATABASE succeeded. However, if ALTER DATABASE OPEN RESETLOGS command was attempted now, it would fail with the specified error.; Action: Fix the error before trying ALTER DATABASE OPEN RESETLOGS.
ORA-38796: Not enough flashback database log data to undo FLASHBACK.: Cause: There was not enough flashback log data to undo the flashback so a flashback was not started.; Action: It is still possible to get to the restore target by doing a flashback until the resetlogs branch point of the restore target is reached. This can be done by executing multiple "flashback to before resetlogs" commands, or by doing a flashback to the exact time or SCN of the desired resetlogs branch point. Note that this flashback cannot be undone should an error occur. The only option is to complete the flashback.
ORA-38797: Full database recovery required after a database has been flashed back: Cause: An attempt was made to recover some datafiles or tablespaces of a database after the database had been flashed back. In order to recover control file and all datafiles correctly, full database recovery is required after a database has been flashed back.; Action: Recover the whole database instead.
ORA-38798: Cannot perform partial database recovery: Cause: See other other messages on error stack for the cause.; Action: See other other messages on error stack for the action.
ORA-38799: Cannot drop guaranteed restore point internally created for snapshot standby: Cause: An attempt is made to drop the guaranteed restore point Oracle created internally for a snapshot standby.; Action: Use the "alter database convert to physical standby" command to convert the snapshot standby to a normal physical standby. This will automatically flashback the database and drop this guaranteed restore point.
ORA-38800: Cannot start Redo Apply on the open physical standby database: Cause: An attempt was made to start Redo Apply on an open physical standby database instance.; Action: Make sure the primary database is at compatibility 11.0.0 or higher. The redo logs to be recovered on an open physical standby database must be generated at compatibility 11.0.0 or higher. If you have any redo below 11.0.0 to be applied on the standby, you must apply them on a mounted standby before restarting recovery on an open standby when the log format advances to 11.0.0 or higher. If this is a RAC standby database, make sure the ACTIVE_INSTANCE_COUNT parameter is not set.
ORA-38801: improper value for ORA_EDITION: Cause: An improper value was used for ORA_EDITION when trying to specify an edition to use at login time. The value is not understandable as an identifier, or is too long.; Action: Correct the value for ORA_EDITION and try again.
ORA-38802: edition does not exist: Cause: This error occurred because a reference was made to an edition that does not exist or that the current user does not have privileges on.; Action: Check the edition name and verify that the current user has appropriate privileges on the edition.
ORA-38803: edition is unusable: Cause: This error occurred because a reference was made to an unusable edition.; Action: Use another edition.
ORA-38804: not a legal edition name: Cause: This error occurred because an attempt was made to create an edition called ORA$BASE, DATABASE_DEFAULT, or USER_DEFAULT. These are not legal edition names. Or a value provided as an edition name is not understandable as an identifier, or is too long.; Action: Choose a different name for the edition.
ORA-38805: edition is in use: Cause: An attempt was made to ALTER or DROP an edition that was being used in another session or was the database default edition.; Action: Retry when the edition is not in use and is not the database default edition.
ORA-38806: edition is being altered or dropped: Cause: An attempt was made to use an edition that was in the process of being altered or dropped.; Action: Use a different edition.
ORA-38807: Implementation restriction: an edition can have only one child: Cause: This error occurred because an attempt was made to create more than one child edition for a parent edition.; Action: Create the edition as a child of the leaf edition.
ORA-38808: edition has a usable parent and a usable child: Cause: An attempt was made to make an edition with a usable parent and a usable child edition unusable.; Action: An edition with a usable parent and a usable child edition cannot be made unusable. Retry after either parent or child has been made unusable.
ORA-38809: edition must be unusable: Cause: This error occurred because an attempt was made to drop a usable edition.; Action: Retry after the altering the edition to be unusable.
ORA-38810: Implementation restriction: cannot drop edition that has a parent and a child: Cause: This error occurred because an attempt was made to drop an edition that has a parent and a child edition.; Action: Retry after dropping the parent or child edition.
ORA-38811: need CASCADE option to drop edition that has actual objects: Cause: This error occurred because an attempt was made to drop an edition that has actual objects.; Action: Specify CASCADE option in drop command.
ORA-38812: maximum number of editions reached: Cause: The number of editions has reached the limit.; Action: Drop some editions before creating new ones.
ORA-38813: editions not supported for schema string: Cause: The Oracle-supplied schema did not support editions.; Action: Do not attempt to enable editions for the specified Oracle-supplied schema.
ORA-38814: ALTER SESSION SET EDITION must be first statement of transaction: Cause: An attempt was made to execute an edition switch within an open transaction.; Action: Commit or rollback the transaction and reexecute the statement, or use DBMS_SESSION.SET_EDITION_DEFERRED if its deferred effect is appropriate.
ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement: Cause: An edition switch failed because it was executed from a PL/SQL block or using recursive SQL.; Action: Execute the statement from a top-level OCI call, or use dbms_session.set_edition if its deferred effect is appropriate.
ORA-38816: edition has a child that inherits objects from the edition: Cause: This error occurred because an attempt was made to drop an edition that a child that inherits objects from the edition.; Action: Retry after the child edition has no inherited objects.
ORA-38817: Insufficient privileges: Cause: You did not have sufficient privileges to execute the subprogram package DBMS_EDITIONS_UTIL.; Action: Obtain the necessary privileges. Please see the package specification for details.
ORA-38818: illegal reference to editioned object string.string: Cause: An attempt was made to violate the rule "A noneditioned object may not depend on an editioned object."; Action: Either make this object editioned; or do not make the illegal reference.
ORA-38819: user string owns one or more objects whose type is editionable and that have noneditioned dependent objects: Cause: An attempt was made to violate the rule "A noneditioned object may not depend on an editioned object."; Action: Either make sure that those objects owned by this user whose type is editionable have no noneditioned dependent objects; or use the FORCE option.
ORA-38820: user has evolved object type: Cause: User could not be edition enabled if it has evolved object type.; Action: Reset the evolved object type first.
ORA-38821: unsupported DBMS_SQL Edition operation: Cause: Could not bind or define ADT, VARRAY, nested table or REF data type when the specified Edition is different from the current edition.; Action: Use the current Edition.
ORA-38822: referential integrity constraints not allowed on editioned views: Cause: An attempt was made to create a referential integrity constraint to or from an editioned view or enable editions for a user that has views with referential integrity constraints.; Action: Do not attempt to create editioned views with referential integrity constraints.
ORA-38823: Crossedition triggers are not allowed to exist when dropping the root edition: Cause: An attempt was made to drop the root edition when enabled crossedition trigger exists.; Action: Drop or disable all the crossedition triggers before dropping the root edition.
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.: Cause: An attempt was made to replace an existing object with a different value for the EDITIONABLE property.; Action: Switch the EDITIONABLE property in the REPLACE statement, or alter the existing object to have an EDITIONABLE property matching the EDITIONABLE property in the REPLACE statement.
ORA-38825: The EDITIONABLE property of an editioned object cannot be altered.: Cause: An attempt was made to alter the EDITIONABLE property of an object whose type has been enabled for editioning in the owner's schema.; Action: Drop the object and re-create it with the desired EDITIONABLE state.
ORA-38826: The EDITIONABLE property of a TYPE or PACKAGE specification and its body must match.: Cause: An attempt was made to create a TYPE or PACKAGE specification or body whose EDITIONABLE property did not match its counterpart.; Action: Switch the EDITIONABLE property in the CREATE statement, or alter the existing object to have an EDITIONABLE property matching the EDITIONABLE property in the CREATE statement.
ORA-38827: DBMS_SESSION.SET_EDITION_DEFERRED failed due to change of PDB.: Cause: An edition switch failed because an attempt was made to change pluggable database (PDB) before the edition switch took effect.; Action: Do not change PDB before the edition switch takes effect.
ORA-38828: DBMS_SESSION.USE_DEFAULT_EDITION_ALWAYS mode is on.: Cause: A change of the session-level edition failed because the overriding USE_DEFAULT_EDITION_ALWAYS mode was on.; Action: Do not change the session-level edition, or first turn off USE_DEFAULT_EDITION_ALWAYS mode.
ORA-38829: FLASHBACK DATABASE failed before modifying any data.: Cause: The FLASHBACK DATABASE command failed before modifying the the database. Look in the alert log for more information about the failure.; Action: Fix the cause of the error and retry the FLASHBACK DATABASE command.
ORA-38850: an enabled thread missing from control file: Cause: A CREATE CONTROLFILE statement was given that did not list all the enabled threads for the database.; Action: Reissue the CREATE CONTROLFILE statement, including all enabled threads.
ORA-38851: cannot mark the current instance (redo thread) as disabled: Cause: The standby switchover or failover operation failed because it needs to mark the current instance (redo thread) as disabled.; Action: Shut down this instance and start up using a different instance name or redo thread number and retry.
ORA-38852: cannot mark the current instance (redo thread) as disabled: Cause: The open resetlogs or standby activation operation failed because it must use a different instance (redo thread) than the current instance (redo thread) to open the database.; Action: Shut down this instance and start up using a different instance name or redo thread number and retry.
ORA-38853: cannot mark instance string (redo thread string) as disabled: Cause: The standby switchover or failover operation failed because it needs to mark an instance (redo thread) as disabled. That instance was up, which prevented it from being disabled.; Action: Shut down the specified instance and retry this command.
ORA-38854: cannot mark instance string (redo thread string) as disabled: Cause: The open resetlogs or standby activation operation failed because it needs to mark an instance (redo thread) as disabled. That instance was up, which prevented it from being disabled.; Action: Shut down the specified instance and retry this command.
ORA-38855: cannot mark instance string (redo thread string) as enabled: Cause: The standby switchover or failover operation failed because it needs to mark an instance (redo thread) as enabled. However, it had less than 2 online redo logs, which prevented it from being enabled.; Action: Add more logfiles to the specified instance and retry the command.
ORA-38856: cannot mark instance string (redo thread string) as enabled: Cause: The open resetlogs or standby activation operation failed because it needs to mark an instance (redo thread) as enabled. However, it had less than 2 online redo logs, which prevented it from being enabled.; Action: Add more logfiles to the specified instance and retry the command.
ORA-38857: cannot mark redo thread string as enabled: Cause: The standby switchover or failover operation failed because it needs to mark a redo thread as enabled. However, the control file was recreated with a MAXINSTANCES value smaller than the thread number of the redo thread.; Action: Recreate the control file with a larger MAXINSTANCES value.
ORA-38858: cannot mark redo thread string as enabled: Cause: The open resetlogs or standby activation operation failed because it needs to mark a redo thread as enabled. However, the control file was recreated with a MAXINSTANCES value smaller than the thread number of the redo thread.; Action: Recreate the control file with a larger MAXINSTANCES value.
ORA-38859: instance string (thread string) is not ready to be disabled: Cause: The command attempted to switch the instance (thread) into a new log before disabling it. The switch attempt failed because all eligible online logs were either being cleared or not completely archived yet.; Action: Wait a few minutes and retry.
ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby: Cause: The command was not permitted because the controlfile indicates the database was in the process of becoming a logical standby database but the controlfile conversion had not completed.; Action: If in the process of creating a logical standby database, perform the remaining instantiation procedures to completion. If this flashback operation followed a Data Guard failure, permit the errant Data Guard operation to successfully complete. Once the instantiation is complete, reissue the flashback operation.
ORA-38861: flashback recovery stopped before reaching recovery target: Cause: Flashback recovery on the standby ended early because the user attempted to flashback to an SCN or time for which there were no redo logs. Most likely, the user is trying to flashback to a future time in the database that the database has never recovered through. Check the alert log to find out which SCN the database recovered to.; Action: Flashback to an older SCN or acquire the necessary redo logs.
ORA-38862: Flashback database logs are in use.: Cause: The command could not be performed because the flashback database logs were locked by another operation, such as FLASHBACK DATABASE or a query of V$FLASHBACK_DATABASE_LOG.; Action: Wait for the other operation to complete.
ORA-38863: datafile string has been restored from an optimized RMAN backup.: Cause: Flashback Database could not flash back the file because it was restored from an RMAN optimized backup with deallocated objects. Flashback cannot revert the file to a time before the last deallocation in the datafile backup.; Action: Restore the file from a backup prior to the Flashback target SCN or time and then retry the command.
ORA-38864: cannot create a guaranteed restore point with user specified SCN or time.: Cause: An SCN or timestamp was specified when creating a guaranteed restore point. This is not supported. You can only create a guaranteed restore point as of the current time.; Action: Avoid this combination of options for creating a restore point.
ORA-38865: cannot create restore point for a future SCN or time.: Cause: An attempt was made to create a restore point with an SCN or timestamp that is in the future.; Action: Revise the SCN or timestamp specified so that it is an SCN or timestamp in the past.
ORA-38866: cannot create restore point for an SCN or time before current database incarnation.: Cause: An attempt was made to create a restore point with an SCN or timestamp that is before the beginning of the current database incarnation.; Action: Revise the SCN or timestamp specified so that it is within current database incarnation.
ORA-38867: database not open: cannot create restore point with the specified timestamp: Cause: An attempt was made to create a restore point with the specified timestamp while the database was not open. The database must be open in order to map the timestamp to an SCN.; Action: Open the database first or pick another way to create the restore point.
ORA-38868: warning: the control file may have incorrect data file structure: Cause: This control file was created or converted based on a control file from a time different from the time of the database.; Action: Open database and all pluggable databases read-only to synchronize the control file with the database dictionary. You can also force recovery to proceed by invoking recovery again.
ORA-38869: datafile string has been restored from an RMAN backup with undo block compression.: Cause: Flashback Database could not flash back the database because a file was restored from an RMAN backup with undo block compression, and the Flashback target was to a time when the missing undo may be needed to open the database.; Action: Restore an earlier backup of the file and retry the command or Flashback to a later time.
ORA-38870: cannot backup a control file that may have incorrect data file structure.: Cause: This control file was created or converted based on a control file from a time different from the time of the database.; Action: Open database read-only to synchronize the control file with the database dictionary to fix the control file.
ORA-38871: cannot enable flashback before open resetlogs after incomplete recovery.: Cause: To enable flashback on a primary database, the database must be clean without requiring open resetlogs.; Action: Open resetlogs first and then enable flashback database.
ORA-38872: Cannot perform backup control file recovery if Flashback Database is enabled.: Cause: RECOVER DATABASE with the BACKUP CONTROLFILE option, or a database recovery that required the control file be made a backup failed because Flashback Database was enabled or there was a guaranteed restore point.; Action: Disable Flashback Database or remove the guaranteed restore point and retry the command.
ORA-38873: missing incarnation information: Cause: Flashback Database failed because incarnation information was not found in the control file. The Flashback target incarnation was not in the control file or had a missing parent incarnation.; Action: Register logs from the missing incarnations and retry the command.
ORA-38874: cannot flashback data file string - missing incarnation information: Cause: Flashback Database failed because incarnation information for the start of the offline range for a file was not found in the control file. Flashback could not update the file's header with the missing incarnation's resetlogs information.; Action: Check the trace log for the offline range of the data file. If redo logs from the missing incarnation can be found, register the logs in the control file and retry the command.
ORA-38875: FLASHBACK DATABASE not started; in test mode: Cause: The FLASHBACK DATABASE command was not performed because it was started in test mode.; Action: No action required.
ORA-38876: redo logs not required: Cause: The FLASHBACK DATABASE command was performed in test mode and determined that no redo logs were required to perform the tested FLASHBACK DATABASE command.; Action: No action required.
ORA-38877: required redo logs are available: Cause: The FLASHBACK DATABASE command was performed in test mode and determined that no redo logs required to perform the tested FLASHBACK DATABASE command were missing.; Action: No action required.
ORA-38878: required redo log is not available: Cause: A redo log needed for the recovery part of FLASHBACK DATABASE could not be found or accessed.; Action: See trace files for details of the problem.
ORA-38879: Cannot flashback data file string; may not be able to undo all changes.: Cause: A data file was plugged in when there was a guaranteed restore point, but Flashback Database was not enabled. It is possible that some changes to the data file, after it was converted, were not logged to the Flashback Database logs.; Action: If the FLASHBACK DATABASE command was meant to rewind the database to a time before the file was plugged in, take the data file offline and retry the command. If the FLASHBACK DATABASE command was meant to rewind the database to a time after the file was plugged in, restore the original version of the plugged in file and retry the command.
ORA-38880: Cannot advance compatibility from string to string due to guaranteed restore points: Cause: Flashback database cannot undo the advance of database compatibility. Therefore, one cannot advance the compatibility of the database while there are guaranteed restore points in the database.; Action: Drop all guaranteed restore points first and retry, or delay the advance of database compatibility to a later time.
ORA-38881: Cannot drop tablespace string on primary database due to guaranteed restore points.: Cause: An attempt was made to drop a tablespace on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo dropping of a tablespace.; Action: Drop all guaranteed restore points first and retry, or delay dropping the tablespace until all guaranteed restore points are removed.
ORA-38882: Cannot drop tablespace string on standby database due to guaranteed restore points.: Cause: An attempt was made to drop a tablespace on a standby database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo dropping of a tablespace.; Action: Drop all guaranteed restore points and rerun recovery on standby database.
ORA-38883: Cannot shrink data file string by string blocks on primary database due to guaranteed restore points.: Cause: An attempt was made to shrink a data file on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo the shrinking of a data file.; Action: Drop all guaranteed restore points first and retry, or delay the data file resize until all guaranteed restore points are removed.
ORA-38884: Cannot shrink data file string by string blocks on standby database due to guaranteed restore points.: Cause: An attempt was made to shrink a data file on a standby database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo the shrinking of a data file.; Action: Drop all guaranteed restore points and rerun recovery on standby database.
ORA-38885: WARNING: Flashback database has been disabled while fast-start failover is enabled.: Cause: Flashback database was disabled while fast-start failover was enabled.; Action: Enable flashback database if fast-start failover is enabled.
ORA-38886: WARNING: Flashback database was disabled due to error when writing flashback database logs.: Cause: Recovery writer (RVWR) encountered an error when writing flashback database logs.; Action: See the error stack in the alert log.
ORA-38887: WARNING: Recovery writer (RVWR) hang due to error when writing flashback database logs.: Cause: An error occurred while writing to the flashback database logs.; Action: Shutdown the instance or turn off flashback database.
ORA-38888: invalid redo thread number: Cause: The provided thread number was invalid.; Action: Specify a valid redo thread number.
ORA-38889: Cannot shrink data file string as server process could not allocate memory to generate before images.: Cause: An error occurred while trying to allocate PGA memory to store before images to write into flashback database log.; Action: Retry the operation after making sure system has sufficient free memory available.
ORA-38890: RESETLOGS option may need to be used to open this PDB: Cause: Pluggable database (PDB) flashback or point-in-time recovery was performed on this PDB.; Action: Either issue the ALTER PLUGGABLE DATABASE OPEN RESETLOGS statement, open the PDB in read only mode, or perform recovery on the PDB and open the PDB.
ORA-38891: cannot use DB_FLASHBACK_LOG_DEST without DB_FLASHBACK_LOG_DEST_SIZE: Cause: There are two possible cause for this error: 1) The DB_FLASHBACK_LOG_DEST parameter was in use when no DB_FLASHBACK_LOG_DEST_SIZE parameter was encountered while fetching initialization parameter. 2) An attempt was made to set DB_FLASHBACK_LOG_DEST with the ALTER SYSTEM command when no DB_FLASHBACK_LOG_DEST_SIZE was in use.; Action: Correct the dependency parameter definitions and retry the command.
ORA-38892: cannot disable flashback log dest - flashback database is enabled: Cause: An attempt was made to set DB_FLASHBACK_LOG_DEST to null while flashback database was enabled. Flashback database requires DB_FLASHBACK_LOG_DEST to be set.; Action: Use the ALTER DATABASE FLASHBACK OFF statement to disable flashback database, then disable the flashback log dest.
ORA-38893: Parameter DB_FLASHBACK_LOG_DEST_SIZE is out of range (1 - string): Cause: Parameter DB_FLASHBACK_LOG_DEST_SIZE specified was not valid.; Action: Specify a valid number within the range.
ORA-38894: flashback log destination parameter mismatch: Cause: The value of parameters DB_FLASHBACK_LOG_DEST and DB_FLASHBACK_LOG_DEST_SIZE must be same in all instances. All databases must have same flashback destination parameters.; Action: Check DB_FLASHBACK_LOG_DEST and DB_FLASHBACK_LOG_DEST_SIZE values in all instances.
ORA-38895: can not set DB_FLASHBACK_LOG_DEST dynamically after flashback database is on: Cause: There are two possible cause for this error: 1) The flashback log can only be either in DB_RECOVERY_FILE_DEST or DB_FLASHBACK_LOG_DEST but not both. As flashback database is already on without a DB_FLASHBACK_LOG_DEST, there will already be flashback logs inside DB_RECOVERY_FILE_DEST. Can not set DB_FLASHBACK_LOG_DEST dynamically now because flashback logs will be in both places after the operation. 2) An attempt was made to change DB_FLASHBACK_LOG_DEST with the ALTER SYSTEM command when flashback database is on; Action: Set DB_FLASHBACK_LOG_DEST dynamically before turning on flashback database.
ORA-38896: can not specify DB_FLASHBACK_LOG_DEST in INIT.ORA file after flashback database has been enabled without it: Cause: Flashback logs can only be in either DB_RECOVERY_FILE_DEST or DB_FLASHBACK_LOG_DEST but not both. Because flashback database is already enabled with flashback logs in DB_RECOVERY_FILE_DEST, one cannot specify DB_FLASHBACK_LOG_DEST in the INIT.ORA file.; Action: Remove ADB_FLASHBACK_LOG_DEST in INIT.ORA file or add it before turning on flashback database.
ORA-38897: cannot remove DB_FLASHBACK_LOG_DEST in INIT.ORA file after flashback database has been enabled with it: Cause: Flashback logs can only be in either DB_RECOVERY_FILE_DEST or DB_FLASHBACK_LOG_DEST but not both. Because flashback database is already enabled with flashback logs in DB_FLASHBACK_LOG_DEST, one cannot remove DB_FLASHBACK_LOG_DEST in the INIT.ORA file.; Action: Add back DB_FLASHBACK_LOG_DEST in the INIT.ORA file or remove it before turning on flashback database.
ORA-38898: cannot set DB_FLASHBACK_LOG_DEST_SIZE to string, minimum quota required is string: Cause: DB_FLASHBACK_LOG_DEST_SIZE cannot be set to new value as it is lower than the minimum quota required.; Action: Set DB_FLASHBACK_LOG_DEST_SIZE to a higher value.
ORA-38899: compatible initialization parameter must be at least release 23.0.0.0.0 in order to use DB_FLASHBACK_LOG_DEST: Cause: The use of DB_FLASHBACK_LOG_DEST requires Oracle Database 23c compatibility but currently the compatible initialization parameter was not set to release 23.0.0.0.0 or later version.; Action: Set the compatible parameter in initialization parameter file to release 23.0.0.0.0 or later version.
ORA-38900: missing mandatory column "string" of error log table "string": Cause: Mandatory column of error logging table is not present; Action: Add the named column to the error logging table. Consult ORACLE documentation for the correct data type.
ORA-38901: column "string" of table "string" must be one of the first "string" columns: Cause: Mandatory information column of error logging table is present, but must be at the beginning of the row.; Action: Create the error logging table correctly. Consult ORACLE documentation for the correct format of an error logging table.
ORA-38902: errors in array DML exceed string: Cause: The operation failed because the array DML had more errors than can be stored internally for BATCH ERRORs.; Action: Do not use BATCH ERROR mode when array DML has more error rows than the number specified in the error.
ORA-38903: DML error logging is not supported for abstract column "string": Cause: A DML Error Logging operation was attempted on a table which has an ADT, REF, VARRAY, or nested table column type, and the error logging table referred to the specified column.; Action: Either do not use DML Error Logging on such a table or remove the offending column from the error logging table. The scalar columns can be logged, but not abstract column types.
ORA-38904: DML error logging is not supported for LOB column "string": Cause: A DML Error Logging operation was attempted on a table which has a CLOB, NCLOB, or BLOB column type, and the error logging table referred to the specified column.; Action: Either do not use DML Error Logging on such table or remove the offending column from the error logging table. The scalar columns can be logged, but not LOB column types.
ORA-38905: DML error logging is not supported for LONG column "string": Cause: A DML Error Logging operation was attempted on a table which has a LONG, or LONG RAW column type, and the error logging table referred to the specified column.; Action: Either do not use DML Error Logging on such a table or remove the offending column from the error logging table. The scalar columns can be logged, but not long column types.
ORA-38906: insert into DML Error Logging table "string" failed: Cause: An error occurred when attempting to log a DML Error on behalf of the DML Error logging clause. This may be intended if a trigger is defined on the error table (which in turn errors out in certain cases).; Action: Determine root cause of error (in error stack).
ORA-38907: DML error logging is not supported for FILE column "string": Cause: A DML Error Logging operation was attempted on a table which has a BFILE column and the Error Logging table referred to the specified column.; Action: Either don't use DML Error Logging on such table or remove the offending column from the error logging table. The scalar columns can be logged, but not BFILE column types.
ORA-38908: internal error occurred during DML Error Logging: Cause: An unexpected error occurred while executing recursive SQL to insert a row into the DML Error Logging table.; Action: Report this error to Oracle Support.
ORA-38909: DML Error logging is not supported with BATCH ERROR mode: Cause: A DML Error Logging operation was attempted on a table which has BATCH ERROR mode also specified.; Action: Refrain from using both DML Error Logging and BATCH ERROR mode on the same table.
ORA-38910: BATCH ERROR mode is not supported for this operation: Cause: BATCH ERROR mode specified for this operation.; Action: Refrain from using BATCH ERROR mode with this operation.
ORA-38911: unique constraint (string.string) violated: Cause: An INSERT statement with a CHANGE_DUPKEY_ERROR_INDEX hint tried to insert a duplicate key into a table.; Action: Either remove the unique restriction or do not insert the key.
ORA-38912: An index must be specified in the index hint: Cause: Index specification was missing in an IGNORE_ROW_ON_DUPKEY_INDEX or CHANGE_DUPKEY_ERROR_INDEX hint.; Action: In the hint, specify a unique index that exists on the table.
ORA-38913: Index specified in the index hint is invalid: Cause: The index specified in an IGNORE_ROW_ON_DUPKEY_INDEX or CHANGE_DUPKEY_ERROR_INDEX hint could not be found.; Action: Specify a unique index that exists on the table. The index cannot be a non-unique index or a bitmap index.
ORA-38914: Either mutate the error or ignore row on unique violation: Cause: IGNORE_ROW_ON_DUPKEY_INDEX and CHANGE_DUPKEY_ERROR_INDEX were both specified in the same statement.; Action: You cannot specify both hints in the same statement. Remove one of these two hints, or both, from the statement.
ORA-38915: Multiple indexes in change or ignore duplicate key hint: Cause: Multiple indexes were specified in an IGNORE_ROW_ON_DUPKEY_INDEX or CHANGE_DUPKEY_ERROR_INDEX hint.; Action: Only one index must be specified in the hint.
ORA-38916: CHANGE_DUPKEY_ERROR_INDEX hint disallowed for this operation: Cause: CHANGE_DUPKEY_ERROR_INDEX hint was specified for the operation.; Action: You cannot specify this hint for this operation. Remove the hint from the statement.
ORA-38917: IGNORE_ROW_ON_DUPKEY_INDEX hint disallowed for this operation: Cause: IGNORE_ROW_ON_DUPKEY_INDEX hint was specified for the operation.; Action: You cannot specify this hint for this operation. Remove the hint from the statement.
ORA-38918: RETRY_ON_ROW_CHANGE hint disallowed for this operation: Cause: RETRY_ON_ROW_CHANGE hint was specified for the operation.; Action: You cannot specify this hint for this operation. Remove the hint from the statement.
ORA-38919: remote table not supported for DML error logging: Cause: A remote table was specified in the DML error logging clause.; Action: You cannot specify a remote table to which errors will be logged. Specify a local table only.
ORA-38950: Source platform string not cross platform compliant: Cause: Cross platform transport was not allowed for this platform.; Action: For a list of supported platforms, query fixed view SYS.V$TRANSPORTABLE_PLATFORM.
ORA-38951: Target platform string not cross platform compliant: Cause: Cross platform transport was not allowed for this platform.; Action: For a list of supported platforms, query fixed view SYS.V$TRANSPORTABLE_PLATFORM.
ORA-38952: Source database not 10.0.0.0 compatible: Cause: Cross platform transport is not supported unless database compatibility is advanced to 10.0.0.0 or higher; Action: Use the compatible parameter to advance source database compatibility and redo the transport
ORA-38953: Cross platform transport is not supported between source platform string and target platform string
ORA-38954: Cross platform transport is not supported between source platform identifier string and target platform identifier string: Cause: The platform identifier in the transported file indicated that the datafile format was different than the target database datafile format.; Action: For a list of supported platforms, query fixed view SYS.V$TRANSPORTABLE_PLATFORM. If both platforms are present, Contact Oracle support
ORA-38955: Source platform string not cross platform compliant: Cause: The platform identifier in the transported file indicated that this platform is not supported for a cross platform transport.; Action: For a list of supported platforms, query fixed view SYS.V$TRANSPORTABLE_PLATFORM.
ORA-38956: Target platform string not cross platform compliant: Cause: Cross platform transport was not allowed for this platform.; Action: For a list of supported platforms, query fixed view SYS.V$TRANSPORTABLE_PLATFORM.
ORA-38958: Source platform string is in different byte order than target platform string: Cause: Probably a conversion was not done before the import phase of the transport.; Action: Use RMAN CONVERT functionality to convert endian ordering.
ORA-38959: Failed to update block 0 to new version 10 format: Cause: An attempt was made to update block 0 to version 10 format.; Action: check additional error messages and contact Oracle Support Services.
ORA-38960: File string from platform string is not compatible with current platform string: Cause: The file was directly copied to this platform from a platform with a different endian ordering.; Action: Use RMAN CONVERT functionality to convert endian ordering.
ORA-38961: data file: string: Cause: Reporting file name for details of another error.; Action: See associated error message.
ORA-39000: bad dump file specification: Cause: The user specified a dump file that could not be used in the current job. Subsequent error messages describe the inadequacies of the dump file.; Action: Specify a dump file that is usable for the job.
ORA-39001: invalid argument value: Cause: The user specified API parameters were of the wrong type or value range. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.; Action: Correct the bad argument and retry the API.
ORA-39002: invalid operation: Cause: The current API cannot be executed because of inconsistencies between the API and the current definition of the job. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.; Action: Modify the API call to be consistent with the current job or redefine the job in a manner that will support the specified API.
ORA-39003: unable to get count of total workers alive: Cause: Attempt to get count of total worker processes alive failed.; Action: Check the additional error messages to see what caused the failure. Correct the error, if possible, and try the operation again. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39004: invalid state: Cause: The state of the job precludes the execution of the API.; Action: Rerun the job to specify the API when the job is an appropriate state.
ORA-39005: inconsistent arguments: Cause: The current API cannot be executed because of inconsistencies between arguments of the API call. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.; Action: Modify the API call to be consistent with itself.
ORA-39006: internal error: Cause: An unexpected error occurred while processing a Data Pump job. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.; Action: Contact Oracle Customer Support.
ORA-39012: Client detached before the job started.: Cause: The client detached or ended their session before the Data Pump job was started.; Action: Create new job and remain attached to the job until it is started.
ORA-39013: Remapping the SYSTEM schema is not supported.: Cause: A remap_schema transform with the SYSTEM schema was specified.; Action: Retry the import command without remapping the SYSTEM schema.
ORA-39014: One or more workers have prematurely exited.: Cause: One or more of the worker processes exited before the job was completed. With no workers, the master process will terminate the job.; Action: Rerun the job. If problem persists, contact Oracle Customer Support.
ORA-39015: job is not running: Cause: An API was executed that required the job to be running, but the job was not active.; Action: Retry the API. If problem persists, contact Oracle Customer Support.
ORA-39016: Operation not supported when job is in string state.: Cause: The state of the job precludes the execution of the API.; Action: Rerun the job to specify the API when the job is an appropriate state.
ORA-39017: Worker request not supported when job is in string state.: Cause: The state of the job precludes the execution of a worker request. This is an internal error.; Action: Contact Oracle Customer Support.
ORA-39018: master process received invalid message number string: Cause: Internal Error; Action: Contact Oracle Customer Support.
ORA-39019: invalid operation type string: Cause: User specified an invalid operation name on an DBMS_DATAPUMP.OPEN API or an invalid operation name was specified in the master table for a restart API.; Action: Correct the operation name and recreate the job.
ORA-39020: invalid mode type string: Cause: User specified an invalid mode on an DBMS_DATAPUMP.OPEN API or an invalid mode was specified in the master table for a restart API.; Action: Correct the mode and recreate the job.
ORA-39021: Database compatibility version string is not supported.: Cause: User selected COMPATIBLE as the version on an DBMS_DATAPUMP.OPEN API, but the current database compatibility version is not supported by the Data Pump API. Database versions before 9.2 are not supported by the Data Pump.; Action: Specify a supported version and recreate the job.
ORA-39022: Database version string is not supported.: Cause: User selected LATEST as the version on an DBMS_DATAPUMP.OPEN API, but the current database version is not supported by the Data Pump API. Database versions before 9.2 are not supported by the Data Pump.; Action: Specify a supported version and recreate the job.
ORA-39023: Version string is not supported.: Cause: User specified an explicit version on an DBMS_DATAPUMP.OPEN API, but the current database version is not supported by the Data Pump API. Database versions before 9.2 are not supported by the Data Pump.; Action: Specify a supported version and recreate the job.
ORA-39024: wrong schema specified for job: Cause: Internal error caused by the master process finding inconsistencies between the schemas specified for the job.; Action: Contact Oracle Customer Support.
ORA-39025: jobs of type string are not restartable: Cause: Attempt to restart a job which was not restartable.; Action: Recreate the job via the open API.
ORA-39026: master table is inconsistent on validation string: Cause: Job cannot be restarted because it failed a validation check. Validation checks are of the form -xx.y where -xx is the value of the PROCESS_ORDER column in the master table where the error was detected and y is the actual validity check for the row.; Action: Recreate the job. If master table has not been modified, but problem persists, contact Oracle Customer Support.
ORA-39027: wrong version of master table: Cause: Job cannot be restarted because the version of the database upon which the job started is different than the current version of the database and the format of the master table has changed between the versions.; Action: Recreate the job.
ORA-39028: cannot restart job from string state: Cause: The job was not in a suitable state for restart. Jobs must begin executing before they can be restarted.; Action: Recreate the job.
ORA-39029: worker string with process name "string" prematurely terminated: Cause: The specified worker process terminated unexpectedly. Subsequent messages describe the reason for the termination.; Action: In many cases, the Data Pump will attempt to automatically restart the worker. If problem persists, contact Oracle Customer Support.
ORA-39030: invalid file type string: Cause: An invalid filetype was specified for an DBMS_DATAPUMP.ADD_FILE API call.; Action: Correct the filetype parameter and reissue the API request.
ORA-39031: invalid filter name string: Cause: An invalid filter name was specified on a DBMS_DATAPUMP.DATA_FILTER API call.; Action: Correct the filter name parameter and reissue the API request.
ORA-39032: Parameter string is not supported in string jobs.: Cause: The specified parameter was not supported for the specified class of jobs.; Action: Re-create the job with the appropriate mode or operation type.
ORA-39033: Data cannot be filtered under the direct path access method.: Cause: The user specified that the data access method for the job was direct which precludes the use of certain data filters.; Action: Use the SUBQUERY or the SAMPLE data filter with the automatic data access method.
ORA-39034: Table string does not exist.: Cause: The user referenced a table in an API that did not exist.; Action: Correct table name and retry API.
ORA-39035: Data filter string has already been specified.: Cause: The user has already specified a data filter that matches on the filter name, schema name, and table.; Action: Specify a different data filter.
ORA-39036: invalid metadata filter name string: Cause: An invalid metadata filter name was specified on a DBMS_DATAPUMP.METADATA_FILTER API call.; Action: Correct the metadata filter name parameter and reissue the API request.
ORA-39037: Object type path not supported for string metadata filter.: Cause: An object type path was specified for the filter, but the filter does not support the object type path parameter.; Action: Remove the object type path parameter.
ORA-39038: Object path "string" is not supported for string jobs.: Cause: The specified object type path is invalid for the job mode.; Action: Correct the object type path.
ORA-39039: Schema expression "string" contains no valid schemas.: Cause: The specified SCHEMA_EXPR filter resulted in no schemas being selected.; Action: Correct the the SCHEMA_EXPR filter specification.
ORA-39040: Schema expression "string" must identify exactly one schema.: Cause: For TABLE mode jobs, the SCHEMA_EXPR filter must identify exactly one schema.; Action: Correct the the SCHEMA_EXPR filter specification.
ORA-39041: Filter "string" either identifies all object types or no object types.: Cause: A Metadata filter specifying path names either returned all objects or no objects in the job.; Action: Correct the the metadata filter specification.
ORA-39042: invalid transform name string: Cause: An invalid transform name was specified on a DBMS_DATAPUMP.METADATA_TRANSFORM API call.; Action: Correct the transform name parameter and reissue the API request.
ORA-39043: Object type string is not supported for string.: Cause: The specified object type is invalid for the specified transform or remap.; Action: Correct the object type.
ORA-39044: Metadata transform string has already been specified.: Cause: The user has already specified the metadata transform for the same class of object types.; Action: Specify a different object_type for the transform.
ORA-39045: invalid metadata remap name string: Cause: An invalid metadata remap name was specified on a DBMS_DATAPUMP.METADATA_REMAP API call.; Action: Correct the metadata remap name parameter and reissue the API request.
ORA-39046: Metadata remap string has already been specified.: Cause: The user has already specified a metadata remap that matches on the remap name and original value.; Action: Specify a different original value.
ORA-39047: Jobs of type string cannot use multiple execution streams.: Cause: The user specified a value of parallelism that is precluded by the operation type or mode of the job.; Action: Specify only a parallelism of 1 for this type of job.
ORA-39048: Unable to start all workers; only string worker(s) available.: Cause: The full degree of parallelism could not be honored due process limits, resource limits, or other internal errors.; Action: Increase process/resource limits for the job.
ORA-39049: invalid parameter name string: Cause: An invalid parameter name was specified on a DBMS_DATAPUMP.SET_PARAMETER API call.; Action: Correct the parameter name and reissue the API request.
ORA-39050: parameter string is incompatible with parameter string: Cause: Two parameters were set that were incompatible with each other. Only the first parameter setting will be used.; Action: Decide which parameter is to be used and stick to it.
ORA-39051: parameter string specified multiple times: Cause: The user has already specified a parameter that matches on the name and the specific parameter doesn't support duplicate definitions.; Action: Specify non-repeatable parameters only once.
ORA-39052: cannot specify SKIP_CURRENT on initial start of a job.: Cause: The user has already specified SKIP_CURRENT for a job that has never executed.; Action: Only specify SKIP_CURRENT when restarting a job.
ORA-39053: parameter or attribute string must be defined for a string job: Cause: The job being defined cannot be started because it is missing the specified definition.; Action: Specify the omitted parameter or attribute before starting the job.
ORA-39054: missing or invalid definition of the SQL output file.: Cause: The job being defined could not be started because it was missing the file to receive the SQL output of the job, the SQL output file name conflicted with the output LOG file, or the definition was unusable.; Action: Specify a valid directory name and file name for the SQL file.
ORA-39055: The string feature is not supported in version string.: Cause: An attempt was made to use a feature that was not enabled in the database version specified for the current job. Typically, this error occurs if the compatibility level of the database was below the current version of the database or if the version for a Data Pump job was specified explicitly. specifies a .; Action: Specify the current database version as a version parameter for the job.
ORA-39056: invalid or duplicate log file specification: Cause: The log file for the job was incorrectly specified.; Action: Specify a valid directory name and file name for the log file.
ORA-39057: invalid worker request string for string jobs.: Cause: The worker process sent a message that wasn't supported for the current job.; Action: Internal error -- contact Oracle Customer Support and report the error.
ORA-39058: current object skipped: string of type string: Cause: The user specified SKIP_CURRENT when restarting a job. This message is a confirmation that the object will not be imported.; Action: User must manually define the object in the target database.
ORA-39059: dump file set is incomplete: Cause: An IMPORT or SQL_FILE operation was being performed but not all of the files from the EXPORT dump file set were included.; Action: Check the export log file and make sure all of the files that were exported are included in the current job.
ORA-39060: table(s) dropped because of conflict with master table: Cause: A table specified by a job was not included because its definition would collide with the master table definition for the current job.; Action: After the job completes. Import the conflicting tables using a unique job name to avoid conflicts with normal user tables.
ORA-39061: import mode string conflicts with export mode string: Cause: The mode used for import cannot be used with a dump file set of specified mode. Transportable jobs are not compatible with other modes.; Action: Perform the import using a mode compatible with the export.
ORA-39062: error creating master process string: Cause: An attempt to create the listed master process failed.; Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39064: unable to write to the log file: Cause: Errors were detecting while writing to the log file. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39065: unexpected master process exception in string: Cause: An unhandled exception was detected internally within the master control process for the Data Pump job. This is an internal error. messages will detail the problems.; Action: If problem persists, contact Oracle Customer Support.
ORA-39067: Unable to close the log file.: Cause: Errors were detecting while closing the log file. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39068: invalid master table data in row with PROCESS_ORDER=string: Cause: A corruption was detected in the master table in the specified row(s). Either the row wasn't found, it was missing columns or had illegal values in its columns.; Action: Rerun the job with an uncorrupted master table.
ORA-39070: Unable to open the log file.: Cause: Errors were detecting while opening the log file. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39071: Value for string is badly formed.: Cause: The value of the user specified filter did not contain a legitimate SQL clause. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39076: cannot delete job string for user string: Cause: Unable to delete a job. Refer to the any following or prior error messages for clarification.; Action: Eliminate the problems indicated.
ORA-39077: unable to subscribe agent string to queue "string": Cause: The Data Pump's communication layer was unable to attach one of its processes to the control or status queue. Subsequent messages will detail the problem.; Action: Fix the problem if possible, or contact Oracle Customer Support.
ORA-39078: unable to dequeue message for agent string from queue "string": Cause: The Data Pump's communication layer was unable to retrieve a message from the control or status queue. Subsequent messages will detail the problem.; Action: Fix the problem if possible, or contact Oracle Customer Support.
ORA-39079: unable to enqueue message string: Cause: The Data Pump's communication layer was unable to send the specified message on the control or status queue. Subsequent messages will detail the problem.; Action: Fix the problem if possible, or contact Oracle Customer Support.
ORA-39080: failed to create queues "string" and "string" for Data Pump job: Cause: The Data Pump's communication layer was unable to create the status and control queues required for interprocess communication. Subsequent messages will detail the problem.; Action: Fix the problem if possible, or contact Oracle Support.
ORA-39081: failed to unsubscribe agent string from queue "string": Cause: The Data Pump's communication layer was unable to unsubscribe a process from the control or status queue. Subsequent messages will detail the problem.; Action: Fix the problem if possible, or contact Oracle Customer Support.
ORA-39082: Object type string created with compilation warnings: Cause: The object in the SQL statement following this error was created with compilation errors. If this error occurred for a view, it is possible that the base table of the view was missing.; Action: This is a warning. The object may have to be recompiled before being used.
ORA-39083: Object type string failed to create with error:\nstring\nFailing sql is:\nstring: Cause: Examine original error code to determine actual cause; Action: Original error code will contain more information
ORA-39084: cannot detach job string for user string: Cause: Unable to detach a job from the session. Refer to any following error messages for clarification.; Action: Eliminate the problems indicated.
ORA-39085: cannot update job string for user string: Cause: Unable to update the fixed table information for a job. Refer to any following or prior error messages for clarification.; Action: Eliminate the problems indicated.
ORA-39086: cannot retrieve job information: Cause: Unable to retrieve fixed table information for a job. Refer to the secondary error messages that follow this one for clarification.; Action: Eliminate the problems indicated by the secondary errors.
ORA-39087: directory name string is invalid: Cause: A corresponding directory object does not exist.; Action: Correct the directory object parameter, or create a corresponding directory object with the CREATE DIRECTORY command.
ORA-39088: File name cannot contain a path specification.: Cause: The name of a dump file, log file, or SQL file contained a path specification."; Action: Use the name of a directory object to indicate where the file should be stored and remove the path specification from the DUMPFILE, LOGFILE or SQLFILE parameter.
ORA-39090: Cannot add devices to file oriented job.: Cause: Attempt to add a device to a job that already contains more than one disk file.; Action: Only specify one file for jobs that contain sequential devices.
ORA-39091: unable to determine logical standby and streams status: Cause: An error occurred when determining if the Data Pump job needed to support logical standby or streams.; Action: The subsequent message describes the error that was detected. Correct the specified problem and restart the job.
ORA-39092: unable to set SCN metadata for object "string.string" of type string: Cause: An error occurred when applying a SCN to the specified object to support logical standby or streams.; Action: The subsequent message describes the error that was detected. Correct the specified problem and restart the job.
ORA-39093: FLASHBACK automatically enabled to preserve database integrity.: Cause: A Data Pump job was required to enable flashback support to specific SCNs in order to preserve the consistency of a logical standby or streams instantiation.; Action: None
ORA-39094: Parallel execution not supported in this database edition.: Cause: Parallel execution of Data Pump jobs is not supported for this database edition.; Action: Specify a parallelism of 1 for jobs not running on Enterprise Edition databases.
ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes: Cause: The Export job ran out of dump file space before the job was completed.; Action: Reattach to the job and add additional dump files to the job restarting the job.
ORA-39096: invalid input value string for parameter string: Cause: A NULL or invalid value was supplied for the parameter.; Action: Correct the input value and try the call again.
ORA-39097: Data Pump job encountered unexpected error string: Cause: An unexpected, potentially non-fatal error occurred while processing a Data Pump job.; Action: Contact Oracle Customer Support.
ORA-39098: Worker process received data objects while loading metadata. Invalid process order range is string..string: Cause: This is an internal error. Messages will detail the problem.; Action: If problem persists, contact Oracle Customer Support.
ORA-39099: cannot create index for "string" on master table string: Cause: One or more indexes couldn't be created on the master table. subsequent error messages describe the failure.; Action: Correct the condition that is preventing the indexes from being created.
ORA-39102: Timeout before master process string finished initialization. Master error:: Cause: The master process whose name is listed started up but did not finish its initialization within the allowed time limit.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39103: Timeout before worker process string finished initialization. Worker error:: Cause: The worker process whose name is listed started up but did not finish its initialization within the allowed time limit.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39104: cannot call this function from a SQL parallel query slave process: Cause: Called a Data Pump process model function from a process which is a SQL parallel query slave process; Action: A SQL parallel query slave process cannot create a Data Pump master process. This is not supported. If this error occurs from a Data Pump client (for example, expdp or impdp), contact Oracle Customer Support and report the error.
ORA-39105: Master process string failed during startup. Master error:: Cause: The master process whose name is listed failed during startup.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39106: Worker process string failed during startup. Worker error:: Cause: The worker process whose name is listed failed during startup.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39107: Master process string violated startup protocol. Master error:: Cause: The master process whose name is listed started up but then exited before notifying the creating process that it was finished with initialization.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39108: Worker process string violated startup protocol. Worker error:: Cause: The worker process whose name is listed started up but then exited before notifying the creating process that it was finished with initialization.; Action: Refer to any following error messages for possible actions. Also, check the trace log for the failed process, if one was created, to see if there is any additional information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39109: Unprivileged users may not operate upon other users' schemas: Cause: An unprivileged user attempted to reference another user's schema during a Data Pump operation. Because of this, no schemas were were selected for the job.; Action: Retry the operation under a username owning the schema.
ORA-39110: error deleting worker processes: Cause: An attempt to delete the worker processes failed.; Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39111: Dependent object type string skipped, base object type string already exists: Cause: During a Data Pump import job, a dependent object is being skipped because its base object already existed.; Action: If the object from the dump file is wanted, drop the base and dependent objects and try to import again using desired filters.
ORA-39112: Dependent object type string skipped, base object type string creation failed: Cause: During a Data Pump import job, a dependent object is being skipped because its base object creation failed.; Action: If the object from the dump file is wanted, drop the base and dependent objects and try to import again using desired filters
ORA-39113: Unable to determine database version: Cause: The Data Pump was unable to determine the compatibility level and version of the current database using SYS.DBMS_UTILITY.DB_VERSION.; Action: Make sure access to the DBMS_UTILITY package is granted to you. If this is a network job, be sure that access to the DBMS_UTILITY package is granted to you on the remote instance.
ORA-39114: Dump files are not supported for network jobs.: Cause: An attempt was made to add a dumpfile to an Import job that is using a network link to the source database.; Action: Do not specify a dumpfile for jobs that do not require dumpfiles.
ORA-39115: string is not supported over a network link: Cause: An attempt was made to use an option that is not supported over network links such as the PARTITION_LIST filter.; Action: Do not attempt to use Data Pump features on network jobs if they are not compatible with jobs over the network.
ORA-39116: invalid trigger operation on mutating table string.string: Cause: A Data Pump load operation failed because a trigger attempted to fire on the table while it was mutating.; Action: Disable trigger(s) on the specified table. Also see ORA-004091.
ORA-39117: Type needed to create table is not included in this operation. Failing sql is:\nstring: Cause: A create table was attempted and a dependent type does not exist in the dumpfile or on the target database. Either the export or the import Data Pump job was a table mode job and types are not included in table mode jobs.; Action: Determine which type(s) are missing and create them on the target system and run the Data Pump import job again.
ORA-39119: worker process interrupt for delete worker processes call by master process: Cause: The master process that created this worker process called delete worker processes to abort the current operation.; Action: No action is necessary. This is an informational error message.
ORA-39120: Table string can't be truncated, data will be skipped. Failing error is:\nstring: 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.
ORA-39121: Table string can't be replaced, data will be skipped. Failing error is:\nstring: Cause: Table data was about to be loaded into a table that already existed and the table_exists_action parameter is replace, but the table could not be dropped.; Action: Determine actual cause by looking at base error.
ORA-39122: Unprivileged users may not perform string remappings.: Cause: A user attempted to remap objects during an import but lacked the IMPORT_FULL_DATABASE privilege.; Action: Retry the job from a schema that owns the IMPORT_FULL_DATABASE privilege.
ORA-39123: Data Pump transportable tablespace job aborted\nstring: Cause: A DBMS_PLUGTS procedure failed and the Data Pump operation could not continue so it was aborted. The DBMS_PLUGTS failure listed describes the original error.; Action: Look at the DBMS_PLUGTS error to determine actual cause.
ORA-39124: dump file name "string" contains an invalid substitution variable: Cause: The substitution variable '%' must be followed by '%','u', or 'U'.; Action: Correct the substitution variable in the dump file name and re-enter the command.
ORA-39125: Worker unexpected fatal error in string while calling string [string]: Cause: An unhandled exception was detected internally within the worker process for the Data Pump job while calling the specified external routine. This is an internal error. Additional information may be supplied.; Action: If problem persists, contact Oracle Customer Support.
ORA-39126: Worker unexpected fatal error in string [string] \nstring: Cause: An unhandled exception was detected internally within the worker process for the Data Pump job. This is an internal error. Additional information may be supplied.; Action: If problem persists, contact Oracle Customer Support.
ORA-39127: unexpected error from call to string \nstring: Cause: The exception was raised by the function invocation, a procedural action extension of export.; Action: Record the accompanying messages and report this as a Data Pump internal error to customer support.
ORA-39128: unexpected DbmsJava error number from statement string: Cause: The error was returned from a call to a DbmsJava procedure.; Action: Record the accompanying messages and report this as a Data Pump internal error to customer support.
ORA-39129: Object type string not imported. Name conflicts with the master table: Cause: The table being imported from the remote instance has the same name as the master table running this Data Pump job.; Action: Rerun the Data Pump job with a nonconflicting name.
ORA-39130: Object type string not imported. Base object name conflicts with the master table: Cause: The object being imported from the remote instance is dependent on an object that has the same name as the master table running this Data Pump job.; Action: Rerun the Data Pump job with a nonconflicting name.
ORA-39132: object type "string"."string" already exists with different hashcode: Cause: An object type could not be created because there was already a type with the same name but a different hashcode on the target system. Tables in the transportable tablespace set that use this object type cannot be read.; Action: Drop the object type from the target system and retry the operation.
ORA-39133: object type "string"."string" already exists with different typeid: Cause: An object type in a transportable tablespace set already exists on the target system, but with a different typeid. The typeid could not be changed because the type is used by an existing table. Tables in the transportable tablespace set that use this object type cannot be read.; Action: Drop the object type from the target system and retry the operation.
ORA-39134: Cannot include "string" tablespace as a Transportable Tablespace: Cause: The user attempt to specify the SYSAUX or SYSTEM tablespace as a member of the transportable tablespace list in the current job. These tablespaces may not be transported between databases.; Action: Specify different tablespaces to be transported.
ORA-39135: File "string" is already a member of this dump set: Cause: An attempt was made to add a new file to an export job but a file with the same name already exists in the dump set for the job.; Action: Reenter the new file information using a different file name.
ORA-39136: cannot specify an SCN on a transportable job: Cause: A target SCN was specified for a table in a transportable job by the streams or logical standy components which was not the defaulted SCN for the table.; Action: This is an internal error. Please report it to Oracle support.
ORA-39137: cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata: Cause: A job was defined with the TABLE_EXISTS_ACTION parameter set to REPLACE or SKIP, but without metadata. Without metadata, data could not be loaded for the requested table actions.; Action: Change the setting of the TABLE_EXISTS_ACTION parameter to APPEND or TRUNCATE or supply Metadata with the data.
ORA-39138: Insufficient privileges to load data not in your schema: Cause: An unprivileged user attempted to load data into a different schema.; Action: Use a privileged account if you must load data not in your schema
ORA-39139: Data Pump does not support XMLType objects in version string. string will be skipped.: Cause: Object had an XMLType column using either an object relational or binary storage format, which is unsupported by Data Pump in the target version.; Action: Use the original export and import utilities to move this object.
ORA-39140: dump file "string" belongs to job string: Cause: When a dump file set consists of multiple files, all files in the set must be specified for an import operation, and all files must have been produced by the same export job. One of the files provided does not belong to the original dump file set. For instance, it was created by a different export job than the other files.; Action: Remove the dump file indicated in the message and retry the import operation providing only the complete set of dump files created by a specific export job.
ORA-39141: dump file "string" is a duplicate of dump file "string": Cause: When a dump file set consists of multiple files, all files in the set must be specified for an import operation. One of the files provided to import was found to be a duplicate of another dump file in the set. This can occur if the files in the dump set were copied or renamed using operating system utilities and the same dump file was inadvertently copied more than once with different destination names.; Action: Remove the dump file indicated in the message and retry the import operation providing only the complete set of dump files created by a specific export job.
ORA-39142: incompatible version number string in dump file "string": Cause: A dump file was specified for an import operation whose version number is incompatible with the dump file version of the Data Pump product currently running on the system. Usually this message indicates that the dump file was produced by a newer version of the Data Pump export utility.; Action: Import this dump file using the Data Pump import utility with the same version as the export which created the file.
ORA-39143: dump file "string" may be an original export dump file: Cause: A dump file was specified for an import operation which appears to have been created using the original export utility. These dump files cannot be processed by the Data Pump import utility.; Action: Try using the original import utility to process this dump file.
ORA-39144: The file name parameter must be specified and non-null.: Cause: A file name was not provided in the DBMS_DATAPUMP.ADD_FILE API call.; Action: Correct the file name parameter and reissue the API request.
ORA-39145: directory object parameter must be specified and non-null: Cause: No directory object was provided in either an DBMS_DATAPUMP.ADD_FILE API call or to the directory parameter used by the Data Pump command line clients.; Action: Correct the directory object parameter and retry the operation.
ORA-39146: schema "string" does not exist: Cause: The specified schema was referenced as the source of a REMAP_SCHEMA parameter, but did not exist in the dump file (for file-based import) or in the source database (for network import).; Action: Specify the correct name of the schema to be remapped.
ORA-39147: cannot migrate Data Pump queue table ownership to this instance: Cause: There are active Data Pump jobs running on another instance in a RAC. All concurrent, active Data Pump jobs must be run on the same instance.; Action: Start this job on the same instance where other active Data Pump jobs are running, or wait until they finish.
ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table: Cause: A Data Pump import detected that a queue table that was to be imported already exists. Importing data into pre-existing queue tables is not supported.; Action: If the data from the dump file is desired, then drop the queue table and perform the import again, or use the import parameter table_exists_action=replace.
ORA-39149: cannot link privileged user to non-privileged user: Cause: A Data Pump job initiated by a user with DATAPUMP_EXP_FULL_DATABASE or DATAPUMP_IMP_FULL_DATABASE roles specified a network link that did not correspond to a user with equivalent roles on the remote database.; Action: Specify a network link that maps users to identically privileged users in the remote database.
ORA-39150: bad flashback time: Cause: A flashback time was specified for the Data Pump job which either could not be parsed or else could not be translated into a system change number (SCN). This typically occurs when specifying a time far in the past.; Action: Specify an explicit SCN for the desired flashback rather than a time.
ORA-39154: Objects from foreign schemas have been removed from import: Cause: An non-privileged user attempted to import objects into a schema other than their own.; Action: Either perform the import from a privileged schema or else remap all schemas that were exported into the username running the import.
ORA-39155: error expanding dump file name "string": Cause: Export was unable to expand the directory object and dump file name into a full file name. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39156: error parsing dump file name "string": Cause: Export was unable to parse the dump file name. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39157: error appending extension to file "string": Cause: Export or Import was unable to append the default extension to create the file name. The given file name could be too long or contain illegal characters. Subsequent messages will detail the problems.; Action: Fix the problems outlined in the secondary messages.
ORA-39159: Cannot call this function from a non-Oracle Data Pump process: Cause: Called an Oracle Data Pump process model function from a process which is not an Oracle Data Pump process.; Action: Refer to error message for additional information. If this error occurs from an Oracle Data Pump Export client or Import client. Try the operation again. If the error persists, contact Oracle Support Services.
ORA-39160: error on whats my name call: Cause: Attempt to get the Data Pump process name failed.; Action: Refer to any following error messages for additional information. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39161: Full database jobs require privileges: Cause: Either an attempt to perform a full database export without the EXP_FULL_DATABASE role or an attempt to perform a full database import over a network link without the IMP_FULL_DATABASE role.; Action: Retry the operation in a schema that has the required roles.
ORA-39162: Transportable tablespace job require privileges: Cause: User attempted to perform a transportable tablespace job without being having the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role.; Action: Retry the operation in a schema that has the required roles.
ORA-39163: A sample size of string is invalid.: Cause: An attempt was made to do data sampling on a table with a value outside of the range of 0 - 100.; Action: Retry the filtering using a sampling number greater than 0 and less than 100.
ORA-39164: Partition string was not found.: Cause: If exporting or importing over the network, the user specified a partition name that was not found in the source database. For importing from files, the user specified a partition name not found in the dump file set.; Action: Retry the operation using the correct partition name.
ORA-39165: Schema string was not found.: Cause: If exporting or importing over the network, either the user specified a schema name that was not found in the source database or else the user lacked the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role that would allow them to access another schema. For importing from files, the user specified a schema name not found in the dump file set.; Action: Retry the operation using the correct schema name.
ORA-39166: Object string was not found or could not be exported or imported.: Cause: If exporting to files or importing over the network, one of the following occurred: - The object specified did not exist in the source database. - The user lacked the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role that would allow access to the object. - The VIEWS_AS_TABLES object contained a type that is not supported with the VIEWS_AS_TABLES parameter. If importing from files, the user specified an object name that was not found in the dump file set.; Action: Retry the operation using the correct object name, correct set of privileges, or a view that has only supported types.
ORA-39168: Object path string was not found.: Cause: If exporting or importing over the network, the user specified an object type path name that was not found in the source database. For importing from files, the user specified an object type path name not found in the dump file set.; Action: Retry the operation using the correct object type path name.
ORA-39169: Local version of string cannot work with remote version of string.: Cause: A Data Pump job specified a network link, but the version on the remote database cannot interoperate with the version on the local database.; Action: Do not specify network links between instance running different versions of the database.
ORA-39170: Schema expression string does not correspond to any schemas.: Cause: A schema expression or schema list was supplied for a Data Pump job that did not identify any schemas in the source database.; Action: Correct the schema specifications and retry the job.
ORA-39171: Job is experiencing a resumable wait.\nstring: Cause: The Data Pump job is stalled with one or more of its sessions having a resumable wait. Resumable waits are typically caused by a non-expandable tablespace running out of space. The follow-on message describes the nature of the wait.; Action: Correct the condition causing the wait. This will typically involve adding datafiles to the tablespace that is full.
ORA-39172: Cannot remap transportable tablespace names with compatibility of string.: Cause: The user attempted to remap a tablespace name in a transportable tablespace job when the compatibility level was set below 10.1.; Action: Reset the compatibility level of the database to a more recent version.
ORA-39173: Encrypted data has been stored unencrypted in dump file set.: Cause: No encryption password was specified for an export job that involved data that was encrypted in the database.; Action: No specific user action is required. This is only a warning that secure data may be readable from within the dump file set.
ORA-39174: Encryption password must be supplied.: Cause: No encryption password was supplied to import a dump file set that was created using an encryption password. Alternatively, no encryption password was supplied to a transportable export job in which one or more tablespaces in the transportable set contained data for tables with encrypted columns.; Action: Specify the encryption password for the dump file set.
ORA-39175: Encryption password is not needed.: Cause: An encryption password was supplied to import a dump file set that was not created using an encryption password.; Action: No user action is required. This is merely a warning message.
ORA-39176: Encryption password is incorrect.: Cause: Wrong encryption password was supplied to import a dump file set.; Action: Resubmit the job using the correct encryption password for the dump file set.
ORA-39177: invalid compression value string: Cause: An invalid value was specified for compression.; Action: Correct the value and recreate the job.
ORA-39178: cannot perform estimate on metadata only jobs: Cause: An estimate was requested for a job by specifying the ESTIMATE or ESTIMATE_ONLY parameter. However, the job was also defined to have no data. These specifications conflict with each other.; Action: Remove one of the conflicting specifications for the job.
ORA-39179: unable to load table "string"."string" because of OID transform: Cause: The OID transform for the job was set to false and the identified table contained either VARRAYs with non-final types or unscoped REF columns. Both of these column types have embedded OIDs so they cannot be imported correctly when OIDs are not preserved.; Action: You must manually move the data with the specified tables when OIDs are not preserved.
ORA-39180: unable to encrypt ENCRYPTION_PASSWORD: Cause: The specified encryption password was unable to be encrypted for placement within the master table or decrypted when it was to be restored from the master table. Subsequent messages will describe the actual error that caused the encryption to fail.; Action: Fix the problems referenced by the subsequent messages. The most common reason for the encryption to fail is the lack of a security wallet.
ORA-39181: Only partial table data may be exported due to fine grain access control on string: Cause: An unprivileged user has tried to export a table that has fine grain access control. The table owner is subjected to access control and may not be able to export all rows in the table. Only the rows that can be seen by that user will be exported. In order to preserve integrity of the table, the user importing the table should have enough privilege to recreate the table with the security policies at import time.; Action: It is strongly recommended that the database administrator handle exporting of this table.
ORA-39182: internal error string occurred during compression phase string\n: Cause: An unexpected error occurred while compressing data buffers.; Action: Contact Oracle Customer Support.
ORA-39183: internal error string ocurred during decompression phase string\n: Cause: An unexpected error occurred while decompressing data buffers.; Action: Contact Oracle Customer Support.
ORA-39184: Transportable Data Pump jobs cannot exclude PLUGTS objects: Cause: A Transportable Data Pump job requires all PLUGTS% objects, but the user-supplied exclude filters were excluding these objects.; Action: Reenter command without excluding PLUGTS% objects.
ORA-39185: The transportable tablespace failure list is: Cause: Some of the tablespaces specified for this job could not be exported.; Action: See specific errors for each tablespace, correct the problem, and try again.
ORA-39186: No tablespaces in the specified list exist.: Cause: The tablespaces specified on the EXPORT command did not exist.; Action: Check the list of tablespaces and reenter command with correct set of tablespaces.
ORA-39187: The transportable set is not self-contained, violation list is: Cause: The tablespaces specified for this job did not satisfy the closure checking. The list of violations specified each closure violation.; Action: See specific errors for violation and correct the problem or change the tablespaces on the command line and try again.
ORA-39188: unable to encrypt dump file set: Cause: Data Pump could not create an encrypted dump file set. This message will be accompanied by other messages that give more details about why the encrypted dump file set could not be created. The most common reason for this message is that you are trying to create a dump file set that can be transparently decrypted, and the database external security device is not open.; Action: If the external security device is not open, then open it. If the external security device is not configured, then the only type of encrypted dump file set that you can create is a password-based dump file set.
ORA-39189: unable to decrypt dump file set: Cause: The dump file set could not be decrypted. The reason could be that either an invalid password was entered, or, when using transparent decryption, the database wallet or external security device was not open.; Action: If password-based import was enabled for this dump file set, then supply the correct password. If transparent import was enabled for this dump file set, then ensure that the database wallet or external security device is open.
ORA-39192: table mode jobs with transportable=always and partition filters only allow objects from one table: Cause: Multiple tables are not supported when specifying partitions while using transportable table mode.; Action: Retry the job specifying only one table.
ORA-39193: Table mode jobs do not allow the schema to be wild carded.: Cause: The table filter included a schema expression with the % wild card.; Action: Retry the job specifying actual schemas.
ORA-39194: Table mode jobs require the tables to be comma separated.: Cause: The string describing tables in a table mode job was not comma separated.; Action: Retry the job specifying the tables separated by commas.
ORA-39195: At least one schema in the TABLE_FILTER does not exist.: Cause: The TABLE_FITER specified contains a schema that does not exist.; Action: Retry the job specifying only schemas that exist.
ORA-39200: Link name "string" is invalid.: Cause: The name of the network link supplied for a Data Pump job was not usable. Secondary messages identify the problem.; Action: Rerun the job using a valid network link.
ORA-39201: Dump files are not supported for estimate only jobs.: Cause: An attempt was made to add a dumpfile to an Export job that only requested file estimates.; Action: Do not specify a dumpfile for jobs that do not require dumpfiles.
ORA-39202: Data cannot be filtered or selected in string jobs.: Cause: A data filter was supplied for the specified type of job, but is not supported in the specified job type. From the command line, data filters can be specified by the CONTENT, TABLES (partition specifications), SAMPLE and QUERY parameters.; Action: Do not restrict data handling on jobs that cannot support data filtering.
ORA-39203: Partition selection is not supported over a network link.: Cause: Specific partitions were selected for a job operating over a network link.; Action: Remove the partition specifications and rerun the job.
ORA-39204: No subsetting of tablespaces is allowed for transportable import.: Cause: A tablespace filter was applied to a transportable import job that was not performed over a network link. In this case, the tablespace may not be changed from its specification at export time.; Action: Rerun the job without specifying a tablespace filter.
ORA-39205: Transforms are not supported in transportable jobs.: Cause: A metadata transformation such as STORAGE or SEGMENT_ATTRIBUTES has been specified for a transportable Data Pump job.; Action: Rerun the job without specifying a transform.
ORA-39206: A parallel degree of string is invalid.: Cause: A bad numeric was supplied for specifying the parallelism to be used within a Data Pump job. The degree of parallelism must be an integer great than 0.; Action: The the degree specifying and retry the parallelism setting.
ORA-39207: Value string is invalid for parameter string.: Cause: A parameter for a Data Pump job was set with a NULL or invalid value.; Action: Refer to the documentation to identify the legal values for each parameter. Retry the operation with a valid value.
ORA-39208: Parameter string is invalid for string jobs.: Cause: The a parameter has been specified that is not supported for the specified type of Data Pump.; Action: Remove the parameter specification and retry the operation.
ORA-39209: Parameter string requires privileges.: Cause: Use of the specified privileges requires the user to have the IMP_FULL_DATABASE role for import jobs or the EXP_FULL_DATABASE role for export jobs.; Action: Remove the parameter specification and retry the operation.
ORA-39210: A PCTSPACE adjustment of string is invalid.: Cause: User specified a storage space transformation that was out of range. Values for PCTSPACE must be greater than zero.; Action: Retry the operation with a valid PCTSPACE value.
ORA-39211: unable to retrieve dumpfile information as specified: Cause: User specified an invalid or inaccessible file with the specified filename and directory object.; Action: Retry the operation with a valid directory object and filename.
ORA-39212: installation error: XSL stylesheets not loaded correctly: Cause: The XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary table "sys.metastylesheet." Either the stylesheets were not loaded at all, or they were not converted to the database character set.; Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
ORA-39213: Metadata processing is not available: Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.; Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
ORA-39214: Data Pump does not support external tables with encrypted columns. string will not be exported: Cause: The object is an external table with encrypted columns and this is unsupported with Data Pump.; Action: External table must be manually recreated on the target system.
ORA-39216: object type "string"."string" hashcode or version number mismatch: Cause: An object type in a transportable tablespace set could not be used because there was a type with the same name but a different hashcode (and type definition) or the same hashcode but different version numbers for the type on the target system. Tables in the transportable tablespace set that use this object type cannot be created.; Action: Drop the object type and dependent objects from the target system if possible and retry the operation.
ORA-39217: object type "string"."string" typeid mismatch: Cause: An object type in a transportable tablespace set already exists on the target system, but with a different typeid. The typeid could not be changed because the type or a dependent type is used by an existing table. Tables in the transportable tablespace set that use this object be created.; Action: Drop the object type and dependent objects from the target system if possible and retry the operation.
ORA-39218: type check on object type "string"."string" failed: Cause: The type check on a type failed. Therefore, the table create for the table which uses the type also fails.; Action: Refer to any following error messages for additional information. Correct the error, if possible, and try the action again.
ORA-39219: directory object name is too long: Cause: The directory object name provided to the Data Pump Job was invalid because its length was greater than 30 characters.; Action: Retry the operation with a valid directory object name.
ORA-39220: file name is too long: Cause: The file name provided to the Data Pump Job was invalid because its length was greater than 4000 characters.; Action: Retry the operation with a valid file name.
ORA-39221: Specifying data filters is invalid when dumpfiles do not contain table data.: Cause: A data filter was supplied for an import job, but the dumpfile does not contain any table data. The export command created a dumpfile with metadata only. No table data was included. From the command line, data filters can be specified by the CONTENT, SAMPLE and QUERY parameters.; Action: Do not restrict data handling on jobs that cannot support data filtering.
ORA-39222: Unable to create global temporary master table string: Cause: Data Pump tried to create a global temporary master table but could not. The errors that follow describe why the table could not be created.; Action: Examine and fix the problems described in the additional errors.
ORA-39223: Internal Data Pump error. Master table information for version string not found.: Cause: An unexpected error occurred while processing the job. The data in an internal table could not be found.; Action: Contact Oracle Support Services.
ORA-39224: string row(s) were rejected with the following error:\nstring: Cause: These rows were not loaded due to constraint or index violations.; Action: Retry the operation when row data is fixed.
ORA-39228: Unable to construct a unique departitioned object name for string string.string:string when defaulted.: Cause: All (sub)partitions in the job were to be created as individual objects and the renaming was defaulted. The job will attempt to create unique object names, but the name creation algorithm was unable to find a unique object name for the specified (sub)partition.; Action: Specify a rename_table transform to use or delete some of the existing objects causing the name conflicts.
ORA-39230: Service name string is not available: Cause: The specified resource service name for the Data Pump job was not available.; Action: Pick a service name that the user is authorized to use.
ORA-39231: invalid data remap name: string: Cause: The specified type of data remapping was not supported.; Action: Only COLUMN_FUNCTION data remaps are supported. Retry the operation using a supported data remap name.
ORA-39232: invalid remap function: string: Cause: The specified package function for performing data remapping was not found.; Action: Either create the specified package function or else grant the user access to the function.
ORA-39233: invalid remap column name: string: Cause: The column name specified for the data remapping either does not exist in the specified table, is not a scalar column, or is not supported.; Action: Specify a scalar column name within the table to be remapped.
ORA-39234: Data cannot be remapped under the direct path access method.: Cause: Data remapping was requested on a job that requires the direct path access method. Data remapping can only be performed using the external table access method.; Action: Retry the job without specifying any access method.
ORA-39235: data remap string has already been specified: Cause: A data remap has already been specified for the indicated column. Only one data remap may be defined for a column.; Action: Remove one of the data remap specifications for the job.
ORA-39237: Failed to load XML document string. Compare process aborted.: Cause: An error occurred while performing XML difference parse.; Action: Resubmit XML compare request with valid document.
ORA-39238: XML node attribute differences are not supported.: Cause: MDAPI XML difference parsing did not support node attributes.; Action: Resubmit XML compare request with valid document.
ORA-39239: No differences found.: Cause: XML documents compared were identical.; Action: No action required.
ORA-39240: Error while processing difference document.: Cause: Error occurred in the MDAPI difference writer.; Action: Refer to any following error messages for additional information. Correct the error, if possible, and try the action again.
ORA-39242: Unable to export/import string due to table attributes.: Cause: See the Data Pump documentation for an explanation of what table attributes prevent an export or import from succeeding.; Action: Resolve conflicting table attributes.
ORA-39243: Import job requires 'TRANSPORT_DATAFILES' parameter.: Cause: The export job used 'TRANSPORTABLE=ALWAYS' and the import job requires TRANSPORT_DATAFILES to be specified.; Action: Specify the transport datafiles associated with this job.
ORA-39245: import job requires export dump file "string": Cause: A Data Pump IMPORT or SQL_FILE operation was being performed but not all of the files from the Data Pump export dump file set were included.; Action: Check the export log file and make sure all of the files that were exported are included in the current job. The import log file also lists the export names of the missing files.
ORA-39246: cannot locate master table within provided dump files: Cause: A Data Pump IMPORT or SQL_FILE operation was being performed but not all of the files from the Data Pump export dump file set were included. In particular, the dump file containing the export job's master table was not provided.; Action: Check the export log file and make sure all of the files that were exported are included in the current job.
ORA-39251: Importing a SecureFile LOB with metadata into a scalar, column string, is not allowed.: Cause: An import of a SecureFile LOB with metadata into a scalar column was attempted.; Action: Change the scalar column to a SecureFile LOB.
ORA-39252: Importing a SecureFile LOB with metadata or archived SecureFile LOB into a BasicFile LOB is not allowed: Cause: An attempt was made to import a SecureFile LOB that contained metadata or was archived at the time of export into a BasicFile LOB.; Action: Perform the import into a different table, perform DBMS_LOB.ARCHIVE_GET on any archived SecureFile LOBs, and then use INSERT AS SELECT to migrate the SecureFile LOB data to the BasicFile LOB.
ORA-39253: Specified tables do not exist.: Cause: The tables specified for this export job did not exist.; Action: Check the specified table list and make sure the tables listed exist.
ORA-39254: Direct path load not possible into preexisting table with column that has a default value and is not being loaded or is default on null; table string, column string: Cause: The direct path access method could not be used to load into a preexisting table that has a column with a default value and that column is not being loaded into, or the column is default on null.; Action: Remove the ACCESS_METHOD parameter from the import command line.
ORA-39255: Failed to fetch PLUGTS_BLKs.: Cause: The Data Pump expected a PLUGTS_BLK object to be exported but none were.; Action: Contact Oracle Support Services.
ORA-39256: Transportable tablespace Data Pump jobs from read-only databases not supported.: Cause: The remote database was read-only and Data Pump export jobs using transportable tablespace over a network link require the remote database to be read/write.; Action: Use Data Pump without transportable tablespace or make the remote database read/write.
ORA-39258: Cannot rename cluster.: Cause: DBMS_METADATA_DIFF was comparing two clusters with different names. There is no SQL ALTER statement to rename a cluster.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39259: Cannot add column to cluster.: Cause: DBMS_METADATA_DIFF was comparing two clusters with different column lists. There is no SQL ALTER statement to add a column to a cluster.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39260: Cannot delete column from cluster.: Cause: DBMS_METADATA_DIFF was comparing two clusters with different column lists. There is no SQL ALTER statement to delete a column from a cluster.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39261: Cannot modify column in cluster.: Cause: DBMS_METADATA_DIFF was comparing two clusters with different column lists. There is no SQL ALTER statement to modify a column in a cluster.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39262: Cannot alter size for hash cluster.: Cause: DBMS_METADATA_DIFF was comparing two hash clusters with different sizes. There is no SQL ALTER statement to modify the size of a hash cluster.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39263: Cannot alter PARALLEL INSTANCES.: Cause: DBMS_METADATA_DIFF was comparing two objects, both with PARALLEL but with different INSTANCES values. There is no SQL ALTER statement to modify PARALLEL INSTANCES.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39264: Cannot alter type of table: string: Cause: DBMS_METADATA_DIFF was comparing tables of different types: relational table, object table or XMLType table. There is no SQL ALTER statement to change a table's type.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39265: Cannot alter object_type of object table: string: Cause: DBMS_METADATA_DIFF was comparing object tables based on different object types. There is no SQL ALTER statement to change an object table's object type.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39266: Cannot add, remove, or modify partitioning attributes.: Cause: DBMS_METADATA_DIFF was comparing two tables with different partitioning attributes. There is no SQL ALTER statement to resolve these differences.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39267: Cannot remove default from table column.: Cause: DBMS_METADATA_DIFF was comparing two table columns, one with a default value, one without. There is no SQL ALTER syntax to remove a column default.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39268: Cannot alter a real column to make it virtual or vice versa.: Cause: DBMS_METADATA_DIFF was comparing two table columns, one virtual, one real. There is no SQL ALTER statement to make a virtual column real or vice versa.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39269: Cannot alter a column of type LONG to anything other than LOB.: Cause: DBMS_METADATA_DIFF was comparing two table columns, the first of type LONG, the second of a data type other than LOB. There is no SQL ALTER statement to modify a long data type to anything other than a CLOB or NCLOB.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39270: Cannot alter a column to or from a LOB data type.: Cause: DBMS_METADATA_DIFF was comparing two table columns, one of type CLOB, NCLOB or BLOB, the second of some other data type. There is no SQL ALTER statement to change the data type to or from a LOB column.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39271: Cannot alter substitutability of column: string: Cause: DBMS_METADATA_DIFF was comparing two table columns. This error may occur because the first column is substitutable and the second column is not, or because the first column is OF TYPE and the second column is substitutable.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39272: Cannot alter organization of nested table column: string: Cause: DBMS_METADATA_DIFF was comparing two nested table columns. One was a heap table, the other an index-organized table. There is no SQL ALTER statement to change the organization of a nested table.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39273: Cannot alter storage type of XMLType column: string: Cause: DBMS_METADATA_DIFF was comparing two XMLType columns with different storage types (CLOB, BINARY, OBJECT RELATIONAL). There is no SQL ALTER statement to change the storage type of an XMLType column.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39274: Cannot alter physical organization of table.: Cause: DBMS_METADATA_DIFF was comparing two tables with different physical organizations (heap, index organized, external, or cluster). There is no SQL ALTER statement to change the physical organization of a table.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39275: Cannot alter INITIAL storage option.: Cause: DBMS_METADATA_DIFF was comparing two tables with different FREELIST GROUPS storage options. There is no SQL ALTER statement to change a table's INITIAL storage option.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39276: Cannot alter MINEXTENTS storage option.: Cause: DBMS_METADATA_DIFF was comparing two tables with different MINEXTENTS storage options. There is no SQL ALTER statement to change a table's MINEXTENTS storage option.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39277: Cannot alter FREELIST GROUPS storage option.: Cause: DBMS_METADATA_DIFF was comparing two tables with different FREELIST GROUPS storage options. There is no SQL ALTER statement to change a table's FREELIST GROUPS storage option.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39278: Cannot alter table with segments to segment creation deferred.: Cause: DBMS_METADATA_DIFF was comparing two tables, the first with allocated segments, the second with deferred segments. There is no SQL ALTER statement to change a table which already has segments to segment creation deferred.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39279: Cannot alter tablespace of overflow segment.: Cause: DBMS_METADATA_DIFF was comparing two index organized tables whose overflow segments have different tablespaces. There is no SQL ALTER statement to change an overflow segment's tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39280: Cannot drop overflow segment.: Cause: DBMS_METADATA_DIFF was comparing two index organized tables, the first with an overflow segment, the second without. There is no SQL ALTER statement to drop an overflow segment.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39281: Cannot alter COMPRESS in index-organized materialized view.: Cause: DBMS_METADATA_DIFF was comparing two index organized materialized views with different key compression values. There is no SQL ALTER statement to modify the key compression of an index organized materialized view.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39282: Cannot alter default tablespace of partitions in partitioned table.: Cause: DBMS_METADATA_DIFF was comparing two partitioned tables with different default tablespaces. There is no SQL ALTER statement to change the default tablespace of a partitioned table.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39283: Cannot drop, split or merge hash partition: string: Cause: DBMS_METADATA_DIFF was comparing two tables or indexes partitioned or subpartitioned by hash, and a (sub)partition in the first object was not present in the second object. Partition maintenance operations such as drop, split or merge can only be performed on list or range (sub)partitioned objects.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39284: Cannot alter the list values of a list subpartition: string: Cause: DBMS_METADATA_DIFF was comparing two tables subpartitioned by list, one of which has a subpartition with the same name but a different values list as a subpartition in the other. There is no SQL ALTER statement to change the list values of a list subpartition.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39285: Cannot alter index key compression.: Cause: DBMS_METADATA_DIFF was comparing two indexes with different values of key compression. There is no SQL ALTER statement to change index key compression.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39286: Cannot convert between types of index.: Cause: DBMS_METADATA_DIFF was comparing two indexes of different types, for example, a table index, a domain index, a cluster index, a bitmap index or a bitmap join index There is no SQL ALTER statement to change the type of an index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39287: Cannot alter index column list.: Cause: DBMS_METADATA_DIFF was comparing two indexes with different column lists. There is no SQL ALTER statement to change the columns of an index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39288: Cannot alter index base table.: Cause: DBMS_METADATA_DIFF was comparing two table indexes defined on different tables. There is no SQL ALTER statement to change the base table of an index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39289: Cannot add or drop local index partition or subpartition: string: Cause: DBMS_METADATA_DIFF was comparing two locally partitioned indexes with different partitions or subpartitions. There is no SQL ALTER statement to add or drop a partition or subpartition of a locally partitioned index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39290: Cannot drop a partition of a globally partitioned index.: Cause: DBMS_METADATA_DIFF was comparing two globally partitioned indexes and a partition in the first index does not exist in the second index. There is no SQL ALTER statement to drop a partition of a globally partitioned index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39291: Cannot alter index storage option: string: Cause: DBMS_METADATA_DIFF was comparing two indexes with different values for the specified storage option. There is no SQL ALTER statement to change this storage option.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39292: Cannot alter join table of bitmap join index.: Cause: DBMS_METADATA_DIFF was comparing two bitmap join indexes with different join tables. There is no SQL ALTER statement to alter the join tables of a bitmap join index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39293: Cannot alter join condition of bitmap join index.: Cause: DBMS_METADATA_DIFF was comparing two bitmap join indexes with different join conditions. There is no SQL ALTER statement to alter the join condition of a bitmap join index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39294: Cannot alter indextype of domain index.: Cause: DBMS_METADATA_DIFF was comparing two bitmap domain indexes with different indextypes. There is no SQL ALTER statement to alter the indextype of a domain index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39295: Cannot alter index base cluster.: Cause: DBMS_METADATA_DIFF was comparing two cluster indexes defined on different clusters. There is no SQL ALTER statement to change the base cluster of a cluster index.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39296: Cannot alter index partitioning type or partitioning columns.: Cause: DBMS_METADATA_DIFF was comparing two indexes with incompatible partitioning: (1) one is partitioned and one is not (2) both are partitioned but in different ways (locally vs. globally, hash vs. range) (3) both are partitioned but on different columns. There is no SQL ALTER statement to change the way an index is partitioned.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39297: Cannot alter materialized view attribute: string: Cause: DBMS_METADATA_DIFF was comparing two materialized views with incompatible attributes. There is no SQL ALTER statement to change this attribute of a materialized view.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39298: Cannot alter materialized view partitioning type or partitioning columns.: Cause: DBMS_METADATA_DIFF was comparing two materialized views with incompatible partitioning: (1) one is partitioned and one is not (2) both are partitioned but in different ways (locally vs. globally, hash vs. range) (3) both are partitioned but on different columns. There is no SQL ALTER statement to change the way a materialized view is partitioned.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39299: Cannot alter materialized view physical organization.: Cause: DBMS_METADATA_DIFF was comparing two materialized views with different physical organizations: heap, index organized, etc. There is no SQL ALTER statement to change the index organization of a materialized view.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39300: Cannot alter materialized view log partitioning type or partitioning columns.: Cause: DBMS_METADATA_DIFF was comparing two materialized view logs with incompatible partitioning: (1) one is partitioned and one is not (2) both are partitioned but in different ways (locally vs. globally, hash vs. range) (3) both are partitioned but on different columns. There is no SQL ALTER statement to change the way a materialized view log is partitioned.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39301: Cannot alter values recorded in materialized view log: string: Cause: DBMS_METADATA_DIFF was comparing two materialized view logs that are recording different values, and the set of values in the first materialized view log cannot be changed to that in the second materialized view log. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39302: Cannot alter tablespace of materialized view log.: Cause: DBMS_METADATA_DIFF was comparing two materialized view logs which have different tablespaces. There is no SQL ALTER statement to change the tablespace of a materialized view log.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39303: Cannot alter attribute of queue: string: Cause: DBMS_METADATA_DIFF was comparing two advanced queues with attribute differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39304: Cannot alter attribute of queue table: string: Cause: DBMS_METADATA_DIFF was comparing two AQ queue tabless with attribute differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39305: Cannot alter attribute of sequence: string: Cause: DBMS_METADATA_DIFF was comparing two sequences with attribute differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39306: Cannot alter attribute of trigger: string: Cause: DBMS_METADATA_DIFF was comparing two triggers with differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39307: Cannot alter attribute of type: string: Cause: DBMS_METADATA_DIFF was comparing two types with differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39308: Cannot alter attribute of view: string: Cause: DBMS_METADATA_DIFF was comparing two views with differences that cannot be reconciled. The error message identifies the specific problem.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39309: Cannot alter tablespace between bigfile and smallfile.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces, one bigfile, one smallfile. There is no SQL ALTER statement to change a tablespace from smallfile to bigfile or vice versa.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39310: Cannot alter tablespace type.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces of different types: permanent, temporary or undo. There is no SQL ALTER statement to change the type of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39311: Cannot alter tablespace blocksize.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces with different blocksizes. There is no SQL ALTER statement to change the blocksize of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39312: Cannot alter tablespace encryption.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces, one encrypted, one not. There is no SQL ALTER statement to change the encryption property of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39313: Cannot alter tablespace flashback mode.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces, one in flashback mode, one not. There is no SQL ALTER statement to alter the flashback mode of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39314: Cannot alter tablespace extent_management.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces with different extent management properties. There is no SQL ALTER statement to alter the extent management properties of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39315: Cannot drop the first data file from a permanent or undo tablespace.: Cause: DBMS_METADATA_DIFF was comparing two permanent or undo tablespaces. The first data file in the first tablespace is missing from the second tablespace. There is no SQL ALTER statement to drop the first data file from a permanent or undo tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39316: Cannot resize a data file in a smallfile tablespace.: Cause: DBMS_METADATA_DIFF was comparing two smallfile tablespaces. A data file in the first tablespace is of a different size from the corresponding data file in the second tablespace. There is no SQL ALTER statement to resize a data file in a smallfile tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39317: Cannot change the segment space management of a tablespace.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces with different segment space management. There is no SQL ALTER statement to change the segment space management of a tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39318: Cannot alter user name.: Cause: DBMS_METADATA_DIFF was comparing two users with different names. There is no SQL ALTER statement to change the name of a user.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39319: Cannot undo password expiration.: Cause: DBMS_METADATA_DIFF was comparing two users and the first user had an expired password. There is no SQL ALTER statement to undo the expiration of a user password.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39320: Column names do not match between export and import databases.: Cause: The column names of the table being imported did not match the column names of the preexisting table.; Action: Ensure the column names match between export and import database.
ORA-39321: Cannot alter functional index or virtual expression column: string: Cause: Altered column was referenced in a virtual column or functional index expression. There is no SQL ALTER statement to change a column which is referenced in one of these types of expressions.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version.: Cause: The source database was at a different time zone version than the target database and there were tables in the dumpfile with TIMESTAMP WITH TIME ZONE columns.; Action: Convert the target database to the same timezone version as the source database or use Data Pump without transportable tablespace.
ORA-39323: cannot load data from external table dump file "string": Cause: A dump file was specified for an import operation that had been created with external tables using the ORACLE_DATAPUMP access driver. This type of dump file cannot be processed using the Data Pump import utility.; Action: Access the data in this dump file with external tables using the ORACLE_DATAPUMP access driver.
ORA-39324: cannot load data from Data Pump dump file "string": Cause: A dump file was specified for a load operation that had been created using the Data Pump Export (expdp) utility. This type of dump file could not be processed as external table using the ORACLE_DATAPUMP access driver.; Action: Access the data in this dump file using the Data Pump Import (impdp) utility.
ORA-39325: TABLE_EXISTS_ACTION cannot be applied to string.: Cause: An object was already in existence that uses a name in common with this table. The name collision could be the table name, a constraint, a LOB storage table, or something else in the table definition.; Action: Drop the existing object before running Data Pump.
ORA-39326: cannot load data into table, string, due to an unusable index: Cause: An unusable index existed on the table. This index prevented data from being loaded into the table associated with this index.; Action: Either drop the unusable index or make it valid before attempting the import operation.
ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set.: Cause: No encryption was specified for an export job that involved data from an Oracle Database Vault realm.; Action: No specific user action is required. This is only a warning that secure data may be readable from within the dump file set.
ORA-39328: encryption password is too long: Cause: The encryption password provided to the Data Pump job was invalid because its length was greater than the maximum allowed. When using the password to encrypt the dump file set, the maximum length is 1000 bytes. When using the password to re-encrypt encrypted columns only, the maximum length is 30 bytes.; Action: Retry the operation with a valid encryption password.
ORA-39329: Tablespace string needs to be locally managed.: Cause: An attempt was made to run an Oracle Data Pump job with the TRANSPORTABLE=ALWAYS parameter. Tablespaces that contain data for EARLY_OPTIONS in an Oracle Data Pump job run with FULL=Y and TRANSPORTABLE=ALWAYS parameter need to be locally managed.; Action: Run the Oracle Data Pump job without the TRANSPORTABLE parameter set to ALWAYS.
ORA-39331: Wallet is not open on remote node.: Cause: The security module wallet was not open on the remote node.; Action: Open the wallet on the remote node.
ORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch.: Cause: The source database is at a different time zone version than the target database and this table contains TIMESTAMP WITH TIME ZONE data.; Action: Convert the target database to the same time zone version as the source database or use Oracle Data Pump with conventional data movement to export then import this table.
ORA-39340: unsupported object, string will be skipped.: Cause: Oracle Data Pump encountered an object type that it currently does not support.; Action: Manually move the object to the target database.
ORA-39341: Cannot convert an existing column into an identity column.: Cause: An attempt was made to convert an existing column into an identity column. There is no SQL ALTER statement that will convert an existing column into an identity column.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39342: Data Pump did not import dependent objects for string due to the previous error string.: Cause: Oracle Data Pump did not import dependent objects because the parent object failed to import properly.; Action: Contact Oracle Support Services.
ORA-39343: Object type string failed to create returning error:\nstring\n: Cause: The object type could not be created. Examine the original error code to determine the actual cause.; Action: The original error code will contain more information.
ORA-39345: Warning: possible data loss in character set conversions: Cause: Oracle Data Pump displayed this message at the start of the import operation because it determined that the character set or the NCHAR character set used by the export database was different from that of the target database and also that the target database character set was not a superset of the export database character set.; Action: No specific user action is required.
ORA-39346: data loss in character set conversion for object string: Cause: Oracle Data Pump import converted a metadata object from the export database character set into the target database character set prior to processing the object. Some characters could not be converted to the target database character set and so the default replacement character was used.; Action: No specific user action is required. This type of data loss can occur if the target database character set is not a superset of the export database character set.
ORA-39347: Character data loss was detected during conversion, the row was rejected.: Cause: The row contained characters that did not exist in the destination character set.; Action: No specific user action is required. The destination character set must be a superset of the source character set to avoid data loss.
ORA-39352: Wrong number of TRANSPORT_DATAFILES specified: expected string, received string: Cause: The number of TRANSPORT_DATAFILES specified on the impdp command was not correct.; Action: Specify the correct TRANSPORT_DATAFILES for this transportable job.
ORA-39353: Data was not imported for string. Cannot locate the time zone version string file.: Cause: This table contains TIMESTAMP WITH TIME ZONE data and Oracle Data Pump needed to load the source version of the time zone file. This version cannot be located.; Action: Install the latest time zone version files.
ORA-39357: \nWarning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.\n: Cause: The Oracle Data Pump client was attached to the root or seed container database.; Action: Continue if this is the desired connection string or attach to a pluggable database within the container database.
ORA-39358: Export dump file version string not compatible with target version string: Cause: The Oracle Data Pump export job version was newer than the target compatibility version.; Action: Upgrade the target database to a compatibility level of at least the export job version, or rerun the export job with a job version that is lower than or equal to the compatibility version of the target database.
ORA-39359: Source time zone version is string and target time zone version is string.: Cause: The time zone version of the source database is not the same as the time zone version of the target database.; Action: Tables containing TIMESTAMP WITH TIME ZONE data cannot be imported with transportable tablespace technology when time zone versions are different between the export and target databases. All affected tables will be reported during the import job and will not be created. If any are reported, convert the target database to the same time zone version as the source or use Oracle Data Pump with conventional data movement to export then import the affected tables.
ORA-39360: Table string was skipped due to transportable import and TSLTZ issues resulting from time zone mismatch.: Cause: The time zone of the source database is different than the time zone of the target database and this table contains TIMESTAMP WITH LOCAL TIME ZONE data.; Action: Convert the target database to the same time zone as the source database or use Oracle Data Pump with conventional data movement to export then import this table.
ORA-39361: Source time zone is string and target time zone is string.: Cause: The time zone of the source database is different than the time zone of the target database.; Action: Tables containing TIMESTAMP WITH LOCAL TIME ZONE data cannot be imported with transportable tablespace technology when time zones are different between the export and target databases. All affected tables will be reported during the import job and will not be created. If any are reported, convert the target database to the same time zone as the source or use Oracle Data Pump with conventional data movement to export then import the affected tables.
ORA-39363: Type evolution could not be preserved for string: Cause: Trying to apply each version of the type during import resulted in compilation warnings. The type was successfully recreated to the latest version only.; Action: Export dump files as well as transportable tablespaces that contain earlier versions of this type cannot be imported on top of this type definition.
ORA-39364: encryption password is too long: Cause: The encryption password provided to the Oracle Data Pump job was invalid because its length was greater than the maximum allowed. When using the password to encrypt the dump file set, the maximum length is 128 bytes. When using the password to re-encrypt encrypted columns only, the maximum length is 30 bytes.; Action: Retry the operation with a valid encryption password.
ORA-39366: disable table lock on string.string failed with:\nstring\n: Cause: Examine the original error code to determine the actual cause.; Action: The original error code contains more information.
ORA-39367: Statistics are being skipped. Cannot locate the time zone version string file.: Cause: Importing statistics requires that the Oracle Data Pump load the source version of the time zone file. This version cannot be located.; Action: Install the latest time zone version files.
ORA-39368: cannot alter partition varray column properties: Cause: DBMS_METADATA_DIFF was comparing two partitioned tables. There is no SQL ALTER statement to change varray column properties.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39369: some rows may not be exported for string due to block corruption: Cause: The corrupted data blocks were ignored when Oracle Data Pump was exporting the table.; Action: No action is required.
ORA-39370: remap value string is too long: Cause: The remap value provided to the Oracle Data Pump job was invalid because its length was greater than the maximum allowed.; Action: Retry the operation with a valid remap value.
ORA-39371: cannot specify partition in remap_table without departitioning: Cause: The 'remap_table' value specified a partition but the tables were not being departitioned.; Action: Either remove the partition name in the 'remap_table' parameter or add the 'partition_options=departition' parameter.
ORA-39372: \nWarning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers.\n: Cause: The Oracle Data Pump job was exporting from a database version that has support for long identifiers and may have objects with long identifiers but the target version does not support long identifiers.; Action: Continue if this is the desired action but be aware that some objects may not be exported and some that are exported will not be able to be imported to the target databse.
ORA-39373: cannot export string to version string due to long identifiers: Cause: This object had long identifiers and could not be exported to the target version specified in the Oracle Data Pump command.; Action: If this is the desired action, then continue, but be aware that this object will not be included in the dump file. If this is not the desired action then change the version parameter to a value greater than or equal to 12.2.0.0.0.
ORA-39374: Statistics failed to export. Failing error is \nstring: Cause: The statistics failed to export.; Action: Examine the original error code to determine the actual cause.
ORA-39375: Statistics failed to import. Failing error is \nstring: Cause: The statistics failed to import.; Action: Examine the original error code to determine the actual cause.
ORA-39376: invalid data encountered (string): Cause: Optional data validation detected invalid data while accessing external table data.; Action: See trace files for details of the problem.
ORA-39377: altering table read-only string.string failed with:\nstring\n: Cause: Altering the table to read-only failed.; Action: Examine the original error code to determine the actual cause.
ORA-39378: Data Pump string import job conflicts with underscore parameter string: Cause: The mode used for import cannot be used with the underscore parameter.; Action: Unset the underscore parameter and retry the import.
ORA-39379: Logging for table string may not be restored.: Cause: The table was created with NO LOGGING specified and the restore to the original value failed.; Action: Verify the logging attributes on the table.
ORA-39380: Cannot alter tablespace with lost write protection.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces. There is no SQL ALTER statement to change tablespace lost write protection.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39381: Cannot add datafile to bigfile tablespace.: Cause: DBMS_METADATA_DIFF was comparing two tablespaces. Datafile can not be added to a bigfile tablespace.; Action: The difference cannot be eliminated with an SQL ALTER statement.
ORA-39382: There are string cursors left open in the string package.: Cause: This is an internal error. The identified package left some cursors opened.; Action: Contact Oracle Support Services.
ORA-39383: There is more data loss than reported for object type string.: Cause: The maximum number of replacement characters for each read operation prevented all objects within this object type that lost data from being found. There should be one or more messages preceding this one that indicate data loss for specific objects within the named object type. However, this message indicates that there may be more objects within the named object type that lost; Action: No specific user action is required.
ORA-39384: Warning: User string has been locked and the password expired.: Cause: Oracle Data Pump displayed this message while importing users because it determined that a user was created with a password version that is no longer supported. See the documentation for PASSWORD_VERSIONS in the system view DBA_USERS for more information.; Action: Connect AS SYSDBA and unlock the account and set a password for the user. This can be done by issuing an "ALTER USER username ACCOUNT UNLOCK;" command followed by an "ALTER USER username IDENTIFIED BY password;" command. See the documentation for the SQLNET.ORA parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER which explains how to control which password versions will be created when the password for the user is reset.
ORA-39385: Data was not imported for string.: Cause: The Data Pump export job had an unreported problem while exporting the data for this table, partition, or subpartition.; Action: Retry the export command including the data for this table, partition, or subpartition.
ORA-39386: cannot load data into sharded table from sharded catalog for table string: Cause: Data pump import operation was trying to load table data into a sharded table from the sharded catalog database. Table data for sharded tables must be loaded into the sharded databases.; Action: Use the data pump to load the table data into the sharded database.
ORA-39387: cannot load metadata into a sharded database: Cause: Data pump import operation was trying to load metadata into a sharded database.; Action: Metadata is propagated to the sharded database from the sharded catalog.
ORA-39388: cannot use transportable tablespace to export from a sharded database: Cause: An attempt was made to export from a sharded database using transportable tablespace.; Action: Perform this operation without transportable tablespace.
ORA-39389: no form of transportable export is allowed from a sharded catalog: Cause: An attempt was made to export from a sharded catalog using a form of transportable Data Pump.; Action: Perform this operation without transportable data movement.
ORA-39390: cannot use Oracle Data Pump with a network link in a sharded environment: Cause: An attempt was made to perform an Oracle Data Pump operation over a network link with either the source or target database being sharded.; Action: Perform this operation without a network_link parameter.
ORA-39391: maximum number of Data Pump jobs (string) exceeded: Cause: The value of the MAX_DATAPUMP_JOBS_PER_PDB initialization parameter exceeded the allowed value.; Action: Retry the operation or increase the maximum allowed value of the MAX_DATAPUMP_JOBS_PER_PDB initialization parameter.
ORA-39392: Data Pump filter object string invalid length: Cause: The Data Pump filter contained an object name that was larger than 128 characters.; Action: Fix the object name in the filter and retry the Data Pump command.
ORA-39393: direct path operation in shard catalog not allowed on sharded table string: Cause: Direct path operations could not be performed on a sharded table from inside of the catalog database for a sharded table. The data for sharded tables lives in other shard databases.; Action: Use direct path operations directly on the shard databases.
ORA-39394: Cannot alter vector encoded attributes on a table column.: Cause: An attempt was made to change a column that was vector encoded with a SQL ALTER statement.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39395: Warning: object string requires password reset after import: Cause: During Data Pump Export or Import, fixed user or shared database link objects were exported and the enforcement of dictionary credentials was set to ENABLED.; Action: After running Data Pump Import, execute the ALTER DATABASE LINK statement for each link mentioned in the error message and reset the password for the link. Failure to reset the password for the link results in an ORA-28449 error when attempting to use the link.
ORA-39396: Warning: exporting encrypted data using transportable option without password: Cause: The encryption password was not specified for an export job that used the transportable option and included one or more encrypted tablespaces.; Action: No specific user action is required. However, note that the wallet on the source and target databases must be identical in order to import the dump file. Continue if this is the desired operation or add an encryption password to the DataPump export command.
ORA-39398: cannot load data, Oracle Data Pump dump file "string" was created in TEST_MODE: Cause: The Oracle Data Pump dump file was created using a value of TEST_MODE for the export TTS_CLOSURE_CHECK parameter. The Oracle Data Pump dump file was in an inconsistent state and could not be loaded.; Action: Re-create the Oracle Data Pump dump file and specify a value of FULL or ON or OFF for the export TTS_CLOSURE_CHECK parameter.
ORA-39399: Dump file set is unusable. TEST_MODE requested.: Cause: This is an informational message to indicate that the Data Pump dump file was created using a value of TEST_MODE for the export TTS_CLOSURE_CHECK parameter. The Data Pump dump file was in an inconsistent state and could not be processed by the Data Pump import utility.; Action: None
ORA-39400: invalid value string for parameter string: Cause: The string supplied for the parameter MAX_DATAPUMP_JOBS_PER_PDB or MAX_DATAPUMP_PARALLEL_PER_JOB was neither an integer nor was it the special value AUTO.; Action: Provide a proper value for this parameter.
ORA-39402: The log or SQL file cannot overwrite dump file "string".: Cause: The name and location of the Data Pump log or SQL file matched the name of an existing Data Pump, external table, or legacy dump file. This message may be seen before the Data Pump job has started or after the job has started, if wildcard dump files are being used.; Action: If this message is seen before the job has started, then retry the operation using a different name or directory object for the log or SQL file. Otherwise, the message is informational and no further action is required.
ORA-39403: object string "string" type identifier mismatch: Cause: An object type in a transportable tablespace set already existed on the target system but with a different type identifier. The object type or dependent type was used by an existing table and could not be changed. Tables in the transportable tablespace set that use this object type could not be created. The alert log contains additional information.; Action: If possible, drop the object type and the dependent objects from the target system and retry the operation.
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version string into a target database with TSTZ version string.: Cause: The source database was at a different time zone version than the target database and there were tables that contained TIMESTAMP WITH TIME ZONE (TSTZ) data.; Action: Convert the target database to the same time zone version or later as the source database or use Oracle Data Pump with conventional data movement to export then import this data.
ORA-39406: Job mode string is not permitted when running as SYSBACKUP.: Cause: A mode other than transportable, table, or tablepsace was specified for the job. When running a Data Pump export or import operation as SYSBACKUP, the mode is limited to transportable, table, and tablespace.; Action: No action is required.
ORA-39407: Warning: Incompatible usage of parameters string and string.\n: Cause: When using the DEPARTITION transform, REMAP_TABLE should reference a specific table partition. Otherwise the REMAP_TABLE is ignored.; Action: No action is required.
ORA-39408: unable to generate checksum for dump file "string": Cause: The Oracle Data Pump Export utility was unable to generate a checksum for the specified dump file. This message is followed by one or more secondary messages.; Action: Take the appropriate action based on the secondary messages.
ORA-39409: unable to verify checksum for dump file "string": Cause: Data Pump Import was unable to verify the checksum for the specified dump file. This message is followed by one or more secondary messages.; Action: Take appropriate action based on the secondary messages.
ORA-39411: header checksum error in dump file "string": Cause: The header block for the Oracle Data Pump dump file contained a header checksum that did not match the value calculated from the header block as read from disk. This indicated that the header was tampered with or otherwise corrupted due to transmission or media failure.; Action: Make sure the filesystem where the dump files are stored does not report any issues and has enough capacity. Re-create the Data Pump export and retry the import. If the problem persists, contact Oracle Support Services.
ORA-39412: file checksum error in dump file "string": Cause: The header block for the Data Pump dump file contained a file checksum that did not match the value calculated from the header block as read from disk. This indicates that the file was tampered with or otherwise corrupted due to transmission or media failure.; Action: Contact Oracle Support Services.
ORA-39416: Warning: dump file checksum verification is disabled: Cause: The Data Pump VERIFY_CHECKSUM parameter was either implicitly or explicitly set to NO and the import dump file set included files that contain checksums.; Action: Continue if the desired behavior is to not perform checksum verification. Otherwise, restart the import operation and include VERIFY_CHECKSUM=YES.
ORA-39417: cannot alter external tables to remove default directory: Cause: DBMS_METADATA_DIFF was comparing two external tables. There is no SQL ALTER statement to remove the default directory.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39418: cannot alter external tables to remove access parameters: Cause: DBMS_METADATA_DIFF was comparing two external tables. There is no SQL ALTER statement to remove the access parameters.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39419: Error string during import when reordering POs in Master table string for object type with sequence number string.: Cause: This is an internal error. Data Pump encountered a potentially non-fatal error during import when reordering process orders. Refer to the error codes and subsequent messages for details.; Action: Rerun the impdp command with a version earlier than release 12.2 or, if the problem persists, contact Oracle Support Services.
ORA-39420: transportable tablespace 'string' clean offline SCN mismatch [string] [string]: Cause: The tablespace clean offline SCN changed during a transportable Data Pump export operation. Tablespaces in the transportable export tablespace set are required to be and to remain in READ ONLY mode for the duration of the operation. During the transportable export operation, a tablespace within the transportable tablespace set was taken out of READ ONLY mode. This resulted in the tablespace clean offline SCN being altered. As a result, the tablespace is incompatible with the current transportable export operation.; Action: ALTER the tablespace to be READ ONLY and then retry the operation.
ORA-39421: cannot modify JSON storage attributes: Cause: DBMS_METADATA_DIFF compared attributes of two JavaScript Object Notation (JSON) columns. JSON storage attributes could not be modified.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39422: invalid definition of the TRANSPORT_DATAFILES_LOG output file: Cause: The job being defined could not be started because either the TRANSPORT_DATAFILES_LOG output file name conflicted with the output LOG file, or the definition was unusable.; Action: Specify a valid directory name and file name for the TRANSPORT_DATAFILES_LOG file.
ORA-39423: The dump file set and data files must be copied to the target database area.: Cause: Information message written to the TRANSPORT_DATAFILES_LOG output file.; Action: None required.
ORA-39424: The data file paths must be updated accordingly before initiating the Import.: Cause: Information message written to the TRANSPORT_DATAFILES_LOG output file.; Action: None required.
ORA-39425: <target_database_area_path>string.string: Cause: Information message written to the TRANSPORT_DATAFILES_LOG output file.; Action: None required.
ORA-39426: Domain indexes of partitioned tables will not be imported.: Cause: The domain indexes were not imported because the PARTITION_OPTIONS parameter was set to MERGE.; Action: Manually create the domain indexes on the target database.
ORA-39427: Dependent objects of partitioned tables will not be imported.: Cause: The dependent objects were not imported because the PARTITION_OPTIONS parameter was set to DEPARTITION.; Action: Manually create the dependent objects on the target database.
ORA-39428: Warning: Statistics not gathered while loading data for table "string": Cause: An attempt was made to automatically collect statistics in an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) environment. If the ACCESS_METHOD parameter is specified as something other than EXTERNAL_TABLE or if properties of the table prevent using EXTERNAL_TABLE, then this warning is displayed.; Action: Gather statistics manually once data loading is complete.
ORA-39429: REMAP_SCHEMA for SYSTEM does not exist, string\n: Cause: The Data Pump REMAP_SCHEMA parameter for import was specified for schema SYSTEM, but the target schema did not exist in the database.; Action: Create the schema in the database and then retry the import operation.
ORA-39430: Warning: Optimized column string.string.string length exceeds index key limit: Cause: An attempt was made to optimize the byte column length with the BYTE_OPTIMIZED transform parameter value to avoid index creation failure during import.; Action: None
ORA-39432: Warning: Grant string failed due to timeout while waiting to lock oracle object.\nFailing sql is:\nstring\n: Cause: A lock timeout error occurred while executing an Oracle object grant DDL because it recompiled the target object which requires a lock on this object. If a lock is not acquired, then a timeout error occurs.; Action: None
ORA-39433: cannot alter domain index parameters: Cause: The DBMS_METADATA_DIFF package was comparing two domain indexes with different parameters. There is no SQL ALTER statement to alter the index type of a domain index.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39435: Warning: string cannot be applied to blockchain table string. No rows processed.: Cause: Oracle Data Pump options SAMPLE, QUERY, REMAP_DATA, and TABLE_EXISTS_ACTION were specified for blockchain tables.; Action: None
ORA-39436: transportable table "string"."string" metadata mismatch: Cause: The metadata of the plugged in transportable table did not match the metadata located in the dump file.; Action: See trace files for details of the problem.
ORA-39437: Warning: DEPARTITIONING cannot be applied to blockchain tables.: Cause: Departitioning options cannot be applied to blockchain tables.; Action: None
ORA-39438: Cannot alter the data type of column string: Cause: An attempt was made to change the data type of this column. There is no SQL ALTER statement to change this column to the new data type.; Action: The difference cannot be eliminated with a SQL ALTER statement.
ORA-39439: Warning: cannot process blockchain tables in transportable jobs or over a network link.: Cause: Oracle Data Pump encountered blockchain tables which are not supported over a network link or in transportable jobs.; Action: None
ORA-39440: failed to verify blockchain rows in table string: Cause: Oracle Data Pump import failed to verify blockchain rows loaded.; Action: None
ORA-39442: Data Pump software update in progress: Cause: DPLOAD.SQL was holding the exclusive lock. Data Pump software update was in progress.; Action: Try again after the software update is complete.
ORA-39444: failed to retrieve the current session address: Cause: Oracle Data Pump was unable to retrieve the current session address.; Action: None
ORA-39445: REMAP_TABLESPACE with wildcard is not mapped to string: Cause: Remapping tablespaces using a wildcard during import was not allowed. Tablespace was either temporary or did not exist.; Action: Use a permanent tablespace with wildcard remapping.
ORA-39446: VIEWS_AS_TABLES error: string does not exist.: Cause: The specified element in the VIEWS_AS_TABLES parameter did not exist.; Action: Retry the operation with an existing and valid view or template table.
ORA-39447: VIEWS_AS_TABLES error: string has invalid properties string.: Cause: The specified element in the VIEWS_AS_TABLES parameter had invalid properties.; Action: Retry the operation with a valid view or template table.
ORA-39448: VIEWS_AS_TABLES error: Cannot create template table string. SQLCODE is string.\nFailing sql is: \nstring: Cause: The specified internal template table could not be created.; Action: None
ORA-39449: cannot disable editioning attributes: Cause: Editioning was not reversible once it had been enabled.; Action: None
ORA-39450: Database release string.string unable to read file created by release string: Cause: A dump file was specified for an import operation whose version number was incompatible with the dump file version of the Data Pump product currently running on the system. Usually this message indicates that the dump file was produced by a newer version of the Data Pump export utility.; Action: Import this dump file using the Data Pump import utility with the same version as the export which created the file.
ORA-39451: PARALLEL value string exceeds dump file set count: Cause: The value specified by the PARALLEL parameter for the Data Pump Export job is greater than the number of dump files indicated.; Action: No specific user action is required. This is an informational message to indicate that the value specified by the PARALLEL parameter exceeds the number of dump files indicated for the Data Pump Export job.
ORA-39452: FILESIZE is outside valid range of stringKB to stringMB: Cause: The value specified for the FILESIZE parameter was either too small to hold the header information for the export file, plus any data, or exceeded the allowed maximum size for a Uniform Resource Identifier (URI) dump file.; Action: Retry the operation using a value for FILESIZE that falls within the valid range.
ORA-39453: Warning: The ENABLE_SECURE_ROLE parameter has been desupported.: Cause: The desupported ENABLE_SECURE_ROLES parameter was specified using either the Data Pump command-line clients, expdp and impdp, or the Data Pump PL/SQL API.; Action: Consult the Oracle Utilities documentation to find a workaround for running a Data Pump operation with secure roles enabled.
ORA-39454: Warning: Ignoring string transform parameter with older dump files.: Cause: OMIT_ACDR_METADATA transform parameter was not supported with dump files older than Oracle Database release 23c, version 23.1.; Action: None
ORA-39458: Transportable tablespaces prevented from being set read/write.: Cause: The tablespaces in the transportable import tablespace set could not be set to read/write access. This may be due to the file system or tablespace data file protection being read only. As a result timezone fixup and bitmap rebuild operations did not occur for tablespaces in the transportable import tablespace set.; Action: Verify the data file protection settings before retrying the operation.
ORA-39459: string was called with a NULL dump file specification.: Cause: The Oracle Data Pump process model function was called with a NULL dump file specification.; Action: Specify a dump file that is valid for the job.
ORA-39460: cannot create password verification function string due to lockdown: Cause: COMMON_SCHEMA_ACCESS lockdown was enabled for the pluggable database (PDB) but there was no PASSWORD_VERIFY_FUNCTION owner identified and the ALLOWED_PVF_OWNERS system parameter was not configured to allow schema-qualified password verification function.; Action: Set the PASSWORD_VERIFY_FUNCTION owner system parameter and retry the import again. - If the ALLOWED_PVF_OWNERS system parameter is set to NULL (default value), contact your database administrator to have it set it to an appropriate value (comma-separated list of database users) to allow schema-qualified password verification function.
ORA-39500: failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored): Cause: The instance was unable to obtain the context or information required to notify the CRS framework.; Action: None Required. The error is ignored.
ORA-39501: failed to notify CRS of a Startup/Shutdown event [string] (ignored): Cause: The instance was unable to communicate with the CRS framework.; Action: None Required. The error is ignored.
ORA-39502: failed to notify CRS of a Startup/Shutdown event [string] (ignored): Cause: The instance was unable to create an environment context.; Action: None Required. The error is ignored.
ORA-39503: failed to notify CRS of a Startup/Shutdown event [string] (ignored): Cause: The instance was unable to populate the environment context.; Action: None Required. The error is ignored.
ORA-39504: failed to notify CRS of a Startup/Shutdown event [string] (ignored): Cause: The instance was unable to find the location of the alert file.; Action: None Required. The error is ignored.
ORA-39510: CRS error performing string on string 'string' on 'string'\nstring: Cause: Unable to perform action on associated CRS resource.; Action: See following error messages for additional information. Fix error and retry.
ORA-39511: Start of CRS resource for instance '%0!s' failed with error:[%1!s]\n%2!s: Cause: The Cluster Ready Services (CRS) detected an error during an attempt to start the indicated resource. The instance start operation was terminated. The accompanying messages provide detailed failure information.; Action: Examine the accompanying messages, correct the indicated problems, and then retry the operation.
ORA-39512: Stop of CRS resource for instance '%0!s' failed with error:[%1!s]\n%2!s: Cause: The Cluster Ready Services (CRS) detected an error during an attempt to stop the indicated resource. The instance stop operation was terminated. The accompanying messages provide detailed failure information.; Action: Examine the accompanying messages, correct the indicated problems, and then retry the operation.
ORA-39600: Queue keys needs to be a suffix of cluster key.: Cause: Attempt to specify queue key columns that don't form a suffix of the cluster key.; Action: Only specify queue key columns as a suffix of cluster key.
ORA-39601: Hash key is required.: Cause: Missing hash key in the cluster key specification.; Action: Specify one or more hash key columns.
ORA-39700: database must be opened with UPGRADE option: Cause: A normal database open was attempted, but the database has not been upgraded to the current server version.; Action: Use the UPGRADE option when opening the database to run catupgrd.sql (for database upgrade), or to run catalog.sql and catproc.sql (after initial database creation).
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE: Cause: The database was mounted for SHARED cluster access.; Action: Set the CLUSTER_DATABASE initialization parameter to FALSE and restart the server with the UPGRADE or DOWNGRADE option.
ORA-39702: database not open for UPGRADE or DOWNGRADE: Cause: An upgrade, downgrade, reload, or patch script was invoked when the database was not open for UPGRADE or DOWNGRADE.; Action: Use STARTUP UPGRADE to open the database for upgrade or to apply a patch set. Use STARTUP DOWNGRADE for running a downgrade script or the reload script.
ORA-39703: server version and script version do not match: Cause: An upgrade, downgrade, reload, or patch script was invoked, but the database instance version was not the version for which the script was intended.; Action: Check that the correct ORACLE_HOME and ORACLE_SID environment variables are set. Also check that the SQL script is being invoked from the correct ORACLE_HOME.
ORA-39704: permission to modify component registry entry denied: Cause: An attempt was made to modify an entry in the component registry, but the session user was not authorized; only the CONTROL or SCHEMA user for the component are authorized to modify the component registry entry.; Action: Connect as either the CONTROL or SCHEMA user for the component.
ORA-39705: component 'string' not found in registry: Cause: No entry in the component registry was found for the specfied component.; Action: Check the spelling of the component ID and use the DBA_REGISTRY view to list the existing components.
ORA-39706: Schema 'string' is not found.: Cause: The schema name specified was not found in the database.; Action: Create the schema, or request privileges to the schema.
ORA-39707: compatible parameter string too high for downgrade to string: Cause: A downgrade was attempted, but the compatible initialization parameter value was greater than the downgrade release version.; Action: Once the compatible value has been raised, downgrade to earlier releases is not supported.
ORA-39708: component 'string' not a string component: Cause: The component was not a component for the specified namespace.; Action: Either enter a valid component identifier for the namespace or set the session namespace to the correct component namespace.
ORA-39709: incomplete component downgrade; string downgrade aborted: Cause: One or more components did not have a status of DOWNGRADED.; Action: Correct the component problem and re-run the downgrade script.
ORA-39710: The database mode conflicts with the connection type.: Cause: An attempt was made to connect to a database when the database was open for upgrade or downgrade, but a conflicting type of connection was specified. Only the SYSDBA and SYSOPER types of administrative connection are allowed while the database is open in upgrade or downgrade mode.; Action: If you are not an administrative user, try to connect again after the database upgrade or downgrade is complete. If you are an administrative user, specify either the AS SYSDBA or the AS SYSOPER administrative connection type.
ORA-39711: critical patch number less than last installed CPU number: Cause: A Critical Patch Update (CPU) script was invoked that had a number that was less than the last CPU installed in the database.; Action: Check the DBA_REGISTRY_HISTORY view to identify the last CPU for the database, and install the most recent CPU.
ORA-39712: database cannot be opened by an Oracle Database XE server: Cause: An attempt was made to open a Standard Edition or Enterprise Edition database with the Oracle Database Express Edition (XE) of the server.; Action: Use the Oracle Database XE server only with Oracle Database XE databases.
ORA-39714: upgrade script utlmmig.sql failed: Cause: A normal database open was attempted, but the upgrade script utlmmig.sql failed to complete.; Action: Use the UPGRADE option when opening the database and then run utlmmig.sql.
ORA-39715: Downgrade script UTLMMIGDOWN.SQL failed.: Cause: A normal database open was attempted, but the downgrade script UTLMMIGDOWN.SQL failed to complete.; Action: Use the DOWNGRADE option when opening the database and then run UTLMMIGDOWN.SQL.
ORA-39716: Downgrade for Oracle Label Sceurity failed.: Cause: Downgrading Oracle Label Security module failed since OLS triggers were found in LBAC_TRIGGER schema.; Action: Disable all the OLS policies and delete all the triggers within LBAC_TRIGGER schema.
ORA-39726: unsupported add/drop column operation on compressed tables: Cause: An unsupported add/drop column operation for compressed table was attemped.; Action: When adding a column, do not specify a default value. DROP column is only supported in the form of SET UNUSED column (meta-data drop column).
ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher: Cause: An add/drop column operation for compressed table has been performed on the database. This requires COMPATIBLE to be set to 10.0.0.0.0 or higher during upgrade from 9.2 to a 10i or higher release.; Action: Set COMPATIBLE to 10.0.0.0.0 and retry the upgrade.
ORA-39728: compressed table cannot have column with LONG data type: Cause: One of the following was attempted: - Created a basic or advanced row-compressed table with a LONG data type. - Altered an existing table with a LONG data type to be basic or advanced row compressed. - Added a LONG data type column to a basic or advanced row-compressed table.; Action: LONG data types are not supported with basic or advanced row-compressed tables. Create the table without a LONG column or change the table to not use basic or advanced row compression. If adding a column, do not use the LONG data type. If modifying attributes of a column to change the data type to LONG the table cannot be basic or advanced row compressed.
ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported: Cause: An attempt was made to partition both sides of PARTITIONED OUTER JOIN.; Action: Specify partitioned table on one side of PARTITIONED OUTER JOIN only.
ORA-39752: redundant column in partitioning and join columns is not allowed: Cause: An attempt was made to specify redundant columns in partitioning and join columns for NATURAL or named column PARTITIONED OUTER JOIN.; Action: Do not specify redundant column in partitioning and join columns.
ORA-39753: unsupported use of subquery in PARTITIONED OUTER JOIN condition: Cause: An attempt was made to use subquery in PARTITIONED OUTER JOIN condition.; Action: Remove subquery from the join condition.
ORA-39754: FULL PARTITIONED OUTER JOIN is not supported: Cause: An attempt was made to use FULL PARTITIONED OUTER JOIN.; Action: Specify FULL PARTITIONED OUTER JOIN through UNION of LEFT and RIGHT PARITTION OUTER JOIN.
ORA-39755: cannot use PARTITIONED OUTER JOIN with a left correlation: Cause: An attempt was made to use a PARTITIONED OUTER JOIN where the right side is a lateral view with a left correlation to the left side and is partitioned.; Action: Rewrite the query without the left correlation.
ORA-39761: stream reset required before loading this stream again: Cause: An attempt was made to load a stream that was previously loaded but has not been reset yet.; Action: Reset the specified stream and convert column array data to it before attempting to load it again.
ORA-39762: streams must be loaded in conversion order: Cause: An attempt was made to load a stream out of conversion order.; Action: Load streams in the same order they were converted.
ORA-39763: stream must be completely loaded before it is reset: Cause: An attempt was made to reset a stream that contains converted column array data and hasn't been completely loaded yet.; Action: Before resetting a stream, load it until a status of OCI_SUCCESS, OCI_NO_DATA, or OCI_NEED_DATA is returned.
ORA-39764: specified stream is not in the specified direct path context: Cause: A direct path operation was attempted using a stream that was not created in the specfied direct path context.; Action: Only use streams created in the specified direct path context.
ORA-39765: stream must be reset before used in a column array conversion: Cause: The stream was completely loaded, but has not been reset yet.; Action: Reset loaded streams after load returns OCI_SUCCESS, OCI_NO_DATA, or OCI_NEED_DATA. The stream can then be used in a column array to stream conversion.
ORA-39766: invaid stream specified for column array conversion: Cause: A stream must be loaded and reset before used again in a column-array-to-stream conversion. This error is issued if another stream has subsequently been converted before the specified stream has been loaded, or if the latest load of this stream returned OCI_ERROR.; Action: Don't convert into a previous stream before it is loaded. Also, when load stream returns OCI_ERROR, the stream must be loaded again to insure any remaining information in the stream is loaded. The stream must be loaded even if the last or only row was in error. There may be error information in the stream that needs to be sent to the server.
ORA-39767: finish is not allowed when unloaded stream data exists: Cause: A direct path finish was attempted when at least one stream buffer has not been completely loaded.; Action: All streams must be loaded after a column array to stream conversion until load stream returns a status of OCI_SUCCESS or OCI_NO_DATA. The load can then be finished.
ORA-39768: only one direct path context top level column array is allowed: Cause: Attempt to create multiple top level column arrays in a direct path context, when only one is allowed.; Action: Create another direct path context if additional top level column arrays are required.
ORA-39769: finish is not allowed with an incompletely loaded last row: Cause: Part of a row has been loaded, but it is not complete.; Action: Finish loading the current row when load stream returns OCI_ERROR or OCI_NEED_DATA.
ORA-39771: stream must be loaded before its handle is freed: Cause: An attempt was made to free a stream handle after conversion but before the stream was loaded.; Action: Load the stream until OCI_SUCCESS, OCI_NEED_DATA or OCI_NO_DATA is returned before attempting to free the stream handle. If OCI_NEED_DATA is returned, another stream must be loaded to complete last row.
ORA-39772: column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA: Cause: An attempt was made to reset a column array when a row conversion is still in progress.; Action: Complete the current row before reseting the column array. To ignore the current row when conversion returned OCI_NEED_DATA, set the current column flag to OCI_DIRPATH_COL_ERROR. This should be followed by a conversion, which will undo and ignore the row. The column array(s) can then be reset.
ORA-39773: parse of metadata stream failed: Cause: An unexpected error occurred while attempting to parse the metadata // stream for a table being loaded.; Action: Call Oracle support.
ORA-39774: parse of metadata stream failed with the following error:\n string: Cause: An unexpected error occurred while parsing the metadata stream.; Action: See the secondary error for more information.
ORA-39775: direct path API commit not allowed due to previous fatal error: Cause: An attempt was made to commit a Direct Path context after a fatal error.; Action: Correct the error and retry.
ORA-39776: fatal Direct Path API error loading table string: Cause: A fatal error was detected loading the specified or previous table.; Action: Correct the error and retry.
ORA-39777: data saves are not allowed when loading LOB columns: Cause: An attempt was made to save data when loading LOB columns or columns stored as LOBs (such as long varchars, varrays and XMLtypes).; Action: Do not attempt to do a data save or partial save when loading LOB columns. A finish save is allowed.
ORA-39778: the parallel load option is not allowed when loading lob columns: Cause: An attempt was made to load lob columns using the attribute OCI_ATTR_DIRPATH_PARALLEL. This error will also be issued when loading any columns that are stored as lobs (such as varrays and xml types).; Action: Do not use the parallel attribute when loading lob columns.
ORA-39779: type "string"."string" not found or conversion to latest version is not possible: Cause: Unable to import table data using the specified type. The type was nonexistent in the database or the input type could not be converted to the existing type. The reasons why a conversion was not possible are: 1. The version of the type in the database was greater than the version of the type at export time because 1 or more attributes have been added or dropped from the type. 2. If the type existed in the database prior to the import operation, then its internal identifier may not match the internal identifier of the type from the export database. The identifiers must match for an import to succeed.; Action: Ensure the types in the database match those at export time.
ORA-39780: Direct path context operations are not allowed after the context is aborted or finished: Cause: The specified direct path context was aborted or finished.; Action: Do not pass a direct path context that has ended to any direct path functions.
ORA-39781: Direct path stream loads are not allowed after another context loading the same table has ended: Cause: Attempt to load a stream in one context after another loading the same table has ended.; Action: Close all contexts before trying to create another that loads the same table as a previous context in the same session.
ORA-39782: Direct path prepare is not allowed after another context loading the same table has ended: Cause: Direct path prepare called after a context loading the same table has ended.; Action: Close all contexts before trying to create another that loads the same table as a previous context in the same session.
ORA-39783: Invalid direct path transaction active: Cause: Direct path operations were not performed in the transaction started by the first OCIDirPathPrepare call.; Action: Ensure the correct transaction is active prior to calling Direct Path API operations.
ORA-39784: This direct path operation is not allowed while another is in progress: Cause: Another direct path operation was active.; Action: Complete any direct path operations in progress before attempting this operation.
ORA-39785: SQL expressions returning ADT objects are not allowed in direct path: Cause: The passed SQL expression returned a user-defined ADT which was not supported.; Action: Remove the SQL expression.
ORA-39786: Number of columns does not match between export and import databases: Cause: External tables could not import into a table with mismatched columns.; Action: Ensure the number of columns matches between export and import database.
ORA-39787: Column string subtype "string"."string" is not instantiable.: Cause: Subtype specified was not instantiable.; Action: Ensure all subtypes specified are instantiable.
ORA-39788: Subtype "string"."string" is specified multiple times for column string.: Cause: Subtype specified was not unique.; Action: Ensure all subtypes specified are unique.
ORA-39789: "string"."string" is not a valid type for column string.: Cause: Subtype specified was not a valid type for the column being loaded.; Action: Ensure all subtypes specified are valid types for the column being loaded.
ORA-39790: Attribute "string" specified multiple times for column string.: Cause: Attribute specified multiple times.; Action: Ensure all attributes specified are unique.
ORA-39791: Attribute "string" for column string is not in subtype "string"."string".: Cause: Attribute was not included in the subtype indicated.; Action: Ensure the attribute is included in the subtype indicated by the specified subtype index.
ORA-39792: Attribute "string" is not valid for subtypes(s) loaded into column string.: Cause: Attribute specified was not included in any subtypes specified for the column or the declared subtype of the column.; Action: Ensure the attribute is included in at least one of the subtypes loaded into the column.
ORA-39793: Attribute "string" is not unique within the hierarchy being loaded.: Cause: The attribute was defined in multiple lines of descent in the hierarchy being loaded.; Action: When describing the attribute, a subtype index must be specified to uniquely identify the attibute being loaded.
ORA-39794: No attributes loaded for subtype "string"."string".: Cause: None of the attributes loaded were included in the type shown.; Action: At least one attribute must be loaded for each subtype specified.
ORA-39795: Subtype index is not first attribute for object table or column, string.: Cause: The subtype index was not the first attribute when describing the atributes of an object column or object table with multiple subtypes.; Action: Describe the subtype index as the first attribute for this object column or object table.
ORA-39796: column array entry for string is not valid for the current subtype: Cause: This column was not part of the current subtype being loaded for this object column or table. Therefore, its entry must be null in the column array.; Action: Set the column array entry to null.
ORA-39797: The subtype index value is not valid.: Cause: The subtype index value in the column array was not valid for the object column or object table.; Action: Set a valid subtype index value in the column array for this table or column.
ORA-39798: The column array row offset number is out of range (max: number).: Cause: The specified row offset was too large for the column array.; Action: Ensure the row offset is in range.
ORA-39799: The column index number is out of range (max: number).: Cause: The specified column index was too large for the column array.; Action: Ensure the column index is in range.
ORA-39800: Database version number does not support the load of multiple subtypes.: Cause: Direct Path API support for loading multiple subtypes of an object table or column was only present in the Oracle 11 release and higher.; Action: Upgrade database to Oracle 11 or higher.
ORA-39801: Subtype "string"."string" is not a valid subtype for column string.: Cause: Subtype specified was not the declared type nor was it derived from the declared type.; Action: Ensure all subtypes specified are either the declared type or derived from the declared type.
ORA-39802: ADT object column string specified a SQL expression which is not allowed in direct path mode.: Cause: The ADT column reported in the error specified a SQL expression which returned the ADT. This is not supported.; Action: Remove the SQL expression.
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-39810: Data saves are not allowed when NO_INDEX_ERRORS is specified.: Cause: Data saves (and the sqlldr ROWS parameter) could not be allowed when loading with the NO_INDEX_ERRORS option.; Action: Do not attempt data saves when loading a table with the NO_INDEX_ERRORS option.
ORA-39811: index string.string had the following error:: Cause: An error occurred on the index; error follows.; Action: Fix the error and retry.
ORA-39812: index string.string partition string had the following error:: Cause: An error occurred on the index; error follows.; Action: Fix the error and retry.
ORA-39813: index string.string had string partition errors:: Cause: A logical index error occurred on a partitioned index which affected one or more index partitions, which are listed below this message.; Action: Fix the error(s) and retry.
ORA-39814: The SKIP_INDEX_MAINTENANCE option is not allowed with NO_INDEX_ERRORS.: Cause: The SKIP_INDEX_MAINTENANCE option was used with the NO_INDEX_ERRORS option.; Action: Do not use SKIP_INDEX_MAINTENANCE with NO_INDEX_ERRORS.
ORA-39815: Direct Path Unload of an external table is not allowed.: Cause: An attempt was made to use Direct Path API Unload to unload an external table.; Action: Do not use Direct Path Unload to unload an external table.
ORA-39816: Direct Path Unload of tables with encrypted column(string.string) is not allowed.: Cause: An attempt was made to use Direct Path API Unload to unload a table with encrypted columns.; Action: Do not use Direct Path Unload to unload a table with encrypted columns.
ORA-39817: index string.string was ignored due to:: Cause: Index was unusable at the start of the load and it was requested that unusable indexes be skipped.; Action: No action required.
ORA-39818: index string.string partition string was ignored due to:: Cause: Index was unusable at the start of the load and it was requested that unusable indexes be skipped.; Action: No action required.
ORA-39819: The OCI_ATTR_DIRPATH_NO_INDEX_ERRORS attribute cannot be set to TRUE in direct path parallel loads.: Cause: An attempt was made to set the OCI_ATTR_DIRPATH_NO_INDEX_ERRORS attribute to TRUE in a direct path parallel load.; Action: Do not set the OCI_ATTR_DIRPATH_NO_INDEX_ERRORS to TRUE for direct path parallel loads.
ORA-39820: Zero length LONG piece detected for column string row string.: Cause: A zero length piece was detected for a LONG column.; Action: Do not use a length of zero when loading LONG columns.
ORA-39821: domain index on columnar data made unusable\n: Cause: An attempt was made to load a columnar table with a domain index using SQL*Loader direct part load; Action: n/a
ORA-39822: A new direct path operation is not allowed in the current transaction.: Cause: All previous direct path contexts ended and the current transaction was ready for a commit or abort of those changes.; Action: Commit or abort the current transaction, and start a new transaction for the next direct path context.
ORA-39823: The attribute OCI_ATTR_DIRPATH_USE_ACTIVE_TRANS is only allowed for load operations.: Cause: The attribute OCI_ATTR_DIRPATH_USE_ACTIVE_TRANS was set for a nonload operation.; Action: Use OCI_ATTR_DIRPATH_USE_ACTIVE_TRANS for load operations only.
ORA-39824: The OCI_ATTR_DIRPATH_USE_ACTIVE_TRANS attribute was set when no transaction was active.: Cause: There was no active transaction to use.; Action: Start a transaction or do not set the attribute OCI_ATTR_DIRPATH_USE_ACTIVE_TRANS to TRUE.
ORA-39825: Direct path load of view or synonym (string.string) with multiple dependencies not permitted.: Cause: An attempt was made to load a view or synonym which has more than a single dependency.; Action: A view or synonym being loaded by the direct path API must resolve to a single object.
ORA-39826: Direct path load of view or synonym (string.string) could not be resolved.: Cause: A synonym or view could not be translated.; Action: Verify that the view or synonym is valid.
ORA-39827: Direct path load of PL/SQL function not permitted.: Cause: An attempt was made to load a PL/SQL function with the direct path API.; Action: Remove PL/SQL function the direct path load.
ORA-39828: Constraint string was disabled because of index string.string error.: Cause: The index used for the constraint was set as unusable.; Action: Fix the error that caused the index to be set unusable.
ORA-39829: function-based index on columnar data made unusable\n: Cause: An attempt was made to load a columnar table with a function-based index using SQL*Loader direct path load.; Action: Rebuild the function-based index after the load completes.
ORA-39830: XML parsing failed \nstring: Cause: XML parser returned an error while trying to parse the document.; Action: Fix the error that caused the document to be invalid.
ORA-39831: Direct path load failed, (string.string) is not a table.: Cause: Object being loaded did not resolve to a table.; Action: Verify that the view or table name is correct.
ORA-39832: Direct path unload was not allowed due to columns with default values.: Cause: Direct path unload was attempted on a table with columns that have default values.; Action: Do not attempt a direct path unload of a table with columns that have default values.
ORA-39833: Direct path parallel load was not allowed on a temporary table.: Cause: A direct path parallel load was attempted on a temporary table.; Action: Do not attempt a direct path parallel load on a temporary table.
ORA-39834: Direct path load or unload was not allowed on a remote table.: Cause: An attempt was made to specify a remote table in a direct path API load or unload.; Action: Do not specify a remote table in a direct path API load or unload.
ORA-39835: Direct path load partition memory exceeded. PGA use is stringkb, PGA limit is: stringkb: Cause: A direct path load ran out of process memory when loading multiple partitions.; Action: Use the PARTITION_MEMORY parameter to limit memory used when loading many partitions. Once this limit is reached, loading of some partition rows will be delayed until memory use falls below the limit. Use a value (kb) lower than the current program global area (PGA) limit included in this message and try the load again.
ORA-39836: Invalid direct path API server context detected: Cause: The data cartridge encountered an unexpected condition.; Action: Contact Oracle Support Services.
ORA-39837: Direct path loading does not support the DEFAULT value clause for column string.: Cause: Direct path loading could not support loading the default value for the data type of the indicated column.; Action: Use conventional path loading. Otherwise, use DEFAULTS=IGNORE, DEFAULTS=IGNORE_UNSUPPORTED_EVALUATE_ONCE or DEFAULTS=IGNORE_UNSUPPORTED_EVALUATE_EVERY_ROW.
ORA-39838: Direct path load of a specific partition with interval subpartitioning is not allowed.: Cause: An attempt was made to load a specific partition of a table that was interval subpartitioned. This is not supported by the Direct Path API.; Action: Load the entire table when the table is interval subpartitioned.
ORA-39839: Direct path default expression cache size (string) is too large.: Cause: An attempt was made to allocate a default expression cache that was too large.; Action: Use a smaller value for the default expression cache and retry.
ORA-39840: A data load operation has detected data stream format error string.: Cause: A dump file data stream format error was detected during a load operation.; Action: The stream format error may have been caused by a corrupted dump file. If possible, re-create the dump file and try again. If the problem persists, contact Oracle Support Services.
ORA-39841: A data load operation detected a data stream format error (see next error), attempting to continue.: Cause: A dump file data stream format error was detected during a load operation. An attempt was made to continue the load from a point beyond the corruption.; Action: The stream format error may have been caused by a corrupted dump file. If possible, re-create the dump file and try again. If the problem persists, contact Oracle Support Services.
ORA-39842: Data load operation was discontinued due to the previous data stream format error.: Cause: A dump file data stream format error was detected during a a load operation. The operation was aborted.; Action: The stream format error may have been caused by a corrupted dump file. If possible, re-create the dump file and try again. If the problem persists, contact Oracle Support Services.
ORA-39843: Invalid direct path API server context detected: Cause: The data cartridge encountered an unexpected condition.; Action: Contact Oracle Support Services.
ORA-39844: Bad stream format detected: [string] [string] [string] [string] [string] [string] [string] [string]: Cause: A dump file data stream format or initialization error was detected during a load or import operation.; Action: The stream format error may have been caused by a corrupted dump file. If possible, re-create the dump file and try again. If the problem persists, contact Oracle Support Services.
ORA-39845: A data load operation detected a data stream format error, attempting to continue.: Cause: A dump file data stream format error was detected during a load operation. An attempt was made to continue the load from a point beyond the corruption.; Action: The stream format error may have been caused by a corrupted dump file. If possible, re-create the dump file and try again. If the problem persists, contact Oracle Support Services.
ORA-39846: The specified number format for column string was invalid.: Cause: The specified number format for the column was not valid.; Action: Specify a valid numeric format and try again.
ORA-39847: Value too large for column string (maximum: string): Cause: An attempt was made to load a column with a value which is too large, possibly after conversion. The maximum value is in characters for character length semantics and bytes for byte length semantics.; Action: Ensure that the destination column is large enough to hold the maximum possibly converted result.
ORA-39849: corrupt metadata stream detected for table string: Cause: The metadata stream for the table was corrupt. Because of the corruption, the table data could not be loaded.; Action: Verify that the file has not been modified since it was created. If it has, use a copy of the original file. If not, contact Oracle Support Services.
ORA-39850: Sequence expressions are not supported for SQLLDR direct path loads on server versions prior to Oracle Database 23c.: Cause: An attempt was made to use a SQLLDR SEQUENCE expression on a server version that did not support it.; Action: Do not attempt to use a SQLLDR SEQUENCE expression on server releases prior to Oracle Database 23c.
ORA-39851: Subtype instances are not supported by this function.: Cause: An attempt was made to use a subtype of a hierarchy as an attribute to a function that does not support subtypes.; Action: Ensure that the argument is not an instance of a subtype of a hierarchy.
ORA-39852: Use of non primary key based OID table is not allowed by this function.: Cause: An attempt was made to use a non primary key based OID table as an input to a function that does not support it.; Action: Ensure that the table is a primary key based OID table.
ORA-39861: auxiliary data file copy file for Pluggable Database string: "string": Cause: This message reports the filename for details of another message.; Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery: Cause: The ALTER PLUGGABLE DATABASE OPEN RESETLOGS command was issued, but the Pluggable Database was not flashed back or point-in-time recovered.; Action: Retry the ALTER PLUGGABLE DATABASE OPEN command without specifying RESETLOGS.
ORA-39863: An earlier Pluggable Database incomplete recovery failed.: Cause: An earlier Pluggable Database flashback or point-in-time recovery failed.; Action: Retry the Pluggable Database flashback or incomplete recovery.
ORA-39864: Data file string on standby database must be restored and renamed, and standby database recovery must be restarted.: Cause: A missing data file was added on a standby database in response to a Pluggable Database (PDB) OPEN RESETLOGS command on the primary database. This data file must be restored and renamed on the standby database before standby database recovery can be restarted.; Action: Restore the missing data file and rename it on the standby database, then restart standby database recovery.
ORA-39865: cannot FLASHBACK beyond Pluggable Database resetlogs operation: Cause: An attempt was made to perform a FLASHBACK DATABASE beyond a Pluggable Database resetlogs system change number (SCN).; Action: Choose a FLASHBACK SCN that is more recent than the Pluggable Database resetlogs SCN.
ORA-39866: Data files for Pluggable Database string must be offline to flashback across special 12.1 PDB resetlogs.: Cause: An attempt was made to perform a FLASHBACK DATABASE beyond a Pluggable Database (PDB) resetlogs performed at 12.1 compatibility. Futhermore, the PDB resetlogs was performed after a flashback or point-in-time recovery (PITR) of the PDB to its parent database incarnation. This is not supported unless all data files in the PDB are offline.; Action: Take the data files for the Pluggable Database (PDB) offline before performing the FLASHBACK DATABASE command. To bring the PDB to the same past point in time as the container database (CDB), those data files can be restored from backups and recovered to that same past point in time. This can be done in one of two ways: * Flashback the CDB and open the CDB with resetlogs. Restore the PDB later, and perform a complete PDB recovery. * Flashback the CDB first. Restore and recover the PDB to the same system change number (SCN). Open CDB with resetlogs.
ORA-39867: PDB restore point 'string' is on an orphan incarnation of the pluggable database.: Cause: The specified PDB restore point was on an orphan incarnation of the pluggable database. One cannot flashback a pluggable database to an orphan incarnation.; Action: Check the restore point and make sure the feature is enabled.
ORA-39868: The specified PDB target incarnation is not on the current database ancestor path.: Cause: The specified recover target incarnation for the pluggable database (PDB) was not on the current database ancestor path.; Action: Specify a recovery target incarnation that is on the current database ancestor path.
ORA-39869: cannot flashback/PITR to a point on orphan PDB incarnation: Cause: An attempt was made to flashback/PITR the Pluggable Database(PDB) to a point on the orphan PDB incarnation. PDB flashback/PITR to a point on orphan PDB incarnation is not supported on standby database or when the database is in shared undo mode.; Action: If flashback/PITR not on standby database, then flashback/PITR the pluggable database to a point after the undo mode was changed to local undo.
ORA-39870: container database is not open in read/write mode: Cause: A command was attempted that requires the container database (CDB) to be open in read/write mode.; Action: Open the container database in read/write mode and try the command again.
ORA-39871: An earlier Pluggable Database resetlogs operation failed after making changes.: Cause: An earlier ALTER PLUGGABLE DATABASE OPEN RESETLOGS command failed after it made some changes.; Action: Perform another Pluggable Database point-in-time recovery before attempting to open the Pluggable Database with RESETLOGS.
ORA-39872: Data file number is in the middle of Pluggable Database resetlogs operation.: Cause: The data file was in the middle of a Pluggable Database resetlogs operation.; Action: Find the right file version or perform more media recovery. For additional information, see other errors.
ORA-39873: Restore all data files to a checkpoint SCN lower than string.: Cause: This error provides additional information for error 39874.; Action: Restore the data files as suggested and restart the recovery process.
ORA-39874: Pluggable Database string recovery halted: Cause: The Pluggable Database was recovered into an orphan branch.; Action: Restore all data files to a checkpoint system change number (SCN) lower than the branch point and restart the recovery process. Check the alert log for additional information.
ORA-39875: Data file string is in the middle of Pluggable Database resetlogs operation.: Cause: The data file is in the middle of a Pluggable Database (PDB) resetlogs operation.; Action: If possible, recover the data file further so that it is not in the middle of a PDB resetlogs operation. Another alternative is to perform PDB point-in-time recovery.
ORA-39876: cannot perform CDB OPEN RESETLOGS because data file string is in the middle of a PDB resetlogs operation: Cause: The data file mentioned was in the middle of a Pluggable Database (PDB) resetlogs operation.; Action: Recover the container database (CDB) to a different system change number (SCN) at which the data files are not in the middle of a PDB resetlogs operation. Alternatively, you can offline the problematic data file and let CDB OPEN RESETLOGS succeed. You may need to perform PDB point-in-time recovery later in order to open the PDB of the offlined data file.
ORA-39877: keyword ONLINE or OFFLINE expected: Cause: The ONLINE or OFFLINE keyword was not specified after the ALL keyword.; Action: Use the correct syntax.
ORA-39878: Only one Pluggable Database name can be specified.: Cause: Multiple Pluggable Database names were specified for the ALTER PLUGGABLE DATABASE OPEN RESETLOGS command.; Action: Specify only one Pluggable Database name.
ORA-39879: Pluggable Database string is in the middle of a Pluggable Database RESETLOGS operation: Cause: There was already an on-going Pluggable Database OPEN RESETLOGS operation for this Pluggable Database.; Action: If needed, retry after the Pluggable Database OPEN RESETLOGS operation completes.
ORA-39880: One or more pluggable databases were in the middle of a point-in-time recovery at this incomplete database recovery SCN.: Cause: In the past, one or more pluggable databases had an active pluggable database RESETLOGS operation as of this incomplete recovery SCN.; Action: Additional messages are logged in the alert log indicating all of the pluggable databases affected by this container database OPEN RESETLOGS operation. Recover the container database to a different system change number (SCN) at which none of the pluggable databases had an active RESETLOGS operation. To continue the container database OPEN RESETLOGS operation at the same SCN, offline all of the data files of the affected pluggable databases first and reissue the command. However, a new point-in-time recovery of the affected pluggable databases would be required before these databases can be opened again.
ORA-39881: Pluggable database string must be closed while recovering the physical standby across PDB RESETLOGS: Cause: The pluggable database (PDB) is open while the physical standby is recovering across a PDB RESETLOGS operation for the PDB.; Action: Close the PDB and restart physical standby recovery.
ORA-39882: cannot create clean pluggable database restore point for the specified pluggable database (con_id:string): Cause: There were still outstanding transactions in the closed pluggable database.; Action: Retry the command after opening the pluggable database and closing all outstanding transactions. Alternatively, create a normal pluggable database restore point.
ORA-39883: Restore point string for pluggable database string is not a clean pluggable database restore point.: Cause: For a pluggable database using shared undo, there was an attempt to flashback pluggable database in SQL without a clean pluggable database restore point. The specified restore point was not a clean pluggable database restore point.; Action: Do one of the following: - Issue flashback pluggable database in RMAN. - Issue the SQL flashback pluggable database command to flashback to a clean pluggable database restore point. - Turn on local undo mode for the pluggable database. The SQL flashback pluggable database command can always be used to flashback a pluggable database using local undo.
ORA-39884: Flashback of PDB (con_id:string) cannot restore data file string which is currently used by PDB (con_id:string).: Cause: The data file required to flashback the specified pluggable database to the specified point in time could not be restored. The file number of the pluggable database data file was used by a different pluggable database.; Action: Flashback the pluggable database to a different point-in-time. Alternatively, drop the conflicting data file from the database first before you flashback the pluggable database. If neither option can be used, you can also flashback the entire consolidated database or restore and recover a copy of the consolidated database to the specified point-in-time. You can then extract the recovered data.
ORA-39885: flashback/PITR of a pluggable database before its creation is not allowed: Cause: The flashback/PITR System Change Number (SCN) or timestamp specified was less than the pluggable database creation SCN or timestamp. Flashback/PITR SCN or timestamp cannot be less than the pluggable database creation SCN or timestamp.; Action: Check the flashback/PITR SCN or timestamp and retry the command.
ORA-39886: With shared undo, one can only use an SQL command to flashback a pluggable database (PDB) to a clean PDB restore point.: Cause: The command issued did not specify a clean pluggable database restore point. For a pluggable database using shared undo, one can only use the SQL Flashback pluggable database command to flashback to a clean pluggable database restore point.; Action: Do one of the following: - Issue flashback pluggable database in RMAN. - Issue the SQL flashback pluggable database command to flashback to a clean pluggable database restore point. - Turn on local undo mode for the pluggable database. The SQL flashback pluggable database command can always be used to flashback a pluggable database using local undo.
ORA-39887: Cannot create restore points for SEED PDB: Cause: There was an attempt to create a restore point for SEED PDB.; Action: Create restore points in ROOT or for a different pluggable database.
ORA-39888: Guaranteed restore points exist for pluggable database string.: Cause: There was an attempt to drop or unplug a pluggable database when there were still guaranteed restore points for this pluggable database.; Action: Drop all the guaranteed restore points for the pluggable database before dropping the pluggable database.
ORA-39889: Specified System Change Number (SCN) or timestamp is in the middle of a previous PDB RESETLOGS operation.: Cause: The specified System Change Number (SCN) or timestamp was in the middle of a previous PDB RESETLOGS operation. More specifically, each PDB RESETLOGS operation may create a PDB incarnation as shown in v$pdb_incarnation. Any SCN between INCARNATION_SCN and END_RESETLOGS_SCN or any timestamp between INCARNATION_TIME and END_RESETLOGS_TIME as shown in v$pdb_incarnation is considered in the middle of the PDB RESETLOGS operation.; Action: Flashback the PDB to an SCN or timestamp that is not in the middle of a previous PDB RESETLOGS operation. If flashback to a SCN on the orphan PDB incarnation is required, then use "RESET PLUGGABLE DATABASE TO INCARNATION" RMAN command to specify the pluggable database incarnation along which flashback to the specified SCN must be performed. Also, ensure that the feature is enabled.
ORA-39890: Flashback or PITR of a pluggable database to a System Change Number (SCN) or timestamp before latest undo mode switch is not allowed.: Cause: An attempt was made to flashback/PITR a pluggable database (PDB) to a System Change Number (SCN) or timestamp that precedes the latest switch between shared and local undo.; Action: Flashback/PITR a pluggable database (PDB) to an SCN or timestamp that comes after the latest switch between shared and local undo.
ORA-39891: Clean PDB restore point cannot be created when CDB is in local undo mode.: Cause: There was an attempt to create a clean restore point when the CDB was in local undo mode. This is not supported. Clean PDB restore points are designed for CDB in shared undo mode. They are not useful for CDB in local undo mode.; Action: Do not use "clean" option when creating the restore point.
ORA-39892: PDB PITR/Flashback to a point in time on an orphan database incarnation is not allowed.: Cause: An attempt was made to flashback or point-in-time recovery (PITR) of a pluggable database (PDB) to a point in time that falls on an orphaned database incarnation.; Action: Flashback or PITR a pluggable database (PDB) to an earlier point in time that falls somewhere along the database direct ancestor path from the current database incarnation.
ORA-39893: PDB restore point could not be created: Cause: There was an attempt to create a restore point for a pdb that was still in the process of being created or was never opened before.; Action: Retry the operation after pdb creation is complete and opened once.
ORA-39894: PDB restore point could not be created: Cause: There was an attempt to create a restore point for a pdb when an application install or upgrade was going on.; Action: Retry the operation after application install or upgrade is complete.
ORA-39895: unable to flashback or PITR a pluggable database: Cause: The flashback or point-in-time recovery (PITR) system change number (SCN) or timestamp specified was less than the SCN or timestamp at which the pluggable database was first opened in read/write mode.; Action: Check the flashback or PITR SCN or timestamp and retry the command.
ORA-39896: INSTANCES clause and RESETLOGS keyword cannot be used together in ALTER PLUGGABLE DATABASE command: Cause: The INSTANCES clause was specified in the ALTER PLUGGABLE DATABASE OPEN RESETLOGS command.; Action: Specify either the INSTANCES clause or the RESETLOGS keyword in the command, but not both.
ORA-39897: A required flashback log has been reused during flashback of a pluggable database.: Cause: At least one required flashback log has been reused during flashback of a pluggable database.; Action: You can no longer flashback this pluggable database to the same point-in-time as specified because a required flashback log file has been reused. You may still be able to flashback this pluggable database to a more recent point-in-time. You can also recover the pluggable database to undo the effect of the failed flashback pluggable database operation.
ORA-39898: unable to locate the specified timestamp along any of the pluggable database incarnations: Cause: The specified timestmap could not be located on any of the Pluggable Database (PDB) incarnations. This could be because the system timestamp went backwards at some point in the past.; Action: Pick a different timestamp, or try using flashback to SCN.
ORA-39899: User specified recovery target incarnation %0!s does not belong to pluggable database %1!s (%2!s): Cause: The recovery target incarnation did not belong to the pluggable database.; Action: Specify a valid pluggable database recovery target incarantion that belongs to the pluggable database.
ORA-39900: specified SCN is beyond the PDB recovery target incarnation: Cause: The specified System Change Number (SCN) was beyond the specified Pluggable Database (PDB) recovery target incarnation.; Action: Use a valid SCN that lies on the PDB recovery target incarnation or set a valid PDB recovery target incarnation corresponding to the specified SCN.
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: Subpartitioned 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.
ORA-39904: Partitioned object string.string is partially contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Check partitions and overflow segments by querying SYS.DBA_IND_PARTITIONS and SYS.DBA_TAB_PARTITIONS.
ORA-39905: Table string.string in tablespace string points to LOB segment string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39906: Constraint string between table string.string in tablespace string and table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39907: Index string.string in tablespace string points to table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39908: Index string.string in tablespace string enforces primary constraints string of table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39909: Index string.string in tablespace string points to table/cluster string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39910: Partitioned Global index string.string in tablespace string points to partition string of table string.string in tablespace string outside of transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39911: Index string.string in tablespace string points to partition string of table string.string in tablespace string outside of transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39912: Partitioned index string.string in tablespace string points to table string.string in tablespace string outside of transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39913: string string.string in tablespace string not allowed in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39914: Index string.string in tablespace string points to subpartition string of table string.string in tablespace string outside of transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39915: Partition string of table string.string in tablespace string points to LOB segment string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39916: Subpartition string of table string.string in tablespace string points to LOB segment string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39917: SYS owned object string in tablespace string not allowed in pluggable set: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39918: PLSQL Functional Index string.string in tablespace string not allowed in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39919: Object string.string in tablespace string not contained within transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Check SYS.DBA_OBJECTS.
ORA-39920: Rollback segment string in tablespace string not allowed in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39921: Default Partition (Table) Tablespace string for string not contained in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39922: Default Partition (Index) Tablespace string for string not contained in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39923: Default Composite Partition (Table) Tablespace string for string not contained in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39924: Default Composite Partition (Index) Tablespace string for string not contained in transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39925: LOB segment string.string in tablespace string points to table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39926: Join index between table string.string in tablespace string and table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39927: Scoped REF constraint between table string.string in tablespace string and table string.string in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39928: string string.string in tablespace string contains evolved type data that have not been upgraded.: Cause: Transportable tablespace operation could not be performed because some tables depending on evolved types were not upgraded.; Action: Transportable tablespace operation can only be performed when all tables depending on evolved types have been upgraded. Perform ALTER TABLE <tab_name> UPGRADE for the table name listed in the message above
ORA-39929: Table string.string in tablespace string has encrypted columns which are not supported.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39930: Violation string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Contact Oracle Support Services.
ORA-39931: XML Schema string Owner: string not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Identify the associated elements and resolve self containment.
ORA-39932: Extensible Index string.string not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Identify the associated table and list of secondary objects and resolve self containment.
ORA-39933: Parent table string.string and its nested table columns are not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Identify the nested tables using view DBA_NESTED_TABLES and resolve self containment.
ORA-39934: Materialized view log string.string in tablespace string and master table string.string in tablespace string are not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39935: Updatable materialized view log string.string in tablespace string and materialized view string.string in tablespace string are not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39936: Token manager for the CSX tablespace string not fully contained in the transportable set.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Include the specified tablespace into the transportable set.
ORA-39937: Unsupported operation, default token tables used for binary XML data.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Copy default token tables into a new token table set using DBMS_CSX_ADMIN package.
ORA-39938: Operation not supported, tablespace string contains binary XML data.: Cause: Informational message to describe a failure during transportable containment checking.; Action: None required.
ORA-39939: More than one set of token tables are used in tablespace string.: Cause: Informational message to describe a failure during transportable containment checking.; Action: Remap tables in the specified tablespace to use same token tables.
ORA-39940: Child reference partitioned table string.string in tablespace string or parent table string.string in tablespace string is included but not both.: Cause: Informational message to describe a failure during transportable containment checking. Both parent and child reference partition tables must be included.; Action: Check reference partitioned tables.
ORA-39941: Partitioned table string.string in tablespace string has a partition that has an incomplete online move.: Cause: This is an informational message to describe a failure during transportable containment checking. Online moves need to be complete before transporting a tablespace.; Action: Use the DBMS_PART.CLEANUP_ONLINE_OP procedure to force the online move to complete.
ORA-39942: Subpartitioned table string.string in tablespace string has a subpartition that has an incomplete online move.: Cause: This is an informational message to describe a failure during transportable containment checking. Online moves need to be complete before transporting a tablespace.; Action: Use the DBMS_PART.CLEANUP_ONLINE_OP procedure to force the online move to complete.
ORA-39943: Global index string.string in tablespace string has orphaned entries.: Cause: This is an informational message to describe a failure during transportable containment checking. Orphaned entries need to be cleaned up before transporting a tablespace.; Action: Use DBMS_PART.CLEANUP_GIDX() to cleanup orphaned index entries.
ORA-39944: Global partitioned index string.string in tablespace string has orphaned entries.: Cause: This is an informational message to describe a failure during transportable containment checking. Orphaned entries need to be cleaned up before transporting a tablespace.; Action: Use DBMS_PART.CLEANUP_GIDX() to cleanup orphaned index entries.
ORA-39945: Token conflicting with existing tokens.: Cause: The binary XML tokens contained in the imported tablespace conflicted with the existing tokens.; Action: Use the dump file export or import instead of transportable tablespace.
ORA-39946: Nondefault token table encountered.: Cause: During transportable tablespace import, a nondefault token table was encountered.; Action: Use the dump file export or import instead of transportable tablespace.
ORA-39947: Table string.string in tablespace string has token tables in tablespace string.: Cause: The token tables for the table were in a tablespace which was not being exported.; Action: Include the specified tablespace into the transportable set.
ORA-39948: QNAMES or NAMESPACES tables for the import are in use.: Cause: The import needed xdb.XDB$IMPORT_NM_INFO and xdb.XDB$IMPORT_QN_INFO to be empty to avoid collisions or corruptions.; Action: This is an internal error. Contact Oracle Support Services.
ORA-39950: invalid parameter for PLSQL warnings flag: Cause: The user either entered invalid value for the PLSQL_WARNINGS flag or the value of the flag conflicts with other values.; Action: Enter correct values for the switch.
ORA-39951: incomplete values specified for PL/SQL warning settings: Cause: The user either did not enter the value for the settings or entered incomplete values.; Action: Enter correct syntax for the switch.
ORA-39952: only numbers can be specified as range values: Cause: The range values did not have numerical values only.; Action: Enter only numerical values.
ORA-39953: the range value specified is beyond allowed range: Cause: The range values were either too low or too high.; Action: Specify only the allowed range values.
ORA-39954: DEFERRED is required for this system parameter: Cause: The ALTER SYSTEM command for PLSQL_WARNINGS did not include the keyword, DEFERRED.; Action: Change the command to use the keyword, DEFERRED.
ORA-39955: invalid PL/SQL warning message number: Cause: The PL/SQL message number specified was not in a valid range.; Action: Specify PL/SQL warning message numbers within the valid range.
ORA-39956: duplicate setting for PL/SQL compiler parameter string: Cause: A PL/SQL compiler parameter was set more than once.; Action: Remove the duplicate PL/SQL compiler setting.
ORA-39957: invalid warning category: Cause: The category of the message was incorrect.; Action: Specify a vaild category
ORA-39958: invalid warning category qualifier: Cause: The category qualifier was incorrect.; Action: Specify a vaild category qualifier.
ORA-39959: invalid warning number (string): Cause: The warning number was incorrect.; Action: Specify a vaild warning number.
ORA-39960: scope can only be SYSTEM or SESSION: Cause: The scope specified was not set.; Action: Specify a vaild scope, either SESSION or SYSTEM.
ORA-39961: message specified was not found: Cause: The message number specified was not set.; Action: specify the message number whise settings have been set in the given scope.
ORA-39962: invalid parameter for PLSQL_CCFLAGS: Cause: The value for the PLSQL_CCFLAGS parameter was not valid.; Action: Specify a vaild value for the PLSQL_CCFLAGS parameter.
ORA-39964: Specified value for _PLSQL_MAX_STACK_SIZE (string) is larger than available memory (string): Cause: The value specified for the _PLSQL_MAX_STACK_SIZE parameter was larger than the amount of stack size available to the process.; Action: Specify a smaller value for the _PLSQL_MAX_STACK_SIZE parameter.
ORA-39965: Collection of records with PL/SQL type attributes are not allowed in this context.: Cause: A collection of records with attributes of PL/SQL types was used as an argument to the TABLE operator, which is not allowed.; Action: Use a collection of records whose attributes are of a type that your operation supports.
ORA-39966: This form is allowed only in WITH clause context: Cause: Only an entry point number was specified for SYS_PLSQL_CPU, SYS_PLSQL_COUNT or SYS_PLSQL_IO costing operator. This is allowed only when these operators are applied to functions appearing in the WITH clause.; Action: Specify the required function, package, or type name. An optional schema name can also be specified.
ORA-39967: Cannot use this PL/SQL procedure while data files are being moved or rekeyed.: Cause: Some data files were being moved or rekeyed either on the primary or standby database.; Action: Check the status of data files and try this command again.
ORA-39968: Invalid value for parameter PLSCOPE_SETTINGS. Value must be from among 'IDENTIFIERS:[ALL|NONE|PLSQL|SQL|PUBLIC], STATEMENTS:[ALL|NONE]'.: Cause: The value for the PLSCOPE_SETTINGS parameter was not valid.; Action: Specify a vaild value for the PLSCOPE_SETTINGS parameter.
ORA-39969: Bind variable should be of a supported PL/SQL type: Cause: A variable of a wrong type was used in the DBMS_SQL.BIND_VARIABLE_PKG call. In the DBMS_SQL.BIND_VARIABLE_PKG call, the type of the variable should be declared in a package specification and should be either a record or one of the supported collection types.; Action: Use a bind variable whose type is one of the supported types for this operation and whose type is declared in a package specification.
ORA-39970: Bind calls are not allowed after cursor execution: Cause: A bind call was used after the cursor was executed. Binds can only be done after the cursor was parsed but before execution.; Action: Move the bind call before cursor execution.
ORA-39971: cannot use this PL/SQL procedure for this pluggable database when PATH_PREFIX information is not accessible: Cause: Some pluggable databases have specified PATH_PREFIX for security purposes, but the PL/SQL procedure was unable to check the PATH_PREFIX because the root was not open or for some other security reasons.; Action: Open the root or connect to the root directly and try this command again.
ORA-39972: cannot use an object type with PL/SQL unique attributes in a SQL statement: Cause: An object type created with PL/SQL unique attributes was used in a SQL statement.; Action: Use only SQL-permitted type attributes in a SQL statement.
ORA-39973: invalid or duplicate named fields in collection type: Cause: The collection type had duplicate or invalid named fields.; Action: Rename the invalid or duplicate field or use an alias in the SELECT list of the cursor type to avoid duplicate or invalid named fields.
ORA-39974: unsupported RECORD type operation: Cause: An attempt was made to use RECORD variable in MEMBER OF operation with target collection that was not null.; Action: Do not use this operation. For backward compatibility, no compile time error was given because no error is raised for null target collection.
ORA-39975: Failed to extend the program call stack depth to string. (The current maximum allowed depth is string frames.): Cause: PL/SQL program execution stack depth is more than permitted.; Action: Contact your DBA to increase the maximum allowed frames. Decrease the stack depth of the program by ensuring less call nesting or evaluate if there is a runway recursion by inspecting the program.