ALTER TABLE MOVE ( Block- or row-oriented ? )
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ALTER TABLE MOVE ( Block- or row-oriented ? )

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello, my Question is:
    Does ORacle move the table-segment database-block- ( due to higher performance ) or row-oriented like an normal INSERT-Stmt.

    This question is important, because if MOVE works only database-block-oriented then Reorgansiation would not change the filling-grade of the Databaseblocks.
    Then exp/imp shpuld be prefered.

    Orca

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Oracle move data of table row by row.
    Because:
    in ALTER TABLE MOVE statment u can use -->
    full set of storage and block structure parameters (including INITIAL, PCTFREE, PCTUSED, MAXTRANS ...)
    oracle can't change any of its without reorganisation db block.

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Thank you!
    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width