ORA-25144: invalid option for CREATE TABLESPACE with TEMPORARY contents

Cause : An invalid option appears.

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

Specify one of the valid options: EXTENT MANAGEMENT DICTIONARY, USER

update : 25-04-2017

ORA-25144 - invalid option for CREATE TABLESPACE with TEMPORARY contents
ORA-25144 - invalid option for CREATE TABLESPACE with TEMPORARY contents

  • ora-19722 : datafile string is an incorrect version
  • ora-06563 : top level procedure/function specified, cannot have subparts
  • ora-31655 : no data or metadata objects selected for job
  • ora-29251 : Index1 is greater than Index2 in call to dbms_sql.bind_array
  • ora-01107 : database must be mounted for media recovery
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-06420 : NETCMN: SID lookup failure
  • ora-06534 : Cannot access Serially Reusable package string
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-16217 : prepare to switchover has not completed
  • ora-39163 : A sample size of string is invalid.
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-00063 : maximum number of log files exceeded string
  • ora-12655 : Password check failed
  • ora-06811 : TLI Driver: could not set the IPX network number at init
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-09959 : IMON: deletion of a process failed.
  • ora-29972 : user does not have privilege to change/ create registration
  • ora-13111 : cannot add topo_geometry layer [string] to topology
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-08331 : Wait operation timed out
  • ora-10634 : Segment is already being shrunk
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-31440 : change set string is empty and cannot be advanced
  • ora-02706 : osnshs: host name too long
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-22276 : invalid locator for LOB buffering
  • ora-02165 : invalid option for CREATE DATABASE
  • 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.