Directory Object
Write Text Files from Oracle PLSQL with UTL_FILE Example
May 2, 2026 / · 5 min read · Oracle Database PLSQL UTL_FILE File IO Oracle DBA Database Programming Directory Object Stored Procedures ·Write Text Files from Oracle PL/SQL with UTL_FILE Example Purpose UTL_FILE is the built-in Oracle PL/SQL package for reading and writing operating-system files from inside the database. The procedure below — taken straight from the shutdownabort.com DBA Quick Guides (Andrew Barry, 2007–2013, preserved via the Wayback …
Read MoreOracle Data Pump: Create the DATA_PUMP_DIR Directory
Apr 11, 2026 / · 5 min read · Oracle Data Pump Database Administration Oracle Backup expdp impdp Directory Object SQL all_directories dba_directories v$parameter ·Oracle Data Pump: Create the DATA_PUMP_DIR Directory Before you can run any Oracle Data Pump export (expdp) or import (impdp) job, Oracle needs to know where to write and read dump files and log files on the server. You do this by creating a directory object inside the database that points to a real folder on the …
Read More