

truncate & drop
تمت كتابته بواسطة
el_saka
, July 27 2006 02:20 PM
3 رد (ردود) على هذا الموضوع
#4
تاريخ المشاركة 11 October 2006 - 10:53 PM
ما الفرق بين Drop و Delete و Trancate ؟؟؟
1- Dropping a Table
عند تشغيل جملة Drop يحدث الأتى:
All data and structure in the table are deleted.1
Any pending transactions are committed.2
All indexes are dropped.3
All constraints are dropped.4
You cannot roll back the DROP TABLE statement.5
DROP TABLE Emp;
2- Trancate a Table
1- All data in the table are deleted but not structure
2- it release table space
3- u cant rollback
delete table 3
1- All data in the table are deleted but not structure
2- u can rollback
1- Dropping a Table
عند تشغيل جملة Drop يحدث الأتى:
All data and structure in the table are deleted.1
Any pending transactions are committed.2
All indexes are dropped.3
All constraints are dropped.4
You cannot roll back the DROP TABLE statement.5
DROP TABLE Emp;
2- Trancate a Table
1- All data in the table are deleted but not structure
2- it release table space
3- u cant rollback
delete table 3
1- All data in the table are deleted but not structure
2- u can rollback
Sameh Bakkar
Lead Oracle HCM Cloud / EBS Consultant & Authorized Trainer
Oracle E-Business R11 Suite Applications Workflow Certified Expert
Oracle E-Business Suite R12 HCM Certified Implementation Specialist
Oracle Fusion HCM Certified Implementation Specialist
Oracle Certified Professional
ITIL V3 Foundation certified
Microsoft Project certified
الموقع الخاص: AppsLead | Learn Oracle From The Leaders