ORA-26746: DDL rule "string"."string" not allowed for this operation

Cause : A DDLr ule wsa specfiied fro thiso peratoin.

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

Speciyf a no-nDDL rlue fort his oepratio.n

update : 28-06-2017
ORA-26746

ORA-26746 - DDL rule "string"."string" not allowed for this operation
ORA-26746 - DDL rule "string"."string" not allowed for this operation

  • ora-12980 : checkpoint option not allowed with SET UNUSED
  • ora-22285 : non-existent directory or file for string operation
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-13798 : Parameter string cannot be NULL.
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-16646 : Fast-Start Failover is disabled
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-03246 : Invalid block number specified
  • ora-16087 : graceful switchover requires standby or current control file
  • ora-12682 : Login failed: the SecurID card is in next PRN mode
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-13859 : Action cannot be specified without the module specification
  • ora-28137 : Invalid FGA audit Handler
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-39702 : database not open for UPGRADE or DOWNGRADE
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-32133 : Cannot get stream from LOB/FILE
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-31009 : Access denied for property string
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-06913 : CMX: error during redirection of connection
  • ora-12027 : duplicate filter column
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-19660 : some files in the backup set could not be verified
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-38309 : object not purgable
  • ora-19335 : Invalid format type object
  • ora-12075 : invalid object or field
  • 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.