Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is purge command
explain about oracle performance tuning

Question Posted / husenaiahb

Answers were Sorted based on User's Feedback



what is purge command explain about oracle performance tuning..

Answer / 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

what is purge command explain about oracle performance tuning..

Answer / pooja

Use the PURGE statement to remove a table or index from
your recycle bin and release all of the space associated
with the object, or to remove the entire recycle bin, or to
remove part of all of a dropped tablespace from the recycle
bin.
PURGE RECYCLEBIN;

Is This Answer Correct ?    24 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is union, minus and interact commands?

0 Answers  

Can we rollback truncate?

0 Answers  

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

How do you optimize a stored procedure query?

0 Answers  

What is function and procedure?

0 Answers  

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

Is sql sequential or random?

0 Answers  

Why we use sql profiler?

0 Answers  

Is microsoft sql free?

0 Answers  

What is sql basics?

0 Answers  

What is sql server and ase?

0 Answers  

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

For more SQL PLSQL Interview Questions Click Here
Categories