Update from object types with type or table dependents 
Author Message
 Update from object types with type or table dependents
I'm new in Oracle 9.i and have following problem:
If I want to insert an new object type in an already existed type,
which contains type or table dependents, I become these
Error Message:
      VBO-1509: Data source could not be updated. Please
      disconnect and try again. ORA-02303: cannot drop or
      replace a type with type or table dependents

If you have some experiences with this problem or you know the solution,
please answer me. I would be very thankful for any help!

Fri, 18 Feb 2005 14:56:52 GMT
 [ 1 post ] 

 Relevant Pages 

1. Update from object types with type or table dependents

2. Help: Oracle8, object type, table type and functions

3. Dependent objects script is empty although many dependent objects exist

4. Updating an object in a typed table

5. NewEra performance difference between base types and object types

6. Type, sub-type, and sub-sub-type database design

7. Table type with user defined data type.

8. Data Type transparent to the type of the table field

9. How?: SHOW USER TYPE tables, views, sp's and HIDE System Types in ENTERPRISE MANAGER

10. Indexing a Dynaset type Recordset, or Requerying a Table type Recordset

11. dynaset-type recordset and table-type recordset

12. convert CHAR type to TEXT type (BLOB) and insert in table

Powered by phpBB® Forum Software