what is purge command
explain about oracle performance tuning

Answer Posted / pooja

Use the PURGE statement to remove a table or index from
your recycle bin and release all of the space associated
with the object, or to remove the entire recycle bin, or to
remove part of all of a dropped tablespace from the recycle
bin.
PURGE RECYCLEBIN;

Is This Answer Correct ?    24 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I clear the screen in sql plus?

536


What does inner join mean?

539


What is db journal file?

508


how to include numeric values in sql statements? : Sql dba

549


How does sql*loader handles newline characters in a record? : aql loader

578






What is data modelling in sql?

511


who introduced sql?

560


How do I partition a table in sql?

531


What does a pl/sql package consist of?

506


Show the two pl/sql cursor exceptions.

605


Is left join inner or outer?

571


What is use of package in pl sql?

523


Is the primary key an index?

584


how to delete an existing column in a table? : Sql dba

542


Is a foreign key always unique?

522