Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Verify Piipe Exists

Verify Piipe Exists

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Mon, 10 Jan 2005 12:46:36 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860760144F226@enhbgpri11.backup>


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
Received on Mon Jan 10 2005 - 11:47:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US