Re: export/import anomaly

From: Doug Harris <ah513_at_FreeNet.Carleton.CA>
Date: Fri, 16 Sep 1994 20:04:12 GMT
Message-ID: <Cw8nr0.D0x_at_freenet.carleton.ca>


In a previous article, khuguley_at_casi.sti.nasa.gov () says:

>I just copied a user's schema (tables,indexes,...) from
>one db to another (exp/imp) and discovered that almost of the
>indexes were imported into the wrong (data) tablespace!
 [ Chomp ]
>All of the indexes (primary key indexes) that were imported to
>the wrong tablespace were initially created
>during table definition as column constraints.

   Are you running 7.0.13 or erlier? I recall that this was a bug in export which was corrected in 7.0.15.

--
   - Doug Harris
     Database Administrator, System Development Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##
Received on Fri Sep 16 1994 - 22:04:12 CEST

Original text of this message