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
Explain what is dbms?
How can you fetch common records from two tables?
What is the usage of the distinct keyword?
Does a join table need a primary key?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what is the bond code in materialized view?
What will you get by the cursor attribute sql%notfound?
How to prepare for oracle pl sql certification?
What is cold data?
How you improve the performance of sql*loader? : aql loader
What is the difference between alter trigger and drop trigger statements?
What are the two types of periodical indexes?
Can a composite key be null?
What view means?
What are the types of triggers in sql?