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 >> Oracle >> Oracle General
  2. Suggest New Category

what is exact difference between drop and truncate table.

Question Posted / samad

Answer Posted / samad

ya its correct sowjanya

DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible

DELETE - deletes all records from a table, the space for the
records remain rollback is possible

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens in oracle commit?

1027

What is set operator oracle?

980

How to create a new tablespace in oracle?

987

What is program global area (pga) in oracle?

1030

Why we use bulk collect in oracle?

1044

What exactly do quotation marks around the table name do?

963

Can select statements be used on views in oracle?

1027

what is reindexing?

1678

How data locks are respected in oracle?

1071

Describe varray?

1059

What do you understand by database schema and what does it hold?

1230

What operating systems are supported by oracle database 10g xe?

1034

How do you find current date and time in oracle?

1047

Explain the use of tables option in exp command.

1117

Why does oracle 9i treat an empty string as null?

1056