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
Ïà¹ØÎĵµ£º
1¡¢ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM IN NUMBER,
ED_NUM IN NUMBER
)
IS
BEGIN
declare
......
< type="text/javascript">
< type="text/javascript">
http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx
Ò»¡¢Ê²Ã´ÊÇ
Oracle
×Ö·û¼¯
Oracle
×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ
,
ÓдóÐ¡Ö ......
OracleÌåϵ½á¹¹Öеĸ÷ÖÖÃû³Æ
¹Ø¼ü×Ö: oracle, Êý¾Ý¿âÃû, ʵÀýÃû, ÓòÃû, È«¾ÖÊý¾Ý¿âÃû, ·þÎñÃû, ÍøÂç·þÎñÃû
Ò»¡¢Êý¾Ý¿âÃû
¡¡¡¡Êý¾Ý¿âÃûÊÇÊý¾Ý¿âµÄ“Éí·ÝÖ¤ºÅÂ딣¬ÓÃÓÚ±êʾһ¸öÊý¾Ý¿â¡£ÔÚ²ÎÊýÎļþÖÐÓÃDB_NAME±íʾ¡£
¡¡¡¡Êý¾Ý¿âÃûÊÇÔÚ°²×°Êý¾Ý¿â¡¢´´½¨ÐµÄÊý¾Ý¿â¡¢´´½¨Êý¾Ý¿â¿ ......
±¾Îijö×Ô “inthirties£¨ÄÐÈËÈýÊ®£©”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦£¬Î´¾×÷ÕßÐí¿ÉתÔØ£¬±Ø×·¾¿·¨ÂÉÔðÈΡ£
ÔÚIBM AIXÉÏ°²×°Oracle RAC (RS/6000)
Ä¿µÄ
´ËÎĵµÏò¶ÁÕßÌṩÈçºÎ°²×°Ò»¸öȺ¼¯£¬°²×°RAC£¬²¢ÔÚIBM AIX HACMP/ES (CRM) 4.4.xÉÏÆô¶¯Ò»¸öȺ¼¯Êý¾Ý¿âµÄÊÖ°ÑÊÖÖ¸µ¼Êֲᣬ¶ÔÓÚ¹ØÓÚÈκÎÕâЩ²½ÖèµÄÆäËü½ ......
OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
Ä¿Ç°ËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕűí¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊÇ±È½Ï ......