exp and constraint indices

From: Doug Harris <ah513_at_Freenet.carleton.ca>
Date: Sun, 19 Sep 1993 05:19:09 GMT
Message-ID: <CDL5Fx.KDy_at_freenet.carleton.ca>


   I rebuilt (full database export/import) my Oracle7 database a while back and discovered (to my great dismay) that all of the indexes created implicitly via primary key constraints on various tables were not restored to there proper place in the universe (read in the appropriate index tablespace). It would seem that with 7.0.12 exp does not export the tablespace and storage parameters for indexes which are born of constraints (these parameters were specified via the USING INDEX clause of constraint definition within the CREATE TABLE statement).

   Could anyone verify if this has been corrected in 7.0.13? I've got a development project about to go production in a few months and am a bit nervous about this one.

Received on Sun Sep 19 1993 - 07:19:09 CEST

Original text of this message