Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page