Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 º¯Êý¶Ô±È

Oracleº¯ÊýºÍmysqlº¯Êý±È½Ï
1.       OracleÖеÄto_number()ת»»³ÉÊý×Ö£»
Oracle> Select to_number(‘123’) from dual;  -----         123;
           &nbs ......

mysqlÓëOracle updateµÄÇø±ð

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

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......

Á¬½Óoracle£¬sqlserverÖÐÊý¾Ý¿âµÄʾÀý´úÂë

Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
 public static void main(String[] args) {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection conn = DriverManager.getConnection(
       &nbs ......

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


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