Re: Importing into locally managed tablespaces

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<990563909.1420.0.nnrp-13.9e984b29_at_news.demon.co.uk>...
> How about -
>
> Import the structures only, until imp breaks,
> then run a script to read all the tablenames
> and index names and do;
>
> alter table/index xxx deallocate unused'
>
> then import the structures again
> and repeat until all structures are loaded.

Um..with all due respect, Jonathan, this is a tad daft. I have hundreds of large tables. Per your suggestion, 'imp' would error out after each run and I would need to do the 'deallocate unused'!

Or, wait a minute, it probably wouldnt even get out the starting gate since no table can be created in my smaller database.

> The script will probably deallocate back to
> just one extent per object.

Yes, I see what you are suggesting. Clever, but all in all, I think extracting the DDL and editing it is the more sure-fire way to do this

Connor, thanks for the 'strings' idea...will try it out.

> (Coincidences abound - I wrote up the answer
> to your original question (without having seen
> the question) on a train-ride this evening to
> post onto my website later on).
 

:-) Received on Wed May 23 2001 - 22:12:49 CDT