RE: Verify Piipe Exists
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <dofreeman@xxxxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Jan 2005 13:03:17 -0500
I believe you can try to create a pipe with the same name and it will fail
because it already exists. Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
