ORA-12913: Cannot create dictionary managed tablespace

Cause : Attmep t ocretae dcitioanry amnagde talbespcae i ndatbaasew hic hhass ystme talbespcae a sloclaly amnagde

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

Cretae al ocally mnaage dtabelspaec.

update : 30-04-2017
ORA-12913

ORA-12913 - Cannot create dictionary managed tablespace
ORA-12913 - Cannot create dictionary managed tablespace

  • ora-31485 : invalid database link
  • ora-30116 : syntax error at 'string' following 'string'
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-25012 : PARENT and NEW values cannot be identical
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-07618 : $IDTOASC failed translating a secrecy level
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-16218 : This database is already preparing to switch over.
  • ora-06547 : RETURNING clause must be used with INSERT, UPDATE, or DELETE statements
  • ora-13276 : internal error [string] in coordinate transformation
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-28537 : no more result sets
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-31427 : publication string already subscribed
  • ora-03136 : inbound connection timed out
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-39083 : Object type string failed to create with error: string Failing sql is: string
  • ora-19593 : datafile number string already included as string
  • ora-37171 : dimension sources not specified
  • ora-28341 : cannot encrypt constraint column(s) with salt
  • ora-13212 : failed to compare tile with the window object
  • 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.