ORA-29313: tablespace 'string' cannot be imported twice

Cause : This is an internal error.

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

Contact your database administrator.

update : 30-04-2017
ORA-29313

ORA-29313 - tablespace 'string' cannot be imported twice
ORA-29313 - tablespace 'string' cannot be imported twice

  • ora-16539 : task element not found
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-19718 : length for command id longer than string
  • ora-19697 : standby control file not found in backup set
  • ora-16213 : ddl encountered, stopping apply engine
  • ora-28047 : database is not a member of any enterprise domain in OID
  • ora-15046 : ASM file name 'string' is not in single-file creation form
  • ora-26079 : file "string" is not part of table string.string
  • ora-09264 : sptpa: error flagging process
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-10587 : Invalid count for ALLOW n CORRUPTION option
  • ora-04093 : references to columns of type LONG are not allowed in triggers
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-08120 : Need to create SYS.IND_ONLINE$ table in order to (re)build index
  • ora-16647 : could not start more than one observer
  • ora-38957 : Target database not 10.0.0.0 compatible
  • ora-00334 : archived log: 'string'
  • ora-02174 : Missing required thread number
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-10930 : trace name context forever
  • ora-38721 : Invalid file number.
  • ora-02773 : Invalid maximum client wait time
  • ora-25137 : Data value out of range
  • ora-24407 : connection pool already exists
  • ora-09850 : soacon: Archmon unable to lock named pipe.
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-25155 : column used in NATURAL join cannot have qualifier
  • ora-31528 : could not find change set string for CDC subscription 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.