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

Home -> Community -> Usenet -> c.d.o.misc -> Table Fermentation

Table Fermentation

From: no-spam <rc_at_!(no-spam)!@!bhfshops.org.uk>
Date: Fri, 05 Dec 2003 12:20:27 GMT
Message-ID: <3fd0770c.863429005@news.demon.co.uk> 





Hi 



I have a table space with about 63 tables in it. Most of the tables
are less than 100k rows. 



If I wanted to defrag the tablespace, can I export and import one
table at a time or do I have to export all the tables in one go and
import back in again



I do not want to use the compress=y option 



Are there additional command I have to issue re the table_space ?



Thanks 
Received on Fri Dec 05 2003 - 06:20:27 CST












Original text of this message













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