ÎÒ´ÓÊÂÁË7ÄêµÄSQL SERVER¹¤×÷ÁË£¬µ«ÊǶÔORACLEÒ»µã²»¶®¡£
Âé·³´ó¼ÒÍÆ¼ö±¾ORACLEÈëÃŵÄÊé¼®¡£¶àл£¡
ѧϰÏÂORACLE
Ó¢ÎÄ¿ÉÒԵϰ¿´¿´¹Ù·½ÎĵµCONCEPTS
ÓÐÄÇô¾ÃµÄÊý¾Ý¿âʹÓþÑéÁË
ºÇºÇ Ó¦¸Ã²»ÄÑ
ÒýÓÃ
ѧϰÏÂORACLE
www.itpub.net
ÒýÓÃ
Ó¢ÎÄ¿ÉÒԵϰ¿´¿´¹Ù·½ÎĵµCONCEPTS
ÓÐÄÇô ......
ÓÉÓÚ·þÎñÆ÷ÖØÐ²¿Ê𣬵¼ÖÂÓÉÓÚ²Ù×÷ϵͳ²»Ö§³ÖÖÐÎÄ£¨Ê¹ÓÃen_us.Utf-8×Ö·û¼¯£©£¬µ¼ÖÂÒ»²¿·ÖÊý¾Ý´æ·ÅÊý¾Ý¿âʱ²»ÊÇÒÔgbk±àÂë´æ´¢¡£ÏÖÔÚÈ¡³öÀ´µÄÊý¾ÝÈ«²¿ÊÇ?ºÅ¡£ÀýÈ磺¡°???????????????????????????????????????????????????????????????u??????????????????????????????????u?????????????????????????u?????????????????????? ......
ÎÒÓõÄÊÇoracle 10gÖ´ÐÐÁËÒÔÏÂÁ½²½£º
1.¿ªÊ¼->cmd->sqlplus system/password as sysdba
Ìáʾ£ºÒÑÁ¬½Ó
2.SQL>shutdown normal
È»ºó£¬´°¿Ú¾Í²»¶¯ÁË¡£
µÈÁË20¶à·ÖÖÓ£¬ÎÒÔÙÖ´ÐС°sqlplus system/password¡±ÏëÁ¬½ÓÊý¾Ý¿â£¬ËüÌáʾ¡°ORA-01090£ºÕýÔڹرÕ-²»ÔÊÐíÁ¬½Ó¡±¡£
Ôõô¹Ø± ......
ÇóÒ»¸öoracle»ù´¡Åàѵ´ó¸Ù£¡
¾ÍÊÇÐèÒªÁгöoracle»ù´¡ÅàѵµÄÏêϸÄÚÈÝ¡£
±ÈÈ磺
1.ÕÆÎÕoracleÌåϵ½á¹¹£ºÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡£¡£¡£
2.ÕÆÎÕ»ù±¾sql¿ª·¢Óï¾ä£ºddl¡¢dml¡£¡£¡£
µÈµÈ¡£¾ÍÊÇÒ»¸öoracleÈëÃŵÄÅàѵ¼Æ»®»ò´ó¸Ù¡£
лл¡£ÎÒÓÊÏäÊÇtanleixy@163.com
{{ ......
±í½á¹¹£ºunit_code state_code state_change_date
K1 S01 2009-11-11
K1 S01 2009-1 ......
RT
ÒýÓÃ
dmpµÄÎļþµ¼ÈëÖ®ºó,Ëæ±ãÑ¡Ôñһϱí,¿´Ò»ÏÂÊý¾Ý¾ÍÖªµÀÓÐûÓе¼Èë³É¹¦!
imp µ¼ÈëÖ®ºóÒ²»áÔÚµ¼ÍêÊý¾Ý,»á¸æËß²Ù×÷ÕßÓÐûÓгɹ¦!
¸Õѧɶ¶¼²»Ã÷°×лл°¡
ÄãʲôÓû§µ¼Èë½øÈ¥µÄ£¬¾ÍÓøÃÓû§µÇ¼½øÈ¥¿ÉÒÔÖ±½Ó²é¿´±íÊÇ·ñµ¼Èë³É¹¦
......