Re: A way to get the system tablespace into smaller files?

If you are lucky you can resize the file to a smaller size:

alter database datafile '<path to file>' resize 500m;

If the High Water Mark is low enough you will be successful

regards,
Peter

"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> schreef in bericht news:39206c8b.0207250334.17019534_at_posting.google.com...
> Hi all,
>
> I'm running 9i on NT and want to be able to do backups on CD-RW. I
> have been careful to add files to the USERS tablespace that are less
> than the size of a
> disk, but the SYSTEM tablespace started off in a 750MB file, of which
> only 300 is currently used. I thought maybe I could Reorganize and
> then make the file smaller, but after the whole painful process of
> setting up and configuring the oracle management server I finally got
> to the message "Oracle does not support the reorganization of the
> system tablespace". Well, I suppose I asked for it, it's probably
> written in the manual somewhere <g>.
> In the short run I'll probably ZIP the file first, but is there a
> long-run solution that's not too painful?
>
> Thanks,
>
> Jon
Received on Thu Jul 25 2002 - 07:06:57 CDT