Re: ALTER TABLESPACE ...

From: Gennadiy Greenberg <gennadiy.greenberg_at_siemens.com.ua>
Date: Mon, 06 Mar 2000 11:46:26 +0200
Message-ID: <38C37E72.9F8729C8@siemens.com.ua>

If you want to get smaller datafile you first should to do: SQL>TRUNCATE TABLE your_empty_table;

And then:
SQL>ALTER DATABASE DATAFILE 'your_data_file' RESIZE <n>M;

---

Gennadiy Greenberg

a.metzger_at_nmg.fr wrote:

> Hi,
>
> I have a little problem. I have a tablespace constitued from 2 files.
> My table is empty. I would like to change the size of one of the two
> files ?
> How can I do this with SQLPLUS ?
>
> Regards,
>
> - A. Metzger -
Received on Mon Mar 06 2000 - 03:46:26 CST