Oracle database consistency checks

From: Koen Lefever <Koen.Lefever_at_dexia.be>
Date: 09 Oct 2000 09:43:52 +0200
Message-Id: <10644.118758@fatcity.com>

Hi,

I have some general questions on how Oracle manages consistency, in comparison to other RDBMSes.

Other RDBMS systems have dedicated programs to check the consistency of the database
(like oncheck for Informix or dbcc for Sybase) and sometimes tools to correct inconsistencies.
I mean consistency on physical level: pointers between rows, pages, files, etc... I'm not aware of such a tool on Oracle.

Does Oracle perform such checks/repairs automatically?
Are there any Oracle or third party tools to perform such checks?
Do I need them? I've never had a "broken chain" or "corrupt page" on Oracle. Am I just lucky or is this an example of a superior architecture?
If such a problem would occur, what can I do except for a full restore?

All links to web pages, books, trainings... where I can find more information on this are welcome.

aTdHvAaNnKcSe & Best regards,
Koen.

From: Nam_Phan_at_manulife.com
Date: Mon, 9 Oct 2000 14:19:20 +0700
Subject: Re: problem with trigger

Hi,
The first, you need to create the sequence, and then run my script file.

CREATE OR REPLACE TRIGGER ar_hkc_dt
BEFORE INSERT
ON employee
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
l_employee_id number(4);
BEGIN
IF inserting THEN

     select emp_seq.nextval into l_employee_id from dual;
     :new.emp_code := l_employee_id;

END IF;
END;
/

Hopefully you get success,

Phan Hoai Nam
Business Analyst,
Chinfon Manulife Insurance Co., Ltd.
Tel: 84-8-8257722, Ext: 2903
Mobile: 091-74 86 95

satish plakote <satish_plakote_at_excite.com>@fatcity.com on 10/09/2000 12:15:54 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: problem with trigger

hi ,
i am doinga project in java and oracle. I am using a set of tables . There r some tables like Employee master,in which i want to have employee code generated by sequences.
I am aming to have a dynamic Java code , where in any table ccan be selected for an insert valeues option.
I want to write a trigger on the database side such that when ever i give an insert query from my java code, the trigger should automatically insert the employee code.
i tried writing a trigger but i got a message" triger created with compilation errors"
Can somebody tell me how to write that trigger.and what should mt insert statement be.Since i am declaring my primary ky as not null. Thanks
satish

Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: satish plakote
  INET: satish_plakote_at_excite.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).







==========================================================
This message is confidential and may also be privileged.  If you are not the
intended recipient, please notify me by return e-mail and delete this message
from your system.  If you are not the intended recipient, any use by you of this
message is strictly prohibited.

Received on Mon Oct 09 2000 - 02:43:52 CDT