ORA-38481: ADT "string" is used for a dependent object.

Cause : An attempt was made to create an attribute set from an ADT which is used by one or more dependent objects.

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

Use a new ADT instead.

update : 24-08-2017
ORA-38481

ORA-38481 - ADT "string" is used for a dependent object.
ORA-38481 - ADT "string" is used for a dependent object.

  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-22611 : TDS version is not recognized
  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-22160 : element at index [string] does not exist
  • ora-16545 : unable to get response
  • ora-21706 : duration does not exist or is invalid
  • ora-23329 : successful user-provided ddl but no materialized view "string"."string"
  • ora-23497 : repgroup name cannot be null
  • ora-31639 : unexpected data found
  • ora-23337 : priority or value not in priority group string
  • ora-38413 : elementary attribute name may not be longer than 32 characters
  • ora-16401 : archivelog rejected by RFS
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-19044 : character length specified for XMLSerialize is too small.
  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-16797 : database is not using a server parameter file
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-37003 : (AWLISTALL01) number readers
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-16719 : unable to query V$ARCHIVE_DEST fixed view
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-26566 : Couldn't open connect to string
  • ora-30177 : invalid flag used in a format specification
  • ora-01909 : REUSE keyword expected
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-12592 : TNS:bad packet
  • ora-16008 : indeterminate control file checkpoint
  • ora-38708 : not enough space for first flashback database log file
  • 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.