|
|
|
|
|
|
| Re: delete from 'dba_objects' table [message #155641 is a reply to message #155590] |
Tue, 17 January 2006 14:52   |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
As others have mentioned, you are barking up the wrong tree.
To literally answer your question though, DBA_OBJECTS is a view, not a table, based on sys.obj$ , sys.user$ and sys.link$
and that's why you cannot delete from it.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: delete from 'dba_objects' table [message #155919 is a reply to message #155913] |
Thu, 19 January 2006 12:07 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
As stated before ,
You need to post what you done and your output.
What you ask, is not possible. When you drop the object, all indexes and constraint that are defined on the object are DROPPED
and no constraints are reported in user_objects.
scott@9i > select object_type,object_name from user_objects;
OBJECT_TYPE OBJECT_NAME
------------------ --------------------
TABLE DEPT
TABLE EMP
TABLE PLAN_TABLE
INDEX SYS_C001698
INDEX SYS_C001701
DATABASE LINK MYDB
6 rows selected.
scott@9i > select table_name,constraint_name from user_constraints;
TABLE_NAME CONSTRAINT_NAME
------------------------------ ------------------------------
DEPT SYS_C001698
EMP SYS_C001699
EMP SYS_C001700
EMP SYS_C001701
EMP SYS_C001702
scott@9i > drop table EMP cascade constraints;
Table dropped.
scott@9i > select object_type,object_name from user_objects;
OBJECT_TYPE OBJECT_NAME
------------------ --------------------
TABLE DEPT
TABLE PLAN_TABLE
INDEX SYS_C001698
DATABASE LINK MYDB
scott@9i > select table_name,constraint_name from user_constraints;
TABLE_NAME CONSTRAINT_NAME
------------------------------ ------------------------------
DEPT SYS_C001698
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
it is Oracle's responsibility and Oracle does it better.