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
With the DBMS_STORAGE_MAP package, you can communicate with the Oracle background process FMON to invoke mapping operations that populate mapping views.
FMON communicates with operating and storage system vendor-supplied mapping libraries.
AUTHID
CURRENT_USER
Dependencies
DBMS_MAP_LIB
MAP_OBJECT
X$KSFMCOMPL
DUAL
MAP_SUBELEMENT$
X$KSFMELEM
MAP_COMPLIST$
V$ARCHIVED_LOG
X$KSFMEXTELEM
MAP_ELEMENT$
V$CONTROLFILE
X$KSFMFILE
MAP_EXTELEMENT$
V$DATAFILE
X$KSFMFILEEXT
MAP_FILE$
V$LOGFILE
X$KSFMSUBELEM
MAP_FILE_EXTENT$
V$TEMPFILE
Supported File Types
ARCHIVEFILE
DATAFILE
SPFILE
CONTROLFILE
LOGFILE
TEMPFILE
Documented
Yes
Exceptions
Error Code
Reason
ORA-32051
mapping service not available
First Available
11.1
Initialization Parameter
set linesize 121
col name format a30
col value format a30
SELECT name, value
FROM gv$parameter
WHERE name LIKE '%f%map%';
ALTER SYSTEM SET file_mapping=TRUE SCOPE=BOTH;
SELECT name, value
FROM gv$parameter
WHERE name LIKE '%f%map%';
Builds mapping information for the file identified by filename
dbms_storage_map.map_file(
filename IN VARCHAR2,
filetype IN VARCHAR2,
cascade IN BOOLEAN,
max_num_fileextent IN NUMBER DEFAULT 100,
dictionary_update IN BOOLEAN DEFAULT TRUE);