ORA-28105: cannot create security relevant column policy in an object view

Cause : Security relevant column argument is not null in policy creation for an object view

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

none

update : 19-08-2017
ORA-28105

ORA-28105 - cannot create security relevant column policy in an object view
ORA-28105 - cannot create security relevant column policy in an object view

  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-39036 : invalid metadata filter name string
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-31194 : Resource string is already deleted
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-03254 : unable to execute the sql in read only database
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-16629 : database reports a different protection level from the protection mode
  • ora-24405 : error occured while trying to create connections in the pool
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-14276 : EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
  • ora-29367 : object string does not exist
  • ora-33454 : (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
  • ora-32639 : Aggregate functions on reference MODELs are not allowed
  • ora-39070 : Unable to open the log file.
  • ora-08100 : index is not valid - see trace file for diagnostics
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-21300 : objects option not installed
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-15064 : communication failure with ASM instance
  • ora-23323 : parameter length exceeds deferred RPC limits
  • ora-32590 : log group specification not allowed here
  • ora-01496 : specified chain row table form incorrect
  • ora-09809 : Unable to get user's group ID from connection
  • ora-24017 : cannot enable enqueue on QUEUE, string is an exception queue
  • ora-07599 : spwat: $SCHDWK failure
  • ora-00306 : limit of string instances in this database
  • 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.