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 -> Tables in Datafile

Tables in Datafile

From: Mill <mill.h_at_ntlworld.com>
Date: Fri, 18 Jun 2004 12:13:26 +0100
Message-ID: <W1BAc.24$sx2.19@newsfe2-win> 





Hi



A previous DBA on our site had extended a tablespace by creating an
additional datafile, unfortunately


he didn't create it with the logging switch.



How can i find out which tables are actually in that part of the datafile ?



I want to recreate the datafile with the logging switch then move all the
data into this new file


and drop the old datafile.



Using Oracle 8i on Windows 2000 Adv Server



Regards



Mill
Received on Fri Jun 18 2004 - 06:13:26 CDT












Original text of this message













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