ORA-22928: invalid privilege on directories

Cause : An attempt was made to grant or revoke an invalid privilege on a directory.

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

Only CREATE, DELETE, READ and WRITE privileges can be granted or revoked on directories. Do not grant or revoke other privileges.

update : 30-04-2017

ORA-22928 - invalid privilege on directories
ORA-22928 - invalid privilege on directories

  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-13278 : failure to convert SRID to native format
  • ora-02712 : osnpop: malloc failed
  • ora-12665 : NLS string open failed
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-01135 : file string accessed for DML/query is offline
  • ora-34363 : (MXDSS13) number other user writing
  • ora-07826 : sspscm: SYS$GETDVIW failure
  • ora-19400 : System type conflict with object SYS.string
  • ora-30732 : table contains no user-visible columns
  • ora-12951 : Attempt to change default permanent tablespace to temporary
  • ora-30157 : An invalid argument was given to operating system call
  • ora-36671 : (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
  • ora-27156 : request for process information failed
  • ora-12453 : label string already exists
  • ora-09280 : sllfcf: error closing file
  • ora-02405 : invalid sql plan object provided
  • ora-28046 : Password change for SYS disallowed
  • ora-01692 : unable to extend lob segment string.string partition string by string in tablespace string
  • ora-12159 : TNS:trace file not writeable
  • ora-08196 : Flashback Table operation is not allowed on AQ tables
  • ora-32125 : Attribute type is not appropriate
  • ora-23439 : refresh group template already exists
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-39039 : Schema expression "string" contains no valid schemas.
  • ora-16757 : resource guard could not get property
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-02368 : file string is not valid for this load operation
  • 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.