ora -08103 error & not able to retirive rows [message #62286] |
Mon, 12 July 2004 05:49 |
ramya
Messages: 87 Registered: August 2002
|
Member |
|
|
hi
i am using 7.3 on solaris 5.5
when i am trying to create table
like i am getting error
SQL> create table mis.aud_bacmar as select * from ta.aud_gui nologging where
2 aud_date between '06-mar-04' and '08-mar-04';
create table mis.aud_bacmar as select * from ta.aud_gui nologging where
*
ERROR at line 1:
ORA-08103: object no longer exists
plan is below
plan
CREATE TABLE STATEMENT
CREATE AS SELECT
TABLE ACCESS BY ROWID AUD_GUI
Rows
Plan
INDEX RANGE SCAN I_AUD_GUI_01
when i selecting the rows
select count(*) from aud_gui where aud_date between '06-mar-04' and '08-mar-04';
i am gettting
137071 rows
if i select count(*) from aud_gui where aud_date = '06-mar-04'
and i am getting
0 rows selected
same for 7 march and 8 march
how to fix it
with regards
ramya
|
|
|