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

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 expʱ EXP 00091´íÎó

對Ò»個DBA»òÐèʹÓÃexp,impµÄÆÕͨÓÃ戶來說£¬ÔÚÎÒ們×öexpµÄ過³ÌÖпÉÄÜ經³£會Óöµ½EXP£­00091 Exporting questionable statistics.這樣µÄEXPÐÅÏ¢£¬Æä實Ëü¾ÍÊÇexpµÄerror message£¬Ëü產ÉúµÄÔ­ÒòÊÇÒò為ÎÒ們exp¹¤¾ßËùÔÚµÄ環¾³&# ......

Oracle ×Ö·û¼¯µÄ²é¿´ºÍÐÞ¸Ä




< type="text/javascript">
< type="text/javascript">
http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx
 
Ò»¡¢Ê²Ã´ÊÇ
Oracle
×Ö·û¼¯

      
Oracle
×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ
,
ÓдóÐ¡Ö ......

oracle job¼ò½é

´´½¨oracle job
oracle job¼ò½é
Ö÷ÒªµÄʹÓÃÇé¾°
¶¨Ê±ÔÚºǫִ́ÐÐÏà¹Ø²Ù×÷:ÈçÿÌìÍíÉÏ0µã½«Ò»ÕűíµÄÊý¾Ý±£´æµ½ÁíÒ»ÕűíÖÐ,2£º¶¨Ê±±¸·ÝÊý¾Ý¿âµÈ
Ê컯˵ÍòÊ¿ªÍ·ÄÑ£¬ÕâÀïÎÒÖ»¼òµ¥¼ÇÊöÒ»¸ö´´½¨Ò»¸ö¼òµ¥µÄjob
²½ÖèÈçÏ£º
1¡¢´´½¨Ò»Õűíg_test
create table G_TEST
(
  ID     NUMBER(1 ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç1¡«2

    ÕâѧÆÚ×¼±¸»¨ÉÙÐíʱ¼äÑо¿Ò»ÏÂoracle£¬Ì¨Ê½»úµÄUbuntu²»Îȶ¨ÀÏ»µ£¬·ÅÆúÁËlinuxÉÏʹÓÃoracleµÄÏë·¨£¬ÔÚ×Ô¼º±Ê¼Ç±¾ÉÏ×°ÁËÒ»¸öoracle 10g express°æ±¾£¬Ñ§Ï°Ò»Ï¡£
    ±¾À´»¹ÏëÓÃÔƶËÐéÄ⻯һÏÂoracle£¬ÊµÑéʧ°Ü£¬ÀÏÀÏʵʵÈÃoracleÇÖÈëÎÒµÄϵͳ¡£¡£¡£囧
    °²×°Íê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ