Essential Oracle Database Administration Commands and Diagnostic Queries
Core Database Operations
Full Database Export
exp system/admin@TARGET_SID file=/backup/db_full.dmp full=y consistent=y
Full Database Import
imp system/admin@TARGET_SID file=/import/full_dump.dmp full=y commit=y ignore=y
Provision Tablespaces
CREATE TABLESPACE APP_LOGS
DATAFILE '/u02/oradata/PROD/log01.dbf' SIZE 2G AUTOEXTEND ON NEXT 256M M ...
Posted on Mon, 03 Aug 2026 16:15:34 +0000 by Cynthia Blue