because Oracle is allocating the same size in tablespace B as is
allocated in tablespace A. So since tablespace A has 512M allocated,
you will get 512 1M extents in tablespace B.
Remember, you are moving the table, not rebuilding it via export/import
or CTAS
- Rick Stephenson <RStephenson_at_Ovid.com> wrote:
> Let me give you the scenarios. Maybe I can get a good explanation
> from
> someone.
>
>
> Tablespace A locally managed uniform extents size 512M.
>
> Tablespace B locally managed uniforma extents size 1M.
>
>
>
> 1) Create table TabA tablespace A. Insert data, and it has 1 extent
> of 512M
> even though the table size is only 76M. This makes sense.
>
> 2) Create table TabA tablespace B. Insert data, and it has 76
> extents of 1M
> each. This makes sense.
>
> 3) Create table TabA tablespace A. Same as scenario 1. Alter table
> TabA
> move tablespace B. Creates 512 extents of 1M each. Why?
>
> The table only needs 76M of space. Why create all those
> additional
> extents?
>
>
>
> Thanks for any information,
>
>
>
> Rick Stephenson
>
>
>
>
>
> This email and any files transmitted with it are confidential and
> intended
> solely for the use of the individual or entity to which they are
> addressed.
> This message contains confidential information and is intended only
> for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete
> this e-mail from your system. If you are not the intended recipient
> you are
> notified that disclosing, copying, forwarding or otherwise
> distributing or
> taking any action in reliance on the contents of this information is
> strictly prohibited.
>
>
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon May 19 2003 - 16:12:07 CDT
