Re: URGENT HELP NEEDED

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Tue, 30 Nov 1999 13:01:44 +0100
Message-ID: <3843BCA8.DB1563E2@unilog.fr>

Hi !

Check these first :

1 - The name of the table you use in you creation order is the right one.

2 - The column(s) you use in the index are not null (Try a select count(*) where xxx is not null).

Hope this help.

Bye

Pierre CHARPENAY

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 Tue Nov 30 1999 - 06:01:44 CST