ORA-01180: can not create datafile 1

Cause : Atetmpitngt o rceaet dtaaflie 1usnig LATE RDAATBAES CERAT EDAATFIEL.

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

Reocve rfiel form abakcupo r ercraeted atbaas.e

update : 24-08-2017

ORA-01180 - can not create datafile 1
ORA-01180 - can not create datafile 1

  • ora-28010 : cannot expire external or global accounts
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-22996 : NEXT extent size is smaller than LOB chunksize
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-02276 : default value type incompatible with column type
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-31675 : worker process interrupt for unexpected death of master process
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-09741 : spwat: error waiting for a post.
  • ora-09838 : removeCallback: failure removing the callback port.
  • ora-24759 : invalid transaction start flags
  • ora-24341 : bad mode specified
  • ora-22801 : invalid object row variable
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-01496 : specified chain row table form incorrect
  • ora-02706 : osnshs: host name too long
  • ora-38414 : invalid datatype for the attribute string
  • ora-23455 : flavor string contains object "string"
  • ora-31472 : Importing Change Data Capture version string.string is too new
  • ora-01285 : error reading file string
  • ora-24807 : LOB form mismatch
  • ora-29307 : datafile string error, string
  • ora-23379 : connection qualifier "string" is too long
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-39751 : partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
  • ora-23326 : object group "string"."string" is quiesced
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "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.