oracle ÔöÁ¿±¸·Ý»Ö¸´²ßÂÔ(»ù´¡ÖªÊ¶)
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆת´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁÈ¡Ò»¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´ÐÐÆäÖеÄÃüÁî¡£´Ë±¸·Ý·½Ê½ÊÇͨ¹ýOracleµÄʵÓù¤¾ßexportºÍimportÀ´ÊµÊ©µÄ£¬
exportÊÇ°ÑÊý¾Ý¿âÖеÄÊý¾Ýµ¼³ö£¬importÊÇ°Ñexportж³öµÄÊý¾Ýµ¼ÈëÊý¾Ý¿âÖС£Í¨¹ý´Ë¹¤¾ß¿ÉÒÔÑÜÉú³ö¶àÖÖ¹¦ÄÜ,
±ÈÈçÕû¸öÊý¾Ý¿âµÄ±¸·Ý¡¢±í½á¹¹Öؽ¨¡¢Êý¾ÝµÄ´«Êä¡¢Óû§µÄ¸Ä±äµÈµÈ¡£
Oracle Export/Import¹¤¾ßÌṩÁËÁé»î¶àÑùµÄ¹¦Äܺ͵¼³ö/µ¼Èëģʽ£¬×ʹÓõÄÈýÖÖģʽÊÇUser¡¢tableºÍfull database¡£³ý´ËÒÔÍ⣬»¹¿ÉÒÔÔÚµ¼³ö/µ¼Èëʱ¾ö¶¨ÊÇ·ñ°üº¬Óë¶ÔÏóÓйصÄÊý¾Ý×ÖµäÐÅÏ¢£¬ÈçË÷Òý¡¢Ô¼Êø¡¢È¨Ï޵ȵȡ£
×¢Ò⣺ͨ¹ýÂß¼±¸·Ý¿ÉÒÔ±¸·ÝÕû¸öÊý¾Ý¿â, »ò½ö±¸·Ý²¿·ÖÖØÒªÊý¾Ý¡£ÒòΪÊÇÂß¼Éϵı¸·Ý,¹ÊÖ»ÄÜÓÃÓÚÂß¼µÄ»Ö¸´Êý¾Ý, Ò»µ©Êý¾Ý¿â±»ÎïÀíËð»µ, µ¼Ö²»ÄÜÆô¶¯,Âß¼±¸·ÝµÄÊý¾Ý²»ÄÜ°ïÖú»Ö¸´Êý¾Ý¿â¡£
1. Export/ImportµÄʹÓþÙÀý£º£¨ÒÔϲÙ×÷¾ùΪÔÚ
(1). ½«Ò»¸öÓû§µÄ¶ÔÏóµ¼Èëµ½ÁíÒ»¸öÓû§Ä£Ê½ÖУº
°ÑÊý¾Ý¿âÖÐÔÓеÄÓû§ExportÖÁÒ»¸ödmpÎļþ£¨Èç°ÑÓû§olduserµÄ¶ÔÏóµ¼³öµ½Îļþolduser0701.dmpÖУ©£º
$ exp sys/password file= olduser0701 owner=olduser grant=N indexes=Y rows=Y
´ÓdmpÎļþÖаÑÒ»¸öÓû§µÄ¶ÔÏóimportÖÁÒ»¸öÓû§µÄģʽÖУ¨´Óolduser0701.dmpÖУ¬°ÑÓû§olduserµÄ¶ÔÏóµ¼Èëµ½Óû§newuserÖУ©£º
$imp sys/password file=olduser0701 fromuser=olduser touser=newuser indexes=Y rows=Y
(2). µ¼Èëʱ±ÜÃâ³öÏÖORA-00942(±í»òÊÇͼ²»´æÔÚ)´íÎó:
ÒòΪ£¬µ¼³öÊÇ°´ÕÕÔÚÊý¾Ý¿âÖжÔÏó½¨Á¢µÄ˳Ðò½øÐеģ¬´Ó¶øÔÚµ¼Èëʱ£¬Êý¾Ý¿â¶ÔÏóÖ®¼äµÄÒÀÀµÐÔ»áÒýÆðijЩÏȵ¼Èë¶ÔÏóÕÒ²»µ½ÆäÒÀÀµ¶ÔÏó£¨Èçview¡¢
procedureµÈµÈ£©£¬¾Í»áÒýÆðORA-00942(±í»òÊÇͼ²»´æÔÚ)´íÎó¡£Í¨³£½â¾öÕâÖÖÎÊÌâµÄ·½·¨ÊÇ£¬×öÁ½´Îµ¼È빤×÷£¬µÚÒ»±éµ¼ÈëʱÉèÖÃÈçÏ£º
$ imp sys/password file=demo0701 full=Y commit=y rows=Y
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æΪһ¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡Ô ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING ......
INTÀàÐÍÊÇNUMBERÀàÐ͵Ä×ÓÀàÐÍ¡£
ÏÂÃæ¼òҪ˵Ã÷£º
£¨1£©NUMBER£¨P,S£©
¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨ÒåÊý×ÖÀàÐ͵ÄÊý¾Ý£¬ÆäÖÐP±íʾÊý×ÖµÄ×ÜλÊý£¨×î´ó×Ö½Ú¸öÊý£©£¬¶øSÔò±íʾСÊýµãºóÃæµÄλÊý¡£¼ÙÉ趨ÒåSALÁÐΪNUMBER£¨6,2£©ÔòÕûÊý×î´óλÊýΪ4루6-2=4£©£¬¶øСÊý×î´óλÊýΪ2λ¡£
£¨2£©INTÀàÐÍ
µ±¶¨ÒåÕûÊýÀàÐÍʱ£¬¿ÉÒÔÖ±½ÓʹÓÃNU ......