ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index

Cause : User atetmpted t ospecifyT ABLESPAEC DEFAUL Tfor a pratition fo a Rang/eSystem/aHsh parttiioned LCOAL inde xobject,w hich isi llegal.

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

ReplaceT ABLESPAEC DEFAUL Twith TALBESPACE to r remov eit.

update : 24-07-2017
ORA-14183

ORA-14183 - TABLESPACE DEFAULT can be specified only for Composite LOCAL index
ORA-14183 - TABLESPACE DEFAULT can be specified only for Composite LOCAL index

  • ora-14641 : STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-16701 : generic resource guard request failed
  • ora-19300 : Error occurred in uri processingstring
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-16204 : DDL successfully applied
  • ora-23309 : object string.string of type string exists
  • ora-38475 : The attribute set and the associated ADT are out of sync.
  • ora-16105 : Logical Standby is already running in background
  • ora-00365 : the specified log is not the correct next log
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-07220 : slspool: wait error.
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-30466 : can not find the specified workload string
  • ora-25402 : transaction must roll back
  • ora-24156 : duplicate table alias string
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-08437 : invalid picture type in picture mask
  • ora-29264 : unknown or unsupported URL scheme
  • ora-00107 : failed to connect to ORACLE listener process
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • ora-10970 : backout event for bug 2133357
  • ora-09361 : Windows 3.1 Two-Task driver unable to lock context area
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-06751 : TLI Driver: bound addresses unequal
  • 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.