Database Administrator

Data synchronization between Oracle GoldenGate databases on Heterogeneous OS Oracle GoldenGate (hereinafter referred to as OGG) synchronizes data between databases of the same type on Heterogeneous OS. Functions implemented by ogg: It can be refined

Summary of common mysql commands and summary of common mysql commands# Modifying Field TypesAlter table 'table _ name' modify column ip varchar (50 );# Adding fieldsAlter table 'table _ name' add ip varchar (50 );# Add a primary key (primary key

ORA-01461: can bind a LONG value only for insert into a LONG column, varchar2ora-01461 I recently encountered such a strange problem when I was working on a project of tianyinda freight interface. Background: Use the application written In proc to

Blue growth note-chasing DBA (5): Not talking about technology, business, annoying application systems, not talking about dba ************************************ Statement *************************************** Personal Growth records on the

How to "play" and "play"Today, I tried to share my story with you how to "play", the topic of today. Do you have any experience like this? Open your circle of friends and you will no longer hear from your friends, some personal pictures of friends

The Toad for Oracle tool was used in further projects. It was easy to use. Although there were too many things stacked on the interface, it felt a little messy, but it was actually quite helpful. After logging on to the database, you can use the

SQL server statement exercises, SQL server statements Related tables: create table DEPT(deptno int not null primary key,dname varchar(14)  null,loc varchar(13) null)create table EMP(empno int not null primary key,ename varchar(10) null,job varchar(9)

Database paging query statement database query and database paging query statement Let's take a look at the paging SQL of a single SQL statement. Method 1: Applicable to SQL Server 2000/2005 Select top page size * FROM table1 WHERE id not in (select

Statistics of SQL Server research-discover and process expired statistics, and analyze SQL statisticsPreface: Statistical information is the main source of information about data distribution in predicates. If you do not know the specific data

[Redis album] [1] methods and steps for installing php-redis under ubuntu12.04, redisphp-redis First release path: Install phpredis I haven't written a blog post for a long time, and I haven't completed many blog posts. Today I just took the time to

How to resolve the inconsistency between SQL Server database instance name and Server name -- EXEC sp_addmediaserver -- @ Server = 'pshgq' -- GO -- Select * from sys. servers -- EXEC sp_dropserver 'pshgq' -- EXEC sp_addserver 'sugon', local -

Connecting PL/SQL to oracle database and plsqloracle DatabaseConnecting PL/SQL to oracle database 1. Introduction Use pl/SQL to connect to a remote oracle database without installing the oracle database. 2. steps: A) install PL/SQL and the oracle

Oracle OS authentication and password file authentication method, oracleosOS Authentication 1. In the SQLNET. ORA (located in the $ ORACLE_HOME/NETWORK/ADMIN directory) file, use vi to edit and comment out the line # SQLNET. AUTHENTICATION_SERVICES =

For RAC databases with NAT or firewall, ORA-12545 connection Errors often occur when load balance is enabled on the server, because after the server forwards client connection requests to other nodes, the client uses the returned IP address to send

SQL Server 2008 database primary key auto-increment insert display value When you delete the table data in the database a few days ago at work, after the deletion, the newly added data does not get the id value of the original data (the table id is

Note: This is a new host that has not yet been created. If the database already exists, you need to perform the database refreshing operation! Environment: SUSE Linux Enterprise Server 11 sp1 (x86_64) Upgrade the Oracle database from 11.2.0.3.0 to 11

MySQL Workbench is a visual database design tool recently released by MySQL AB. This tool is a dedicated tool for designing MySQL databases.The physical data model you created in MySQL Workbench is called. A physical data model is a data model for a

8.3.5 Adding or Dropping Online Redo Log Files 8.3.5 add or delete the current redo log file Changing the size and number of the online redo log files is sometimes done to tune the database. you can add or drop online redo log file groups or members

The AWR report in Oracle is currently the best performance analysis and diagnosis tool officially provided. With the help of a continuous snapshot analysis, we can quickly obtain the overall performance analysis indicators and locate the problem

Oracle lock table, unlock statement, oracle unlock statementZookeeper -- 1. the following statement is used to query which objects are locked: select object_name, machine, s. sid, s. serial # from v $ locked_object l, dba_objects o, v $ session s