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


Please Help Members By Posting Answers For Below Questions

What does the file extension accdb stand for?

723


Why is pl sql needed?

689


What is before trigger?

745


What is meant by cursor in sql?

738


What does the argument [or replace] do?

821


What is sql injection owasp?

743


What is the difference between cluster and non-cluster index?

820


how is myisam table stored? : Sql dba

791


How do I write a sql query in pgadmin 4?

729


Explain the the update statement in sql?

782


What is data type in database?

742


What is not null in sql?

800


Which are the different types of indexes in sql?

770


Explian rowid, rownum?

761


how can we destroy the cookie? : Sql dba

752