does this " PURGE RECYCLEBIN;"
removes all objects from all tablespace , all schemas and all recycle bin object
if called from connect sys/ as sysdba
or do i have to call this command from all schemas, if yes then should i call it from sys and system also.
or only calling it from sys , it will release memory of all deleted objects?
The documentation that Srini provided a link to is quite clear.
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: PURGE RECYCLEBIN;
+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