ORACLE 10g Âß¼µ¼Èë(IMPDP)ÎÊÌâ
ĿǰÎÒÐèÒª½«¹«Ë¾ÀïÃæ·þÎñÆ÷µÄÊý¾Ý¿âÕû¸öµ¼³ö,È»ºóÄõ½¿Í»§ÄÇÀïµ¼Èë½øÈ¥ÓÃ,ÔÚ¹«Ë¾²âÊÔ½×¶ÎÖÐ,³öÏÖµ¼³öÀ´µÄÊý¾Ý¿âDMPÎļþÔÙÖØÐµ¼ÈëÊý¾Ý¿âÒÔºó,Êý¾Ý¿âµÄÆóÒµ¹ÜÀíÆ÷ûÓÐÁË,ÔÚ·þÎñÖÐҲûÓÐCONSOLEÄÇÏî·þÎñÁË,¾¿¾¹ÊÇʲôÔÒòÄØ?Çë¸ßÊÖ½â´ð.Ïêϸµã×îºÃ..Ê®·Ö¸Ðл
consoleûÓÐß·£¿
ÄãµÄµ¼³öºÍµ¼ÈëµÄÊý¾Ý¿â°æ±¾ÊÇÒ»ÖµÄ÷á¡£ ×îºÃ°æ±¾Ò»Ö¡£
×Ö·û¼¯Ò²ÒªÒ»Ö¡£
ÎҸоõÓ¦¸ÃÊÇÄãµÄOracleûÓÐ×°ºÃ°É£¬µ¼ÈëÊý¾Ý²»»áÓ°ÏìÕâ¸öµÄ¡£
·þÎñÖÐÓÐûÓÐCONSOLE£¬ÊÇÄã°²×°Êý¾ÝʱÐèҪעÒâµÄ£¬Õâ¸ö¸úÄãµ¼Èëµ¼³öÊý¾Ý¿âÃ²ËÆÃ»¹ØÏµ°É¡£
Äã²é²éÊDz»Êǰ²×°³öÁËʲôÎÊÌâ¡£
ÎÒ°²×°µÄÊý¾Ý¿âûʲôÎÊÌâ,¿ªÊ¼Ê±ÊÇÓÐEMµÄ,²¢ÇÒÒ²ÓÐCONSOLEµÄ·þÎñ,¶øÇÒ²âÊÔʱÎÒÊÇÔÚ±¾µØµ¼Èëµ¼³öµÄ.ÔÚµ¼ÈëʱΪÁËÄÜÑéÖ¤ÊÇ·ñÕæÕýµ¼Èë,ÎÒÏȰÑ֮ǰ´óʵÀýɾ³ýÁË,È»ºóµ¼ÈëµÄ,²»ÖªµÀ¸úÕâ¸öÓÐûÓйØÏµÄØ,¶øÇÒÎÒÖØÐ½¨Á¢ÊµÀýÒÔºóCONSOLEÓÖÖØÐ³öÏÖÁË,,,
UP
UP
ÕâÖÖÎÊÌâÊǰ²×°ºÍÐ¶ÔØÊ±³öÏֵĴíÎ󣬺͵¼Èëµ¼³öûÓйØÏµ
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......