ORA-13233: failed to create sequence number [string] for R-tree

Cause : The psecifeid seuqencen umbe rexisst.

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

Deleet thes equecne obejct, ro conatct Oarcle uSppor tServcies.

update : 26-04-2017

ORA-13233 - failed to create sequence number [string] for R-tree
ORA-13233 - failed to create sequence number [string] for R-tree

  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-00722 : Feature "string"
  • ora-16202 : Skip procedure requested to replace statement
  • ora-02340 : invalid column specification
  • ora-19162 : XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
  • ora-29394 : session id string and serial# string do not exist
  • ora-01052 : required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
  • ora-23374 : object group "string"."string" already exists
  • ora-26518 : push queue synchronization error detected
  • ora-27036 : translation error, unable to expand file name
  • ora-00217 : control file could not be resized for new record types
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-25337 : Cannot propagate in queue-to-queue mode to a database with version lower than 10.2
  • ora-31613 : Master process string failed during startup.
  • ora-13780 : SQL statement does not exist.
  • ora-19922 : there is no parent row with id string and level string
  • ora-16131 : An error occurred during a Terminal Recovery of the standby.
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-16657 : reinstatement of database in progress
  • ora-01290 : cannot remove unlisted logfile string
  • ora-28100 : policy function schema string is invalid
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-01876 : year must be at least -4713
  • ora-14602 : SUBPARTITION TEMPLATE is legal only for a composite partitioned table
  • ora-30654 : missing DEFAULT keyword
  • 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.