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 : 18-08-2017

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

  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-00306 : limit of string instances in this database
  • ora-10614 : Operation not allowed on this segment
  • ora-19618 : cannot name files after restoreValidate has been called
  • ora-13211 : failed to tessellate the window object
  • ora-02850 : File is closed
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-24021 : queue table definition not imported for string.string
  • ora-01764 : new update value of join is not guaranteed to be unique
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-02724 : osnpbr: cannot send break message to orapop
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-06772 : TLI Driver: error sending command
  • ora-01866 : the datetime class is invalid
  • ora-01237 : cannot extend datafile string
  • ora-02759 : Not enough request descriptors available
  • ora-00399 : corrupt change description in redo log
  • ora-00285 : TIME not given as a string constant
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-36884 : (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
  • ora-19587 : error occurred reading string bytes at block number string
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-39058 : current object skipped: string of type string
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • 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.