¡¾×ª¡¿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²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷ÔÔò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬ ......
oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢ linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼
Æô¶¯ lsnrctl start
怬 sqplus /nolog
Á¬½ÓÊý¾Ý¿â connect /as sysdba
Æô¶¯Êý¾Ý¿â startup
¹Ø±ÕÊý¾Ý¿â s ......
Ïȹ¹ÔìÒ»¸ö±í:
create table emp2(
id number(2),
name varchar(10),
currdate date,
action varchar2(1)
)
´´½¨´¥·¢Æ÷£º
create or replace trigger d_i_u_emp2
after insert or update or delete on mysort
begin
if inserting then
insert into emp2 values (12,'dog',sysdate,'i');
elsif deleting then ......
Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......