Re: LTM

From: Marco <themommi_at_iol.it>
Date: 29 Apr 2004 03:16:36 -0700
Message-ID: <1bd20b7d.0404290216.79761103@posting.google.com>

Hi HJR,

>Create a new tablespace with 3M extents,
> and then 'alter table X move
>tablespace NEWONE'. Finally, drop the original tablespace.
>Not particularly elegant, I suppose...

Yes ;-)
I am new to Oracle and I sought a
"magic wand" to remedy at my error.

Now I have understood that it isn't the magic wand..... simply I should create new tablespace....

>Who cares in any case? Your tables will
> simply have six times the number
> of extents in one than they would in the other,
> which is of no consequence at all, ordinarily.
Yes...... but I have read many books..... internet faq..... tutorial.... and then I have estimated (for my oracle objects) the row mean , the pctfree, the rows per blocks, the row number and, at last, the value of initial! :-) Then I have planned the set of tablespaces and, in the end!, I have wrong the tablespace DDL.... :-( :-( :-( It's irritating!! ;-) ;-) ;-)

In any case I have realized that there aren't problems if my extent size is 512K instead of 3M.

Regards,

Marco. Received on Thu Apr 29 2004 - 05:16:36 CDT