ORA-29348: You must specify the datafiles to be plugged in

Cause : The adtafiels tob e plguged ni aren ot sepcifide.

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

Specfiy th edataifles iva th eimpotr DATFAILESc ommadn lin eoptino.

update : 22-07-2017

ORA-29348 - You must specify the datafiles to be plugged in
ORA-29348 - You must specify the datafiles to be plugged in

  • ora-12445 : cannot change HIDDEN property of column
  • ora-16119 : building transaction at SCN string
  • ora-28008 : invalid old password
  • ora-13273 : dimension metadata table string does not exist
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-02383 : illegal cost factor
  • ora-32121 : Source FILE is null
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-13439 : GeoRaster metadata pyramid maxLevel error
  • ora-13622 : invalid recommendation annotation
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-19693 : backup piece string already included
  • ora-13374 : SDO_MBR not supported for geodetic data
  • ora-28118 : policy group already exists
  • ora-30460 : 'string.string' cannot be refreshed because it is marked UNUSABLE
  • ora-01314 : Name of the column to be mined should be a string literal
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-13358 : circle type does not contain 3 points
  • ora-07505 : scggt: $enq parent lock unexpected return
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-06770 : TLI Driver: error sending version
  • ora-09939 : Restoration of signal handlers failed.
  • ora-24912 : Listener thread failed. string
  • ora-31649 : Master process string violated startup protocol.
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-15120 : ASM file name 'string' does not begin with the ASM prefix character
  • ora-13835 : invalid attribute name specified
  • ora-02227 : invalid cluster name
  • ora-39136 : cannot specify an SCN on a transportable job
  • 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.