Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle´Ó·Ç¹éµµÄ£Ê½±ä³É¹éµµÄ£Ê½

http://www.cuijie.net.cn/?cat=6
¸ü¸ÄÊý¾Ý¿âµÄ¹éµµÄ£Ê½ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬ÔÚmountģʽÏÂÐ޸쬼òÒª²½Öè
1   ÒÔshutdown immediate ·½Ê½¹Ø±ÕÊý¾Ý¿â
2  Æô¶¯ÊµÀýµ½mount״̬
3  ¸ü¸ÄÔËÐÐģʽ²¢´ò¿ªÊý¾Ý¿â
²Ù×÷²½Ö裺
1   µÇ¼Êý¾Ý¿â²é¿´Êý¾Ý¿âµÄ¹éµµ×´Ì¬
     SQL> archive log list;
     Èç¹û³öÏÖÐÅÏ¢£º
     Database log mode              No Archive Mode
     Automatic archival             Disabled
     ÔòΪ·Ç¹éµµÄ£Ê½
2  ¹Ø±ÕÊý¾Ý¿â
     SQL>shutdown immediate;
3   Æô¶¯Êý¾Ý¿âµ½mount״̬
     SQL>startup mount;
4   Æô¶¯¹éµµÄ£Ê½
     SQL>alter database archivelog;       (·Ç¹éµµÄ£Ê½Îª£ºalter database noarchivelog)
  
5   ´ò¿ªÊý¾Ý¿â
     SQL>alter database open;
      ²é¿´¹éµµÄ£Ê½×´Ì¬
     SQL>archive log list
      Èç¹û³öÏÖÐÅÏ¢£º
      Database log mode              Archive Mode
      Automatic archival             Enabled
      ³É¹¦¸Ä³É¹éµµÄ£Ê½
http://uplinux.com/online/dodev/sjk/2009/1103/243.html
OracleÊý¾Ý¿â¿ÉÒÔÔËÐÐÔÚ2ÖÖģʽÏÂ:¹éµµÄ£Ê½(archivelog)ºÍ·Ç¹éµµÄ£Ê½(noarchivelog)
¹éµµÄ£Ê½¿ÉÒÔÌá¸ßOracleÊý¾Ý¿âµÄ¿É»Ö¸´ÐÔ£¬Éú²úÊý¾Ý¿â¶¼Ó¦¸ÃÔËÐÐÔÚ´ËģʽÏ£¬¹éµµÄ£Ê½Ó¦¸ÃºÍÏàÓ¦µÄ±¸·Ý²ßÂÔÏà½áºÏ£¬Ö»Óй鵵ģʽûÓÐÏàÓ¦µÄ±¸·Ý²ßÂÔÖ»»á´øÀ´Âé·³¡£
±¾Îļòµ¥½éÉÜÈçºÎÆôÓú͹رÕÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
1.shutdown normal»òshutdown immediate¹Ø±ÕÊý¾Ý¿â
[oracle@jumper oracle]$ sqlplus "/ as sysdba"


Ïà¹ØÎĵµ£º

Oracle³£ÓÃÓï¾ä

--ÈçºÎÓÃgrade±íµÄ×ÊÁÏÈ¥¸üÐÂusertable±íµÄ×ÊÁÏ£¨ÓйØÁªµÄ×Ö¶Îuserid£©
 update usertable u set u.grade =
 (select g.grade from grade g where g.userid = u.userid);
 
--ÈçºÎʹ²éѯ½á¹û×Ö¶ÎÉú³ÉÐòºÅ
select rownum, t.* from sm_t_pad_new t
--ÈçºÎ¿ìËÙ×öÒ»¸öºÍÔ­±íÒ»ÑùµÄ±¸·Ý±í
 create ......

ÓÅ»¯select count(*) (תoracleÅàѵÀÏʦµÄÎÄÕÂ)


select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 sele ......

linuxÉÏʹÓÃrlwrap ½â¾öoracle¿ÉÒÔÉÏϼü²é¿´ÃüÁî

linux ÉϵÄoracle sqlplus ²»ÄÜÀûÓà ÉÏ, Ï ¼üÀ´²é¿´ÃüÁËÑË÷µ½½â¾öÎÊÌâµÄ°ì·¨£¬ÕûÀíÈçÏÂ
°²×°Èí¼þrlwrap¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣬¸ÃÈí¼þÊÇÓÃcдµÄ³ÌÐò
¹Ù·½ÏÂÔØµØÖ·£ºhttp://utopia.knoware.nl/~hlub/uck/rlwrap/
°²×°¹ý³Ì£º
ÎÒÃÇÒ²¿ÉÒԲ鿴½âѹºóµÄtar°ü£¬²é¿´README°ïÖúÎļþ
shell>tar -zxvf rlwrap-0.36.tar.gz
sh ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â


    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......

OracleÓû§¹ÜÀí

--´´½¨±í¿Õ¼ä
create tablespace Ãû³Æ
(
datafile='·¾¶\Ãû³Æ.ora',
size='50M',
autoextend='on'
)
/
--´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace Ãû³Æ
(
tempfile='·¾¶\Ãû³Æ.ora',
size='50M',
autoextend='on'
)
/
--´´½¨Óû§
create user Óû§Ãû  idtenified  by ÃÜÂë
/
--ΪÓû§Ö¸¶¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ