һ̨Oracle ServerÀïÄÜ·ñ°²×°¶à¸öOracle Database?
ĿǰÕýÔÚ×¼±¸OCAµÄ¿¼ÊÔ£¬µ«ÊǶÔÓÚÒ»¸ö¸ÅÄî²»ÊǺÜÇå³þ¡£
ÎÒĿǰ֪µÀÒ»¸öÊý¾Ý¿â·þÎñOracle Server°üº¬ÁËOracle DatabaseºÍOracle Instance. ÎÒÏÖÔÚÏëÒªÖªµÀ£¬Ò»Ì¨Oracle Server ÉÏÄÜ·ñ°²×°¶à¸öOracle Database, Ò»¸öOracle DatabaseÏÂÄÜ·ñ°²×°¶à¸öʵÀý£¿
Oracle DatabaseºÍOracle Instanceµ½µ×ÓÐɶ·Ö±ð£¿
Ò»¸öserver¿ÉÒÔ°²×°¶à¸ödatabase,ÿ¸ödatabase¶ÔÓ¦Ò»¸öinstance.
databaseÓëinstanceÊÇÒ»¶ÔÒ»µÄ¹ØÏµ.
databaseÊÇÎïÀíÎļþµÄ¼¯ºÏ,¶øinstanceÊÇÄÚ´æÇøµÄ¼¯ºÏ.
ÔÚRAC»·¾³Ï£¬Ò»¸ödatabase¶ÔÓ¦¶à¸öinstance.Ò»¸öinstanceÖ»ÄܶÔÓ¦Ò»¸ödatabase.
Ò»¸öOracle Êý¾Ý¿â¿ÉÒÔÅܶà¸öʵÀý£¨SID£©. ÕâЩµ¥¸öʵÀýÒ²¿ÉÒÔ³ÆÎªÊý¾Ý¿â¡£ ÓеãÈÆ....
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
ллÁË£¬ºÜÓаïÖú£¬ÖÕÓÚÃ÷°×ÁË
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃ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
......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
×Ö¶Î FORGANGUID TOTAL FSTATETYPE
1 0412105DA35645EA9A32AE160EEA25BF 1;1 estIllnessRest;estRetire
2 05AF08C3195B4075847685E96711457D 1 estRegular
3 10EDE82520F24289B7 ......