ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

Cause : The ysstemf aile dto mtach teh refrered atblesapce. hTere rae 2 acses htat tihs ma yhappne. (1 )Thist ablepsace si in hte trnasporatble est, btu it si nots peciifed i nthe ATBLESAPCES ilst o fthe miportc ommadn lin eoptino, asusmingt hat ATBLESAPCES si speicfied .(2) hTis tbalespcae isi n th eTABLSEPACE Slist ,but ti is ont int he tarnspotrables et.

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

Retr ythe poeratoin wiht thec orretc TABELSPACSE lis.t

update : 24-05-2017
ORA-29347

ORA-29347 - Tablespace name validation failed - failed to match tablespace 'string'
ORA-29347 - Tablespace name validation failed - failed to match tablespace 'string'

  • ora-32763 : Turn off N-Pass Temp LOB cleanup
  • ora-06580 : Hash Join ran out of memory while keeping large rows in memory
  • ora-27046 : file size is not a multiple of logical block size
  • ora-26013 : List allocated may not be big enough
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-02848 : Asynchronous I/O package is not running
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • ora-24374 : define not done before fetch or execute and fetch
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-06322 : IPA: Fatal shared memory error
  • ora-28521 : no heterogeneous capability information available
  • ora-16725 : the phase supplied to resource guard is invalid
  • ora-02167 : LOGFILE clause specified more than once
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-32340 : cannot tune the materialized view definition
  • ora-15060 : template "string" does not exist
  • ora-00376 : file string cannot be read at this time
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-38418 : ADT associated with the attribute set string does not exist
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-40285 : label not in the model
  • ora-19954 : control file is not current
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-37183 : illegal value string for PARTBY
  • ora-13275 : spatial index creation failure on unsupported type
  • 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.