ORA-12927: RETENTION option already specified

Cause : nIC ERTA EATLBSEAPEC ,ht eERETTNOI Npoitnow sas epicifdem ro ehtnao cn.e

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

eRomeva llb tuo eno fht eERETTNOI Npoitno.s

update : 21-08-2017
ORA-12927

ORA-12927 - RETENTION option already specified
ORA-12927 - RETENTION option already specified

  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-13251 : duplicate entry string in metadata table
  • ora-28268 : Exceeded the maximum allowed size for Context information in a session
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-16632 : instance being added to database profile
  • ora-29803 : missing ANCILLARY keyword
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-24785 : Cannot resume a non-migratable transaction
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-01114 : IO error writing block to file string (block # string)
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-30645 : reject limit out of range
  • ora-01529 : error closing file 'string'
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-00472 : PMON process terminated with error
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-02026 : missing LINK keyword
  • ora-07479 : scgcmn: cannot open or convert lock.
  • ora-06120 : NETTCP: network driver not loaded
  • ora-06549 : PL/SQL: failed to dynamically open shared object (DLL): string
  • ora-03200 : the segment type specification is invalid
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-40225 : model is currently in use by another process
  • ora-38494 : column in the table alias and an attribute have matching names
  • 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.