Conrad - What command did you use to re-index? Drop index / create index?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Sorry, I forgot this additional infromation...
ALTER ...REBUILD..
Thanks
COnrad..
-Original Message-
WILLIAMS
Sent: Monday, January 13, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Conrad - What command did you use to re-index? Drop index / create index?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a
little rusty. If you search METALINK, you will find quite a few issues with
this command on various Oracle versions. I believe that the basic principle
is the same - Oracle builds a new index in the background, syncs up any
Though I'm not sure, I *believe* that in 7.3 indexes must
be taken offline during a rebuild.
That being the case, your users queries would not have
executed properly. i.e. FTS would take place for queries
that normally used indexed access.
Jared
On Monday 13 January 2003 08:14, Conrad
Dennis,
Here/ in this senario '
'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except
to anlyze table with cascade structure which will reveal any index
corruption relating to that table. There was a bug in 7.3.4.3 where index
rebuilding with parallel clause was resulting
Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was
that a great version).
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Here/ in this
Yes, it is as of today...We are still having 7.3.4.5 for our Oracle
Financials 10.7 Application. This may be the last year for this version...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 13 Jan 2003 12:38:39 -0800
Were you analyzing while rebuilding Indexes ?
If that is the case.. there are chances of possible corruption.
Try to give
select count(*) from table_name;
and
select * from table_name;
Hope this may provide you with some answer.
HTH
- Original Message -
To: Multiple recipients of