Database Administrator

Recently I wrote a database collection program. The process is to periodically collect data from the SQLSERVER database to the Oracle database. Data is generated once an hour, and each time the data volume is about 2 W. Sping3 + hibernate4 is used

1. Save the excel file as. csv. 2. Use Notepad to open the. csv file. The first line is all fields. 3. Create a table structure Create table yu_rt_01 asselect Transaction_Id, Last_Update_Date, Last_Updated_By, Creation_Date, Created_By,

When using srvctl to create a service, note that the TAF policy option must be configured through the dbms_service package. The following example demonstrates how to create a service felix_ora:1. view the existing service of the system before the

Update the new database from 32 to 64-bit 11G 11 2 0 3 An internal error occurs when an SQL statement is executed. Using PL/SQL DEVELOPER to query the execution opportunity of this statement triggers the ORA600

Use mybatis-paginator to implement Paging   1. Introduction to mybatis-paginator Mybatis-paginator is an open-source project on gethub. It is used to obtain paging data in the java background. This open-source project also provides a list component (

The syntax of Merge is as follows: MERGE [hint] INTO [schema .] table [t_alias] USING [schema .] { table | view | subquery } [t_alias] ON ( condition ) WHEN MATCHED THEN merge_update_clause WHEN NOT MATCHED THEN merge_insert_clause;What is MERGE

The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases. PL/SQL Developer is one of the main tools used by Oracle databases to import

Query all data table content Mysql> show tables; # view all tables in the current database + ---------------------- + | tables | + -------------------- + | biao | ceshi_biao | + -------------------- + 2 rows in set (0.00 sec) mysql> select * from

Case study: delete the file system log group and retain the ASM log GroupNote:To migrate an oracle File System to ASM, delete the log Group of the file system and retain only the ASM log group. If both are retained, the read/write log performance is

A transaction is a series of steps in a logical unit of work. Transactions are used to ensure the security of data operations. Transaction Features: Atomicity(Atomicity) Consistency(Stability,Consistency) Isolation(Isolation) Durability(Reliability)

Zookeeper Where \ what? Root Pdb Remarks Control files and redo log files Y   Belongs to the CDB and not to a specific iner Shared UNDO and default database temporary tablespace Y    

When synchronizing Oracle tables to sqlserver, this error may occur when you apply data on sqlserver. 17:20:24 WARNING OGG-01154 SQL error-2147217887 mapping APPLSYS. FND_FLEX_VALIDATION_RULES to dbo. FND_FLEX_VALIDATION_RULES [SQL error-2147217887 (

Scenario reproduction: The maintainer wants to use the plsql developer tool to view the data of a table a year ago. There are about rows of data in the table. Because there is no service at this time, the maintainer closes the application. When you

Like the session in. net, if you know the sessionID in the database, all operations will be known, because you have the unique identity. There are many things that can be done, such as: which user is doing what, what SQL is being executed, and how

For example, there are two phases in table 1 and table 2, and you want to use like for join queries // use concat to connect the string select t1.id, t1.title, t2.keyword from t1 inner join t2 on t1.title like concat ('%', t2.keyword, '% ');//

It is also used for record for future contact! It basically contains the advanced usage of General SQL! Drop table if exists stu; create table stu (name varchar (30), age int, stuid int not null PRIMARY key AUTO_INCREMENT, idnum int, sex varchar (30

Introduction: Redis is a memory-based database. It also provides several persistent solutions that allow users to write data in the memory to the local file system for use after the next restart or after the host. This article describes how to set

Recently deleted the archive log of DG, [oracle@.local logs]crontab -l* 8 * * * sh /home/oracle/dbscripts/del_arc.sh This script calls the three scripts that generate the delete verification respectively. cat del_arc.sh#! /bin/bashsource

1. Assign "system permissions" to someone"SQL> grant connect to aobama with admin optionThis means that the admin database connection permission is granted to "aobama", and "aobama" can grant this permission to others.2. Questions about permission

I. Description I recently came into contact with the mysql database, so I am free to study it. Today I will demonstrate how to install mysql with the source code. If I use the rpm package for installation, I personally feel quite simple. MySQL