ORA-28116: insufficient privileges to do direct path access

Cause : Users with insufficient privileges attempting to do direct path access of tables with fine grain access control policies.

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

Ask the database administrator to do the operation. Note that users can work with security administrator to temporarily drop/disable the policies at time of export, import, or load, but this has security implication, and thus access of the database must be controlled carefully.

update : 25-04-2017
ORA-28116

ORA-28116 - insufficient privileges to do direct path access
ORA-28116 - insufficient privileges to do direct path access

  • ora-23487 : object groups "string"."string" and "string"."string" do not have the same connection qualifier
  • ora-12027 : duplicate filter column
  • ora-28547 : connection to server failed, probable Oracle Net admin error
  • ora-06122 : NETTCP: setup failure
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-13065 : cannot delete a child layer with a parent layer
  • ora-07636 : smsdbp: $MGBLSC failure
  • ora-02750 : osnfsmmap: cannot open shared memory file ?/dbs/ftt_.dbf
  • ora-13158 : Oracle object string does not exist
  • ora-26018 : Column string in table string does not exist
  • ora-04054 : database link string does not exist
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-22131 : hexadecimal string length is zero
  • ora-29366 : invalid CONSUMER_GROUP argument specified
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-04093 : references to columns of type LONG are not allowed in triggers
  • ora-27154 : post/wait create failed
  • ora-07408 : slbtpd: overflow while converting to packed decimal.
  • ora-27513 : parameter string contains invalid value string
  • ora-27416 : BYDAY= clause in repeat interval or calendar contains an invalid weekday
  • ora-00603 : ORACLE server session terminated by fatal error
  • ora-40201 : invalid input parameter string
  • ora-25405 : transaction status unknown
  • ora-13422 : invalid model coordinate parameter
  • ora-00825 : cannot set db_block_buffers if sga_target set
  • ora-39082 : Object type string created with compilation warnings
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-25353 : branch marked for deletion
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • 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.