Orcale Tutorial Content
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Logical Backup & Recovery
TABLES EXPORT Using Export Utilities
ﻴﺴﺘﻁﻴﻊ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﺼﺩﻴﺭ ﺍﻟﺠﺩﺍﻭل ﺍﻟﺘﻲ ﻴﻤﻠﻜﻬﺎ ﻭﻜﺫﻟﻙ ﻴﺴﺘﻁﻴﻊ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﺼﺩﻴﺭ ﺠﻤﻴﻊ ﺍﻟﺠﺩﺍﻭل ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
ﻭﺃﻴﻀﺎﹰ ﻜل ﻤﻥ ﻴﻤﻠﻙ ﺍﻟﺼﻼﺤﻴﺔ EXP_FULL_DATABASE ﻴﺴﺘﻁﻴﻊ ﺘﺼﺩﻴﺭ ﺠﺩﺍﻭل ﻤﺴﺘﺨﺩﻡ ﺁﺨﺭ، ﺃﻤﺎ ﺒﺩﻭﻥ ﻫﺫﻩ ﺍﻟﺼﻼﺤﻴﺔ ﻓﻼ ﻴﺴﺘﻁﻴﻊ ﺘﺼﺩﻴﺭ ﺠﺩﻭل ﻻ ﻴﻤﻠﻜﻪ.
ﺃ- ﻜﻴﻑ ﻴﺼﺩﺭ ﺍﻟﻤﺴﺘﺨﺩﻡ VBS ﺍﻟﺠﺩﻭل EMPLOYEE ﺍﻟﺫﻱ ﻴﻤﻠﻜﻪ؟
C:\>EXP VBS/VBS FILE=D:\EXPORT\EMPLOYEE.DMP TABLES=EMPLOYEE |
ﻴﻤﻜﻥ ﺼﻴﺎﻏﺔ ﺃﻤﺭ ﺍﻟﺘﺼﺩﻴﺭ ﺃﻋﻼﻩ ﺒﺎﻟﻁﺭﻴﻘﺔ ﺍﻟﺘﺎﻟﻴﺔ
|
ﺍﺨﺘﻠﻔﺕ ﺍﻟﺼﻴﺎﻏﺔ ﻭﻟﻜﻥ ﺍﻟﻨﺘﻴﺠﺔ ﻭﺍﺤﺩﺓ، ﻟﺫﺍ ﻓﻤﻥ ﺍﻷﻓﻀل ﻋﺩﻡ ﻜﺘﺎﺒﺔ ﺍﻟﺨﻴﺎﺭﺍﺕ ﺇﻻ ﺇﺫﺍ ﺃﺭﺩﻨﺎ ﺃﻥ ﻨﻐﻴﺭ ﻓﻲ ﻗﻴﻤﻬﺎ ﺍﻻﻓﺘﺭﺍﻀﻴﺔ، ﻋﻠﻰ ﺴﺒﻴل ﺍﻟﻤﺜﺎل ﻟﻭ ﺃﺭﺩﻨﺎ ﺃﻥ ﻨﺼﺩﺭ ﺍﻟﺠﺩﻭل ﺒﻤﺎ ﻓﻴﻪ ﺍﻟﻘﻴﻭﺩ Constraints
ﻓﻤﻥ ﺍﻷﻓﻀل ﻋﺩﻡ ﻜﺘﺎﺒﺔ ﺍﻟﺨﻴﺎﺭ Constraints=Y ﻭﺫﻟﻙ ﻷﻨﻙ ﺇﺫﺍ ﻟﻡ ﺘﻜﺘﺒﻪ ﺼﺭﺍﺤﺔ ﻓﺈﻥ ﺍﻟﺼﻴﻐﺔ ﺘﺤﺘﻭﻴﻪ ﻀﻤﻨﹰﺎ.
ﺃﻤﺎ ﺇﺫﺍ ﻟﻡ ﺘﺭﻏﺏ ﻓﻲ ﺘﺼﺩﻴﺭ ﺍﻟﻘﻴﻭﺩ ﻤﻊ ﺍﻟﺠﺩﻭل ﻓﺎﻟﻭﺍﺠﺏ ﻜﺘﺎﺒﺔ ﺍﻟﺨﻴﺎﺭ Constraints=N ﻓﻲ ﺼﻴﺎﻏﺔ ﺃﻤﺭ ﺍﻟﺘﺼﺩﻴﺭ، ﻭﻫﻜﺫﺍ ﺒﻘﻴﺔ ﺍﻟﺨﻴﺎﺭﺍﺕ.
ﻭﻟﻨﻔﺘﺭﺽ ﺍﻵﻥ ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ VBS ﻴﺭﻏﺏ ﻓﻲ ﺘﺼﺩﻴﺭ ﺍﻟﺠﺩﻭل EMPLOYEE ﺍﻟﺫﻱ ﻴﻤﺘﻠﻜﻪ ﻭﻟﻜﻥ ﺩﻭﻥ ﺒﻴﺎﻨﺎﺕ.
C:\>EXP VBS/VBS FILE=D:\EXPORT\EMPLOYEE.DMP LOG=D:\EXPORT\EMPLOYEE.LOG TABLES=EMPLOYEE ROWS=N |
ﺏ- ﻜﻴﻑ ﻴﺼﺩﺭ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭ ﻤﻥ ﻴﻤﻠﻙ ﺍﻟﺼﻼﺤﻴﺔ EXP_FULL_DATABASE ﺍﻟﺠﺩﻭل Employee ﺍﻟﻤﻤﻠﻭﻙ ﻟﻠﻤﺴﺘﺨﺩﻡ VBS؟
C:\>EXP SYSTEM/SYS FILE=D:\EXPORT\EMPLOYEE١.DMP LOG=D:\EXPORT\EMPLOYEE1.LOG TABLES=VBS.EMPLOYEE |
ﻻﺤﻅ ﺍﺴﻡ ﺍﻟﺠﺩﻭل ﻤﺴﺒﻭﻗﺎﹰ ﺒﻤﻥ ﻴﻤﻠﻜﻪ TABLES=VBS.EMPLOYEE.
ﺇﺫﺍﹰ ﻟﻴﺱ ﺸﺭﻁﺎﹰ ﺃﻥ ﻴﺼﺩﺭ ﻤﺴﺘﺨﺩﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺠﺩﺍﻭﻟﻪ ﺇﺫ ﻴﺴﺘﻁﻴﻊ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭ ﻤﻥ ﻴﻤﻠﻙ ﺍﻟﺼﻼﺤﻴﺔ EXP_FULL_DATABASE ﺃﻴﻀﺎﹰ ﺘﺼﺩﻴﺭ ﺠﺩﺍﻭل ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
ﺒﺎﻟﻤﻨﺎﺴﺒﺔ ﻟﻭ ﻭﺠﺩ ﺍﻻﻭﺭﻜل ﻓﻲ ﺍﻟﻤﺴﺎﺭ ﺍﻟﻤﺤﺩﺩ ﻹﻨﺸﺎﺀ ﻤﻠﻑ ﺍﻟﺘﺼﺩﻴﺭ FILE.DMP ﻤﻠﻔﺎﹰ ﺁﺨﺭ ﺒﻨﻔﺱ ﺍﻻﺴﻡ ﻓﺎﻨﻪ ﻴﻘﻭﻡ ﺒﺈﻋﺎﺩﺓ ﺍﻟﻜﺘﺎﺒﺔ ﻓﻴﻪ.
ﺍﻵﻥ ﻟﻭ ﺤﺎﻭل ﺍﻟﻤﺴﺘﺨﺩﻡ PENT ﺘﺼﺩﻴﺭ ﺍﻟﺠﺩﻭل EMPLOYEE ﺍﻟﻤﻤﻠﻭﻙ ﻟﻠﻤﺴﺘﺨﺩﻡ VBS ﻤﻊ ﺍﻟﻌﻠﻡ ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ PENTA ﻻ ﻴﻤﻠﻙ ﻫﺫﻩ ﺍﻟﺼﻼﺤﻴﺔ EXP_FULL_DATABSE، ﻓﻤﺎﺫﺍ ﺘﺘﻭﻗﻊ ﺃﻥ ﺘﻜﻭﻥ ﺍﻟﻨﺘﻴﺠﺔ؟
ﺍﻟﻨﺘﻴﺠﺔ ﻫﻲ EXP-900000 no privilege to export VBS table EMPLOYEE.
ﻟﻴﺱ ﻟﺩﻴﻙ ﻫﺫﻩ ﺍﻟﺼﻼﺤﻴﺔ ﻟﺫﺍ ﻓﺸﻠﺕ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺼﺩﻴﺭ.
ﻟﻨﻔﺘﺭﺽ ﺍﻵﻥ ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ VBS ﻴﺭﻴﺩ ﺃﻥ ﻴﺼﺩﺭ ﺍﻟﺠﺩﻭل EMPLOYEE ﺍﻟﺫﻱ ﻴﻤﺘﻠﻜﻪ ﻭﻟﻜﻥ ﻴﺭﻴﺩ ﺃﻥ ﻴﺼﺩﺭ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺸﺭﻁ ﻤﻌﻴﻥ ﻤﺜﻼﹰ WHERE EMP_NO=2.
ﻫﻨﺎ ﻨﺴﺘﺨﺩﻡ ﺍﻟﺨﻴﺎﺭ Query.
C:\>EXP VBS/VBS FILE=D:\EXPORT\EMPLOYEE.DMP TABLES=EMPLOYEE QUERY=’WHERE EMP_NO=2' |
---------------------------------------