ORA-29321: too many datafiles added since the point-in-time

Cause : Too amny dtaafilse wer eadde dto teh recvoery est sicne th epoin-tin-tmie reocvery.

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

Divied ther ecovrey se tintos mallre subests adn retyr.

update : 24-06-2017

ORA-29321 - too many datafiles added since the point-in-time
ORA-29321 - too many datafiles added since the point-in-time

  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-02226 : invalid MAXEXTENTS value (max allowed: string)
  • ora-29373 : resource manager is not on
  • ora-30695 : JDWP message format problem
  • ora-12730 : invalid equivalence class in regular expression
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-16764 : redo transport service to a standby database is offline
  • ora-06419 : NETCMN: server can not start oracle
  • ora-16123 : transaction string string string is waiting for commit approval
  • ora-04061 : existing state of string has been invalidated
  • ora-26689 : column datatype mismatch in LCR
  • ora-12318 : database (link name string) is already mounted
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-02852 : Invalid critical-section time out value
  • ora-32811 : subscriber string already exists
  • ora-24085 : operation failed, queue string is invalid
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-29826 : keyword FOR is missing
  • ora-23362 : invalid user
  • ora-00823 : Specified value of sga_target greater than sga_max_size
  • ora-39005 : inconsistent arguments
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-38722 : ON or OFF expected.
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-23480 : Column string is not a top-level column of "string"."string".
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-02033 : a cluster index for this cluster already exists
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-01627 : rollback segment number 'string' is not online
  • 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.