Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Shrink Tablespace
The following statement attempts to change the size of datafile
'DISK1:DB1.DAT':
ALTER DATABASE
DATAFILE 'disk1:db1.dat' RESIZE 10 M;
exortica_at_bigfoot.com (Chang Houw) wrote in <je6w5.7613$K6.47626_at_news>:
>How do i shrink a tablespace ? it seems too large for a little data ? and
>how i partitioned existing data from a table ?
>
>
Received on Thu Sep 14 2000 - 02:00:20 CDT