ITPub博客

Below is the process of the testing. Primary Side. O01DMS0Target Side. O01LEE3[@more@]PURPOSE-------This Notes explains how to exclude (filter out) specific tables from the capture process and replication, when using schema level Streams replication.SCOPE & APPLICATION-------------------To be used by DBA's as a reference when configuring and implementing the Oracle Streams capture process for schema replication.PROBLEM-------You have configured the Streams capture process at the schema level

This article is intended to quickly setup a stream environment for playing in which the schema HR in primary side will be in sync with the one in target side.[@more@]Primary Side. O01DMS0Target Side. O01LEE3########################################################################################1.1> Logon to SYS to create an account for stream at primary side.SQL> show userUSER is "SYS"SQL>SQL> create user strmadmin identified by strmadmin 2 default tablespace tbs_stream t

For these examples, assume the following statements have been issued:[@more@]CREATE ROLE security_admin IDENTIFIED BY honcho; GRANT CREATE PROFILE, ALTER PROFILE, DROP PROFILE, CREATE ROLE, DROP ANY ROLE, GRANT ANY ROLE, AUDIT ANY, AUDIT SYSTEM, CREATE USER, BECOME USER, ALTER USER, DROP USER TO security_admin WITH ADMIN OPTION; GRANT SELECT, DELETE ON SYS.AUD$ TO security_admin; GRANT security_admin, CREATE SESSION TO swilliams; GRANT security_admin TO system_administrator; GRANT CREATE SESSION

What is Partition Pruning?Some tables are so large that a Full Table Scan is unthinkable. If these tables are not partitioned, they should be.[@more@]The most common (by far) form of partitioning is Range Partitioning on a DATE column. For example, a table may be partitioned on TXN_DATE, with a separate partition for each year, month, or even day (I have seen a multi-terabyte database where daily partitions were the norm!).If Oracle can use the WHERE predicates to eliminate some partitions from

Use the following approach to create tables with constraints and indexes:[@more@]1. should be created enabled and validated. All other constraints (Create the tables with the constraints. NOT NULL constraints can be unnamed andCHECK, UNIQUE,PRIMARY KEY, and FOREIGN KEY) should be named and created disabled.See Also: information about the Oracle Database SQL Language Reference for moreCREATE INDEX and ALTER INDEXstatements, as well as restrictions on rebuilding indexesSee Also: Database Administr

http://www.dbspecialists.com/files/presentations/bulk_binds.html[@more@]

The same configuration as the case one.[@more@]1 1> Take a full backup at Standby site[oracle@RAC02 lyon_Dont_touch]$ rman target / catalog rman/cat@catadbRecovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 20 11:07:37 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: O01DMS0A (DBID=231561342, not open)connected to recovery catalog databaseRMAN> backup database;Starting backup at 20-JUN-08using channel ORA_DISK_1channel ORA_DISK_1: starting fu

Advanced Backup & Recovery For Oracle Dataguard based on The Reference Using Recovery Manager with Oracle Data Guard in Oracle Database 10gIn a standby environment, backing up data files and archived redo log files taken on the primary or standby system are usable on either system for recovery. Although some files such as the control file and SPFILE must be backed up on the primary database, the process of backing up data files and archived redo log files can be off-loaded to the standby sys