Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Combining Datafiles
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
![]() |
![]() |