OracleÖбíµÄ¹éÊôÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
OracleÖУ¬ÔÚsqlplusÖÐÓÃij¸öÓû§µÇÈëºó£¬È»ºóÔÚ´´½¨Ò»¸ö±í £¬Õâ¸ö±íÊDz»ÊǾÍÊôÓÚÕâ¸öÓû§£¿
Êǵġ£Ö»ÒªÄã²»´øschemaǰ׺µÄ»°
e.g. create table abc(...)£¬ÄÇÕâ¸öabc¾ÍÊôÓÚµ±Ç°Óû§¡£
Èç¹ûÓÐÁ˺ÏÊʵÄȨÏÞÖ®ºó£¬µ±Ç°Óû§Îªscott£¬ËüÓÐȨÏÞÔÚnajiutanÏ´´½¨±í
create table najiutan.abc(...)£¬ÄÇô¸Ã±íÈÔÈ»ÊôÓÚnajiutan¡£
¿ÉÒÔÕâôÈÏΪ
Êǵģ¬ÊÇÕâÑùµÄ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......