Home » RDBMS Server » Server Administration » ora -08103 error & not able to retirive rows
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
Previous Topic: host string
Next Topic: problem in locating the correct Host String
Goto Forum:
  


Current Time: Thu Jan 09 03:45:04 CST 2025