ʹÓÃOracle µÄ imp ,exp ÃüÁîʵÏÖÊý¾ÝµÄµ¼Èëµ¼³ö
Ò».˵Ã÷
oracle µÄexp/impÃüÁîÓÃÓÚʵÏÖ¶ÔÊý¾Ý¿âµÄµ¼³ö/µ¼Èë²Ù×÷;
expÃüÁîÓÃÓÚ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öÖÁ±¾µØ,Éú³ÉdmpÎļþ;
impÃüÁîÓÃÓڰѱ¾µØµÄÊý¾Ý¿âdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶³ÌµÄOracleÊý¾Ý¿âÖС£
¶þ.Óï·¨
¿ÉÒÔͨ¹ýÔÚÃüÁîÐÐÊäÈë imp help=y »ñÈ¡impµÄÓï·¨ÐÅÏ¢:
=============================================================================
C:\Documents and Settings\auduser>imp help=y
Import: Release 9.0.1.1.1 - Production on ÐÇÆÚ¶þ 5ÔÂ 20 18:21:57 2008
(c) Copyright 2001 Oracle Corporation. All rights reserved.
¿ÉÒÔͨ¹ýÊäÈë IMP ÃüÁîºÍÄúµÄÓû§Ãû/¿ÚÁî
ºó½ÓÓû§Ãû/¿ÚÁîµÄÃüÁî:
Àý³Ì: IMP SCOTT/TIGER
»òÕß, ¿ÉÒÔͨ¹ýÊäÈë IMP ÃüÁîºÍ¸÷ÖÖ²ÎÊýÀ´¿ØÖÆ“µ¼Èë”
°´ÕÕ²»Í¬²ÎÊý¡£ÒªÖ¸¶¨²ÎÊý£¬Äú¿ÉÒÔʹÓùؼü×Ö:
¸ñʽ: IMP KEYWORD=value »ò KEYWORD=(value1,value2,...,vlaueN)
Àý³Ì: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
»ò TABLES=(T1: P1,T1: P2)£¬Èç¹û T1 ÊÇ·ÖÇø±í
USERID ±ØÐëÊÇÃüÁîÐÐÖеĵÚÒ»¸ö²ÎÊý¡£
¹Ø¼ü×Ö ËµÃ÷£¨Ä¬ÈÏ£© ¹Ø¼ü×Ö ËµÃ÷£¨Ä¬ÈÏ£©
--------------------------------------------------------------------------
USERID Óû§Ãû/¿ÚÁî FULL µ¼ÈëÕû¸öÎļþ (N)
BUFFER Êý¾Ý»º³åÇø´óС fromUSER ËùÓÐÈËÓû§ÃûÁбí
FILE ÊäÈëÎļþ (EXPDAT.DMP) TOUSER Óû§ÃûÁбí
SHOW Ö»ÁгöÎļþÄÚÈÝ (N) TABLES ±íÃûÁбí
IGNORE ºöÂÔ´´½¨´íÎó (N) RECORDLENGTH IO ¼Ç¼µÄ³¤¶È
GRANTS µ¼ÈëȨÏÞ (Y) INCTYPE &nbs
Ïà¹ØÎĵµ£º
1.1.1 °²×°OracleÊý¾Ý¿â·þÎñ¶Ë
°´ÕÕ°²×°Ïòµ¼£¬ÕýÈ·°²×°Oracle 9i¡£
°´ÕÕĬÈÏÑ¡Ïµã»÷ÏÂÒ»²½£¬¼´¿É¡£
ͼ 2 2 Oracle °²×°Ïòµ¼ - »¶ÓʹÓÃ
ͼ 2 3 Oracle °²×°Ïòµ¼ - Îļþ¶¨Î»
ÕâÀÐè×¢ÒâOracleµÄ°²×°Îļþ·¾¶²»ÄÜ°üº¬¿Õ¸ñºÍÖÐÎÄÃû¡£Ä¬ÈÏ°²×°Â·¾¶ÊÇD:\oracle\ora92,ÕâÀィÒéʹÓÃÕâ¸ö°²×°Â·¾¶¡££¨°²×°£© ......
1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size  ......
author£ºskate
time£º2010/03/03
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORA ......
ת×Ô£ºhttp://hi.baidu.com/magus163/blog/item/a4f783178e39ef00c93d6de6.html
¡¾ÕâƪÎÄÕÂÀý×Ó½²½âµÄ±È½ÏÏêϸ£¬ÎÒ¾Íת¹ýÀ´ÁË¡¿
Oracle9iÒýÈëÁËMERGEÃüÁî,ÄãÄܹ»ÔÚÒ»¸öSQLÓï¾äÖжÔÒ»¸ö±íͬʱִÐÐinsertsºÍupdates²Ù×÷. MERGEÃüÁî´ÓÒ»¸ö»ò¶à¸öÊý¾ÝÔ´ÖÐÑ¡ÔñÐÐÀ´updating»òinsertingµ½Ò»¸ö»ò¶à¸ö±í.
Oracle 10gÖÐMERGEÓÐÈ ......