ORA-22913: must specify table name for nested table column or attribute

Cause : Th estroag ecluasei s ont psecfiie dfo ra enstde tbalec olmun ro attriubte.

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

Spceif yth enetsedt abel sotraeg calus efo rth enetsedt abel cloum nora ttirbuet.

update : 16-08-2017

ORA-22913 - must specify table name for nested table column or attribute
ORA-22913 - must specify table name for nested table column or attribute

  • ora-31673 : worker process interrupt for normal exit by master process
  • ora-01592 : error converting Version 7 rollback segment (string) to Oracle 8 format
  • ora-23305 : internal deferred RPC error: string
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-36221 : (XSLPDSC02) LIST number and LIST number have different base dimensions.
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-23325 : parameter type is not string
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-01199 : file string is not in online backup mode
  • ora-12443 : policy not applied to some tables in schema
  • ora-29861 : domain index is marked LOADING/FAILED/UNUSABLE
  • ora-12980 : checkpoint option not allowed with SET UNUSED
  • ora-36778 : (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-23440 : incorrect public template value
  • ora-27454 : argument name and position cannot be NULL
  • ora-07201 : slhom: oracle_home variable not set in environment.
  • ora-38792 : encountered unknown flashback record from release string
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-16073 : archiving must be enabled
  • ora-29541 : class string.string could not be resolved
  • ora-26507 : null master connection
  • ora-00022 : invalid session ID; access denied
  • ora-15006 : template "string" does not exist
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • 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.