what is purge command
explain about oracle performance tuning
Answers were Sorted based on User's Feedback
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|
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
|Is This Answer Correct ?||24 Yes||1 No|
What is integrity constraints?
What is the purpose of cursors in pl/sql?
how to debugg a procedure or package using dbms_output.put_line in plsql
How do I view a procedure in sql?
Is truncate ddl or dml?
Why do we use cursors?
Is it possible for a table to have more than one foreign key?
What is latest version of sql?
List the ways to get the count of records in a table?
What is sql mysql pl sql oracle?
What are sql objects?
What are the usage of SAVEPOINTS?