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

OracleµÄ³õʼ»¯²ÎÊýÎļþ

     oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£ 
     pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀý²ÎÊýµÄ¶¯Ì¬Ð޸쬵«²»ÄÜÖ±½ÓÐ޸ģ¬Ö±½ÓÐ޸ĻáËð»µspfile²ÎÊýÎļþ£¬´Ó¶øÒýÆðʵÀýÆô¶¯Ê§°Ü¡£
     pfileÎļþµÄĬÈÏÃû³ÆÎª init<SID>.ora
     spfileÎļþµÄĬÈÏÃû³ÆÎª  spfile<SID>.ora
     Á©ÎļþµÄλÖÃÔÚ  <$oracle_home>/product/10.2.1/db_1/dbs/
     ³õʼ»¯²ÎÊýÎļþµÄÓÅÏȼ¶Îª spfile<sid>.ora   ---->  spfile.ora ---->  init<SID>.ora
     ¿ÉÒÔʹÓà show parameter spfile ²é¿´µ±Ç°¿´ÕýÔÚʹÓõijõʼ»¯²ÎÊýÎļþÊÇÄĸö
spfileÓëpfileµÄ»¥Ïàͬ²½
create pfile from spfile  »ò
create pfile = <pfilename> from spfile = <spfilename>
create spfile from pfile »ò
create spfile = <spfilename> from pfile = <pfilename>
Ö»ÄÜÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öϽøÐÐcreate spfile²Ù×÷£¬ÇÒÎļþÃû²»ÄÜÓëÕýÔÚʹÓõÄÊý¾Ý¿âµÄspfileÏàͬ£¬·ñÔò»á´´½¨Ê§°Ü¡£


Ïà¹ØÎĵµ£º

OracleÖд´½¨¡¢Ð޸ġ¢É¾³ýÐòÁÐ

1¡¢´´½¨ÐòÁÐÓï·¨£º(ÐèÒªCREATE SEQUENCEϵͳȨÏÞ)
CREATE SEQUENCE ÐòÁÐÃû
[INCREMENT BY n] ---ÓÃÓÚ¶¨ÒåÐòÁеIJ½³¤¡£
                                ......

oracle ¹éµµÈÕÖ¾

 C:\Documents and Settings\Administrator>sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> SHUTDOWN NORMAL/IMMEDIATE
SQL> STARTUP MOUNT
SQL> ARCHIVE  LOG  LIST                    
SQL> ALTER DATA ......

spring+hibernateÖд¦Àíoracle BLOB

 1¡¢ÅäÖÃhibernate£º
    1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
    2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ 
            org.springframework.orm.hibernate3.support.BlobByteArray ......

Oracleѧϰ±Ê¼Çժ¼1

 1.create alter insert update selectµÈ
ÈçºÎ½¨±í
   ѧÉú±ístudent
        create table student( --ѧÉú±í
           xh number(4), --ѧºÅ
           ......

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣡ¡¡¡ ÔÚ´óÐÍµÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ