oracleºº×ÖתƴÒô
Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË
ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð
ÄÄλ˧¸çÄܸøÏêϸµÄ˵һϰ¡ ¸Ðл
{{
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÏÖÓÐÒ»¸ö´æ·ÅÁ˿ռäÊý¾ÝµÄ±í£¬ÎÒÏëͨ¹ýsql³ÌÐò£¬°ÑÀïÃæµÄ×ø±êÐÅÏ¢¶Á³öÀ´£¬ÄÄλ°ïæ¸øÐ´¶Î³ÌÐò°É¡£
Çë°ÑÄãµÄ ±í½á¹¹¡¢²âÊÔÊý¾Ý¡¢ºÍ×îÖյĽá¹û Ìù³öÀ´£¬ÕâÑùÁýͳ£¬Ôõô°ïÄã¡£¡£¡£¡£
ÌùÊý¾ÝÉÏÀ´!
ÒýÓÃ
ÌùÊý¾ÝÉÏ ......