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
bin.
PURGE RECYCLEBIN;
Is This Answer Correct ? | 24 Yes | 1 No |
What is count * in sql?
What is the maximum size of sqlite database?
What is indexing oracle sql?
How to handle bulk data?
What are the three pl sql block types?
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?
Can we use rowid as primary key?
How many primary keys can a table have?
Mention what plvcmt and plvrb does in pl/sql?
full outer join syntax
How does a self join work?
which tcp/ip port does sql server run on? : Sql dba