Oracle DBMS_DNFS
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 Only STANDARD
Documented Yes
First Available 11.2.0.2
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/dbmsdnfs.sql
Subprograms
 
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');

Related Topics
Built-in Functions
Built-in Packages
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx