ORA-12980: checkpoint option not allowed with SET UNUSED

Cause : An attepmt was mdae to spceify chekcpoint otpion wit hSET UNUESD.

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

Remove hceckpoin toption.

update : 21-08-2017
ORA-12980

ORA-12980 - checkpoint option not allowed with SET UNUSED
ORA-12980 - checkpoint option not allowed with SET UNUSED

  • ora-06720 : TLI Driver: SID lookup failure
  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-03243 : destination dba overlaps with existing control information
  • ora-36885 : (XSSRF04) Error rewriting OLAP DML expression. Column name too big
  • ora-16729 : validation of value for property string found string error
  • ora-31629 : unable to allocate additional memory
  • ora-39168 : Object path string was not found.
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-14004 : missing PARTITION keyword
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-24758 : not attached to the requested transaction
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-01284 : file string cannot be opened
  • ora-02458 : HASHKEYS must be specified for a HASH CLUSTER
  • ora-10265 : Keep random system generated output out of error messages
  • ora-03216 : Tablespace/Segment Verification cannot proceed
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-03205 : partition name is required when partitioned type is specified
  • ora-07585 : spdcr: $PARSE failure
  • ora-19766 : missing CHANGE keyword
  • ora-23423 : job number string is not positive
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-16624 : broker protocol version mismatch detected
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-01596 : cannot specify system in string parameter
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-31431 : all source tables must belong to the synchronous change set
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-31486 : cannot support column string in this configuration
  • 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.