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

oracleÆô¶¯¹ý³Ì

Æô¶¯¸÷¸öģʽµÄ¹ý³Ì£º
1.nomount ----¶Á²ÎÊýÎļþ---À©ÄÚ´æ/Æô½ø³Ì£¨Ö÷ÒªÊÇÖؽ¨¿ØÖÆÎļþ£©
2.mount ------¶Á²ÎÊýÎļþ---ÕÒ¿ØÖÆÎļþ---¿ª¿ØÖÆÎļþ---ÕÒÊý¾ÝÎļþ/ÈÕÖ¾ÎļþλÖÃÓëÃû³Æ---ÁªÏµÊµÀýÓëÊý¾Ý¿â
  £¨Ö÷ÒªÊǻָ´Êý¾Ý¿â£©
3.open--------´ò¿ªÊý¾ÝÎļþ---´ò¿ªÈÕÖ¾Îļþ


Ïà¹ØÎĵµ£º

OracleÖÐ Alter Table Óï¾äµÄʹÓÃ

alter table µÄ¹¦ÄÜÊÇÐ޸ıí¸ñ¡£°üÀ¨ÖØÃûÃü£¬¼Ó¼õ×Ö¶Î,ÐÞ¸Ä×Ö¶ÎÀàÐͺʹóС£¬´¦Àí Ô¼ÊøµÈµÈ¡£±¾Àý×ÓÖ®´¦Àí±íÃûºÍ×ֶΣ¬´úÂëÈçÏ£º
create table liu(a varchar2(20),b number(2))
alter table liu rename to jin
rename jin to cai
alter table cai add  c varchar2(30)
alter table cai add  (d varchar2(3 ......

.NetÓëOracleµÄÊý¾Ý¿âÁ¬½Ó³Ø


ʱ¼ä: 2006-06-15  À´×Ô£ºCSDN
< type="text/javascript"><!--
google_ad_client = "pub-0103898066674568";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text";
google_ad_channel = "";
google_color_ ......

Ïòoracle±íÖвåÈë´óÁ¿Êý¾Ý

ÐèÒª´óÁ¿oracle²âÊÔÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ·½·¨¡£
DECLARE
 i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
 i := i + 1;
 INSERT INTO TEST_TABLE(ID, XM) VALUES(i, 'ÐÕÃû' || i);
END LOOP;
COMMIT;
 END; ......

½ÌÄãÈçºÎÓÃOMSʵÏÖOracleÖÐÊý¾Ý±¸·Ý

ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓкܶàµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......

oracle Ëø±í´¦Àí

--²é³öËùÓб»ËøסµÄ±í
select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY, c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;
--ͨ¹ýSID, SERIAL½âËø
--alter system kill sessio ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ