Oracle Óû§ÃûÏê½â
°²×°ORACLEʱ£¬ÈôûÓÐΪÏÂÁÐÓû§ÖØÉèÃÜÂ룬ÔòÆäĬÈÏÃÜÂëÈçÏ£º
Óû§Ãû/ÃÜÂë
µÇ¼Éí·Ý
˵Ã÷
sys/change_on_install
SYSDBA»òSYSOPER
²»ÄÜÒÔNORMALµÇ¼£¬¿É×÷ΪĬÈϵÄϵͳ¹ÜÀíÔ±
system/manager
SYSDBA»òNORMAL
²»ÄÜÒÔSYSOPERµÇ¼£¬¿É×÷ΪĬÈϵÄϵͳ¹ÜÀíÔ±
sysman/oem_temp
sysman ΪomsµÄÓû§Ãû
scott/tiger
NORMAL
ÆÕͨÓû§
aqadm /aqadm
SYSDBA»òNORMAL
¸ß¼¶¶ÓÁйÜÀíÔ±
Dbsnmp/dbsnmp
SYSDBA»òNORMAL
¸´ÖƹÜÀíÔ±
3¸öĬÈÏÓû§
sys [as sysdba]
system
scott tiger
´´½¨Óû§
create user Óû§Ãû identified by ÃÜÂë;
ϵͳȨÏÞ
grant/revoke create session to/from ̞;
grant/revoke create table to/from ̞;
grant/revoke unlimited tablespace to/from ̞;
grant create session to public;
²éѯµ±Ç°Óû§ÓµÓеÄϵͳȨÏÞ
select * from user_sys_privs;
¶ÔÏóȨÏÞ
grant/revoke select on ±íÃû to/from Óû§Ãû;
grant/revoke all on ±íÃû to/from Óû§Ãû;
²éѯµ±Ç°Óû§ÓµÓеĶÔÏóȨÏÞ
select * from user_tab_privs;
¶ÔÏóȨÏÞ¿ÉÒÔ¿ØÖƵ½ÁÐ
grant update(ÁÐÃû) on ±íÃû to Óû§Ãû;
ÉèÖÃÏÔʾʱÐпí
set linesize 400,ͬʱ¼ì²éÃüÁîÐд°¿Ú¿í¶ÈÊÇ·ñºÏÊÊ¡£
ϵͳȨÏ޵Ĵ«µÝ
grant create table to ̞ with admin option;
¶ÔÏóȨÏ޵Ĵ«µÝ
grant select on ±íÃû to Óû§Ãû with grant option;
½ÇÉ«
create role ½ÇÉ«Ãû;
grant create session to ½ÇÉ«Ãû;
drop role ½ÇÉ«Ãû;
×¢Ò⣺ÓÐЩϵͳȨÏÞÎÞ·¨Ö±½Ó¸³Óè½ÇÉ«
½ÇÉ«²»ÊôÓÚij¸öÓû§£¬Êǹ²Óõġ£
create tableÓëcreate any tableÇø±ð
Ç°Õ߸ø×Ô¼º´´½¨±í£¬ºóÕ߸ø×Ô¼ºÓë±ðµÄÓû§´´½¨±í
Oracle sysÓû§ÐÞ¸ÄÆäËûÓû§ÃÜÂë
alter user Óû§Ãû identified by ÃÜÂë
OracleµÄÈýÖÖÑéÖ¤»úÖÆ
²Ù×÷ϵͳÑéÖ¤£ºÀûÓòÙ×÷ϵͳ¹ÜÀíÔ±µÇ½
ÃÜÂëÎļþÑéÖ¤£ºOracle 10G XEµÄÃÜÂëÎļþλÖÃ
D:\oraclexe\app\oracle\product\10.2.0\server\database\PWDXE.ora
Êý¾Ý¿âÑéÖ¤
LinuxÏ£¬ÏÈÆôlsnrctl¼àÌý·þÎñ£¬ÔÙÆôOracleʵÀý£¬Í¨¹ý¼àÌýÅжÏÁ¬½ÓʵÀý¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Óï·¨:
select *
from [TABLE] as of timestamp
to_timestamp('ʱ¼ä', ’ʱ¼ä¸ñʽ')
×÷Óãº
²éѯij¸öʱ¼äµãµÄÊý¾Ý£¬ÔÚÕâ¸öʱ¼äµãÖ®ºó£¬Êý¾Ý¸ü¸ÄÒѾÌá½»ÁË¡£
¿ÉÒÔÓÃÀ´¸üÕýÓû§¶ÔÊý¾ÝµÄÎó²Ù×÷
¿ÉÒÔÓÃÀ´»ñÈ¡Êý¾ÝµÄ¸ü¸ÄÇé¿ö£¬±ÈÈçƵÂʵÈ
ÔÀí£º
µ±Êý¾Ýupdate»òdeleteʱ£¬ÔÀ´µÄÊý¾Ý ......
* Èç¹ûij¸öÔ¼ÊøÖ»×÷ÓÃÓÚµ¥¶ÀµÄ×ֶΣ¬¼´¿ÉÒÔÔÚ×ֶ춶¨ÒåÔ¼Êø£¬Ò²¿ÉÒÔÔÚ±í¼¶¶¨ÒåÔ¼Êø£¬µ«Èç¹ûij¸öÔ¼Êø×÷ÓÃÓÚ¶à¸ö×ֶΣ¬
±ØÐëÔÚ±í¼¶¶¨ÒåÔ¼Êø
* ÔÚ¶¨ÒåÔ¼Êøʱ¿ÉÒÔͨ¹ýCONSTRAINT¹Ø¼ü×ÖΪԼÊøÃüÃû£¬Èç¹ûûÓÐÖ¸¶¨£¬ORACLE½«×Ô¶¯ÎªÔ¼Êø½¨Á¢Ä¬ÈϵÄÃû³Æ
¶¨Òåprimary keyÔ¼Êø(µ¥¸ö×ֶΣ©
create t ......
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆת´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁÈ¡Ò»¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´Ð ......