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¿ÉÖ´ÐеÄÎļþ¡£Èç¹ûÏëɾ³ýµÄ¸É¸É¾»¾»£¬ÓÃÉÏÃæµÄ·½·¨¡£
Ïà¹ØÎĵµ£º
²úÉú±í¿Õ¼äÒ»°ã¶¼ÊÇDBA»òÌØȨÓû§À´Íê³ÉµÄ£¬Èç¹ûÒªÒÔÆäËûµÄÉí·ÝÀ´²úÉú£¬Õâ¸öÓû§±ØÐëÓÉCreate tablespaceȨÏÞ²ÅÐС£²úÉúÒ»¸ö±í¿Õ¼äʱ£¬Ò»°ãÐèÒª²úÉúÒ»¸öÊý¾ÝÎļþ£¬²¢È·¶¨ÎļþµÄ´óСºÍ¶ÎµÄ´óС¡£
²úÉúÒ»¸ö±í¿Õ¼ä£¬È·¶¨Êý¾ÝÎļþ£¬Îļþ´óСºÍÇø´óС¡£
create tablespace date01 datafile d:\oracle\oradata\scut\date01.dbf ......
OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
ÔÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......
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 ......
insert into
select * into t_dest from t_src; -- ÒªÇóÄ¿±ê±í²»´æÔÚ
insert into t_dest(a, b) select a, b from t_src; -- ÒªÇóÄ¿±ê±íÒÑ´æÔÚ
¶¯Ì¬SQL
execute immediate ......