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

ÓÃoracle¶ÁÈ¡±¾µØÎļþ

ÓÃoracle¶ÁÈ¡±¾µØÎļþ
Ê×ÏÈÒªÔÚoracleÖд´½¨Îļþ¼Ð£¬È»ºó¸³ÓèÏàÓ¦µÄ¶ÁдȨÏÞ£¬È»ºóÊý¾Ý¿â²ÅÄܶÁȡϵͳÖеÄÎļþ
--´´½¨Îļþ¼Ð ²¢¸³ÓèȨÏÞ¸øÓû§
create or replace directory DIRNAME as 'D:\skybook2';
grant read,write on directory DIRNAME as to USERNAME;
GRANT EXECUTE ON utl_file TO USERNAME;
´´½¨³É¹¦¿ÉÒԲ鿴һÏÂ
--²é¿´ÏµÍ³ËùÓд´½¨µÄÎļþ¼Ð
select * from ALL_DIRECTORIES;
±àдһ¸ö¼òµ¥µÄ¶ÁÈ¡ÎļþµÄ´æ´¢¹ý³Ì
create or replace procedure loadfiledata(p_path varchar2,  --ÎļþµÄ·¾¶ (ÉÏÎÄÖн¨Á¢µÄÎļþÃû DIRNAME)
                                                                p_filename varchar2 --ÎļþµÄÃû×Ö(Èç text.txt, test.jsp)
) as
  v_filehandle utl_file.file_type; --¶¨ÒåÒ»¸öÎļþ¾ä±ú
  v_text varchar2(100); --´æ·ÅÎı¾
  v_name test_loadfile.name%type;
  v_addr_jd test_loadfile.addr_jd%type;
  v_region test_loadfile.region%type;
  v_firstlocation number;
  v_secondlocation number;
  v_totalinserted number;
  begin
  if (p_path is null or p_filename is null) then
  goto to_end;
  end if;
  v_totalinserted:=0;
  /*open specified file*/
  v_filehandle:=utl_file.fopen(p_path,p_filename,'r');
  loop
  begin
  utl_file.get_line(v_filehandle,v_text);----½«ÎļþдÈëv_text
 
  exception
  when no_data_found then
  exit;
  end ;
  v_firstlocation:=instr(v_text,',',1,1);
  v_secondlocation:=instr(v_text,',',1,2);
  v_name:=substr(v_text,1,v_firstlocation-1);
  v_addr_jd:=substr(v_text,v_firstlocation+1,v_secondlocation-v_firstlocation-1);
  v_region:=substr(v_text,v_secondlocation+1);
  /*²åÈëÊý¾Ý¿â²


Ïà¹ØÎĵµ£º

ORACLEÊý¾Ý×Öµä

²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
 SQL>select username,default_tablespace from user_users;
        ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
        SQL>select * from user_role_privs;
        ²é¿´µ±Ç°Óû§µÄÏµÍ³È ......

¹ØÓÚOracleÔÚAIXƽ̨ʵʩµÄ ÅàѵÄÚÈݰ²ÅÅ

¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38    ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈݰ²ÅÅ   Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵ ......

Oracle ¿ØÖÆÎļþ


Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......

oracleÔÚlinuxÏÂÔõô°²×°

red hat linux ϰ²×° oracle 10g
racle¿¼×ÊÁÏ:
Oracle¹Ù·½ÍøÕ¾: http://download.oracle.com/docs/html/B10813_01/toc.htm
Ò»¡¢ÒÔrootÓû§µÇ¼, ½øÐÐÈçϲÙ×÷£º
1 ¼ì²éÓ²¼þÒªÇó
* Ö÷Òª°üÀ¨£º
********************************************************************
* ÄÚ´æ:      & ......

ORACLE´æ´¢¹ý³Ì

ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô­×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
 
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼-------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ