Re: URGENT HELP NEEDED

From: Cong TANG <lai-tang_at_mycity.at>
Date: Wed, 01 Dec 1999 21:35:46 +0100
Message-ID: <384586A2.678E510B@mycity.at>

Maybe the index columns have null values. If your version of RDBMS is 7.3 or higher, you can rebuild indexes using the command:

ALTER INDEX index_name REBUILD;
or
ALTER INDEX index_name REBUILD
TABLESPACE tablespace_name;

There is no need to drop and re-create indexes in that case.

karinas_at_my-deja.com wrote:

> Hi there
>
> I hope I'm on the correct forum, if not please advise me where to post.
>
> I have the following problem on an Oracle database.
>
> The indexes on the tables had to be dropped and re-created.
>
> When I created the index, it gave me the message: Index created with 0
> rows.
>
> If there was 1000 rows in the table, shouldn't it have said: Index
> created with 1000 rows?
>
> How can I solve the problem?
>
> Thanks for the help
> Karina Scholtz
> Accord Business Solutions
> South Africa
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Wed Dec 01 1999 - 14:35:46 CST