Re: Purge command
Date: Thu, 2 Oct 2008 15:10:09 -0700 (PDT)
On Oct 1, 8:29 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> 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