Re: Unlimted Extents = 505?

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 12 Dec 2002 13:55:29 -0600
Message-ID: <ubqhvuk8v2rce0bfd6bn8g620f5oi5fdpb@4ax.com>

One other point - if you do not specify the storage details in the create table statement, the tablespace's settings will be used.

Rogbaker_at_gdi.net (Rogbaker) wrote:

>Magpies,
>I am not sure I follow. Since I dropped the tables, there were no
>existing settings. I expected to have the same settings of the tables
>I exported/imported.
>-Roger
>
>
>"magpies" <-_-> wrote in message news:<ata089$pmv1_at_imsp212.netvigator.com>...
>> You can just to truncate the tables but to drop it out. Otherwise, import
>> will create a new table based on its original setting.
>> Now you can truncate the tables again, set the table at apporiate value
>> using 'alter table' command. Lastly, import the tables using 'import table'
>> option instead of 'full import'.
>>
Received on Thu Dec 12 2002 - 13:55:29 CST