Importing into locally managed tablespaces

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 21 May 2001 19:57:23 -0700
Message-ID: <77e87b58.0105211857.54d3b61e@posting.google.com>

I am migrating our 2KB db block size production database to a 8K block size. All on Solaris, Oracle 8.1.5

Thought this might be a good opportunity to move to the locally managed tablespace feature.

Still in testing mode... I created locally managed (autoallocate) tablespaces in a new 8K database and did the 'imp full=y destroy=n'.

To my surprise, I see that 'imp' is trying to create the objects with their original STORAGE parameters (initial, next, etc).

I was under the impression (from reading the docs) that when creating objects in locally managed tablespaces with autoallocate turned on, Oracle ignores the 'STORAGE' clause in the CREATE TABLE/INDEX statements.

Comments? Is this a known bug? Received on Mon May 21 2001 - 21:57:23 CDT