Home » RDBMS Server » Server Administration » Purging Oracle pipe
Purging Oracle pipe [message #374836] Thu, 05 July 2001 10:06 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
Is there any SQL command that I can execute from SQLPlus or equivalent to purge an Oracle pipe that is full?

Thanks in advance

Report message to a moderator

Re: Purging Oracle pipe [message #374838 is a reply to message #374836] Thu, 05 July 2001 12:38 Go to previous message
Daniel Eikenberry
Messages: 1
Registered: July 2001
Junior Member
procedure dbms_pipe.purge(pipename in varchar2);

so you should be able to

execute dbms_pipe.purge("yourpipename");

or something similar

Report message to a moderator

Previous Topic: OCP-Database Operator Exam(Test# 1Z0-401)
Next Topic: how to display all the content of a char field in SQL*WorkSheet
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 17:38:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.