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

OracleÓû§È¨ÏÞ¿ØÖÆ

1£©¡¢¹¹ÔìʵÀý£º
ÎÒÃÇÒѾ­´´½¨ºÃÊý¾Ý¿âÓû§test_user£¬Ï±ߴæÔÚtest_table±íºÍtest_procedure´æ´¢¹ý³Ì¡£ÎÒÃÇÒѾ­´´½¨ºÃÒ»¸ö¿ÕµÄ´úÀíÊý¾Ý¿âÓû§agent_user¡£
2£©¡¢µÇ¼test_userÓû§£¬½«test_userϱíµÄselectȨÏ޺ʹ洢¹ý³ÌµÄexcuteȨÏÞ¸³¸ø´úÀíÓû§agent_user¡£
SQL>GRANT select ON test_table TO agent_user;
SQL>GRANT excute ON test_procedure TO agent_user;
3£©¡¢µÇ¼agent_userÓû§£¬´´½¨ºÍtest_userϱíºÍ´æ´¢¹ý³Ì¶ÔÓ¦µÃ±ðÃû£¬ÕâÑù¾Í¿ÉÒÔʹÓÃagent_user×ÔÓÉ·ÃÎÊtest_userϵÄÊý¾Ý¿âʵÌåÁË¡£
SQL>create synonym test_table for test_user.test_table;
SQL>create synonym test_procedure for test_user. test_procedure;


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
      &nb ......

½øÐÐoracleµÄÀ䱸·Ý

1¡¢À䱸·Ý±ØÐ뽫Êý¾Ý¿â·þÎñÆ÷Í£Ö¹£¬²»È»»Ö¸´µÄʱºòÎÞ·¨»Ö¸´
Í£Ö¹·þÎñÆ÷µÄÃüÁ
ÔÚsqlplusϵǽsqlplus£ºsqlplus "/as sysdba"
Í£Ö¹oracle·þÎñ£º shutdown immediate;£¨´ËÃüÁîµÈ´ýÊÂÎñÖ´ÐÐÍê±ÏºóÔٹرգ©
ÊÇÔÚ²»ÐÐÖ±½ÓÇ¿ÐÐÖÕÖ¹:shutdown abort;£¨´ËÃüÁîÖ±½Ó¹Ø±ÕʵÀý·þÎñ£©
¹Ø±Õlistener£º
linuxÃüÁlsnrctl
È»ºóÍ ......

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

oracle online documentation

oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ