Using Create directory & UTL_FILE in Oracle
Using Create directory & UTL_FILE in Oracle
作者:eygle出處:http://www.eygle.com/blog
日期:April 22, 2005
瀏覽次數: 本文連結:
| Blog首頁 |
Create directory讓我們可以在Oracle資料庫中靈活的對檔案進行讀寫操作,極大的提高了Oracle的易用性和可擴充套件性。
其語法為:
|
目錄建立以後,就可以把讀寫許可權授予特定使用者,例如:
|
此時使用者eygle就擁有了對該目錄的讀寫許可權。
讓我們看一個簡單的測試:
類似的我們可以透過utl_file來讀取檔案:
可以查詢dba_directories檢視所有directory.
可以使用drop directory刪除這些路徑.
|
類似的我們可以透過utl_file來讀取檔案:
|
可以查詢dba_directories檢視所有directory.
|
可以使用drop directory刪除這些路徑.
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/72973/viewspace-608621/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create directory in OracleOracle
- oracle 11g expdb autoextend tablespace and create directory error;OracleError
- oracle中create directory建在/home/oracle下可能存在的風險Oracle
- oracle create a new database using backup controlfile to traceOracleDatabase
- oracle utl_fileOracle
- pg_basebackup 報錯could not create directory
- Oracle ASM User Directory and Group DirectoryOracleASM
- Fatal error in launcher: Unable to create process using '"'Error
- create a partition table using a exsit table
- Oracle - UTL_FILE包之詳解Oracle
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM File DirectoryOracleASM
- Oracle ASM Alias DirectoryOracleASM
- Oracle ASM Template DirectoryOracleASM
- move oracle 10 directoryOracle
- ORACLE directory 目錄Oracle
- How to Quickly Create a Copy of a Table using Transact-SQLUISQL
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- 12CR2 using create database command for create non-CDB rac databaseDatabase
- Using UTL_FILE Package To Perform File I/O (UNIX) And Basic FAQ_44307.1PackageORM
- Create orders using SAP Commerce Cloud Restful APICloudRESTAPI
- Oracle ASM Attributes DirectoryOracleASM
- Oracle ASM Volume DirectoryOracleASM
- Oracle ASM Active Change DirectoryOracleASM
- oracle 之recovery directory databaseOracleDatabase
- Oracle內建包UTL_FILE使用說明Oracle
- GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2Database
- Oracle ASM Disk Used Space DirectoryOracleASM
- Oracle ASM Staleness Directory and Staleness RegistryOracleASM
- Oracle Directory(目錄)介紹Oracle
- oracle利用utl_file包來讀寫檔案Oracle
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- Oracle ASM Continuing Operations DirectoryOracleASMUI
- Oracle Directory目錄的知識Oracle
- mysqld: Can‘t create directory ‘E:\Software\mysql-5.7.24-winx64\data\‘ (Errcode: 2 - NoMySql
- Linux 無許可權建立資料夾( 報錯:Unable to create ... directory.)Linux
- ADI-1 CREATE DOCUMENT報錯BNE_UIX_PHYSICAL_DIRECTORY is not configuredUI
- Using Oracle SecureFiles LOBsOracle