truncate & drop
تمت كتابته بواسطة
el_saka
, July 27 2006 02:20 PM
3 رد (ردود) على هذا الموضوع
أعلى
#4
sameh bakkar
-
- فريق الإشراف
-
- 1,019 مشاركة
مشرف قسم المبتدئين
-
البـلـد:
تاريخ المشاركة 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
Principal Oracle Apps Techno-Functional Consultant / Oracle E-Business Suite Certified Trainer
Oracle E-Business R11 Suite Applications Workflow Certified Expert
Oracle E-Business Suite R12 HCM Certified Implementation Specialist
Oracle Certified Professional
ITIL V3 Foundation certified
Microsoft Project certified
الموقع الخاص: AppsLead | Your Honest Guide | Sameh Bakkar
