Re: recovering tablespace room

From: Jay Scheiner <jxs_at_wolpofflaw.com>
Date: Wed, 09 Feb 2000 00:07:07 GMT
Message-ID: <38a0af56.1875588735@news.erols.com>

Perhaps I was not clear enough. I have moved the tables to another tablespace (well, I'm working on it, and learning as I go). I dropped the tables in the SYSTEM tablespace, but the files on the disk drive are still huge. Can the files be compated/purged of data that is no longer logically there but perhaps still physically present?

On Tue, 08 Feb 2000 12:16:50 -0800, rockcogar <rock_cogarNOroSPAM_at_my-deja.com.invalid> wrote:

>I assume that you are referring to data that does not belong in
>the system tablespace, like that of another user ?
>
>If so, make sure "that user" has their default tablespace set
>for their own tablespace (use ALTER USER ..., to fix it). The
>(re)CREATE newtable as select * from oldtable' the table(s)
>{using different names} so they will go in the correct
>tablespace. DROP tables that are in the old tablespace. RENAME
>the tables.
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Feb 08 2000 - 18:07:07 CST