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
DATABASE EXPORT Using Export Utilities
ﻭﻴﺴﻤﻰ ﺃﻴﻀﺎﹰ FULL EXPORT ﻭﺍﻟﻤﻘﺼﻭﺩ ﺒﻪ ﻋﻤل ﺘﺼﺩﻴﺭ ﻟﻜل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻴﺤﺘﺎﺝ ﻫﺫﺍ ﺍﻟﻨﻭﻉ ﻤﻥ ﺍﻟﺘﺼﺩﻴﺭ ﻟﻠﺼﻼﺤﻴﺔ EXP_FULL_DATABASE.
ﻭﻓﻰ ﻫﺫﺍ ﺍﻟﻨﻭﻉ ﻤﻥ ﺍﻟﺘﺼﺩﻴﺭ ﻴﻤﻜﻥ ﺘﻁﺒﻴﻕ ﺍﻟﺨﻴﺎﺭ INCTYPE ﺃﻱ ﺘﺤﺩﻴﺩ ﻨﻭﻉ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻫل (Complete or Cumulative or Incremental).
ﻻﺒﺩ ﻤﻥ ﺍﻟﺘﻨﺒﻴﻪ ﻤﻥ ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ SYS ﻻ ﻴﺘﻡ ﺘﺼﺩﻴﺭﻩ ﻋﻨﺩ ﺘﺼﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
C:\>EXP SYSTEM/SYS FILE=D:\EXPORT\FULL.DMP FULL=Y INCTYPE=COMPLETE |
ﻫﻜﺫﺍ ﻗﻤﻨﺎ ﺒﻌﻤل ﺘﺼﺩﻴﺭ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻟﺨﻴﺎﺭ COMPLETE، ﺍﻵﻥ ﻴﻤﻜﻥ ﺇﻨﺸﺎﺀ ﻨﺴﺨﺔ ﺘﺭﺍﻜﻤﻴﺔ ﺃﻭ ﺘﺯﺍﻴﺩﻴﺔ (Cumulative or Incremental) ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
ﻭﻤﺘﺎﺒﻌﺔ ﺫﻟﻙ ﺒﻭﺍﺴﻁﺔ DBA_EXP_FILES.
SELECT FILE_NAME FROM DBA_EXP_FILE; |
ﺍﻵﻥ ﺴﻨﻘﻭﻡ ﺒﻌﻤل ﻨﺴﺨﺔ ﺘﺭﺍﻜﻤﻴﺔ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
C:\>EXP SYSTEM/SYS FILE=D:\EXPORT\FULL١.DMP FULL=Y INCTYPE=CUMULATIVE |
ﻜﻤﺎ ﻴﻤﻜﻥ ﺍﻻﺴﺘﻌﻼﻡ ﻤﻥ ﺨﻼل ﺍلDBA_EXP_FILES VIEW
ﺍﻻﺴﺘﺨﺩﺍﻡ |
ﺍﻟﻭﺼﻑ |
ﺍﻟﻤﺘﻐﻴﺭ |
EXP & IMP |
ﻟﻌﺭﺽ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ ﺍﻟﻤﺘﺎﺤﺔ ﻟﻭﺴﻴﻠﺔ ﺍﻟﺘﺼﺩﻴﺭ ﺃﻭ ﺍﻻﺴﺘﻴﺭﺍﺩ ﻤﻊ ﺘﻭﻀﻴﺢ ﻤﺨﺘﺼﺭ ﻋﻥ ﺍﻟﻤﺘﻐﻴﺭ |
HELP |
EXP & IMP |
ﻭﺘﺸﻤل ﺍﺴﻡ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻭﻜﻠﻤﺔ ﺍﻟﻤﺭﻭﺭ ﻟﻼﺘﺼﺎل ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ |
USERID |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻤﻜﺎﻥ ﺍﻟﻤﻠﻑ ﻟﺘﺼﺩﻴﺭ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ |
FILE |
EXP & IMP |
ﻹﻨﺸﺎﺀ ﻤﻠﻑ ﻴﺤﻭﻯ ﺘﻔﺎﺼﻴل ﻋﻤﻠﻴﺔ ﺍﻟﺘﺼﺩﻴﺭ ﺃﻭ ﺍﻻﺴﺘﻴﺭﺍﺩ |
LOG |
EXP & IMP |
ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺨﺼﺼﺔ ﻤﻥ ﺍﻟﺫﺍﻜﺭﺓ ﺍﻟﻤﺅﻗﺘﺔ ﻭﺍﻟﺘﻲ ﺘﺴﺘﺨﺩﻡ ﻟﻭﻀﻊ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺼﺩﺭﺓ ﻤﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺇﻟﻰ ﺍﻟﻤﻠﻑ ﺃﻭ ﺍﻟﻤﺴﺘﻭﺭﺩﺓ ﻤﻥ ﺍﻟﻤﻠﻑ ﺇﻟﻰ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ |
BUFFER |
EXP |
ﺃﻗﺼﻰ ﺤﺠﻡ ﻟﻤﻠﻑ ﺍﻟﺘﺼﺩﻴﺭ |
FILESIZE |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻗﺎﺌﻤﺔ ﺍﻟﺠﺩﺍﻭل ﺍﻟﻤﺭﺍﺩ ﺘﺼﺩﻴﺭﻫﺎ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩﻫﺎ |
TABLES |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻤﺎ ﺇﺫﺍ ﻜﻨﺎ ﻨﺭﻴﺩ ﺘﺼﺩﻴﺭ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﻊ ﺍﻟﺠﺩﺍﻭل ﺃﻡ ﻻ |
ROWS |
EXP |
ﻟﻭﻀﻊ ﺸﺭﻭﻁ ﺃﺜﻨﺎﺀ ﺘﺼﺩﻴﺭ ﺍﻟﺠﺩﺍﻭل |
QUERY |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻤﺎ ﺇﺫﺍ ﻜﻨﺎ ﻨﺭﻏﺏ ﻓﻲ ﺘﺼﺩﻴﺭ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩ ﺍﻟﻔﻬﺎﺭﺱ ﺃﻡ ﻻ |
INDEXES |
EXP & IMP |
ﻟﺩﻤﺞ ﺍﻻﻤﺘﺩﺍﺩﺍﺕ ﺍﻟﺨﺎﺼﺔ ﺒﺎﻟﺠﺩﻭل ﺇﻟﻰ ﻭﺍﺤﺩ ﻓﻘﻁ |
COMPRESS |
EXP |
ﻟﻌﻤل ﺇﺤﺼﺎﺌﻴﺎﺕ ﻋﻥ ﺍﻟﺠﺩﺍﻭل ﻭﺍﻟﻔﻬﺎﺭﺱ ﺍﻟﻤﺭﺍﺩ ﺘﺼﺩﻴﺭﻫﺎ |
STATISTICS |
EXP |
ﻫﺫﺍ ﺍﻟﺨﻴﺎﺭ ﻟﻀﻤﺎﻥ ﻋﻤل ﺘﺼﺩﻴﺭ ﻟﻠﻜﺎﺌﻨﺎﺕ ﺩﻭﻥ ﺤﺩﻭﺙ ﺘﻐﻴﻴﺭ ﻓﻲ ﺍﻟﻜﺎﺌﻨﺎﺕ ﺃﺜﻨﺎﺀ ﻋﻤل ﺍﻟﺘﺼﺩﻴﺭ، ﻭﻫﻭ ﻴﺸﺒﻪ ﻭﻀﻊ ﺍﻟﻜﺎﺌﻨﺎﺕ ﻓﻲ ﺍﻟﻨﻤﻁ ONLY READ |
CONSISTENT |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻤﻠﻑ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ ﺍﻟﺫﻱ ﻴﺤﺘﻭﻯ ﻋﻠﻰ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻓﻲ ﻤﻠﻑ ﺍﻟﺘﺼﺩﻴﺭ |
PARFILE |
EXP & IMP |
ﻫل ﺘﺭﻴﺩ ﺘﺼﺩﻴﺭ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩ ﺼﻼﺤﻴﺎﺕ ﺍﻟﻜﺎﺌﻨﺎﺕ |
GRANT |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﺍلTABLESPACES ﺍﻟﻤﺭﺍﺩ ﺘﺼﺩﻴﺭﻫﺎ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩﻫﺎ |
TABLESPACE |
EXP & IMP |
ﻭﻫﻰ ﺘﺴﺘﺨﺩﻡ ﻓﻘﻁ ﻋﻨﺩ ﺍﻟﺘﻌﺎﻤل ﻤﻊ ﺍلTABLESPACE ﻭﻴﺠﺏ ﺃﻥ ﺘﺄﺨﺫ ﺍﻟﻘﻴﻤﺔ Y |
TRANSPORT_TABLESPACE |
EXP |
ﻟﺘﺤﺩﻴﺩ ﻗﺎﺌﻤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﺍﻟﻤﺭﺍﺩ ﺘﺼﺩﻴﺭﻫﻡ |
OWNER |
EXP & IMP |
ﻭﻫﺫﺍ ﺍﻟﺨﻴﺎﺭ ﻟﻌﻤل ﺘﺼﺩﻴﺭ ﺃﻭ ﺍﺴﺘﻴﺭﺍﺩ ﻟﺠﻤﻴﻊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ |
FULL |
EXP & IMP |
ﻭﻫﻭ ﻟﺘﺤﺩﻴﺩ ﻨﻭﻉ ﺍﻟﺘﺼﺩﻴﺭ ﺃﻭ ﺍﻻﺴﺘﻴﺭﺍﺩ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻫﻨﺎﻙ ﺜﻼﺙ ﺃﻨﻭﺍﻉ ﻋﻨﺩ : ﺍﻟﺘﺼﺩﻴﺭ COMPLETE -١ INCREMENTAL -٢ CUMULATIVE -٣ |
INCTYPE |
EXP |
ﻟﺘﺤﺩﻴﺩ ﻤﺎ ﺇﺫﺍ ﻜﺎﻥ ﺍﻟﺘﺼﺩﻴﺭ ﺴﻴﺘﻡ ﺒﻭﺍﺴﻁﺔ ﺍﻷﺴﻠﻭﺏ ﺍﻟﻤﺒﺎﺸﺭ ﺃﻱ ﻋﻥ ﻁﺭﻴﻕ ﻨﻘل ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﻥ ﺍﻟﺩﻴﺴﻙ ﺇﻟﻰ BUFFER CACH |
DIRECT |
EXP & IMP |
ﻟﺘﺤﺩﻴﺩ ﻋﺭﺽ ﺘﻔﺎﺼﻴل ﺍﻟﺘﺼﺩﻴﺭ ﻭﺍﻻﺴﺘﻴﺭﺍﺩ |
FEEDBACK |
IMP |
ﻓﻘﻁ ﻟﻌﺭﺽ ﻤﺎ ﺴﺘﻜﻭﻥ ﻋﻠﻴﻪ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﻴﺭﺍﺩ ﻭﻻ ﻴﺅﺩﻯ ﻟﻼﺴﺘﻴﺭﺍﺩ ﺍﻟﻔﻌﻠﻲ |
SHOW |
IMP |
ﻟﺘﺤﺩﻴﺩ ﺍﺴﻡ ﺃﻭ ﻤﺠﻤﻭﻋﺔ ﺍلSCHEMAS ﺍﻟﺘﻲ ﺘﻡ ﺘﺼﺩﻴﺭ ﺒﻴﺎﻨﺎﺘﻬﺎ ﻭﻨﺭﻴﺩ ﺍﺴﺘﻴﺭﺍﺩ ﺒﻴﺎﻨﺎﺘﻬﺎ |
FROMUSER |
IMP |
ﻟﺘﺤﺩﻴﺩ ﺍﺴﻡ ﺃﻭ ﻤﺠﻤﻭﻋﺔ ﺍلSCHEMAS ﺍﻟﺘﻲ ﻨﺭﻴﺩ ﺘﻭﺭﻴﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﻬﺎ |
TOUSER |
IMP |
ﻟﺘﺤﺩﻴﺩ ﻫل ﺘﺭﻴﺩ ﺘﺠﺎﻫل ﺇﻅﻬﺎﺭ ﺭﺴﺎﺌل ﺍﻟﺨﻁﺄ ﺍﻟﺘﻲ ﺘﻔﻴﺩ ﻭﺠﻭﺩ ﻫﺫﺍ ﺍﻟﻜﺎﺌﻥ ﻤﺴﺒﻘﺎﹰ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ |
IGNORE |
---------------------------------