Re: Table Fermentation

On Fri, 05 Dec 2003 08:25:54 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>no-spam wrote:
>
>> 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
>
>Is this: Guess what version I'm using day?
>
>And what do you mean by "not wanting to use" an option? Do you want us
>to guess why too?

Daniel

 it is Oracle 8.1.7... but as far as I know the import and export work the same for any version of Oracle .. so the version if does not come

into my question !!!!!!!!!!!!!!!!!!!

The compress=y on export will cause the table to be created in one extent during import, which will cause probelm for me becasue the entire table will not fit into one data file within the table space

I thought this was a simple enough question as to how to reduce the number of extents used by tables.

>Daniel Morgan
>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>damorgan_at_x.washington.edu
>(replace 'x' with a 'u' to reply)
>
Received on Fri Dec 05 2003 - 10:47:19 CST