ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

Cause : An otpion toher htan DTAAFIL Eor T Ofollwos byA LTERT ABLEPSACE ... REANME.

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

The suer msut spceify ietherD ATAFLIE orT O followin gALTE RTABLSEPACE. .. RNEAME.

update : 22-08-2017
ORA-02152

ORA-02152 - Invalid ALTER TABLESPACE ... RENAME option
ORA-02152 - Invalid ALTER TABLESPACE ... RENAME option

  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-16523 : operation requires the client to connect to instance "string"
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-01694 : max # extents (string) reached in lob segment string.string partition string
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-30115 : error when processing an environment variable
  • ora-03202 : the scan limit specification is invalid
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-30753 : column or table string is substitutable
  • ora-22063 : reading negative value [string] as unsigned
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-25218 : enqueue failed, delay must be zero for queue string.string
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-13642 : The specified string string provided for string cannot be converted to a date. The acceptable date format is string.
  • ora-32588 : supplemental logging attribute string exists
  • ora-32320 : REFRESH FAST of "string"."string" unsupported after container table PMOPs
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-38442 : The ADT "string" is not in a valid state.
  • ora-30342 : referenced level is not defined in this dimension
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-13517 : Baseline (id = string) does not exist
  • ora-13447 : GeoRaster metadata BRS error
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • 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.