Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Combining Datafiles

Re: Combining Datafiles

From: Rich Woods <rawoods_at_concentric.net>
Date: 1996/12/29
Message-ID: <32C72A2D.7898@concentric.net>#1/1

Brian Spears wrote:
>
> HI,
> Is there a way to combine two datafile into one? Can it be
> done without bringing the Database Down?
>
> Brian
> brspears_at_dsi.bc.ca

Export the contents of the two datafiles, drop the two small datafiles, create one large datafile for the tablespace in question, and Import the contents.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Sun Dec 29 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US