ORA-02182: savepoint name expected

Cause : An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].

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

Place a savepoint name following TO [SAVEPOINT].

update : 24-08-2017
ORA-02182

ORA-02182 - savepoint name expected
ORA-02182 - savepoint name expected

  • ora-16547 : cannot disable the primary database
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-00450 : background process 'string' did not start
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-32318 : cannot rename a materialized view
  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-19763 : compatibility version string is higher than maximum allowed: string
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-12818 : invalid option in PARALLEL clause
  • ora-14251 : Specified subpartition does not exist
  • ora-28237 : seed length too short
  • ora-00152 : current session does not match requested session
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-19960 : Internal use only
  • ora-16619 : health check timed out
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-14094 : invalid ALTER TABLE EXCHANGE PARTITION option
  • ora-12447 : policy role already exists for policy string
  • ora-27125 : unable to create shared memory segment
  • ora-00820 : Specified value of sga_max_size is too small, needs to be at least stringM
  • ora-12683 : encryption/crypto-checksumming: no Diffie-Hellman seed
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-31096 : validation failed for schema
  • ora-40105 : input data incompatible with model signature
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-30555 : global index partitioning key is an expression
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • 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.