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 is the difference between functions, procedures, and packages in pl/sql?

473


how to calculate the difference between two dates? : Sql dba

539


What is sql data?

537


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

587


How to pronounce postgresql?

567






What is primary key and unique key?

535


Explain table and field in sql?

567


tell us something about heap tables. : Sql dba

587


Is not equal in sql?

557


How do you explain an index number?

522


What is sqlite used for?

516


Mention what does plv msg allows you to do?

656


What is pivot table in sql?

514


what is a view? : Sql dba

626


What packages(if any) has oracle provided for use by developers?

5011