To clean up the recycle bin of the Oracle database to which webfocus connects i tried using the statement PURGE RECYCLEBIN.
But this always throws an error saying VIEW REYCLEBIN cannot be found. I can select from the RECYCLEBIN through WebFOCUS and also run the PURGE statement outside of webfocus,through any Oracle client using the same Oracle id. Is there any restriction on using the PURGE command through WebFOCUS?

This message has been edited. Last edited by: Kerry,

If this is an Oracle command, are you embedding it in:

SQL SQLORA
command
END

syntax?

Yes

SQL ORA
PURGE RECYCLEBIN;
END

Just the PURGE commands will not work

quote:

SQL SQLORA

Make sure this is correct. See above.

My syntax is correct,because I have been using the same for all Oracle statements all the time.

quote:

PURGE RECYCLEBIN

I assume that you have DROP TABLE commands and that is why you want to purge the RECYCLEBIN

If that is the reason change the DROP to

DROP TABLE tablename PURGE;

That way it will not go into the recycle bin at all.

Thanks JG.
That does not create any Recycle Bin objects.
But do you know why the simple PURGE RECYLEBIN command does not work from webfocus?

Just curious if you've tried the "SHOW recyclebin" command?

George that's one for tech support.

I assume it's because RECYCLEBIN is not a table or view and so webFocus does not generate the correct syntax.

NFR perhaps.