Re: script to rebuild all indexes in a database?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 19 Oct 1999 19:56:02 +0800
Message-ID: <380C5C52.2D5B@yahoo.com>

David Spaisman wrote:
>
> Hello:
>
> I am planning to rebuild the non clustered indexes and clustered indexes for
> the production database.
>
> I am using a faciliy in DBArtisan to generate a script to rebuild all
> nonlcustered(and non-primary indexes). This facility only generates the ddl
> for index which are not clustered( primary key) indexes so that I ahve to
> generate the table ddl to get the index name and storage parameters which I
> want to change and cut and paste these parameters into a create index
> script. Very labor-intnsive.
>
> Doers any one have a script that will generate the ddl for the clustred
> indexes as well as the nonlcustered indexes with the storage parameters and
> tablespace assignment so that I can revise both parameters?
>
> THanks.
>
> David. Spaisman

exp full=y rows=n file=blah
imp full=y indexfile=indexes.sql file=blah

should be a very good start
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Oct 19 1999 - 06:56:02 CDT