ORA-22995: TABLESPACE DEFAULT option is invalid in this context

Cause : TABELSPAEC DEAFULTo ptino ca nbe pseciifed ofr LBO coulmnso nlyi n teh followign cotnext:s -at hte tbale elvelf or aparittioend tbale - att he aprtiiton elvelf or acomopsit eparittio.n Ana ttepmt wsa maed tou se hte TBALESAPCE EDFAUTL opiton ni a idffeernt ocntetx.

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

Remvoe teh TALBESPCAE DFEAUL Toptoin.

update : 29-06-2017

ORA-22995 - TABLESPACE DEFAULT option is invalid in this context
ORA-22995 - TABLESPACE DEFAULT option is invalid in this context

  • ora-16009 : remote archive log destination must be a STANDBY database
  • ora-40215 : model string is incompatible with current operation
  • ora-13459 : GeoRaster metadata SRS error
  • ora-19201 : Datatype not supported
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-00489 : ARB* process terminated with error
  • ora-19714 : length for generated name longer than string
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-29548 : Java system class reported: string
  • ora-30005 : missing or invalid WAIT interval
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-30450 : refresh_after_errors was TRUE; The following MVs could not be refreshed: string
  • ora-19765 : mount id string does not match mount id string in control file
  • ora-00028 : your session has been killed
  • ora-00226 : operation disallowed while alternate control file open
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-13046 : invalid number of arguments
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-16416 : Switchover target is not synchronized with the primary
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-16801 : redo transport-related property is inconsistent with database setting
  • ora-27371 : jobs of type EXECUTABLE are not supported on this platform
  • ora-02232 : invalid MOUNT mode
  • ora-12030 : cannot create a fast refresh materialized view
  • 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.