Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: re-structure tablespace
John Wood wrote:
> Hi there...
>
> I am using Oracle 9.2 on Window 2000 platform. When I first build a
> database, I created a tablespace of 60G. It consisted of two 30G data
> filest.
>
> And now I found that I only need 30G for the tablespace. I would like to
> re-size the tablespace and at the same time, use smaller file size, say 4G.
> What would be the easiest way to do, other than export and re-import the
> whole tablespace ?
>
> Can I export with transport_tablespace option; drop the tablespace, then
> import with the transport_tablespace option ? Can I specify filesize=4G in
> transportable tablespace export ?
>
> Thanks in advance.
>
> JW
>
>
How is looking at the manual?!?
SQL*Plus reference, for instance, has a beautiful little
snippet on the RESIZE option of the ALTER DATABASE
command, DATAFILE subsection.
-- Regards, Frank van BortelReceived on Fri Apr 15 2005 - 06:35:03 CDT