| |
http://classappsdba.blogspot.com/2013/05/some-common-ora-error-codes.html
ORA-00439: feature not enabled: Table compression. ORA-01031: insufficient privileges. ORA-01722: invalid number. ORA-02303: cannot drop or replace a type with type or table dependents. ORA-04044: procedure ...
|
http://oraclecomandos.blogspot.com/2013/05/ora-error-listado-errores-oracle-ora_7590.html
ORA-02303: cannot drop or replace a type with type or table dependents. Cause: An attempt was made to drop or replace a type that has dependents. There could be a substitutable column of a supertype of the type being ...
|
http://oracsd.blogspot.com/2013/04/upgrade-downgrade-oracle-version.html
SQL> !grep -i ora- catproc.log | egrep -v -- "conflicts with another|ORA-02303|Rem|--|ORA-00955|ORA-00942|ORA-01434|ORA-04043|ORA-01418". DOC> The following PL/SQL block will cause an ORA-20000 error and ...
|
http://listadeerrosoracle.blogspot.com/2013/04/ora-02303.html
ORA-02303: cannot drop or replace a type with type or table dependents. Cause: An attempt was made to drop or replace a type that has dependents. There could be a substitutable column of a supertype of the type being ...
|
http://oraclequirks.blogspot.com/2008/06/ora-02303-cannot-drop-or-replace-type.html
ORA-02303: cannot drop or replace a type with type or table dependents. Let's build a simple test case to see what happens and how we can circumvent the problem. By the way, this is also a good opportunity to see the ...
|
http://ora-exp.blogspot.com/2011/11/solution-of-ora-02303-cannot-drop-or.html
Solution of "ORA-02303: cannot drop or replace a type with type or table dependents" and "ORA-14452: attempt to create, alter or drop an index on temporary table already in use". Connected to Oracle Database 11g ...
|
http://mhizbullah.blogspot.com/2012/05/ora-02303-cannot-drop-or-replace-type.html
Try to modify a type and CREATE OR REPLACE TYPE gives the error: ORA-02303: cannot drop or replace a type with type or table dependents. If you need to modify a type you need to drop all the dependent (child) objects ...
|
http://hi.baidu.com/sqlpub/item/a75c7897c4825717934f417d
the type since this will result in an ORA-02303 error as follows: ORA-02303: cannot drop or replace a type with type or table dependents. We must first drop all tables containing the target TYPE, then the TYPE itself as follows: ...
|
http://www.knoworacle.com/2013/05/forced-replacement-of-types-in-11g.html
SQL> create or replace type ty_trans 2 as object 3 ( 4 trans_id number (4), 5 trans_amt number 6 ) 7 / create or replace type ty_trans * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents ...
|
http://urisnotaword.wordpress.com/2010/06/23/ora-02303-cannot-drop-or-replace-a-type-with-type-or-table-dependents/
ORA-02303: cannot drop or replace a type with type or table dependents. Which means that a table is still using the type: SQL> desc mytable;. Name Null? Type mycol1 varchar2(50) mycol2 mytype. So, drop the column from ...
|
http://www.scripterworld.com/2009/11/ora-02303-cannot-drop-or-replace-type.html
Scripter World: ORA-02303: cannot drop or replace a type with type or table dependents.
|
http://e-dba.blogspot.com/2012/06/ora-02303-cannot-drop-or-replace-type.html
ORA-02303: cannot drop or replace a type with type or table dependents. Cause: An attempt was made to drop or replace a type that has type or table dependents. Action: For DROP TYPE, drop all type(s) and table(s) depending on the type ...
|
http://midba.blogspot.com/2012/06/deinstall-9205-intermedia.html
ORA-02303: cannot drop or replace a type with type or table dependents drop type ORDSYS.ORDIMGB * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents drop type ORDSYS.
|
http://burakyurdakul.blogspot.com/2010/04/how-to-drop-type-with-dependents-ora.html
If you try to drop or create replace a type with dependent tables or procedures you ll get the error ora-02303. Work around is use option force : drop type type_name force; This will drop type so you can create the type again.
|
https://www.tibcommunity.com/message/38788
ORA-02303: cannot drop or replace a type with type or table dependents. Type created. create or replace type T_TIME_EVENT UNDER T_EVENT(currentTime NUMBER, nextTime NUMBER, closure varchar2(4000), ttl ...
|
http://laurentschneider.blogspot.com/2006/07/cpu-july-2006.html
ORA-02303: cannot drop or replace a type with type or table dependents. 21/7/06 ... ORA-02303 is an allowed error to occur. Possible ... ORA-02303 appeared for me too for ~10 times, but everything works OK and I'm happy.
|
http://yvrk1973.blogspot.com/2012/08/112033-patch-set-update-for-oracle-11g.html
13035360 - TASK FORCE: UNEXPECTED ORA-02303: RAISED FROM PATCH EDITION OF THE INSTANCE 13370330 - ORA-600[QKEISEXPRREFERENCED1] FROM QUERY W/ VIRTUAL COLUMN WITH A CONSTANT ...
|
http://r-ozturk.blogspot.com/2012/01/ora-02303-cannot-drop-or-replace-type.html
ORA-02303: cannot drop or replace a type with type or table dependents. You can't replace type sources if it has dependent object(s). for example another type is produced from this type. If you want to replace new source you ...
|
http://kyforest.blog.163.com/blog/static/111772842011511114526142/
ORA-02303: 无法使用类型或表的相关性来删除或取代一个类型,kyforest的网易博客,在委屈中平衡，妥协中前行，虚怀中充实，放弃中收获，谦卑中完善！,在委屈中平衡,妥协中前行,虚怀中充实,放弃中收获,谦卑中完善！
|
http://www.unlimitedtricks.com/getting-an-error-ora-06502-plsql-numeric-or-value-error-character-string-buffer-too-small/
ORA-02303: cannot drop or replace a type with type or table dependents. So this means you're using SQL Types, with inheritance. Sorting this out is a bit of a problem. There is some syntax which we can use with the ALTER TYPE command ...
|