Re: Purge command
From: Vince <vinnyop_at_yahoo.com>
Date: Tue, 7 Oct 2008 07:28:37 -0700 (PDT)
Message-ID: <8bd17900-063e-4e8d-8970-94bdfebf6818@r66g2000hsg.googlegroups.com>
Date: Tue, 7 Oct 2008 07:28:37 -0700 (PDT)
Message-ID: <8bd17900-063e-4e8d-8970-94bdfebf6818@r66g2000hsg.googlegroups.com>
On Oct 3, 11:34 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> <The 9i client doesn't know 10g SQL. If you call your command from the
> <9i client but wrapped in pl/sql the command will be executed in the
> <10g server successfully.
>
> SQL is not excuted by 10g engine ?
> some control is done by sql*plus ?
> Thanks
You may want to try
BEGIN
EXECUTE IMMEDIATE 'purge dba_recyclebin';
END;
/
So that the actual syntax will pass SQL*Plus and turn it over to the database (10g) Received on Tue Oct 07 2008 - 09:28:37 CDT