oracle µ¼Èëºó ÔÚÄIJ鿴 - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ´ÓÁíÍâһ̨»ú×ÓÉϵÄoracleÉϵ¼³öÁËÒ»¸öÓû§A£¬µÃµ½A.DMP£¬µ¼³öÊdzɹ¦µÄ¡£ È»ºó£¬ÔÚÎҵĻú×ÓÉϵ¼ÈëÁËoracleÖУ¬ÎÒÔÚÓû§BϽøÐеÄIMPµ¼È룬ÏÔʾ³É¹¦ÖÕÖ¹µ¼È룬ûÓгöÏÖ¾¯¸æ£¬¿ÉÎҵǼµ½BÒÔºó£¬È´Ã»Óз¢ÏÖÓÐÈκε¼ÈëµÄ¶«Î÷£¬ÓÃPL/SQLÒ²¿´²»¼û¡£Çë¸÷λ°ïæָ½Ìһϣ¬Èç¹û²é¿´µ¼ÈëµÄÓû§¡£¼±£¡
exp/imp Óï¾äÔõôдµÄ£¿¡¡Ìù³öÀ´¿´¿´..
ÄãÊDz»Êǵ¼ÈëÁ˱ðµÄÓû§ÖÐÈ¥ÁË
лл¥ÉϵÄÌáÐÑ£¬ÎÒ¸Õ²ÅÊǰ´×ÅimpµÄÌáʾÃüÁî½øÐеĵ¼È룬½á¹ûÒ²²»ÖªµÀµ¼Èëµ½ÄÄÁË£¬ÏÖÔÚ°´×ÅÄã˵µÄÎÒµ¼Èë½øÈ¥ÁË¡£ÔÙ´Îлл£¡
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......