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

oracle Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡


oracle
Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
½â¾ö·½·¨±³¾°

ÕûÀíc
Å̵ÄÀ¬»øÎļþ£¬°Éoralce
µÄ¡£log
ÈÕÖ¾Îļþɾ³ý¡£

È»ºóoralce
Ò»Ö±²»ÄÜʹÓã¬Ìáʾtns
ÓÐÎÊÌ⣬
È»ºóÔÙÍùÉÏÕÒ×ÊÁÏ£¬Ò»Ö±Ã»Óнâ¾öµô£¬ºóÀ´¿´µ½Ò»±ßÎÄÕÂÈçÏ£¬ÎÊÌâ½â¾öµôÁË£¬Ìغʹó¼Ò·ÖÏí£¡
===================================================
ÏÂÊôÄÚÈÝΪת
===================================================
 
 
×Ô¼º»úÆ÷°²×°µÄoracle
£¬ÍêÈ«ÊÇΪÁË·½±ãѧϰ£¬µ«ÊÇÈç¹ûstartup
£¬»úÆ÷Ê®·ÖÂý£¨ÄÚ´æ512M
£©,
ËùÒԺþÃûÓÐstartup
ÁË£¬½ñÌìstartup
£¬³öÎÊÌâÁË£º
 Microsoft Windows XP [
°æ±¾ 5.1.2600] (C) 
°æÈ¨ËùÓР1985-2001 Microsoft Corp. C:\Documents and Settings\5201314 
>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on 
ÐÇÆÚÎå 5
Ô 26 10:14:25 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. 
SQL> conn sys/dd as sysdba 
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£ 
SQL> statrup SP2-0042: 
δ֪ÃüÁî "statrup" - 
ÆäÓàÐкöÂÔ¡£ 
SQL> startup ORACLE 
Àý³ÌÒѾ­Æô¶¯¡£ Total System Global Area 205520896 bytes Fixed Size 1248092 bytes Variable Size 88081572 bytes Database Buffers 109051904 bytes Redo Buffers 7139328 bytes 
Êý¾Ý¿â×°ÔØÍê±Ï¡£ ORA-00313: 
ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (
ÓÃÓÚÏ̠߳1) 
µÄ³ÉÔ± ORA-00312: 
Áª»úÈÕÖ¾ 1 
Ï̠߳1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\MYDB\REDO01.LOG' 
SQL> alter database open resetlogs; alter database open resetlogs * 
µÚ 1 
ÐгöÏÖ´íÎó: ORA-01139: RESETLOGS 
Ñ¡Ïî½öÔÚ²»ÍêÈ«Êý¾Ý¿â»Ö¸´ºóÓÐЧ 
SQL> alter database open&nb


Ïà¹ØÎĵµ£º

oracle ³£Óú¯Êý

1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......

oracleÓÅ»¯ »º´æ¶ÔÏóÓëÊý¾Ý

author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇÆ½ºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊǰÑÊý¾Ý ......

ORACLEÀàËÆsplitº¯ÊýµÄ¹¦ÄÜ

 SELECT ID,
       col_name,
       SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
       SUBSTR(col_name,
              ......

´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©

´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©
ÓÐÁ½ÖÖ´´½¨Êý¾Ý¿âµÄ·½Ê½£¬Ò»ÖÖÊÇÒÔÃüÁîÐнű¾·½Ê½£¬¼´ÊÖ¶¯·½Ê½´´½¨£»ÁíÒ»ÖÖÊÇÀûÓÃOracleÌṩµÄÊý¾Ý¿âÅäÖÃÏòµ¼À´´´½¨¡£±¾ÆªÖ÷Òª½éÉÜÔÚUnixºÍWindowsÏÂÒÔÃüÁîÐнű¾·½Ê½´´½¨OracleÊý¾Ý¿â¡£
     Ò»¸öÍêÕûµÄÊý¾Ý¿âϵͳ£¬Ó¦°üÀ¨Ò»¸öÎïÀí½á¹¹¡¢Ò»¸öÂß¼­½á¹¹¡¢Ò»¸öÄÚ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ