ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

Cause : Attemp tto speicfy LOGIGNG fora AlterT able Add Overfolw.

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

don't od that

update : 28-06-2017

ORA-28663 - Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
ORA-28663 - Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

  • ora-31696 : unable to export/import string using client specified string method
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-01197 : thread string only contains one log
  • ora-13826 : empty SQL profile not allowed for create or update SQL profile
  • ora-01287 : file string is from a different database incarnation
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-16411 : ONDEMAND archival requires active managed recovery operation
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-32738 : Hang analysis aborted due to failed memory copy
  • ora-22280 : no more buffers available for operation
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-24328 : illegal attribute value
  • ora-27045 : unable to close the file
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-13227 : SDO_LEVEL values for the two index tables do not match
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-16045 : circular archive log destination dependency chain
  • ora-31415 : change set string does not exist
  • ora-01080 : error in shutting down ORACLE
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-33072 : (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
  • ora-19206 : Invalid value for query or REF CURSOR parameter
  • ora-38434 : could not evaluate expression "string"
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • 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.