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 -> copy data from one datafile to another?

copy data from one datafile to another?

From: nodge <nodge.trottier_at_googlemail.com>
Date: Wed, 04 Jul 2007 08:16:47 -0700
Message-ID: <1183562207.769468.179090@k79g2000hse.googlegroups.com> 





Hey guys,



second problem today:



is it possible to remove some datafiles from a tablespace and put this
data back into the remaining datafiles? All datafiles are there for
the same tablespace. Is there a simple command to do this?



I've got a big tablespace with more then 40 datafiles - each file is
400MB. Therer are 4 file which I want to be removed. It's a RAW
Filesystem and these 4 Files were created on the real file system by
accident.



Thx


Nodge
Received on Wed Jul 04 2007 - 10:16:47 CDT












Original text of this message













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