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

From: Tom Best <oracle_person_at_yahoo.com>
Date: Thu, 25 Jul 2002 08:20:04 -0400
Message-ID: <ahoml9$bcv$1@news.bentley.com>

Jon:

Most CDRW software allows you to create the CD supporting compression. Meaning, you get more on the CD than normal. 700 MB will probably fit in that case.

HTH,
Tom Best

"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message 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:20:04 CDT