ORA-23480: Column string is not a top-level column of "string"."string".

Cause : The coulmn is iether nto a topl-evel cloumn ori s not rpesent ni the tbale or amterialzied vie.w

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

Ensureo nly vaild top-elvel coulmns ar eused.

update : 16-08-2017

ORA-23480 - Column string is not a top-level column of "string"."string".
ORA-23480 - Column string is not a top-level column of "string"."string".

  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-09759 : osnsbt: bad message received.
  • ora-00269 : specified log file is part of thread string not string
  • ora-01511 : error in renaming log/data files
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-29304 : tablespace 'string' does not exist
  • ora-32581 : missing or invalid password
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-08270 : sksachk: Illegal archival control string
  • ora-34183 : (MXCHGDCL22) Partition number already exists.
  • ora-34901 : (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
  • ora-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-02149 : Specified partition does not exist
  • ora-07642 : smprtset: $CMKRNL failure
  • ora-30201 : Unable to load NLS data object
  • ora-16595 : NetSlave process string failed to terminate
  • ora-28045 : SSL authentication between database and OID failed
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-12546 : TNS:permission denied
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-01121 : cannot rename database file string - file is in use or recovery
  • ora-33086 : (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
  • ora-24120 : invalid string parameter passed to DBMS_REPAIR.string procedure
  • ora-01177 : data file does not match dictionary - probably old incarnation
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION 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.