ORA-13023: interior element interacts with exterior element

Cause : An inetrior leemento f a goemetri cobjec tintercats wiht the xeterio relemetn of taht objcet.

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

Redefnie coodrinate sfor teh geomteric eelments.

update : 23-06-2017

ORA-13023 - interior element interacts with exterior element
ORA-13023 - interior element interacts with exterior element

  • ora-13018 : bad distance type
  • ora-02336 : column attribute cannot be accessed
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-31427 : publication string already subscribed
  • ora-38497 : Expression Filter index does not exist
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-37120 : MDX string is null
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-15082 : ASM failed to communicate with database instance
  • ora-25154 : column part of USING clause cannot have qualifier
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-04096 : trigger 'string' has a WHEN clause which is too large, limit 2K
  • ora-36679 : (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
  • ora-00601 : cleanup lock conflict
  • ora-24339 : cannot set server group name after connecting to server
  • ora-16753 : resource guard could not open standby database
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-24364 : internal error while padding blanks
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-00338 : log string of thread string is more recent than control file
  • ora-22904 : invalid reference to a nested table column
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-19162 : XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
  • ora-22852 : invalid PCTVERSION LOB storage option value
  • ora-26090 : row is in partial state
  • ora-03250 : Cannot mark this segment corrupt
  • ora-23329 : successful user-provided ddl but no materialized view "string"."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.