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

what are sequences

1096


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

550


how many triggers are allowed in mysql table? : Sql dba

559


What are character functions?

630


what are the different type of sql's statements ? : Sql dba

522






What does joining a thread mean?

548


Can we insert in view in sql?

568


What are the limitations of sql express?

529


What is the maximum database size for sql express?

538


What is sorting in sql?

503


what is the difference between delete and truncate statement in sql? : Sql dba

551


what does the t-sql command ident_current does? : Transact sql

544


Is it possible to include an insert statement on the same table to which the trigger is assigned?

561


what is the difference between where clause and having clause? : Sql dba

540


Why do we use view in sql?

534