OracleÊý¾Ý¿âÃæÊÔÎÊÌ⼯ºÏ¼°¼¼ÇÉ
ÕâƪÎÄÕÂÊÇORACLEÃæÊÔµÄÎÊÌâ½õ¼¯£¬ËäÈ»²»È«Ã棬µ«ÊÇÕâƪÎÄÕ»áÈÃÄãÖªµÀÈçºÎÈÃÃæÊÔ¿¼¹ÙÁ˽âÄã¶ÔORACLE¸ÅÄîµÄÊìϤ³Ì¶È¡£
1.½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´²Ù×÷Ï൱¼òµ¥£¬²¢ÇÒÓÉÓÚÀ䱸·ÝµÄÊý¾Ý¿â¿ÉÒÔ¹¤×÷Ôڷǹ鵵ģʽÏÂ,Êý¾Ý¿âÐÔÄÜ»á±È¹éµµÄ£Ê½ÉԺᣣ¨ÒòΪ²»±Ø½«archive logдÈëÓ²ÅÌ£©
2.Äã±ØÐëÀûÓñ¸·Ý»Ö¸´Êý¾Ý¿â£¬µ«ÊÇÄãûÓпØÖÆÎļþ£¬¸ÃÈçºÎ½â¾öÎÊÌâÄØ£¿
½â´ð£ºÖؽ¨¿ØÖÆÎļþ£¬Óôøbackup control file ×Ó¾äµÄrecover ÃüÁî»Ö¸´Êý¾Ý¿â¡£
3.ÈçºÎת»»init.oraµ½spfile?
½â´ð£ºÊ¹ÓÃcreate spfile from pfile ÃüÁî.
4.½âÊÍdata block , extent ºÍ segmentµÄÇø±ð£¨ÕâÀィÒéÓÃÓ¢ÎÄÊõÓ
½â´ð£ºdata blockÊÇÊý¾Ý¿âÖÐ×îСµÄÂß¼´æ´¢µ¥Ôª¡£µ±Êý¾Ý¿âµÄ¶ÔÏóÐèÒª¸ü¶àµÄÎïÀí´æ´¢¿Õ¼äʱ£¬Á¬ÐøµÄdata block¾Í×é³ÉÁËextent . Ò»¸öÊý¾Ý¿â¶ÔÏóÓµÓеÄËùÓÐextents±»³ÆΪ¸Ã¶ÔÏóµÄsegment.
5.¸ø³öÁ½¸ö¼ì²é±í½á¹¹µÄ·½·¨
½â´ð£º1.DESCRIBEÃüÁî
2.DBMS_METADATA.GET_DDL °ü
6.ÔõÑù²é¿´Êý¾Ý¿âÒýÇæµÄ±¨´í
½â´ð£ºalert log.
7.±È½ÏtruncateºÍdelete ÃüÁî
½â´ð£ºÁ½Õ߶¼¿ÉÒÔÓÃÀ´É¾³ý±íÖÐËùÓеļǼ¡£Çø±ðÔÚÓÚ£ºtruncateÊÇDDL²Ù×÷£¬ËüÒƶ¯HWK£¬²»ÐèÒªrollback segment .¶øDeleteÊÇDML²Ù×÷, ÐèÒªrollback segment ÇÒ»¨·Ñ½Ï³¤Ê±¼ä.
8.ʹÓÃË÷ÒýµÄÀíÓÉ
½â´ð£º¿ìËÙ·ÃÎʱíÖеÄdata block
9.¸ø³öÔÚSTAR SCHEMAÖеÄÁ½ÖÖ±í¼°ËüÃÇ·Ö±ðº¬ÓеÄÊý¾Ý
½â´ð£ºFact tables ºÍdimension tables. fact table°üº¬´óÁ¿µÄÖ÷ÒªµÄÐÅÏ¢¶ødimension tables ´æ·Å¶Ôfact table ijЩÊôÐÔÃèÊöµÄÐÅÏ¢
10.FACT TableÉÏÐèÒª½¨Á¢ºÎÖÖË÷Òý£¿
½â´ð£ºÎ»Í¼Ë÷Òý £¨bitmap index£©
11. ¸ø³öÁ½ÖÖÏà¹ØÔ¼Êø?
½â´ð£ºÖ÷¼üºÍÍâ¼ü
12. ÈçºÎÔÚ²»Ó°Ïì×Ó±íµÄÇ°ÌáÏ£¬Öؽ¨Ò»¸öĸ±í
½â´ð£º×Ó±íµÄÍâ¼üÇ¿ÖÆʵЧ£¬Öؽ¨Ä¸±í£¬¼¤»îÍâ¼ü
13. ½âÊ͹鵵ºÍ·Ç¹éµµÄ£Ê½Ö®¼äµÄ²»Í¬ºÍËüÃǸ÷×ÔµÄÓÅȱµã
½â´ð£º
Ïà¹ØÎĵµ£º
2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚÈ¡Öµ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖƱíÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
table ......
ĬÈϵÄÇé¿öÏ£¬Èç¹ûûÓÐÅäÖÃѹËõ±¸·Ý£¬»òÕß±¸·ÝµÄʱºòûÓз¢³öcompressed ÃüÁÄÇôORACLE»á²ÉÓÃNULLÊý¾Ý¿éµÄѹËõ·½·¨À´±¸·ÝÊý¾Ý¿â£¬²ÉÓÃÕâÖÖ·½·¨±¸·Ý£¬ORACLE¾Í²»»á±¸·Ý´ÓδʹÓùýµÄÊý¾Ý¿é¡£ÁíÍâÒ»ÖÖ±¸·Ý¾ÍÊDzÉÓÃcompressedÃüÁîѹËõ±¸·Ý£¬²ÉÓÃÕâÖÖ·½·¨£¬ORACLE»áʹÓÃѹËõËã·¨À´±¸·ÝÊý¾Ý£¬Í¨³£»á ......
½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
תÔØ
------------------- ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......