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

OracleÊý¾Ý¿âÍêȫжÔØ

1¡¢ Í£Ö¹oracleËùÓеķþÎñ£¨¿ªÊ¼--ÔËÐÐ--ÊäÈëservices.msc£©
2¡¢ ɾ³ý×¢²á±íÉϵÄORACLEµÄÓйؼüÖµ(¿ªÊ¼-->ÔËÐÐ-->ÊäÈëregedit£©½«HKEY_LOACAL_MACHINE/SOFTWAREϵÄÖ÷¼üORACLEÈ«²¿É¾³ý¡£
3. ÏÂÃæɾ³ýOracle·þÎñ£º½øÈëHKEY_LOACAL_MACHINE/SYSTEMÖ÷¼üÏ£¬ÔÚControlSet001¡¢ControlSet002¡¢CurrentControlSet-->ServiceÖÐɾ³ýÏà¹ØµÄOracle·þÎñ¡££¨Ò²¿ÉÒÔÔÚ×¢²á±íÖÐɾ³ýoracle,orcl,ora´òÍ·µÄ×¢²áÏ¿ÉÄÜÓв¿·Öɾ³ý²»ÁË£¬²»Óùܣ©
4. ɾ³ýOracleÈí¼þËùÔÚµÄĿ¼£¨OracleÈí¼þµÄÓÐЩÅäÖÃÐÅÏ¢´æ´¢ÔÚÕâ¸öĿ¼£¨C:Program Files\Oracle£©£© È»ºóÔÙɾ³ýÈí¼þ°²×°µÄʵ¼ÊĿ¼£¬Èç¹ûɾ³ýÖУ¬³öÏÖ²»ÄÜɾ³ýµÄÎļþ£¬Çë¸øËü¸ÄÃû£¬È»ºóÖØÐÂÆô¶¯²Ù×÷ϵͳ£¬ ÔÙɾ³ýÕâЩÎļþ¡£ÕâÑùÎÒÃǾͳ¹µ×ɾ³ýÁËÓйصÄÎļþ£¬¶ÔÒÔºó°²×°OracleÊý¾Ý¿âûÓÐÈκÎÓ°Ïì¡£ Èç¹ûÄãÓÃOracleµÄжÔسÌÐò£¬Ê×ÏÈ£¬ÓÃdatabase configuration assistant¹¤¾ßɾ³ýËù½¨Á¢µÄÊý¾Ý¿â£¬ÕâÑù¾Íɾ³ýÁËÊý¾Ý¿âµÄÊý¾ÝÎļþ£¬ µ«ÊDz»ÄÜɾ³ýOracle¿ÉÖ´ÐеÄÎļþ¡£Èç¹ûÏëɾ³ýµÄ¸É¸É¾»¾»£¬ÓÃÉÏÃæµÄ·½·¨¡£


Ïà¹ØÎĵµ£º

oracle ²Ù×÷±í¿Õ¼äºÍÊý¾ÝÎļþ

²úÉú±í¿Õ¼äÒ»°ã¶¼ÊÇDBA»òÌØȨÓû§À´Íê³ÉµÄ£¬Èç¹ûÒªÒÔÆäËûµÄÉí·ÝÀ´²úÉú£¬Õâ¸öÓû§±ØÐëÓÉCreate tablespaceȨÏÞ²ÅÐС£²úÉúÒ»¸ö±í¿Õ¼äʱ£¬Ò»°ãÐèÒª²úÉúÒ»¸öÊý¾ÝÎļþ£¬²¢È·¶¨ÎļþµÄ´óСºÍ¶ÎµÄ´óС¡£
²úÉúÒ»¸ö±í¿Õ¼ä£¬È·¶¨Êý¾ÝÎļþ£¬Îļþ´óСºÍÇø´óС¡£
create tablespace date01 datafile d:\oracle\oradata\scut\date01.dbf ......

OracleÆô¶¯·þÎñÏê½âÒÔ¼°ÊÖ¶¯¿ØÖÆ

OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
Ô­ÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......

Oracle 1Z0 053 Exam

Exam Number/Code : 1Z0-053
Exam Name : Oracle Database 11g: Administration II
Questions and Answers : 167 Q&As
Update Time: 2010-05-15
1. You are not sure if Flashback Database is enabled. What database column and view can you query to
see if the flashback logs are being created in the ......

µãµãµÎµÎ(Oracle)

insert into
    select * into t_dest from t_src; -- ÒªÇóÄ¿±ê±í²»´æÔÚ
    insert into t_dest(a, b) select a, b from t_src; -- ÒªÇóÄ¿±ê±íÒÑ´æÔÚ
¶¯Ì¬SQL
    execute immediate ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ