Oracle ±¾µØÎļþµÄд³öÎÊÌâ
SQL code:
declare
fhandle utl_file.file_type;
fp_buffer varchar2(4000);
begin
fhandle := utl_file.fopen ('DATA_SHIPPING','test.txt', 'R');--'DATA_SHIPPING'ÊDZ¾µØµÄÒ»¸ö·¾¶ ÆäֵΪ£º'/mnt/SShare/data/shipping'
utl_file.fclose(fhandle);
end;
ÉÏÃæ´úÂë¿ÉÒÔÕý³£ÔËÐС£
µ«ÊÇÒÔдµÄÐÎÊÆ´ò¿ª ¾Í²»ÐÐÁË
fhandle := utl_file.fopen ('DATA_SHIPPING','test.txt', 'W');
ÕâÑù¾Í»á±¨´íÁË£¡
ÓÐÄÄλ´óÏÀ Á˽âÊÇʲôÔÒò£¬¸æËßһϡ£Ð¡µÜÕâÀïл¹ýÁË¡£
¿ÉÄÜÊǶÔĿ¼ûÓÐдµÄȨÏÞ£¬ÓÃuser_tab_privs_recd±í¿´¿´
SQL code:
SELECT owner, table_Name, privilege from user_tab_privs_recd
WHERE table_name='DATA_SHIPPING';
¸Ðл zcs_1 µÄ´ð¸´¡£
µ«ÊÇ£¬½á¹ûÈçÏ£º
1 SYS DATA_SHIPPING READ
2 SYS DATA_SHIPPING WRITE
»¹ÊDz»ÄÜ Ð´£¡
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡
Error while performing database login with the Oracle driver:
Io exc ......