what is purge command
explain about oracle performance tuning




Answers were Sorted based on User's Feedback



what is purge command explain about oracle performance tuning..

Answer / apurva

Purge command is used to clear the recycle bin.
It can also be used with drop command
ex. drop table <tablename> purge;
this command will clear away the table from database as
well as from the recycle bin. After firing of purge command
you cannot retrive the table using flashback query.

Is This Answer Correct ?    37 Yes 3 No

what is purge command explain about oracle performance tuning..

Answer / 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




More SQL PLSQL Interview Questions

What is integrity constraints?

5 Answers   Satyam, Ramco,


What is the purpose of cursors in pl/sql?

0 Answers  


how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,


How do I view a procedure in sql?

0 Answers  


Is truncate ddl or dml?

0 Answers  






Why do we use cursors?

0 Answers  


Is it possible for a table to have more than one foreign key?

0 Answers  


What is latest version of sql?

0 Answers  


List the ways to get the count of records in a table?

0 Answers  


What is sql mysql pl sql oracle?

0 Answers  


What are sql objects?

0 Answers  


What are the usage of SAVEPOINTS?

5 Answers  






Categories