OracleÓÃimpºÍexpʵÏÖÊý¾ÝµÄµ¼ÈëºÍµ¼³ö
ImpºÍExp
ÃüÁîÏê½â:
Exp
µ¼³ö
ģʽ:
Fullģʽ---µ¼³ö
Õû¸öÊý¾Ý¿â
Userģʽ---µ¼³ö
Ö¸¶¨µÄÓû§
Tableģʽ—µ¼³ö
Ö¸¶¨µÄ±í
Tablespaceģʽ—µ¼³ö
±í
¿Õ¼ä
Exp
µ¼³ö
²ÎÊý:
OWNERÖ¸¶¨Òªµ¼³ö
µÄÓû§Áбí
FULL=y±íʾҪµ¼³ö
Õû¸öÊý¾Ý¿â
TablesÖ¸¶¨Òªµ¼³ö
µÄ±í
TablepacesÖ¸¶¨Òªµ¼³ö
µÄ±í
¿Õ¼ä
ROWS=y±íʾµ¼³ö
±í
Êý¾Ý
,·ñÔòÖ»µ¼³ö
±í
µÄ½á¹¹.
HELP=Y±íʾҪ»ñÈ¡°ïÖú
IndexsÖ¸¶¨ÊÇ·ñµ¼³ö
Ë÷Òý
Grants±íʾÊÇ·ñµ¼³ö
ÊÚȨ
QUERYÖ¸¶¨²éѯÌõ¼þ,ÔÊÐíÓû§µ¼³ö
±í
µÄÒ»²¿·ÖÊý¾Ý
TriggersÖ¸¶¨ÊÇ·ñµ¼³ö
´¥·¢Æ÷
1.Full
ģʽ:
°ÑÊý¾Ý¿âorclÍêÈ«µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
system/pafirc@orcl file=e:\ pafirc.dmp full=y
2.User
ģʽ:
°Ñsystem,pafircÓû§µÄ±í
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp owner=(system, pafirc)
3.Table
ģʽ:
°Ñ±í
tab_projµ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj)
4.
±¸·Ý±í
ÖеIJ¿·ÖÊý¾Ý
°Ñ±í
tab_projÖеÄ×Ö¶ÎbudgetСÓÚ500000Êý¾Ý
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj) query=\" where budget<500000\"
ÈçÏÂͼ:
clip_image014
Imp
ÃüÁîÊý¾Ý
µÄµ¼Èë
ÀàËÆexp
,Ö»Òª°Ñexp
»»³Éimp¾Í¿ÉÒÔ,Èç¹ûµ¼Èë³É¹¦,»áÓÐÏÂÃæµÄÌáʾ:
clip_image016
clip_image018
Èý.´´½¨Óû§¼°ÊÚȨ
1.´´½¨Óû§:
CREATE USER PAFIRC
IDENTIFIED BY PAFIRC
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
2.ÊÚÓèÓû§È¨ÏÞ
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
GRANT CONNECT TO PAFIRC WITH ADMIN OPTION;
GRANT RESOURCE TO PAFIRC WITH ADMIN OPTION;
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
ALTER USER PAFIRC DEFAULT ROLE DBA,CONNECT,RESOURCE;
Ïà¹ØÎĵµ£º
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐзҳµÄÔʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN >= 21 ......
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin200 ......
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣡ¡¡¡ ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ ......
½çÃ濪·¢ÈËÔ±±¨ÓкܶàÖظ´Êý¾ÝÔÚÓû§È¨ÏÞ±í¡£È»ºóÎÒɾ³ýÁ˱íÊý¾Ýdelete ·½Ê½£¬ÐÞ¸ÄÁ˶ÔÓ¦µÄ´æ´¢¹ý³Ìʹ֮²»Öظ´£¡
ºóÀ´·¢ÏÖ ÖØÐÂÀ»ØµÄÊý¾ÝûȨÏÞ¡£ Ö»ºÃÉÁ»Øµ½½ñÌìÁ賿ÁË£¡
SQL> ALTER TABLE BA.T_POWER_ADMIN ENABLE ROW MOVEMENT;
Table altered
SQL> flashback table ba.t_Power_Admin to tim ......