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 -> Cannot Drop Table

Cannot Drop Table

From: <oppurtunity_at_my-deja.com>
Date: 2000/04/21
Message-ID: <8dqfks$4i9$1@nnrp1.deja.com>#1/1

Hi

Background
I'm moving tables from Dict Managed tablesapces to locally managed tablespaces. I the process I'm doing the following

  1. Alter table X Rename to T_X;
  2. Create X Tablespace LM_Y as select * from T_X;
  3. Alter table X add constraint primary key ...
  4. Drop Table T_X;

Problem
A,B,C Work fine
D Fails on following error
ORA-00600: internal error code, arguments: [kntgslm], [0], [], [], [], [], [], []

ThanX
Sri Shivananda

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CDT

Original text of this message

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