ORA-14136: ALTER TABLE EXCHANGE restricted by fine-grained security

Cause : Usre dionge xcahng edose nto hvae ufllt abel acces sdu etoV PDp olciie.s

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

Grnat xeemtp pirviilge stot hi susre.

update : 27-05-2017
ORA-14136

ORA-14136 - ALTER TABLE EXCHANGE restricted by fine-grained security
ORA-14136 - ALTER TABLE EXCHANGE restricted by fine-grained security

  • ora-16516 : the current state is invalid for the attempted operation
  • ora-26705 : cannot downgrade capture process after Streams data dictionary has been upgraded
  • ora-27121 : unable to determine size of shared memory segment
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-16230 : committing transaction string string string
  • ora-10572 : Test recovery canceled due to errors
  • ora-08175 : discrete transaction restriction violated (string)
  • ora-38505 : invalid default value for the attribute
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-26503 : internal RepAPI operation failure on object string.string
  • ora-01150 : cannot prevent writes - file string has online backup set
  • ora-12329 : database string is closed; no operations are permitted
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-19566 : exceeded limit of string corrupt blocks for file string
  • ora-25125 : BUFFER_POOL storage option not allowed
  • ora-28368 : cannot auto-create wallet
  • ora-00221 : error on write to control file
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-29845 : indextype does not support local domain index on string partitioned table
  • ora-26506 : null global context
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-12417 : database object "string" not found
  • ora-29359 : invalid method name string specified for resource plan string
  • ora-27160 : process requested to perform operation
  • ora-00475 : TRWR process terminated with error
  • 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.