DBA
Oracle CREATE DIRECTORY Command Explained
Apr 12, 2026 / · 5 min read · Oracle DBA SQL DataPump Directory Database Administration PLSQL Oracle Scripts all_directories dba_directories ·Oracle CREATE DIRECTORY Command Explained The Oracle CREATE DIRECTORY command creates a directory object — a logical alias inside the Oracle database that points to a real folder on the server's file system. This is one of the most used setup steps for Oracle Data Pump exports and imports, UTL_FILE file operations, …
Read MoreOracle expdp Schema Export Using Data Pump
Apr 9, 2026 / · 6 min read · Oracle DataPump expdp Database Backup Schema Export DBA Oracle Scripts Logical Backup ·Oracle expdp Schema Export Using Data Pump Oracle Data Pump's expdp utility lets you export a full database schema — including tables, indexes, constraints, and data — into a portable dump file. This guide breaks down the single-line command that does exactly that for the andy schema. Purpose of This Command The goal …
Read MoreOracle: Disable Flashback with DBMS_FLASHBACK.DISABLE
Mar 11, 2026 / · 5 min read · Oracle Flashback PLSQL DBA Database Administration Oracle Scripts Backup Recovery Admin Guide dbms_flashback ·Overview When working with Oracle Database, there are times when you need to look at data from the past — like rewinding a video to see what happened earlier. Oracle gives you a tool called Flashback to do this. But once you are done looking at past data, you must turn Flashback off. The command to do that is: 1EXEC …
Read MoreOracle Flashback Query: Copy Historical Data to a Table
Mar 10, 2026 / · 6 min read · oracle database flashback query sql dba data recovery insert append ctas oracle admin ·Oracle Flashback Query: Copy Historical Data Into a New Table Sometimes you need to go back in time and recover data the way it looked at a specific moment — without restoring the full database. Oracle makes this possible with Flashback Query, using the AS OF TIMESTAMP clause to read historical data directly from the …
Read MoreOracle: Get Current SCN with DBMS_FLASHBACK
Mar 8, 2026 / · 5 min read · oracle scn flashback dba sql database recovery read consistency admin scripts dba_tab_privs v$database dbms_flashback ·How to Find the Current SCN in Oracle Database Using DBMS_FLASHBACK What number marks "now" inside an Oracle database? The System Change Number (SCN) does. One call to DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER returns it from any session that has EXECUTE on the package. What Is an SCN? The System Change Number (SCN) is a …
Read MoreOracle Fast Recovery Area: Set db_recovery_file_dest
Mar 7, 2026 / · 10 min read · oracle dba backup recovery flashback fast recovery area alter system dynamic parameters fra v$recovery_file_dest v$recovery_area_usage ·Oracle Fast Recovery Area: Set DB Recovery File Dest and Size Purpose The Oracle Fast Recovery Area (FRA) is a disk location where Oracle keeps files related to backup and recovery. Two dynamic initialization parameters, db_recovery_file_dest and db_recovery_file_dest_size, control its location and its disk quota. …
Read MoreDB_FLASHBACK_RETENTION_TARGET: Set Oracle Flashback Window
Mar 6, 2026 / · 5 min read · Oracle Flashback DBA Recovery Database Administration ALTER SYSTEM Fast Recovery Area Point In Time Recovery v$database ·Set Oracle Flashback Database Retention Target with ALTER SYSTEM Oracle Flashback Database lets you rewind your entire database to a past point in time without a full restore. The command ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET controls how far back in time that rewind can go. What This Command Does The …
Read MoreOracle Flashback: Enable with Shutdown, Mount, ALTER
Mar 5, 2026 / · 6 min read · Oracle Flashback DBA Database-Recovery Oracle-Backup SQL Data-Protection Admin-Guide v$database v$flashback_database_log ·How to Enable Oracle Database Flashback: Shutdown, Mount, and ALTER Commands Oracle Flashback Database is one of the most powerful data protection tools available to a DBA. This guide walks you through the four commands needed to turn on Oracle Flashback — from a clean shutdown to opening the database in flashback …
Read MoreOracle Full Export via Named Pipe and Gzip in KSH
Mar 3, 2026 / · 7 min read · oracle shell-scripting ksh database-backup linux dba compression oracle-export ·Oracle Full Database Export Using a Named Pipe and Gzip Compression in KSH Exporting a full Oracle database can produce very large dump files. This script solves that problem by streaming the export directly through a Linux named pipe into gzip, compressing the output on the fly — without ever writing an uncompressed …
Read MoreOracle exp/imp Parameter File: Direct Path User-to-User Data Migration Moving two schemas from one database to another with the original exp and imp tools means typing a long list of options twice, once per tool. A parameter file (parfile) keeps those options in one place, so the same run can be repeated and checked …
Read More