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 : 23-09-2017

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

  • ora-30690 : timeout occurred while registering a TCP/IP connection for data traffic detection
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-16070 : parameter string contains an invalid REGISTER attribute value
  • ora-36316 : (PHYS02) Relation workspace object must be a single-dimensional relation that relates one INTEGER dimension to another.
  • ora-07432 : unable to perform nested sleep
  • ora-09290 : sksaalo: error allocating memory for archival
  • ora-13401 : duplicate entry for string in USER_SDO_GEOR_SYSDATA view
  • ora-22057 : bad integer length [string]
  • ora-08006 : specified row no longer exists
  • ora-27076 : unable to set limit for open files
  • ora-12542 : TNS:address already in use
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-13156 : table to be registered string.string is not empty
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-00712 : cannot rename system tablespace
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-31666 : Master process string had an unhandled exception.
  • ora-31640 : unable to open dump file "string" for read
  • ora-13604 : The specified parameter string cannot be fetched as a SQL table.
  • ora-23379 : connection qualifier "string" is too long
  • ora-19045 : character set id specified for XMLSerialize not valid
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-23484 : internal internet Application Server error: string
  • ora-27101 : shared memory realm does not exist
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-23367 : table string is missing the primary key
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • 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.