Oracle Tips by Burleson
Create LogMiner tablespace syntax
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
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
'logmnr_tbs.dbf' SIZE 25M
The above text is
an excerpt from:
High Speed Replication and Data
by Madhu Tumma
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA