Previously, we configured Oracle10gStream table-level replication. If a replication environment already exists, we need to clear the existing replication environment before configuring other types of replication. No
Oracle 10g Stream table-level
Configure the database environment, goldengate users, install goldengate, and perform other operations. Use the Data Pump to configure one-way Oracle-Oracle replication: -- Here I only configure Synchronization
Configure the database environment,
1.The system permission unlimited tablespace is an implicit system permission in the DBA and resource roles. When a user obtains the role of DBA or resource,The unlimited tablespace system permission is also implicitly authorized to the user.
2.The
1.System PermissionsUnlimited tablespaceIs hidden inDba, resourceA system permission in the role. When the user obtains the role of dba or resource,The unlimited tablespace system permission is also implicitly authorized to the user.
2.System
I. Oracle10g provides the ADDM function. It is naturally easy to use em to view the ADDM report. The following two methods are available if you use SQL:
1. The following SQL statement can be used to obtain the latest report.
Set long 1000000
Oracle always thinks that the operations on all partitions are the same. Only data changes will invalidate the partition status. I didn't expect the implementation methods of HASH partitions to be different.
A Study on adding new partitions to a
Oracle's use of null in not in
In the past, I also summarized some Oracle NULL problems. It happened that I saw another point that I didn't find before when I was reading the book, that is the question of using null in not in.
SQL> select * from
RULE-based optimizer (learning notes) and rule learning notesCui Hua's Oracle-based SQL optimization learning notes1.1 RULE-based Optimizer
(1) CBO
(2) RBO
Compared with CBO, RBO has obvious permissions. When RBO is used, once a problem occurs in
Convertible tablespace: a set of self-contained and read-only tablespaces are used to export only metadata. At the operating system layer, the data files of these tablespaces are copied to the target platform and the metadata is imported into the
In Oracle 10 Gb, the flash back family is divided into the following members:Flashback DatabaseFlashback dropFlashback tableFlashback query (flashback query, flashback version query, and flashback transaction query)The following describes flashback
1, the concept of temporary table
Temporary table (Global temporary table): Online shopping for e-commerce
Temporary tables are used to store private data for a session or transaction. Once a temporary table is established, its structure persists,
Null and In:null values are not included in the result set.
A105024@o02dms1>select * from Test;
ID NAME
---------- -------------- ------
1 A
B
3 C
A105024@o02dms1>select * from test where ID in (1);
ID NAME
---------- --------------------
1
This question is the examination authority knowledge Point, the authority divides into two kinds, the system permission and the object permission, this question mainly speaks the system authority, we first comes to understand what is the system
Two days ago, it was mentioned that the serializable isolation does not support the ability to delay segment creation and interval partitioning, and it is thought that because both of these methods are recursively generating DDL operations in DML,
Query Baseline information:Sql>select sql_handle,sql_text,plan_name,origin,version,created,last_modified,last_executed,last_verified, Enabled,accepted,fixed from Dba_sql_plan_baselines;No rows selectedSql>alter system set
Environment Introduction:A total of two disk groups: CRS and Data;crs use normal redundancy; Data uses external redundancy.Add a new ASM disk procedure (slightly)1. Pre-migrationSql> Select Group_number, Failgroup, Name,path from V$asm_disk order by
Recently there is a set of space tension, found that there is a large bin$ opening table Partition,index partition type of segment, query confirmation is 2 months ago deleted objects, manually emptied Dba_recyclebin use purge, but all the past few
I don't know how many people know clearly. in Oracle, if a composite index is used, assume that one of the three fields of the index (a, B, c) is deleted (including unused, how Does Oracle handle this index. Similarly, what should Oracle do if it is
I believe many people have encountered the ORA-02429: cannot drop index used for enforcement of unique/primary key error, the corresponding Chinese prompt "ORA-02429: Unable to delete the index used to force a unique/primary key ", in fact, the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.