Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c74g2000cwc.googlegroups.com!not-for-mail
From: sanjeev_atvankar@hotmail.com
Newsgroups: comp.databases.oracle.server
Subject: How to LOCK TABLE/READ ONLY table in own schema after data insertion
Date: 6 Jun 2006 03:03:31 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1149588211.336181.204190@c74g2000cwc.googlegroups.com>
NNTP-Posting-Host: 202.140.131.13
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149588216 16491 127.0.0.1 (6 Jun 2006 10:03:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 10:03:36 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 linuxproxy:8080 (Squid/2.4.STABLE6)
Complaints-To: groups-abuse@google.com
Injection-Info: c74g2000cwc.googlegroups.com; posting-host=202.140.131.13;
   posting-account=6oT3ig0AAACNCRQ5ccZrOCQkAb9HyeFl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268600

Hello Guys

I am developing one application in which there are two tables as
follows
1)call_by_call_details(this table stores each call by call details) and
tables columns are as follows
(call_id,caller_name,call_type,call_Date)

2)call_by_call_hist (this table stores monthwise history from
call_by_call_details) and columns are as follows
(Rep_Month,call_type)

I have written the query that create history and put into
call_by_call_hist on Every month end with the help of procedure and Job
scheduling.

But after inserting the data into call_by_call_hist i want to lock this
table till next insert,that means no one can change the data from hist
table i.e.In this hist table only insert and fire a query is possible.

Could anyone give me the solution(possibly with explaination).

Thanks in advance

Sanjeev