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

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot Drop Table

Re: Cannot Drop Table

From: GC <assistant_madman_at_hotmail.com>
Date: 2000/04/21
Message-ID: <3900CB88.BDF38E26@hotmail.com>#1/1

oppurtunity_at_my-deja.com wrote:
>
> Hi
>
> Background
> I'm moving tables from Dict Managed tablesapces to locally managed
> tablespaces. I the process I'm doing the following
> A. Alter table X Rename to T_X;
> B. Create X Tablespace LM_Y as select * from T_X;
> C. Alter table X add constraint primary key ...
> D. Drop Table T_X;
>
> Problem
> A,B,C Work fine
> D Fails on following error
> ORA-00600: internal error code, arguments: [kntgslm], [0], [], [], [],
> [], [], []

If you have an oracle support agreement, contact support. Hopefully a trace file was created that you can send to oracle support for analysis.

Cheers,
GC Received on Fri Apr 21 2000 - 00:00:00 CDT

Original text of this message

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