Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing into locally managed tablespaces
No. I don't have much experience with the autoallocate policy, for sure (the general advice is that if you're going to use LMTs, stick with the uniform extent method). But LMTs have always paid attention to the Storage Clause -it's what they decide to do with it that gets interesting.
Short story: LMT with 1M uniform extents. Create table with initial of 3.2M, next 26K. What do you get? To start with, 4 extents of 1 meg each (that's your Initial dealt with, with a bit of rounding up just to keep you happy). When the table extends, you'll get a 5th extent of 1 meg (that's the 26K being "ignored" -actually, it's not ignored as such, it's just suffering from a major dose of rounding up).
(Precisely what you'd get depends entirely on your release of Oracle. 8.1.5 did things rather differently than 8.1.7. But you get the idea, I hope. The storage clause is, in all case, being made to fit to what the LMT can offer. It's not being ignored exactly, but is taken merely as a general sense of what you are wanting to do -but the LMT always has the last say).
Regards
HJR
-- =============================!!============================= The views expressed are my own only, and definitely NOT those of Oracle Corporation =============================!!============================= "Vikas Agnihotri" <onlyforposting_at_yahoo.com> wrote in message news:77e87b58.0105211857.54d3b61e_at_posting.google.com...Received on Mon May 21 2001 - 22:54:32 CDT
> 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?