Oracle in a Nutshell

Calls

PROCEDURE DBMS_STORAGE_MAP.MAP_ELEMENT (elemname IN VARCHAR2, cascade IN BOOLEAN, dictionary_update IN BOOLEAN DEFAULT TRUE);

Builds mapping information for elemname. If cascade, all elements with the elemname I/O stack directed acyclic graph (DAG) are mapped. If dictionary_update, mapping information in the data dictionary is also updated.

PROCEDURE 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);

Builds mapping information for filename of filetype, which is DATAFILE, SPFILE, TEMPFILE, CONTROLFILE, LOGFILE, or ARCHIVEFILE. If cascade, all elements within the filename I/O stack DAG are mapped. max_num_fileextent is the maximum number of file extents to be mapped. If dictionary_update, mapping information in the data dictionary is also updated.

PROCEDURE DBMS_STORAGE_MAP.MAP_OBJECTS (objname IN VARCHAR2, owner IN VARCHAR2, objtype IN VARCHAR2);

Builds mapping information for owner.objname of objtype.

PROCEDURE DBMS_STORAGE_MAP.MAP_ALL (max_num_fileext IN NUMBER DEFAULT 100, dictionary_update IN BOOLEAN DEFAULT TRUE);

Builds mapping information for all type of Oracle files except archive logs. max_num_fileext is the maximum number of file extents to be mapped. If dictionary_update, mapping information in the data dictionary is also updated.

PROCEDURE DBMS_STORAGE_MAP.DROP_ELEMENT (elemname IN VARCHAR2, cascade IN BOOLEAN, dictionary_update IN BOOLEAN ...