oracle ѧϰ±Ê¼Ç
start d:\a.sql
@ d:\a.sql
edit [d:\a.sql]
spool d:\a.sql ½«ÆÁÉÏÄÚÈÝ Êä³öµ½Ö¸¶¨Îļþ
spool off
set linesize 320
set pagesize 100
set autoprint on
set serveroutput on
variable v1 refcursor
exp imp ±¸·Ý »Ö
Ö»¶ÁÊÂÎñ
set transaction read only
Óô¦£¬ÉèÖÃÖ»¶ÁÊÂÎñºó£¬ÆäËûÓû§Ìá½»µÄÊÂÎñÔÚÕâÀï²»¿É¼û£¬Óô¦¾ÍÊÇÓÃÓÚͳ¼Æ£¬µ«ÓÖ²»ÏëÈ¡µÃͳ¼Æʱ·¢ÉúµÄÊÂÎñÌá½»
Óû§¹ÜÀí :
µÇ½£º
sqlplus scott/tiger
sqlplus system/root as sysdba
system sys sysdba scott;; sys ³¬¼¶¹ÜÀíÔ±£¬ ¾ßÓнÇÉ«dba ; system ÊÇϵͳ¹ÜÀíÔ±£¬½ÇÉ«dbaoper ,±Èsys µÍÒ»¼¶£¬Ã»ÓÐcreate database ȨÏÞ
´´½¨Óû§ create user jixiuf identified by jixiuf_passwd;
create user userName identified by yourPasswrod default tablespace users temporary tablespace temp quota 50M on users quota 400K on temp;
create user userName identified by yourPasswrod default tablespace ts1 temporary tablespace ts2 unlimited on ts1 ;
Çл»Óû§ conn system/root; disconnect
ÏÔʾµ±Ç°Óû§ show user
¸ü¸ÄÃÜÂë password userName
ɾ³ýÓû§:drop user jixiuf [cascade] £¬Èç¹û jixiuf Óû§ÒѾ´´½¨¹ýһЩ±í£¬¼Ócascade ¼¶ÁªÉ¾³ý
ȨÏÞ·ÖϵͳȨÏ޺ͶÔÏóȨÏÞ£¬ÏµÍ³È¨ÏÞÊÇÓû§¶ÔÊý¾Ý¿âµÄ¿ØÖÆȨ£¬¶ÔÏóȨÏÞÊÇÓû§¶ÔÆäËüÓû§ËùÓµÓÐÊý¾Ý¶ÔÏóµÄ²Ù×÷ȨÏÞ
¶ÔÏóȨÏÞ £ºÈçselect ,update delete ,create index
ϵͳ ȨÏÞ £ºÈçcreate session ¼´Á¬½Óµ½Êý¾Ý¿â
grant [ϵͳÌØȨÃû][½ÇÉ«] to [Óû§ÃûÁбí ][public] [with admin option ]
grant connect to jixiuf ; ½ÇÉ«connect¸³Óèjixiuf ´ËÓû§¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â connect,resource,dba Èý¸öÖØÒª½ÇÉ« ,ÓµÓÐresource ¿ÉÒÔÔÚ±í¿Õ¼ä½¨±í£¬ grant resource to jixiuf
ÊÚȨ£º
grant select on tableName to jixiuf[ with grant option]; ¾ßÓÐÁËselect * from userName.tableName
grant select,update,delete on userName.tableName to jixiuf ;
grant all on userName.table to jixiuf; Ôöɾ¸Ä²éȨ
Èç¹ûÊǶÔÏóȨÏÞ ¿ÉÒÔ¼Ówith grant option £¬
ÈôÊÇϵͳȨÏÞ Ôò´øwith admin option Èç:
grant connnect to jixiuf with admin
Ïà¹ØÎĵµ£º
Oracleѧϰ±Ê¼ÇÈý·½°¸
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
·½°¸£¨schema£©
ÔÚOracleÖУ¬ÎÒÃÇ¿ÉÒÔ¶ÔÊý¾Ý¿â¶ÔÏó·Ö×飬Õâ¾ÍÊÇ·½°¸£¨schema£©£¬ÊÇÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ¡£Ò»¸öÓû§Ò»°ã¶ÔÓ¦Ò»¸öschem ......
對Ò»個DBA»òÐèʹÓÃexp,impµÄÆÕͨÓÃ戶來說£¬ÔÚÎÒ們×öexpµÄ過³ÌÖпÉÄÜ經³£會Óöµ½EXP£00091 Exporting questionable statistics.這樣µÄEXPÐÅÏ¢£¬Æä實Ëü¾ÍÊÇexpµÄerror message£¬Ëü產ÉúµÄÔÒòÊÇÒò為ÎÒ們exp¹¤¾ßËùÔÚµÄ環¾³ ......
Ò»£®ÒýÑÔ
ORACLEÊý¾Ý¿â×Ö·û¼¯£¬¼´OracleÈ«Çò»¯Ö§³Ö(Globalization Support)£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLEΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼¯£¬ÆäÖÐoracle8 ......
1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕ߶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴º ......
ÕâѧÆÚ×¼±¸»¨ÉÙÐíʱ¼äÑо¿Ò»ÏÂoracle£¬Ì¨Ê½»úµÄUbuntu²»Îȶ¨ÀÏ»µ£¬·ÅÆúÁËlinuxÉÏʹÓÃoracleµÄÏë·¨£¬ÔÚ×Ô¼º±Ê¼Ç±¾ÉÏ×°ÁËÒ»¸öoracle 10g express°æ±¾£¬Ñ§Ï°Ò»Ï¡£
±¾À´»¹ÏëÓÃÔƶËÐéÄ⻯һÏÂoracle£¬ÊµÑéʧ°Ü£¬ÀÏÀÏʵʵÈÃoracleÇÖÈëÎÒµÄϵͳ¡£¡£¡£囧
°²×°Íê ......