¡¾×ª¡¿oracle ȨÏÞ¹ÜÀíÏà¹ØÃüÁî
Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§
sqlplus sys as sysdba;//ͬÉÏ
sqlplus scott/tiger;//µÇ½ÆÕͨÓû§scott
Èý¡¢¹ÜÀíÓû§
Java´úÂë
create user zhangsan;//ÔÚ¹ÜÀíÔ±ÕÊ»§Ï£¬´´½¨Óû§zhangsan
alert user scott identified by tiger;//ÐÞ¸ÄÃÜÂë
ËÄ£¬ÊÚÓèȨÏÞ
1¡¢Ä¬ÈϵÄÆÕͨÓû§scottĬÈÏδ½âËø£¬²»ÄܽøÐÐÄǸöʹÓã¬Ð½¨µÄÓû§Ò²Ã»ÓÐÈκÎȨÏÞ£¬±ØÐëÊÚÓèȨÏÞ
Java´úÂë
/*¹ÜÀíÔ±ÊÚȨ*/
grant create session to zhangsan;//ÊÚÓèzhangsanÓû§´´½¨sessionµÄȨÏÞ£¬¼´µÇ½ȨÏÞ
grant unlimited session to zhangsan;//ÊÚÓèzhangsanÓû§Ê¹Óñí¿Õ¼äµÄȨÏÞ
grant create table to zhangsan;//ÊÚÓè´´½¨±íµÄȨÏÞ
grant drop table to zhangsan;//ÊÚÓèɾ³ý±íµÄȨÏÞ
grant insert table to zhangsan;//²åÈë±íµÄȨÏÞ
grant update table to zhangsan;//Ð޸ıíµÄȨÏÞ
grant all to public;//ÕâÌõ±È½ÏÖØÒª£¬ÊÚÓèËùÓÐȨÏÞ(all)¸øËùÓÐÓû§(public)
2¡¢oralce¶ÔȨÏÞ¹ÜÀí±È½ÏÑϽ÷£¬ÆÕͨÓû§Ö®¼äÒ²ÊÇĬÈϲ»ÄÜ»¥Ïà·ÃÎʵģ¬ÐèÒª»¥ÏàÊÚȨ
Java´úÂë
/*oralce¶ÔȨÏÞ¹ÜÀí±È½ÏÑϽ÷£¬ÆÕͨÓû§Ö®¼äÒ²ÊÇĬÈϲ»ÄÜ»¥Ïà·ÃÎʵÄ*/
grant select on tablename to zhangsan;//ÊÚÓèzhangsanÓû§²é¿´Ö¸¶¨±íµÄȨÏÞ
grant drop on tablename to zhangsan;//ÊÚÓèɾ³ý±íµÄȨÏÞ
grant insert on tablename to zhangsan;//ÊÚÓè²åÈëµÄȨÏÞ
grant update on tablename to zhangsan;//ÊÚÓèÐ޸ıíµÄȨÏÞ
grant insert(id) on tablename to zhangsan;
g
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
µ±Ç°Èκΰ汾µÄORACLE¿Í»§¶ËÔÚÈκΰ汾µÄWINDOWS7É϶¼²»ÄÜÕý³£Íê³É°²×°¡£
Ö÷ÒªÊÇÒòΪORACLE°²×°µÄÏȾöÌõ¼þÀï²Ù×÷ϵͳ°æ±¾²»·ûºÏ£¬µ«ÊÇÕâ¸öÒÉÎÊ¿ÉÒÔÐÞ¸Ärefhost.xml´¦Àí£¬ ¾ßÌåÊÇÔÚrefhost.xmlÖÐÌí¼Ó
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
& ......
oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢ linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼
Æô¶¯ lsnrctl start
怬 sqplus /nolog
Á¬½ÓÊý¾Ý¿â connect /as sysdba
Æô¶¯Êý¾Ý¿â startup
¹Ø±ÕÊý¾Ý¿â s ......
Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......
OracleϵÁУºLOB´ó¶ÔÏó´¦Àí
Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
&nbs ......