Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to drop a nested table?

How to drop a nested table?

From: Bogien <bogien_at_conecto.pl>
Date: Fri, 01 Jun 2001 13:12:36 +0200
Message-ID: <3B1778A4.319658F3@conecto.pl>

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/~bogien
Received on Fri Jun 01 2001 - 06:12:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US