Re: Separating Data and Index

In article dated 1 Sep 1996 23:27:55 GMT, Vijay Vardhineni 604-1835 (vvardh01) wrote:
> I am trying to separate data from indexes in an existing table using
> export/import.
>
> imp system/manager file=expdat.dmp indexfile=index.sql
>
> If I view index.sql it only shows 2 indexes to modify. Where are the
> other 198???

The other indexes are probably created by primary or foreign key constraints. Have a look at the table ddl extracted by 'indexfile=...' and you will see the constraints there.

--
 _--_|\  John Verhoeven (johnv_at_acix.DIALix.oz.au or johnv_at_DIALix.oz.au)
/      \ >>>> Writing programs in assembler is like digging post <<<<
*_.--._/ >>>> holes with a teaspoon:  it takes a long time, but  <<<<
      v  >>>> you have complete control over all the dirt.       <<<<