what is purge command
explain about oracle performance tuning
Answer Posted / 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 |
Post New Answer View All Answers
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Explain the uses of a database trigger?
what is try_catch block in procedure
What are different types of triggers?
what is the syntax used for partition in tsql? : Transact sql
how can we know the number of days between two given dates using mysql? : Sql dba
what is oltp (online transaction processing)? : Sql dba
Does a user_objects view have an entry for a trigger?
How do you sort in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
What is a delimiter in sas?
What are sql procedures?
How do I count rows in sql?
How do I count rows in sql query?
What does t sql mean?