This content has been marked as final. Show 3 replies
Pl check the documentation - http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables011.htm#ADMIN11682
i have read but it was not clear, and time was less so i asked (i am new bie).
The documentation that Srini provided a link to is quite clear.1 person found this helpful
Quoting it here (with emphasis added) :
Users can purge the recycle bin of their own objects, and release space for objects, by using the following statement:
+If you have the SYSDBA privilege, then you can purge the entire recycle bin by specifying DBARECYCLEBIN, instead of RECYCLEBIN_ in the previous statement.+
Hemant K Chitale