From oracle-l-bounce@freelists.org Wed Mar 31 18:11:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i310BRj12127 for ; Wed, 31 Mar 2004 18:11:27 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i310BQo12122 for ; Wed, 31 Mar 2004 18:11:27 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 205016354CF; Wed, 31 Mar 2004 19:07:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15357-09; Wed, 31 Mar 2004 19:07:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 534B1635594; Wed, 31 Mar 2004 19:07:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 31 Mar 2004 19:06:38 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A5D06354E3 for ; Wed, 31 Mar 2004 19:06:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14163-58 for ; Wed, 31 Mar 2004 19:06:36 -0500 (EST) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64020635548 for ; Wed, 31 Mar 2004 19:06:36 -0500 (EST) Received: from ryan2le36ofjce ([68.98.163.81]) by lakemtao01.cox.net (InterMail vM.5.01.06.08 201-253-122-130-108-20031117) with SMTP id <20040401001457.SZUE26108.lakemtao01.cox.net@ryan2le36ofjce> for ; Wed, 31 Mar 2004 19:14:57 -0500 Message-ID: <4ea201c4177e$abe50e50$51a36244@ryan2le36ofjce> From: "Ryan" To: Subject: problem dropping synonyms Date: Wed, 31 Mar 2004 19:17:08 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_4E9F_01C41754.C2D83EE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2243 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan.gaffuri@cox.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPart_000_4E9F_01C41754.C2D83EE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am attempting to drop a synonym and it hangs. This tells me the = synonym is locked. I check v$access and it's not being used. I also = checked v$lock. Anywhere else to look? ------=_NextPart_000_4E9F_01C41754.C2D83EE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I am attempting to drop a synonym and = it hangs.=20 This tells me the synonym is locked. I check v$access and it's not being = used. I=20 also checked v$lock. Anywhere else to look?

------=_NextPart_000_4E9F_01C41754.C2D83EE0-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------