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

¡¾×ª¡¿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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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


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

oracle ´´½¨Óû§


oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢   linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼  
Æô¶¯    lsnrctl start
µÇ¼    sqplus /nolog
Á¬½ÓÊý¾Ý¿â    connect  /as   sysdba
Æô¶¯Êý¾Ý¿â    startup
¹Ø±ÕÊý¾Ý¿â    s ......

Oracle Óï¾ä¼¶´¥·¢Æ÷

Ïȹ¹ÔìÒ»¸ö±í:
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 ......

Aix 5.3ÏÂ×Ô¶¯±¸·ÝOracle¶à¸öʵÀý£¬²¢ÉÏ´«ÖÁFTP·þÎñÆ÷

Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ