You can Resize datafiles.
ALTER DATABASE DATAFILE 'F:\ORACLE\ORADATA\RD2\TEMP01.DBF' RESIZE 15360K
/
ALTER DATABASE DATAFILE 'F:\ORACLE\ORADATA\RD2\TEMP01.DBF' AUTOEXTEND ON
NEXT 64K MAXSIZE UNLIMITED
/
"Chris" <chris.Ilmberger_at_dataflux.com> wrote in message
news:b830170e.0110310812.48a6de7b_at_posting.google.com...
> I have an Oracle Database that has grown over 4 gig. I deleted many
> tables and want to know how I can shrink the database using SQL Plus.
> Does anyone know how to do this?
Received on Thu Nov 01 2001 - 12:12:34 CST
