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

Home -> Community -> Usenet -> c.d.o.tools -> Move tables?

Move tables?

From: Little Prince <milan1810_at_geocities.com>
Date: Wed, 18 Jul 2001 00:07:09 +0800
Message-ID: <9j1ns2$q827@ctmsun0.macau.ctm.net> 






I uses Oracle 8.0.6. I have a tablespace USERS which consistes of 3
datafiles (fno 4, 5 and 6). I found that most of the tables are stored in
datafile with fno 6. How can I move some tables to the other 2 datafiles?



Regards,


Andrew
Received on Tue Jul 17 2001 - 11:07:09 CDT












Original text of this message













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