Re: Merge System Datafile in Oracle v7.3

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 12 Sep 2003 01:57:49 -0700
Message-ID: <1a75df45.0309120057.4e685c70@posting.google.com>

"Yong Boon, Lim" <limyb_at_megasteel.com.my> wrote

> l've the following problems, my system datafiles are configurated as
> following,
> ------ ------------------------------------------------------------
> SYSTEM USER$DISK:[ORACLE7.DB_SMC]ORA_SYSTEM.DBS 62914560
> SYSTEM USER$DISK:[ORACLE7.DB_SMC]ORA_SYSTEM1.DBS 37154816
> SYSTEM USER$DISK:[ORACLE7.DB_SMC]ORA_SYSTEM2.DBS 32768
> SYSTEM USER$DISK:[ORACLE7.DB_SMC]ORA_SYSTEM3.DBS 5120000
>
> l would like to merge these file into one system datafiles, is there anyway
> l could do it?

Why do you think it is a problem? What tangible benefit is there to having a single file?

Yeah, I also think it "nice" to have a single SYSTEM tablespace datafile. But beer is also nice. No justification needed. :-)

BTW, I hope that the file system name Oracle7 does not imply that you are still running Oracle 7? If so.. it will be a darn good idea to upgrade to 9i. ASAP.

--
Billy

Received on Fri Sep 12 2003 - 03:57:49 CDT