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 are date and time data types in mysql? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
How is debugging done?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is a dirty read sql?
what is a trigger? : Sql dba
What is sql comments?
What is consistency?
Can there be 2 primary keys in a table?
What is a temporal data type?
What are inbuilt functions in sql?
Why do you partition data?
what is a composite primary key ? : Sql dba
What is difference between pl and sql?
What is difference between my sql and sql?