Renaming tables and dropping indexes under Oracle 8.0.4.0.0

From: Evert J. Smit <e.smit_at_caiw.nl>
Date: Thu, 13 May 1999 09:39:09 +0200
Message-ID: <7hdvnc$l6$1@news.kabelfoon.nl>

Hi,

I want to create a view from a table. The problem is that i've to rename the table and give the view the name of that table. What happens with the constraints of that table after it's been renamed ? Does the constraints change automaticly or are they dropped and do I have to created them again with the new name of the table?

I'm using a tablespace for all the indexes, primary keys, etc. But this tablespace is growing and growing. Can I drop all the indexes and primary keys so that the tablespace increases and after that create the indexes and primary keys again ? Isn't this also better for the performance?

Thanks,
Evert Received on Thu May 13 1999 - 02:39:09 CDT