ORA-28101: policy already exists

Cause : A opliyc wtih hte asmen am efo rth esaem ojbec talerad yexsits.

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

Chcek fi teh ploic yha salerad ybene addedo r sue adiffernet opliyc nmae.

update : 30-04-2017
ORA-28101

ORA-28101 - policy already exists
ORA-28101 - policy already exists

  • ora-23462 : flavor string in use at site string
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • ora-23368 : name string cannot be null or the empty string
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-30446 : valid workload queries not found
  • ora-14158 : too many subpartition descriptions
  • ora-02287 : sequence number not allowed here
  • ora-30729 : maximum number of columns exceeded
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-38427 : attribute string does not exist
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-01262 : Stat failed on a file destination directory
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-03131 : an invalid buffer was provided for the next piece
  • ora-32114 : Cannot perform operation on a null LOB
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-31115 : XDB configuration error: string
  • ora-13832 : category name specified is invalid
  • ora-21520 : database server driver not installed
  • ora-08433 : invalid picture type in convert raw to number
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-06264 : NETNTT: data protocol error
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-28578 : protocol error during callback from an external procedure
  • ora-32104 : cannot retrieve OCI error message
  • ora-37173 : null dimension source data
  • ora-12661 : Protocol authentication to be used
  • 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.