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 : 22-09-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-25019 : too much concurreny
  • ora-01411 : cannot store the length of column in the indicator
  • ora-09961 : Unable to restore termination signal handler
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-06141 : NETTCP: no privilege for user
  • ora-01201 : file string header failed to write correctly
  • ora-28053 : the account is inactive
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-30338 : illegal dimension hierachy name
  • ora-31694 : master table string failed to load/unload
  • ora-07549 : sftopn: $OPEN failure
  • ora-14505 : LOCAL option valid only for partitioned indexes
  • ora-06538 : statement violates string RESTRICT_REFERENCES pragma
  • ora-02145 : missing STORAGE option
  • ora-10660 : Segment is a shared lob segment
  • ora-30680 : debugger connection handshake failed
  • ora-32052 : failed to start mapping service
  • ora-33448 : (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
  • ora-00151 : invalid transaction ID
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-32141 : get method does not match the type of the parameter
  • ora-38439 : invalid operation "string"
  • ora-29335 : tablespace 'string' is not read only
  • ora-02443 : Cannot drop constraint - nonexistent constraint
  • ora-32631 : illegal use of objects in MODEL
  • ora-24373 : invalid length specified for statement
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • 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.