ORA-28163: GRANT already specified

Cause : The GRANT clause was specified twice.

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

Use only one GRANT clause.

update : 19-08-2017

ORA-28163 - GRANT already specified
ORA-28163 - GRANT already specified

  • ora-31658 : specifying a schema name requires a table name
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-36178 : (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-22996 : NEXT extent size is smaller than LOB chunksize
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-29927 : error in executing the ODCIStatsCollect / ODCIStatsDelete routine
  • ora-32156 : Cannot perform operation on stream
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-37004 : (AWLISTALL02) number reader
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-02272 : constrained column cannot be of LONG datatype
  • ora-07587 : spdcr: $CREPRC failure
  • ora-28007 : the password cannot be reused
  • ora-26732 : invalid file group string privilege
  • ora-30460 : 'string.string' cannot be refreshed because it is marked UNUSABLE
  • ora-33443 : (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
  • ora-08460 : invalid environment clause in environment parameter
  • ora-24033 : no recipients for message
  • ora-14000 : only one LOCAL clause may be specified
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-19223 : XP0003 - syntax error in XQuery expression
  • ora-12402 : invalid format string: string
  • ora-29389 : too many errors during validation
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-02707 : osnacx: cannot allocate context area
  • ora-02838 : Unable to arm signal handler for the alarm signal
  • ora-29525 : referenced name is too long: '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.