Re: Purge command
From: mathewbutler <mathewbutler_at_yahoo.com>
Date: Thu, 2 Oct 2008 15:10:09 -0700 (PDT)
Message-ID: <41c7f713-92a8-4457-8fbd-15af4247be58@j22g2000hsf.googlegroups.com>
Date: Thu, 2 Oct 2008 15:10:09 -0700 (PDT)
Message-ID: <41c7f713-92a8-4457-8fbd-15af4247be58@j22g2000hsf.googlegroups.com>
On Oct 1, 8:29 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> when I am connected to a 10.20.4 database
> with a 9i client, the purge command doesn't work:
>
> > purge dba_recyclebin;
>
> SP2-0734: unknown command beginning "purge dba_..." - rest of line ignored.
>
> Why ?
> The documentation says it is a SQL command
>
> Thanks in advance
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.
Mathew butler Received on Thu Oct 02 2008 - 17:10:09 CDT