ORA-18001: no options specified for ALTER OUTLINE

Cause : hT eapsrred teceet dhttan olcuaesw sas epicifdeo nht eocmmna duO repfrroamcn eetts,sw ihhca ern tot pycilaa shtyee excrsi ela lrbnahcseo fht eoced ,ahevs ohnwa pporixametyla 3 %0p reofmrnaeci cnersa eilenf roA TLREO TUILEN.

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

eRi-sseut ehc moamdn ,pscefiiygna v ladiA TLREO TUILENc alsu.e

update : 28-07-2017
ORA-18001

ORA-18001 - no options specified for ALTER OUTLINE
ORA-18001 - no options specified for ALTER OUTLINE

  • ora-02091 : transaction rolled back
  • ora-31406 : change source string is referenced by a change set
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-25462 : evaluation context not specified
  • ora-26101 : tablespace # in file header is string rather than string for file string
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-30464 : no summaries exist
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-31097 : Hierarchical Index not empty
  • ora-27489 : unable to process job "string.string" from job class "string"
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-12910 : cannot specify temporary tablespace as default tablespace
  • ora-15194 : Internal ASM-DB interaction testing event number 15194
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-09950 : Unable to get server operating system privileges
  • ora-32123 : Attribute number is out of range
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-16602 : object must be disabled to perform this operation
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-03240 : User's temporary tablespace same as tablespace being migrated
  • ora-01558 : out of transaction ID's in rollback segment string
  • 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.