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
What is the difference between functions, procedures, and packages in pl/sql?
how to calculate the difference between two dates? : Sql dba
What is sql data?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How to pronounce postgresql?
What is primary key and unique key?
Explain table and field in sql?
tell us something about heap tables. : Sql dba
Is not equal in sql?
How do you explain an index number?
What is sqlite used for?
Mention what does plv msg allows you to do?
What is pivot table in sql?
what is a view? : Sql dba
What packages(if any) has oracle provided for use by developers?