Tags: Oracle goldengate initial Load methodNon-Oracle DB is illustrated with SQL Server as an example:My train of thoughtA:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destinationa-> b->c Note: B on both the rep process and ext process, at this time, C also need to establish a rep process for B.A->b can complete the online initialization synchronization (EXPDP based on the SCN number
Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So
ORACLE-012: Automatic varchar2 and number conversion for numbers only in oracle, oracle-012varchar2
When an association query is used, the fields in the two tables define different types. One field is of the varchar2 type, and the other is of the number type. The content is as follows: '20160301' and 00187. In use, the varchar2 type is automatically converted to
There are several modes of locking in Oracle:0:none1:null Empty2:row-s line Sharing (RS): Shared table locks, Sub share3:row-x Line Exclusive (RX): For row modifications, sub Exclusive4:share shared Lock (S): Prevents other DML operations, Share5:s/row-x shared Row Exclusive (SRX): Block other transaction operations, Share/sub exclusive6:exclusive Exclusive (X): Independent access use, exclusive
The types provided by 1.
export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database character set:SELECT * from V$nls_parameters WHERE PARAMETER in (' Nls_characterset ',
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL status
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 2005 11:01:01
Copyright (c) 1991,200 2, Oracle Corporation. A
It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the database, but yesterday, the local no reason to connect to the server database.
Oracle Server entry and oracle management routineI. Common oracle database management toolsOracle Universal Installer (OUI): used to install, upgrade, or delete Software ComponentsOracle Database Configuration Assistant (DBCA): a graphical user interface tool that interacts with OUI. It can also be used independently to create, delete, or modify databases.SQL * P
What is a relational database? Oracle database architecture, Oracle cluster introduction, and oracle Architecture
What is a relational database?
Databases based on Relational Models.
What is a relational model?
Use rows and columns in a two-dimensional table to maintain the data model.
Oracle database architectur
Tags: style blog http ar file Data SP Div 2014 1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all versions2 oralce Server: comprised of Oracle instances and Oracle datab
Oracle 10g and Oracle 11g hand-built case--oracle 10gSystem environment:Operating system: RedHat EL6Oracle:oracle 10g and Oracle 11gThe Manual construction of the library is relatively easy to implement, this case is from 10g and 11g, by hand to build a library to do a simple control, can see 11g and 10g a simple diff
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R2 11.2.0.4. The operating system version is Oracle
How to uninstall the "hidden oracle" software installed after an error is reported, and the hidden oracle
**************************************** ******************************** **************
Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.
Please leave a messag
Oracle undo complexity-oracle Core Technology Reading Notes 4, undo-oracle
I. Overview
Undo stores old data. For example, if you modify A record to change abc of column A to def, abc is saved in undo. There are two purposes: 1. if your transaction has not been committed, but you have modified column A, when someone else reads this data, they should not be able to
The Data Guard is Oracle's remote replication technology, which has physical and logical points, but in general it needs to have a separate system in place, where two hardware configurations can be different, but the software structure of the two systems is consistent, including software versions, directory storage structures, As well as the data synchronization (in fact, is not real-time synchronization), the two systems as long as the network is available, is a remote disaster-tolerant solutio
Oracle Easy Interface ToolBackground: I work on a remote machine, I need to call data to the Oracle 11g server, the Oracle client is already installed on the remote machine, but neither SQL Plus nor SQL developer and PL SQL developer are available (DBAs don't fix it for a few days). I have the server IP, Oracle user na
ALL_TAB_PRIVS_RECD represents the permissions on an object that the user is public or grantee
Dba_col_privs all authorizations on the database column
Dba_role_privs show roles that have been granted to a user or other role
Dba_sys_privs system permissions that have been granted to a user or role
Dba_tab_privs all permissions on a database object
ROLE_ROLE_PRIVS displays the roles that have been granted to the user
ROLE_SYS_PRIVS displays system permissions granted to users through roles
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.