Re: export / import

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Fri, 04 Feb 2000 04:52:55 GMT
Message-ID: <HWsm4.1088$Qp1.272893@ratbert.tds.net>

Indexes are keyed on ROWID. When you reimport the data into the table, they receive new ROWID values. This renders your indexes unusable. If you have 8i, you can reorg tables/indexes without export/import using:

ALTER TABLE tablename MOVE STORAGE(new storage clause); ALTER INDEX indexname REBUILD STORAGE (new storage clasue);

Just make sure you have ample space since it temporarily makes a copy of the object.

Hth,
Mike

Graeme Farmer wrote in message ...
>Is it possible to export/import (for re-org) data only leaving the indexes
>intact? When you drop a table it also drops any indexes associated with it
>so would I be correct in assuming that you perform the export, truncate the
>tables then import the data or does the truncate command also kill the
>indexes. I don't have enough of a window at the weekend to export/import
>both data and rebuild of indexes.
>
>Thanks
>Graeme.
>
>
>
Received on Thu Feb 03 2000 - 22:52:55 CST