 |
|
Create LogMiner tablespace syntax
Oracle Tips by Burleson
|
Oracle Streams
-
Create the LogMiner Tablespace
Every Capture process spawns a LogMiner
process. The LogMiner process and its environment use many objects
which are also essential for managing Streams. Some of the LogMiner
objects are used by the Streams Capture process.
By default, all
LogMiner tables are created to use the SYSAUX tablespace; however,
it may be desirable to have LogMiner tables use an alternate
tablespace to segregate logminer tables from tables in th SYSAUX
tablespace.
The creation of a LogMiner tablespace for
LogMiner objects is done for easy management, not for performance, and
the idea if placing "like minded" function tables into segregated
tablespaces is not new.
To use an alternate LogMiner tablespace, it is recommended that
the separate tablespace be created and LogMiner related objects
moved to this tablespace. Oracle provides the
dbms_logmnr_d.set_tablespace procedure to achieve this.
As an example, a tablespace called LOGMNR_TBS
should be created. After the tablespace has been created, the
dbms_logmnr_d.set_tablespace procedure should be used to move
the objects to the alternate tablespace.
-- To create the tablespace
CREATE TABLESPACE
LOGMNR_TBS
DATAFILE
'logmnr_tbs.dbf' SIZE 25M
AUTOEXTEND ON
MAXSIZE UNLIMITED
/
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
