| Re: Ora-01502 [message #53077] |
Tue, 27 August 2002 10:27 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
select table_owner, table_name,index_name, uniqueness, status
from user_indexes
where status != 'VALID';
Check the status of the indexes immediately after you create them - they should be valid. Are you doing something like a SQLLOAD in DIRECT mode? I can't remember, but I think that errors during DIRECT load can cause indexes to go invalid.
Try:
analyze table XYZ validate structure cascade;
That will check the indexes on the table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
