 |
|
ss
Oracle Tips by Burleson |
Oracle Streams
Chapter 4 -
Capture
and Propagate Configuration
LogMiner TableSpace
-- To move all the objects, execute
BEGIN
DBMS_LOGMNR_D.SET_TABLESPACE('LOGMNR_TBS');
END;
/
Creating the Streams Administrator
A user will have to be created to act as the
Streams administrator. Any name can be given to the user, as there
is no restriction on naming conventions. However, it is recommended
that a new tablespace be created for the use of the Streams
administrator account. By using a separate tablespace, a place is
created for all of the related objects in this tablespace. This
separate tablespace makes it easy to manage and monitor the growth
of the tablespace.
The following SQL statements show the steps for
the creation of the tablespace, creation of the Streams
administrator account, and the granting of necessary privileges to
that administrator account.
setup_streams.sql
--
*************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial
purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial
purpose,
-- contact rtp AT rampant.cc
--
*************************************************
spool setup_strmadm.log
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
|
|
