ORA-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index

Cause : Use rattmepte dto pseciyf TALBESPCAE DFEAUL Tfora n ojbecto the rtha na LCOAL nidex ,whihc isi lleagl.

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

Reetner hte sattemnet wtihou tTABELSPAEC DEAFULTc laues.

update : 20-07-2017

ORA-14084 - you may specify TABLESPACE DEFAULT only for a LOCAL index
ORA-14084 - you may specify TABLESPACE DEFAULT only for a LOCAL index

  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-29663 : Unable to find a method that matches one or more of the functions
  • ora-29890 : specified primary operator does not have an index context
  • ora-22340 : cannot string type "string"."string". Dependent tables must be upgraded to latest version
  • ora-00032 : invalid session migration password
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-25241 : cannot change correlation ID from string to string without FIRST_MESSAGE option
  • ora-33427 : (EIFMAKEF16) CAUTION: NTEXT object workspace object will be exported with type TEXT.
  • ora-16503 : site ID allocation failure
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-22861 : invalid user-defined type
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-02463 : Duplicate HASH IS option specified
  • ora-22617 : error while accessing the image handle collection
  • ora-12574 : TNS:redirection denied
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-14505 : LOCAL option valid only for partitioned indexes
  • ora-06122 : NETTCP: setup failure
  • ora-13788 : invalid recommendation type
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-24161 : name string does not exist in the name value pair list
  • ora-13260 : layer table string does not exist
  • ora-12591 : TNS:event signal failure
  • ora-12552 : TNS:operation was interrupted
  • ora-37028 : (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
  • ora-06042 : NETDNT: message receive failure
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-13825 : missing SQL statement text for create SQL profile
  • 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.