| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: reduce DBF file size?
UofA wrote:
>
> Hi there,
>
> We have a problem with trying to resize a database file. We need to make
> Oracle 8i for NT 'shrink' it's system schema datafile. I have tried to use
> "ALTER TABLESPACE 'filename' 'SIZE', but Oracle seems to want to make a copy
> of the datfile as part of completing the command.
>
> Is there a way to make Oracle simply 'prune' an existing file - removing
> empty extents/blocks - without actually making a copy of the file in the
> process?
>
> Thanks in advance,
> Eric
>
> A bit more detail...
> An new application got it's default tablespace set as SYSTEM (this was a a
> mistake we discovered later). We ran the app's routines to populate the
> database and they worked fine. So we set the app to run overnight importing
> data into it's Oracle tables and went home.
>
> Next morning Oracle's SYSTEM table file had grown to fill the disk it was
> on - the disk is about 25 gigs. We don't have another 25 gig volume handy,
> so the ALTER TABLESPACE above is unworkable.
alter database datafile '...' size nnn
You can shrink to the point where there are no further blocks in that
file.
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 09 1999 - 03:53:30 CST
 |
 |