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

If you use winzip or equivalent on all of the datafiles they generally pack down pretty well, typically 250-500 mb total. You can also zip individual files and put on different CDs. Make sure the OracleService is shutdown before doing any of this.

--Peter

Jon Waterhouse wrote:
>
> 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 Mon Aug 05 2002 - 10:03:09 CDT