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

oracle ÐòÑÔ

¹ØÓÚдÐò£¬È˵ÄÒ»±²×ÓÓкܶàµÄµÚÒ»´Î£¬¸øÊéдÐò£¬¶ÔÎÒÀ´ËµÒ²ÊǵÚÒ»´Î£¬¶øÇÒÊǺÜÄѵõÚÒ»´Î¡£Ò»°ãÈËÊéдÍêÁË£¬¶¼»áÕÒÒ»¸öÓеãÃûÆøµÄÈËÀ´ÎªÖ®×öÐò£¬ÔÚÕâÀïÎÒÖ»ÄܲÑÀ¢Ò»ÏÂ
¡£ÒòΪÎÒ×ܾõµÃ¸øÒ»±¾ÊéдÐòµÄÈË£¬ÔÚÊéµÄÄÚÈÝ·½Ã棬ÖÁÉÙÒ²µÃÊǰë¸öר¼Ò£¬È»ºó²ÅÄÜÓз¢ÑÔȨ¡£¶ø±¾ÈËÔÚoracle·½Ã棬Á¬°ëͰˮµÄËã²»ÉÏ¡£ÕâÒ»´ÎÒ²¿ÖÅÂÖ»ÄÜÊDZ»oracleÒ»°ÑÁË
¡£
¹ØÓÚдÊéÕâ»ØÊ£¬ÎÒÏàÐÅÔÚÕâ¸öʱ´ú£¬ºÜ¶àÈ˶¼Ïëд£¬»òÕßÒѾ­Ð´ÁË¡£µ«ÊÇÏëÒ²ºÃ£¬ÒѾ­Ð´ÁËÒ²ºÃ£¬ÕæÕýÄܰÑÊéдºÃ¿ÖÅÂÒ²²»¶à¡£µ«ÊÇÎÒÃÇÖªµÀСÕÔͬ־µÄµÚÒ»±¾Ê飬ÎÞÂÛÊÇÊг¡»¹ÊǶÁÕß·´À¡¶¼ÊǷdz£²»´íµÄ¡£ÏúÁ¿Ò²ÊÇÔÚͬÀàÊé¼®Öкܿ¿Ç°µÄ¡£µ±È»£¬ËµÊéµÄºÃÓë²»ºÃ£¬ÆäʵҲÊÇÒ»¸ö¼ûÈʼûÖǵÄÎÊÌâ¡£ÎÒÃÇÖªµÀ£¬ÔÚÏÖÔÚÕâ¸öʱ´ú£¬³öÒ»±¾Êé²»ÄÑ£¬ÄѵÄÊÇÒª³öÒ»±¾ºÃÊé¡£ÖÁÓÚСÕÔͬ־µÄµÚ¶þÊéºÃÓë²»ºÃ£¬ÏÖÔÚ»¹²»ÊǸǹ׶¨ÂÛµÄʱºò¡£
¹ØÓÚÔõôѧºÃoracle£¿ËµËü²»ÄÑÒ²ÄÑ¡£Ò»¸öÐÂÊÖ£¬Èç¹ûÔÚoracleÁìÓòûÓиöÈýÎåÄêʱ¼äµÄרÐÄŬÁ¦£¬¿ÖÅÂÊÇÄÑ³ÉÆøºòµÄ¡£Õæ¿ÉνÊDz»¾­Ò»·¬±ù˪¿à£¬ÄĵÃ÷»¨·ÅÇåÏ㡣˵ÄÑÒ²²»ÄÑ£¬Ä³ÈËÔø¾­Ëµ¹ý£¬ÊÀÉÏÎÞÄÑÊ£¬Ö»Òª¿ÏÅʵÇÂï¡£Æäʵ¼¼ÊõÕâ¸ö¶«Î÷£¬²»¹ÜÊÇoracle»¹ÊÇjava»òÕßÊDZðµÄ£¬µÀÀí¶¼ÊÇÒ»Ñù£¬ÄÇÅÂÄãÊÇÓÞ±¿£¬Ö»ÒªÅ¬Á¦¡¢×¨×¢£¬Äã¾ÍÄܵõ½ÄãÏëÒª¡£ÒòΪ¼¼ÊõÊÇѧÎÊ£¬Ö»ÒªÄã²»ÆÛÆ­Ëû£¬ËûÊDz»¿ÉÄÜÆÛÆ­ÄãµÄ£¬¼ÈÈ»Ä㸶³öÁË£¬µ±È»¾Í»áÓлر¨¡£ÕýÈçÎäÏÁС˵ÖдóÏÀ£¬Ã¿Ò»¸ö¾ø¶¥¸ßÊÖ¶¼ÊÇÎÞÊý¸öµ¥µ÷¡¢¿ÝÔï¡¢ÎÞÁĵĹý³ÌÖгɳ¤ÆðÀ´µÄ¡£ËäÈ»ÄÇÖ»ÊÇÒÕÊõ£¬µ«ÊÇÉú»îµÄµÀÀíÊǶ¼Ò»ÑùµÄ¡£Ð¡ÕÔͬ־ҲÊǾ­ÀúÁË8Äê¶àµÄ·çÓêÄ¥í£¬ÖÕÓÚÐ޳ɽñÌìµÄÕý¹û¡£ÔÚoracle·½ÃæÒ²ËãÊǸö·ÇÖøÃûµÄ¸ßÊÖ£¬»òÕßר¼Ò¡£Èç¹ûÏëÔÚoracle·½ÃæÓÐËùµÄ·¢Õ¹µÄÅóÓÑ£¬ÎÞÂÛÊǼ¼Êõ±¾Éí»¹ÊÇ·¢Õ¹·½Ïò¶¼²»·ÁСÕÔͬ־¶à×ö½»Á÷¡£
˳±ãÔÙ˵˵СÕÔÕâ¸öÈ˱¾Éí£¬ËäȻҲÓкܶàʱºòÇÅÇéµÄºÜ£¬µ«ÊÇ×ܵÄÀ´Ëµ»¹ËãÊÇÒ»¸öºÃÈË¡£×öÊÂÇé×î´óµÄÌØµã¾ÍÊÇÖ´ÖøºÍÈÏÕæ£¬ÔÚ¼¼ÊõÁìÓòÒ²ËãÊǸöÖµµÃѧϰµÄÈË¡£±¾ÈËÒ»Ö±ÒÔºó
¾ÍÓиö¹Ûµã£¬ÀÏʦºÍÒ½ÉúÕâÁ½Ö°Òµ£¬ËäÈ»¶¼ÐèҪѧÀú¡¢ÄÜÁ¦¡¢ÖªÊ¶£¬µ«ÊÇÊ×ÏÈÐèÒªµÄ»¹ÊÇÊÇÈËÆ·¡£Ð´ÊéÒ²Ò»Ñù£¬ÎÄÕÂǧ¹ÅÊ£¬Ò»³¯ÓÀÁ÷´«£¬Ð´³öÀ´Êé¸ü¼ÓÁËÁË£¬Ç§¹ÅÁ÷´«£¬Èç¹ûÈË
Æ·²»ºÃ£¬Ð´³öÀ´µÄ¶«Î÷¿ÖÅÂÒ²Ö»ÄÜÒÅ»öǧÄê¡£ËùÒÔ±¾È˾õµÃСÕÔͬ־µÄÊéÂ½èÒ»¾äÁ÷ÐÐÓïÀ´Ëµ£¬Õâ¸ö¿ÉÒÔÓУ¡
˵ÁËÕâô¶à£¬ËµËµÕâ±¾Êé°É£¬ÓÉÓÚʱ¼ä¹ØÏµ£¬±¾ÈËÒ²Ö»ÊÇ´ó¸Åä¯ÀÀÁËÒ»±é£¬¸ÐÊÜ×îÉîµÄÊÇ£¬ÊéÉÏ˵ºÜ¶àÎÊÌâºÜ¶à¶¼ÊÇÎÒÔÚ¿ª·¢¹ý³ÌÖÐÔø¾­¼û¹ý»òÕßÇ×ÉíÓöµ½¹ýµÄÎÊÌâ¡£±¾ÈËÒòΪ´ÓÊ¿ª·¢ºÃ¶àÄêÁË£¬×ÔÈ»ÔÚora


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

oracleÈ«ÎÄË÷ÒýÖ®STORAGE PREFERENCE



OracleÈ«ÎÄË÷ÒýµÄSTORAGEÊôÐÔÊÇΪÁ˸øÈ«ÎÄË÷ÒýÉú³ÉµÄ¸¨Öú±íÉèÖô洢²ÎÊýµÄ¡£
OracleµÄÈ«ÎÄË÷Òý»áÉú³ÉÒ»ÕÅ»ò¶àÕŸ¨Öú±í£¬ÓÉÓÚÕâЩ±íÊÇOracle×Ô¶¯Éú³ÉµÄ£¬Óû§Ã»Óа취ֱ½ÓÉèÖÃÕâЩ±íºÍË÷ÒýµÄÎïÀí²ÎÊý£¬Òò´ËOracleÌṩÁËSTORAGEÊôÐÔ£¬×¨ÃÅÉèÖÃÕâЩ¸¨Öú±íºÍË÷ÒýµÄÎïÀí²ÎÊý¡£
SQL> SELECT * from TAB;
TNAME ......

VC++ÓÃOO4OÁ¬½ÓOracleÊý¾Ý¿â

ÔÚ´ò°üoralce¿Í»§¶Ëºó£¬¾­³£»áÓöµ½Õâ¸öÎÊÌâ“specified   class   not   registered   in   registry”
½â¾ö°ì·¨£º
       ÕâÊÇÒòΪÓм¸¸öÁ´½Ó¿âdll»òocxûע²áµÄÔ­Òò£¬¾­±¾È˲âÊÔΪÒÔÏÂ5¸öÎļþ£º
     ......

Oracle 10.2.0.3 Patch°²×°Ö®BUGÏê½â

ORA-00704: bootstrap process failure
ORA-1092 signalled during: alter database open...
½øÐÐÈçϲÙ×÷ºóOK.
SQL>startup upgrade
For Windows
SQL>@d:\oracle\product\10.2.0\db_1/rdbms/admin/catupgrd.sql
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
´ýcatupgrd ......

Oracle³£Óýű¾Ê¾Àý

CREATE SEQUENCE s_report_id     INCREMENT BY 1   MAXVALUE 999999    START WITH 1;  
CREATE SEQUENCE checkup_no_seq  NOCYCLE          MAXVALUE 999999    START WITH 2;
 
CRE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ