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 ¡¢³·ÏúÓû§ÊÚÓèµÄȨÏÞ
±
Ïà¹ØÎĵµ£º
update £ºµ¥±íµÄ¸üв»ÓÃ˵ÁË£¬Á½ÕßÒ»Ñù£¬Ö÷Ҫ˵˵¶à±íµÄ¸üÐÂ
Oracle> OracleµÄ¶à±í¸üÐÂÒªÇó±È½ÏÑϸñ£¬ËùÒÔÓеÄʱºò²»ÊǺܺÃд£¬ÎÒÃÇ¿ÉÒÔÊÔÊÔOracleµÄÓαê
&n ......
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ÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......
oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷ÔÔò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬ ......
Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ´Ðз¾¶,Èç¹ûûÓÐ×ö¹ýͳ¼Æ£¬CBOÒ²¾ÍûÓÐ×öcostÆÀ¹ÀµÄÒÀ¾Ý ......