Oracle Ŀ¼·þÎñ
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
CREATE [OR REPLACE] DIRECTORY directory
AS 'pathname
';
±¾°¸Àý¾ßÌå´´½¨ÈçÏÂ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬¾ßÌåÓï·¨ÈçÏÂ:
GRANT READ[,WRITE] ON DIRECTORY directory
TO username
;
ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ÁдȨÏÞ¡£
ÈÃÎÒÃÇ¿´Ò»¸ö¼òµ¥µÄ²âÊÔ:
SQL> create or replace directory UTL_FILE_DIR as '/opt/oracle/utl_file';
Directory created.
SQL> declare
2 fhandle utl_file.file_type;
3 begin
4 fhandle := utl_file.fopen('UTL_FILE_DIR', 'example.txt', 'w');
5 utl_file.put_line(fhandle , 'eygle test write one');
6 utl_file.put_line(fhandle , 'eygle test write two');
7 utl_file.fclose(fhandle);
8 end;
9 /
PL/SQL procedure successfully completed.
SQL> !
[oracle@jumper 9.2.0]$ more /opt/oracle/utl_file/example.txt
eygle test write one
eygle test write two
[oracle@jumper 9.2.0]$
ÀàËÆµÄÎÒÃÇ¿ÉÒÔͨ¹ýutl_fileÀ´¶ÁÈ¡Îļþ:
SQL> declare
2 fhandle utl_file.file_type;
3 fp_buffer varchar2(4000);
4 begin
5 fhandle := utl_file.fopen ('UTL_FILE_DIR','example.txt', 'R');
6
7 utl_file.get_line (fhandle , fp_buffer );
8 dbms_output.put_line(fp_buffer );
9 utl_file.get_line (fhandle , fp_buffer );
10 dbms_output.put_line(fp_buffer );
11 utl_file.fclose(fhandle);
12 end;
13 /
eygle test write one
eygle test write two
PL/SQL procedure successfully comple
Ïà¹ØÎĵµ£º
½¨Á¢ÁÙʱ±í½á¹¹
create global temporary table myemp as select * from emp;
Ð޸ıí½á¹¹
alter table dept modify (Dname char(20));
alter table dept add (headcount number(3));
¸´ÖÆÒ»¸ö±í
create table emp3 as select * from emp;
²ÎÕÕij¸öÒÑ´æÔÚµÄ±í½¨Á¢Ò»¸ö±í½á¹¹£¬²»ÐèÒªÊý¾Ý
create table emp4 as selec ......
×Ö¶ÎÀàÐÍ
ÖÐÎÄ˵Ã÷
ÏÞÖÆÌõ¼þ
ÆäËü˵Ã÷
CHAR
¹Ì¶¨³¤¶È×Ö·û´®
×î´ó³¤¶È2000 bytes
VARCHAR2
¿É±ä³¤¶ÈµÄ×Ö·û´®
×î´ó³¤¶È4000 bytes
¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®
×î´ó³¤¶È2000 bytes
NVARCHAR2
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®
×î´ó³¤¶È4000 bytes
......
ÎÒÃÇ¿ÉÄÜ»á³öÏÖÕâÖÖÇé¿ö£¬Ä³¸ö±íÔÀ´Éè¼Æ²»ÖÜÈ«£¬µ¼Ö±íÀïÃæµÄÊý¾ÝÊý¾ÝÖØ¸´£¬ÄÇô£¬ÈçºÎ¶ÔÖØ¸´µÄÊý¾Ý½øÐÐɾ³ýÄØ£¿
ÖØ¸´µÄÊý¾Ý¿ÉÄÜÓÐÕâÑùÁ½ÖÖÇé¿ö£¬µÚÒ»ÖÖʱ±íÖÐÖ»ÓÐijЩ×Ö¶ÎÒ»Ñù£¬µÚ¶þÖÖÊÇÁ½ÐмǼÍêȫһÑù¡£
Ò»¡¢¶ÔÓÚ²¿·Ö×Ö¶ÎÖØ¸´Êý¾ÝµÄɾ³ý
ÏÈÀ´Ì¸Ì¸ÈçºÎ²éÑ¯ÖØ¸´µÄÊý¾Ý°É¡£
ÏÂÃæÓï¾ä¿ÉÒÔ²éѯ³öÄÇЩÊý¾ÝÊÇÖØ¸´µÄ£º
se ......
ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......