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

ORACLEÖн¨Á¢×ÔÔö×Ö¶Î

OracleÖв»ÏñÆäËûÈçmysqlµÈÊý¾Ý¿âµÄÓÐ×ÔÔö×ֶΣ¬Èç¹ûÐèÒªÔòÐèÒª½èÖúÐòÁкʹ¥·¢Æ÷
Ê×ÏȽ¨±í
½¨Á¢ÐòÁÐ
½¨´¥·¢Æ÷
For example£º
create table SYS_MESSAGE
(
ID NUMBER not null PRIMARY KEY,
M_TYPE VARCHAR2(10) not null,
TITLE VARCHAR2(200),
CONTENT LONG,
M_TIME VARCHAR2(50),
AUTHOR VARCHAR2(20)
);
CREATE SEQUENCE SYS_MESSAGE_ID_SEQ
INCREMENT BY 1
START WITH 1
NOMAXVALUE
MINVALUE 1
CACHE 50
;

CREATE OR REPLACE TRIGGER SYS_MESSAGE_ID_TRIGGER
BEFORE INSERT ON SYS_MESSAGE
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SYS_MESSAGE_ID_SEQ.NEXTVAL INTO:NEW.ID from DUAL;
END;


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â

Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Àý³Ì£­>ÅäÖã­>Ò»°ãÐÅÏ¢ÖÐ Æô¶¯ºÍÍ£Ö¹Êý¾Ý
Í£Ö¹Êý¾Ý¿âÓ¦¸ÃÑ¡Ôñ£ºµ±ËùÓÐÊÂÎñ½áÊøÊ±¡£
Ò²¿ÉÒÔÓÃÃüÁîÆô¶¯ºÍÍ£Ö¹(ÓÃoracleÓû§µÇ½)
Æô¶¯   £º lsnrctl start     //Æô¶¯ lister
          sqlplus /nolog <<EO ......

oracle archive mode ¹éµµ

ORACLEÊý¾Ý¿âÓÐÁ½ÖÖÔËÐз½Ê½£ºÒ»Êǹ鵵·½Ê½(ARCHIVELOG)£¬¹éµµ·½Ê½µÄÄ¿µÄÊǵ±Êý¾Ý¿â·¢Éú¹ÊÕÏʱ×î´óÏ޶Ȼָ´ËùÓÐÒÑÌá½»µÄÊÂÎï;¶þÊDz»¹éµµ·½Ê½(NOARCHIVELOG)£¬»Ö¸´Êý¾Ý¿âµ½×î½üµÄ»ØÊյ㡣ÎÒÃǸù¾ÝÊý¾Ý¿âµÄ¸ß¿ÉÓÃÐÔºÍÓû§¿É³ÐÊܶªÊ§µÄ¹¤×÷Á¿µÄ¶àÉÙ£¬°ÑÎÒÃÇÕýʽÔËÐеÄÊý¾Ý¿â²ÉÓÃΪ¹éµµ·½Ê½;ÄÇЩÕýÔÚ¿ª·¢ºÍµ÷ÊÔµÄÊý¾Ý¿â²ÉÓò»¹é ......

OracleÊý¾Ý¿âµÄÓÅ»¯Éè¼Æ

[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£­7597(2008)0720043£­01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......

²é¿´oracleµÄϵͳÎļþÄÚÈÝ

ÔÚÃüÁî¸ñʽÏ£¬½øÈësqlplusµÄ±à¼­×´Ì¬ÖÐ
 
£¨1£©²é¿´¿ØÖÆÎļþµÄÄÚÈÝ£º
SQL> DESC v$controlfile
 Ãû³Æ                               &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ