Re: Maintenance on Indexes

Doug,

Are you sure that the indexfile option, export definition of primary keys ???

Thanks, I am interesting for the answer

Regards. Olivier

Doug Carter wrote:

> Gillian,
>
> A fairly easy way to do this is to export your database (rows=n is fine and
> you can use compress=y) and then create an indexfile. If using unix it is
> normally fairly easy to massage this file. An example follows:
>
> #Create index file from export:
>
> imp / file=expfile.dmp fromuser=ifneeded touser=neededif ignore=y indexes=y
> indexfile=indexes.sql rows=n
Received on Wed Mar 18 1998 - 00:00:00 CST