Update from object types with type or table dependents 
Author Message
 Update from object types with type or table dependents
Hello,
I'm new in Oracle 9.i and have following problem:
If I try to insert a new object type in an already existend type, which
contains type or table dependents, I become these Error Message:

    VBO-1509: Data source could not be updated. Please disconnected and
    try again. ORA-2303: 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 thankfull for any help.



Tue, 15 Feb 2005 22:49:32 GMT
 Update from object types with type or table dependents

Are you using Data Guard? Not sure what you meant this:

Quote:
> If I try to insert a new object type in an already existend type, which
> contains type or table dependents, I become these Error Message:

Better post your SQL so that people know exactly what you are doing.
The error message of ORA-02303 is self-explainatory. You can not drop
a type which has dependents, much like you can not drop a table which
has other tables referencing it via foreign keys.

SQL> create type typ1 as object (c1 varchar2(1));
  2  /

Type created.

SQL> create type typ2 as table of typ1;
  2  /

Type created.

SQL> drop type typ1;
drop type typ1
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents

SQL> drop type typ2;

Type dropped.

SQL> drop type typ1;

Type dropped.



Wed, 16 Feb 2005 05:55:24 GMT
 
 [ 2 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