Re: How can I combine two datafile into one?

From: Ken Nichols <knichols_at_mcsilo.ilo.dec.com>
Date: 1997/09/24
Message-ID: <342901A6.51A7@mcsilo.ilo.dec.com>#1/1

Jizhong,

The slow-but-sure way is to export the objects in the SYSTEM tablespace, drop and recreate the tablespace, then import the objects.

If there's another way, I would like to hear about it from some of the advanced DBAs out there.

Good luck,

Ken

Dr. J. Wang wrote:
>
> Our previous DBA used two datafiles for SYSTEM tablespace (say datafile1 20M,
> 5 M used and datafile2 50M, 2 M used). It seems odd to me since I think one is
> easier to manage and should be more efficient. Anyway, how can I combine them
> into only one file?
>
> Thanks
>
> Jizhong
Received on Wed Sep 24 1997 - 00:00:00 CDT