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

oracle ´´½¨Óû§


oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢   linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼  
Æô¶¯    lsnrctl start
µÇ¼    sqplus /nolog
Á¬½ÓÊý¾Ý¿â    connect  /as   sysdba
Æô¶¯Êý¾Ý¿â    startup
¹Ø±ÕÊý¾Ý¿â    shutdown immediate
2¡¢   ÔÚÊý¾ÝÖд´½¨Óû§Ãû
Æô¶¯Êý¾Ý¿âºó´´½¨Óû§Ãû
Á¬½Ó³¬¼¶Óû§    connect system/admin    system ϵͳÓû§Ãû×Ö   admin ÃÜÂë
´´½¨Óû§Ãû×Ö    create user sha identified by admin   Óû§Ãû£º sha ÃÜÂë :admin
           ¿ÉÒÔд    Default tablespace user   // Ö¸¶¨´æ´¢¶ÔÏóʹÓõÄĬÈÏ¿Õ¼ä±í ĬÈÏÊÇ system
               Temporary tablespace temp; // ±£´æÁÙʱ¶ÔÏóËùʹÓõĿռä±í ĬÈÏÊÇ system
        ÉÏÃæµÄÁ©ÐУ¬¿ÉÒÔд ¿Õ¼ä±íΪ user ÁÙʱΪ temp £»²»Ð´¾ÍĬÈÏ
3¡¢   Ìí¼ÓÓû§µÄȨÏÞ
Grant ÊÇÊÚÓèȨÏÞµÄ È磺
     Grant create session to sha £» // ÊÚÓè sha Á¬½ÓÊý¾ÝµÄȨÏÞ
  ϵͳȨÏÞÈçÏ£º
ϵͳÌØȨ
ÔÊÐíÖ´ÐеIJÙ×÷
Create session
Á¬½ÓÊý¾Ý¿â
Create sequence
´´½¨ÐòÁÐ
Create synonym
´´½¨Í¬Ãû¶ÔÏó
Create table
´´½¨±í
Create any table
´´½¨ÈκÎģʽµÄ±í
Drop table
ɾ³ý±í
Create procedure
´´½¨´æ´¢¹ý³Ì
Execute any procedure
Ö´ÐÐÈκÎģʽµÄ´æ´¢¹ý³Ì
Create user
´´½¨Óû§
Create view
´´½¨ÊÓͼ
Drop user
ɾ³ýÓû§
Drop any table
ɾ³ýÈκÎģʽµÄ±í
4¡¢   ÏòÓû§ÊÚÓèϵͳÌØȨ
Grant execute any procedure to sha with admin option 
´Ë¾äÒâ˼ΪΪ sha Óû§´´½¨ÏµÍ³ÌØȨ²¢ÇÒ¿ÉÒÔÓà sha Ϊ±ðµÄÓû§ÊÚÓèȨÏÞ
Á¬½Ó sha Óû§   connect sha/admin
¿ÉÒÔ´´½¨±ðµÄÓû§
5 ¡¢²é¿´Óû§È¨ÏÞ
½øÈë sha Óû§ connect sha/admin
Select * from user_sys_privs; ¿ÉÒԲ鿴µ½Ò»¸öÁÐ±í£¬
Áдú±í Óû§Ãû ȨÏÞ ÊÇ·ñ¿ÉÒÔ¸ø±ðµÄÓû§¸½¼ÓȨÏÞ£¨ N ¡¢ Y £©  
Ðдú±í ȨÏÞ¶¼ÓÐÄÇЩ
6 ¡¢³·ÏúÓû§ÊÚÓèµÄȨÏÞ
±


Ïà¹ØÎĵµ£º

mysqlÓëOracle updateµÄÇø±ð

update £ºµ¥±íµÄ¸üв»ÓÃ˵ÁË£¬Á½ÕßÒ»Ñù£¬Ö÷Ҫ˵˵¶à±íµÄ¸üÐÂ
   
       Oracle> OracleµÄ¶à±í¸üÐÂÒªÇó±È½ÏÑϸñ£¬ËùÒÔÓеÄʱºò²»ÊǺܺÃд£¬ÎÒÃÇ¿ÉÒÔÊÔÊÔOracleµÄÓαê
               &n ......

mysql,sqlserver,oracleÈýÖÖÊý¾Ý¿âµÄ´ó¶ÔÏó´æÈ¡

mysql ´ó¶ÔÏó´æÈ¡:
¡¡¡¡ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
¡¡¡¡blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
¡¡¡¡mediumblodÊÇ24´Î·½,
¡¡¡¡Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
¡¡¡¡MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
¡¡¡¡ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL va ......

¹ØÓÚoracleµ¼Èësqlserver´æÔÚµÄΨһË÷ÒýÎÊÌâ

ÎÒÔÚ°ÑoracleÊý¾Ýµ¼ÈësqlserverÖÐʱ£¬·¢ÏÖÔÚoracleÖÐ×ֶζ¨ÒåΪΨһË÷Òýʱ£¬²»Í¬¼Ç¼µÄ´Ë×Ö¶ÎÈç¹ûΪ¿Õ²»±»ÈÏΪÊÇÖظ´µÄ£¬µ«ÔÚsqlserverÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......

oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö


oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷Ô­Ôò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
 
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
 
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬ ......

Oracle 10g StatisticÊý¾Ýͳ¼Æ


Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ´Ðз¾¶,Èç¹ûûÓÐ×ö¹ýͳ¼Æ£¬CBOÒ²¾ÍûÓÐ×öcostÆÀ¹ÀµÄÒÀ¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ