Re: Move records

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 15 Jul 2004 01:14:10 +0300
Message-ID: <011a01c469ef$e6310910$63a423d5@porgand>

> alter table enable row movement;
>
> As the command shows, that allows ROWS to be moved between partitions.
RECORDS I would generalize this somewhat:
Alter table enable row movement allows an existing row's ROWID to change.

With 10g you can shrink an existing table (using alter table shrink space), causing complete rows physical locations to change, thus also rowid change, even in nonpartitioned table.

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 17:11:23 CDT