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

Íêȫɾ³ýOracle 10g

Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£­>ÉèÖã­>¿ØÖÆÃæ°å£­>¹ÜÀí¹¤¾ß£­>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£­>³ÌÐò£­>Oracle – OraDb10g_home1>Oracle Installation Products£­> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal Installer±¾Éí²»Äܱ»É¾³ý;
3¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,°´del¼üɾ³ýÕâ¸öÈë¿Ú;
4¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services,¹ö¶¯Õâ¸öÁбí,ɾ³ýËùÓÐOracleÈë¿Ú;
5¡¢ÔËÐÐrefedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application,ɾ³ýËùÓÐOracleÈë¿Ú;
6¡¢ÓÒ¼üÎҵĵçÄÔ£­>ÊôÐÔ£­>¸ß¼¶£­>»·¾³±äÁ¿,ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨;
7¡¢´Ó×ÀÃæÉÏ¡¢STARTUP(Æô¶¯)×é¡¢³ÌÐò²Ëµ¥ÖÐ,ɾ³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê;
8¡¢É¾³ýc:\Program Files\OracleĿ¼;
9¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼;
10¡¢É¾³ýÓëOracleÓйصÄÎļþ,Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle,ɾ³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼,²¢´ÓWindows XPĿ¼(Ò»°ãΪd:\WINDOWS)ÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ;
11¡¢WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î,ɾ³ý¸Ã¶Î;
12¡¢ÈçÓбØÒª,ɾ³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN;
13¡¢µ½Ê¼þ²é¿´Æ÷ÖÐ,ɾ³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷:Èç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö,Ôò²»ÓÃÀí»á,ÖØÐÂÆô¶¯,¿ªÊ¼Ðµİ²×°,°²×°Ê±,Ñ¡ÔñÒ»¸öеÄĿ¼,Ôò,°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó,Ô­À´µÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle µÄDMLÃüÁîµÄÏêϸ´¦Àí¹ý³Ì

Ô­ÎĵØÖ·£ºhttp://book.csdn.net/bookfiles/732/10073222578.shtml
¶ÔÓÚDMLÓï¾äÀ´Ëµ£¬Ö»ÒªÐÞ¸ÄÁËÊý¾Ý¿é£¬OracleÊý¾Ý¿â¾Í»á½«ÐÞ¸ÄǰµÄÊý¾Ý±£ÁôÏÂÀ´£¬±£´æÔÚundo segmentÀ¶øundo segmentÔò±£´æÔÚundo±í¿Õ¼äÀï¡£´ÓOracle 9iÆð£¬ÓÐÁ½ÖÖundoµÄ¹ÜÀí·½Ê½£º×Ô¶¯Undo¹ÜÀí£¨Automatic Undo Management£¬¼ò³ÆAUM£©ºÍÊÖ¹¤Undo¹ÜÀí£¨ ......

OracleÊý¾Ý¿âDBFÎļþÎóɾ³ý½â¾ö·½°¸

·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......

oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨


oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨 
 
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾ­ÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾Êǰ´ÈÕÆÚ¼Ç¼µÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS  where to_char(START ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ