Re: Merge System Datafile in Oracle v7.3

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Fri, 12 Sep 2003 06:18:19 +0200
Message-ID: <76i2mv4p6pl1an6leeo9emj0q4h4qtlqp2@4ax.com>

On Fri, 12 Sep 2003 09:01:44 +0800, "Yong Boon, Lim" <limyb_at_megasteel.com.my> wrote:

>Hi good morning,
>
>l've the following problems, my system datafiles are configurated as
>following,
>
>STATUS NAME
>BYTES
>---------- -----------------------------------------------------------------
>---- ----------
>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?
>
>Thank you in advance.
>

Yes,
export the database
recreate the database with a correct datafile clause import
Other than that: impossible

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 11 2003 - 23:18:19 CDT