´«ÖDz¥¿ÍOracleÊÓƵѧϰ±Ê¼Ç
ÊÖ¶¯Æô¶¯Êý¾Ý¿â£º
Æô¶¯¼àÌý³ÌÐò£ºlsnrctl start
Æô¶¯Oracle·þÎñ£ºoradim -startup -sid orcl»òÕßnet start oracleserviceorcl
ÆäÖÐorclΪÊý¾Ý¿âµÄ·þÎñÃû»òÕßSID£¬oradim -startup -sid orclÕâ¸öÃüÁîÒÔÇ°×Ô¼ºÃ»Óùý
ȨÏÞ¹ÜÀí£º
ϵͳȨÏÞ£º
create user zhangsan identified by zhangsan;
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
create table mytable (id int);
insert into mytable values(1);
select * from mytable;
select * from user_sys_privs;---²éѯµ±Ç°µÇ½Óû§µÄϵͳȨÏÞ
revoke create table from lisi;
revoke unlimited tablespace from lisi;
grant create any table to public;--ÊÚÓèËùÓÐÓû§
×¢Ò⣺grantÓëtoÊÇÅä¶ÔʹÓõģ¬¶ørevokeÓëfromÅä¶ÔʹÓõÄ
¶ÔÏóȨÏÞ£º
grant select on tablename to lisi;
grant on tablename to lisi;
revoke all on tablename from lisi;
select * from user_tab_privs;---²éѯµ±Ç°µÇ½Óû§µÄ¶ÔÏóȨÏÞ
disconn ¶Ï¿ªÁ¬½Ó
¶ÔÏóȨÏÞ¿ÉÒÔ¿ØÖƵ½ÁУº
grant update(name) on mytab to lisi;
grant insert(id) on mytab to lisi;
update wangwu.mytab set name='songyakun',id=1 where id=2;
×¢Ò⣺²éѯºÍɾ³ý²»ÄÜ¿ØÖƵ½ÁУ¬Ö»ÄÜ¿ØÖƵ½ÐÐ
select * from user_col_privs;---²éѯµ±Ç°µÇ½Óû§µÄÁÐȨÏÞ
ȨÏ޵Ĵ«µÝ£º
Çл»ÒÔsysµÇ½£º
grant alter any table to lisi;
grant alter any table to lisi with admin option;
grant select on A to lisi with grant option;
Çл»ÒÔlisiµÇ½:
grant alter any table to wangwu;
½ÇÉ«¹ÜÀí£º
create role myrole;
grant create session to myrole;
&nbs
Ïà¹ØÎĵµ£º
ÎÄÕÂÒ»£ºSCNÊÇʲô£¿The System Change Number
system change number (SCN)ÊÇÒ»¸ö·Ç³£ÖØÒªµÄ±ê¼Ç£¬OracleʹÓÃËüÀ´±ê¼ÇÊý¾Ý¿âÔÚ¹ýȥʱ¼äÄÚµÄ״̬ºÍ¹ì¼£¡£
OracleʹÓÃSCNÀ´±£´æËùÓб仯µÄ¹ì¼£¡£SCNÊÇÒ»¸öÂ߼ʱÖÓÀ´¼Ç¼Êý¾Ý¿âʼþ¡£Ëü·Ç³£µÄÖØÒª£¬²¢²»ÊÇÖ»ÊÇΪÁ˻ָ´¡£
SCNÓеãÀàËÆÓÚsequence£¬OracleÔÚSGAÖÐÔ ......
ORACLE 10gÏÂÔصØÖ·
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.co ......
½ñÌì²Å·¢ÏÖÁËwmsys.wm_concatÕâ¸öÓÐȤÓÐÓõĺ¯Êý£¬ËüµÄ×÷ÓÃÊÇÒÔ','Á´½Ó×Ö·û¡£
Àý×ÓÈçÏ£º
SQL> create table idtable (id number,name varchar2(30));
Table created
SQL> insert into idtable values(10,'ab');
1 row inserted
SQL> insert into idtable values(10,'bc');
1 row inserted
SQL> insert ......
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐÐ ......