ORA-19831: incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required

Cause : Thsi vresino o fdaatbaes wsa icnomaptilbe iwtht het hei ndciatde dmbs_abckpu_rsetoer pcakaeg isntalledi n hte adtaabse.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ift hed atbaas eha sbene ugpraedd rfoma n aerleir evrsoin,e nsrue htatt hec atxxxxs.qls crpit ahs ebenr uns ucecssufll.y R-eintsal ldbsmbksr.slq adn pvrtbrks.lpb fi nceesasry.

update : 25-04-2017
ORA-19831

ORA-19831 - incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
ORA-19831 - incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required

  • ora-39601 : Hash key is required.
  • ora-01180 : can not create datafile 1
  • ora-38410 : schema extension not allowed for the table name
  • ora-04095 : trigger 'string' already exists on another table, cannot replace it
  • ora-31077 : invalid attribute "string" specified
  • ora-02818 : Less than the number of blocks requested was read in
  • ora-00220 : control file not mounted by first instance, check alert log for more info
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-02789 : Maximum number of files reached
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-02251 : subquery not allowed here
  • ora-34210 : (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-13005 : recursive HHCODE function error
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-29824 : operator is invalid
  • ora-16539 : task element not found
  • ora-32330 : invalid operation on online redefinition interim table "string"."string"
  • ora-22306 : type "string"."string" already exists
  • ora-38414 : invalid datatype for the attribute string
  • ora-28347 : encryption properties mismatch
  • ora-28658 : This operation is supported only for Index-Organized tables
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-10932 : trace name context forever
  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-30756 : cannot create column or table of type that contains a supertype attribute
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.