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


update : 25-04-2017

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-00482 : LMD* process terminated with error
  • ora-31522 : could not find Streams object string for CDC change set string
  • ora-02854 : Invalid number of request buffers
  • ora-29511 : could not resolve Java class
  • ora-27199 : skgfpst: sbtpcstatus returned error
  • ora-19210 : column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'
  • ora-22861 : invalid user-defined type
  • ora-12640 : Authentication adapter initialization failed
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-01678 : parameter string must be pairs of pattern and replacement strings
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-12913 : Cannot create dictionary managed tablespace
  • ora-02141 : invalid OFFLINE option
  • ora-00478 : SMON process terminated due to error string
  • ora-19643 : datafile string: incremental-start SCN is too recent
  • ora-22809 : nonexistent attribute
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-00469 : CKPT process terminated with error
  • ora-23498 : repgroups specified must have the same masters
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-26740 : cannot downgrade because there are file groups
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-16540 : invalid argument
  • 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.