Oracle | DBMS

Oracle DBMS_DNFS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Provides an interface to assists in creating a database using files in the backup set by renaming files in the DNFS test database. The new file points to the original file for reads.

AUTHID CURRENT_USER

Data Types TYPE varchar2_table IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;

Dependencies

STANDARD (only)

Documented Yes: Packages and Types Reference

First Available 11.2

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsdnfs.sql

Subprograms

CLONEDB_RENAMEFILE

RESTORE_DATAFILE_PERMISSIONS

UNMOUNTVOLUME

CLONEDB_RENAMEFILE

Renames files in a DNFS database to the new name. The new file points to the original file for reads. dbms_dnfs.clondb_renamefile( srcfile IN VARCHAR2, destfile IN VARCHAR2);

exec dbms_dnfs.renameFile('/imp/oradata/PRD/uwdata_prd6.dbf', '/app/oracle/oradata/DEV/oradata_dev1.dbf');

RESTORE_DATAFILE_PERMISSIONS

Restore datafile read/write permission. If a PDB is not named the default is the current PDB. dbms_dnfs.restore_datafile_permissions(pdb_name IN VARCHAR2 DEFAULT NULL);

exec dbms_dnfs.restore_datafile_permissions('PDBDEV');

UNMOUNTVOLUME

Unmounts a DNFS volume dbms_dnfs.unmountvolume( server IN VARCHAR2, volume IN VARCHAR2);

exec dbms_dnfs.unMountVolume('PERRITO5', '/mnt/UWDATA/NFSDATA');