Hi....
I dropped the containing table for a nested table, but the
nested table is still an object in the schema.
Also there are two system named indexes listed in the
view 'all_objects', shown below. These indexes are
NOT listed
in the view 'all_indexes'.
1* select * from all_objects where object_name
like 'SYS_C00237%'
Object Data Object Object
OWNER OBJECT_NAME SUBOBJECT_NAME Id Id Type
------- ----------- -------------- ------ ----------- ------
PLANNER SYS_C002373 ~... 26,172 26,172 INDEX
PLANNER SYS_C002374 ~... 26,173 26,173 INDEX
Time Stamp
OBJECT_NAME CREATED LAST_DDL_ Date-Time
----------- --------- --------- -------------------
SYS_C002373 23-DEC-01 23-DEC-01 2001-12-23:18:49:25
SYS_C002374 23-DEC-01 23-DEC-01 2001-12-23:18:49:25
Status
OBJECT_NAME - TEMPORARY GENERATED SECONDARY
----------- -------- --------- --------- ---------
SYS_C002373 VALID N Y N
SYS_C002374 VALID N Y N
The object_id suggests the indexes were created when the
containing table and nested table were created.
These three objects are all that are left in the schema, except
for the TYPEs used in the nested table.
When I try to drop the indexes, I get...
ORA-01418 specified index does not exist
Cause: An ALTER INDEX, DROP INDEX, or VALIDATE INDEX statement
specified the name of an index that does not exist. Only
existing indexes can be altered, dropped, or validated. Existing
indexes may be listed by querying the data dictionary.
Action: Specify the name of an existing index in the ALTER
INDEX, DROP INDEX, or VALIDATE INDEX statement.
When I try to drop the USER using CASCADE, I get...
ORA-00604 error occurred at recursive SQL level string
Cause: An error occurred while processing a recursive SQL
statement (a statement applying to internal dictionary tables).
Action: If the situation described in the next error on the
stack can be corrected, do so; otherwise contact Oracle Customer
Support.
Followed by the ORA-01418 error.
When I try to drop the nested table, I get the error message...
ORA-22914 DROP of nested tables not supported
Cause: An attempt was made to DROP a nested table.
Action: Nested tables cannot be explicitly dropped. nested
tables can only be dropped by dropping their containing parent
table.
The depedencies look O.K., except that the dropped containing
table isn't in it.
Since I can easily recreate this schema, how can I drop the
user? Or fix this in any way?
Help and thanks....