Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Shrink Tablespace

Re: Shrink Tablespace

From: Doug Edmunds <dae_alt3_at_juno.com>
Date: 13 Sep 2000 23:00:20 PST
Message-ID: <8FAEE730Dedmundspacifiercom@199.2.117.165>

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

Original text of this message

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