RE: Verify Piipe Exists

Donald, Try the following query:

set echo off
rem pipe_usr.sql
rem SQL*Plus script to display Oracle pipe usage rem
rem 19980204 m d powell New Script.
rem
select u.username, p.name, p.type
from v$db_pipes p,

       sys.dba_users u
where p.ownerid = u.user_id
order by p.name, u.username
/

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman, Donald Sent: Monday, January 10, 2005 12:47 PM
To: Oracle-L (E-mail)
Subject: Verify Piipe Exists

I am trying to install a vendor application with an Oracle repository = and not making much progress. The install has failed and the cleanup = requires that the pipe be purged and removed or the database be bounced. = I've been through this four times since Friday afternoon. I can't find = any way to view whether or not a pipe exists. I know its not a = conventional database object and that its some sort of memory structure. =  Is there a way to do this? Where do I look?

This is what they gave me to remove the pipe.

declare ret number;=20
begin=20
dbms_pipe.purge('usernamePIPE_MASTER');=20 ret:=3Ddbms_pipe.remove_pipe(user||'pipe_master1');=20 end;=20

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 10 2005 - 12:01:40 CST