A way to get the system tablespace into smaller files?

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 25 Jul 2002 04:34:08 -0700
Message-ID: <39206c8b.0207250334.17019534@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 - 06:34:08 CDT