windows7 °²×°Oracle 10g¿Í»§¶Ë
ÕâÁ½ÌìÔÚwindows7ÉÏ°²×°OracleÅöµ½Á˵ãÎÊÌâ,Ê×ÏÈÄÃOracle 10g32λµÄ°²×°°üÈ¥×°£¬½á¹ûÒ»Çж¼Õý³££¬PL/SQLÁ¬½Ó·þÎñÆ÷Êý¾Ý¿âÕý³££¬
µ«ÊÇÖ´ÐÐÎҵijÌÐòʱ×ÜÊDZ¨ÎÞ·¨½âÎöÁ¬½Ó±êʶ·û¡£¡£ºóÀ´ÓÐͬÊÂ˵¿ÉÄÜÊÇwindows7 ÊÇ64λµÄϵͳµÄÔÒò¡£½ÓמÍÏÂÔØÁË64λµÄOracle
10g °æ±¾µÄ¡£¡£µ«ÔÚ°²×°Ê±£¬Ìáʾϵͳ²Ù×÷°æ±¾¹ý¸ß£ºÖ»Ö§³Ö4.1£¬5.1²Ù×÷ϵͳ£¬windows7²Ù×÷ϵͳΪ6.1¡£½á¹ûÓÖ°²×°²»ÁË¡£½Ó×ÅÔÚÍøÉÏ
²éÁËЩ×ÊÁÏ¡£°²ÕÕ×ÊÁÏ°²×°³É¹¦¡£
°²×°·½·¨£ºÊ×ÏÈÏÂÔØOracle 10g Vista°æ±¾µÄ°²×°°ü¡£
Æä´ÎÔÚ½âѹºÃµÄÎļþ¼ÐÖÐÕÒµ½refhost.xmlÎļþ£¨¿ÉÄÜ´æÔÚ¶à¸ö¸ÃÎļþ£©£¬ÔÚÎļþÖÐÌí¼ÓÒÔÏÂÄÚÈÝ
<!--Microsoft Windows 7-->
<operating_system>
<version value="6.1"></version>
</operating_system>
×¢£ºÕâ¿ÉÒÔʹÔÚ¼ì²éÏȾöÌõ¼þµÄʱºò¾Í¿ÉÒÔÈƹý²Ù×÷ϵͳµÄ¼ì²é¡£
±£´æ¡£¡£½Ó×ÅÆô¶¯°²×°³ÌÐò¡£³É¹¦
OracleµÄ¹ÙÍøÏÂÔØOracle Database 10g Client Release 2 (10.2.0.3)
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracle ¹éµµÓë²»¹éµµ
1. ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½
£¨1£©Ê¹ÓÃÃüÁ
-------------------------------------------------
SQL> archive log list
Êý¾Ý¿âÈÕ־ģʽ ´æµµÄ£Ê½
×Ô¶¯´æµµ ÆôÓÃ
´æµµÖÕµã f:\oradata\dblearn\arch
×îÔçµÄ¸ÅÒªÈÕÖ¾ÐòÁÐ 14
ÏÂÒ»¸ö´æµµÈÕÖ¾ÐòÁÐ 16
µ±Ç°ÈÕÖ¾ÐòÁÐ 16
--- ......
Ò».ÌÞ³ý±íÖÐÊý¾ÝÁ½ÖÖ²½Öè
a. delete * from My_Table;
b. truncate table My_Table;
¶þ.ÌÞ³ýÕû¸ö±í
drop table My_Table;
ºÎÒԻظ´²»Ð¡ÐÄ Drop µôµÄ±íÄØ,ʵÔò Oracle ÖÐÒ²ÓÐÏà·ÂµÄ "»ØÊÕÕ¾"
ÀýÈ粻СÐÄÌÞ³ýÁ˱í My_Table
drop table My_Table;
Õâ¸öʱ·ÖÔÙÓÃSELECT»°Óï²éѯ´Ë±íʱ£¬½«»áÌáÐѱí»òÊÓͼ²»´æÔÚ.
µ«¿ÉÒÔÓ ......
drop table test;
select count(*) from test;
--´´½¨²âÊÔ±í
create table test
(
id number(9),
nick varchar2(30)
);
--²åÈë²âÊÔÊý¾Ý
begin
for i in 1..100000 loop
insert into test(id) values(i);
end loop;
commit;
end;
select * ......
ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ
×÷Õߣº[תÌù] ³ö´¦£º
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæʵÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔÇ°¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øûÓÐʲôͷÐ÷ÁË¡£ÕýÈçһλÍøÓÑÎÄÕÂËù½²£º“&h ......