From metalink.
fact: Oracle Server - Enterprise Edition 8
symptom: Error performing a SELECT statement
symptom: ORA-08103: object no longer exists
symptom: Table is being truncated by other session
symptom: Analyze table validate structure cascade returns no errors
cause: This ORA-08103 occurs on the next block read after the truncate
command.
The LOCK TABLE IN EXCLUSIVE MODE does not prevent the table from being
SELECTED from. Thus, when the query has started and while this query
runs
and the truncate occurs, this ORA-08103 may surface on the next block
read.
This is considered intended behavior.
When a TRUNCATE occurs the DATAOBJ# in OBJ$ gets increased by one and
thus
may lead to this ORA-08103 'object no longer exists'
fix:
Possible solutions are:
- Use DELETE instead of TRUNCATE
- Use SELECT FOR UPDATE as this will try to lock the table
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x68227849.[Email address protected]
Sent: Friday, April 28, 2006 6:00 AM
To: LazyDBA Discussion
Subject: Oracle Question
To All,
Skika Abdelali,
Are you sure you are not a "developer"(Oh my! Phew!)? hehe.
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Skika Abdelali [mailto:A.[Email address protected]
Sent: Friday, April 28, 2006 5:53 AM
To: Edwards, Ed
Subject:
Hello Mr Ed,
I can not have acess any more to Lazy DBA :(((
I have to paye ... snif snif
Any way ... I have a problem with one database , if you have time
purharps you can answer me or you can put it in the forums... please
please (I'm not a developper)
Hi,
I have a problem with one database. (oracle 8.1.6 under windows NT)
Startup and shutdown have no problem ---> no error in alert file.
But with some tables I have the error ORA-08103 when I try the select
count(*) from table !!!!
*********************************************************
SQL> select count(*) from CONSOMMATION;
select count(*) from CONSOMMATION
*
ERROR at line 1:
ORA-08103: object no longer exists
*********************************************************
SQL> select table_name from dba_tables
2 where table_name ='CONSOMMATION';
TABLE_NAME
------------------------------
CONSOMMATION
*********************************************************
SQL> desc CONSOMMATION
Name Null? Type
------------------------------- -------- ----
NUMERO_BASE NOT NULL VARCHAR2(16)
SESSION_ID NOT NULL NUMBER(5)
NUMERO_TETE NOT NULL VARCHAR2(9)
DATE_DEBUT_PERIODE NOT NULL DATE
DATE_FIN_PERIODE NOT NULL DATE
CODE_APPEL NOT NULL NUMBER(5)
TYPE_INDEX NOT NULL NUMBER(5)
INDEX_DEBUT_PERIODE NUMBER(19,4)
INDEX_FIN_PERIODE NUMBER(19,4)
NUMERO_TETE_REMPLACANTE VARCHAR2(9)
INDEX_TETE_REMPLACANTE NUMBER(19,4)
TYPE_INSTALLATION NUMBER(5)
NOMBRE_JOURS NOT NULL NUMBER(5)
NOMBRE_PRODUITS NOT NULL NUMBER(5)
DATE_LA_POSTE DATE
**************************************************************
I check all my datafiles with DBVERIFY and all seams ok !!!
Can some one help? Can I rebuild the database? Can I get all my data
without using the restor?
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x68889154.[Email address protected]
Sent: Friday, April 28, 2006 5:06 AM
To: LazyDBA Discussion
Subject: SQL Check for numbers only
Having a bad morning and can't think of the best way to tackle this....
I have a 6 char text column which must only contain numbers (0-9) and
must not
contain any spurious characters.
Whats the select statement that would check for this.
I really hope this is not an easy solution otherwise I'm going to feel
silly
and Ed won't award me any coke !
But I really can't think at the moment....more caffeine needed !
--
Brett Exton.
________________________________________________________________________
This e-mail and any attachments transmitted with it represents the
views of the individual(s) who sent them and should not be regarded
as the official view of Bridgend County Borough Council. The contents
are confidential and intended solely for the use of the addressee. If
you have received it in error, please inform the system administrator
on (+44) 01656 642111.
This e-mail and any attachments have been scanned with 'MessageLabs
SkyScan' - http://www.messagelabs.com/
________________________________________________________________________
Maer'r e-bost hwn ac unrhyw atodiadau a drosglwddir gydag ef yn
cynrychioli
safbwyntiau'r unigolyn (unigolion) a'u hanfonodd ac ni ddylid eu
hystyried fel
safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r
cynnwy
syn gyfrinachol ac wedi'i fwriadu at ddefnydd y person y'i cyfeiriwyd
ato yn
unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i
weinyddwry system ar (+44) 01656 642111.
Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda
'MessageLabs SkyScan' - http://www.messagelabs.com/
________________________________________________________________________
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page