Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> How to drop a nested table?
After creating a table DICTIONARY having a nested table STORED_TRANSLATIONS:
> create table DICTIONARY of ENTRY
> nested table TRANSLATIONS store as STORED_TRANSLATIONS;
...i cannot drop this nested one. I have full admin priviliges, but my Oracle8i 8.1.6 still says:
> drop table STORED_TRANSLATIONS;
> *
> ERROR in line 1:
> ORA-22914: DROP of nested tables not supported
Dropping parent table DICTIONARY and dropping type ENTRY (w/ FORCE) does not help.
Any ideas how to solve it? Thanks...
-- @_/ Michal "Bogien/Bogna" Prinke \/\ _ | \ / oo email: bogien_at_conecto.pl, tel: 830-17-21, era gsm: 606 48-75-34 oo g-g: 160130, www: http://www.math.put.poznan.pl/~bogienReceived on Fri Jun 01 2001 - 06:12:36 CDT