Database Administrator

Migrate Oracle database files to ASM Read navigation Migrate data files to ASM Migrate log files to ASM Migrate control files to ASM Migrate data files to ASM Database migration in the case of Database Consistency: Start the database to the

Oracle condition selection statement and loop statement Oracle Condition Selection statements (IF, CASE), LOOP statements (LOOP, WHILE, and FOR), and sequential control statements (GOTO, NULL ).1. IF condition selection statement1.1 simple condition

Optimization of multi-level distribution interconnection with third-party APIs to obtain data systems, and third-party APIs Recently, I was working on a multi-level distribution management system based on likes. All members of the store had likes

Connect to Mariadb and mariadb remotely // This article describes how to connect to the Mariadb database on centos7. // There is no difference with mysql Package test. java. mysql; import java. SQL. connection; import java. SQL. driverManager;

Common listener-related errors in ALERT logs 3: troubleshooting of ORA-609 TNS-12537 and TNS-12547 or TNS-12170 TNS-12535 errors, ora-609tns-12535In the ALERT Log in 1.11G, the error ORA-609 TNS-12537 and TNS-12547 or TNS-12170 12170, 'tns-12535 and

Linux system time synchronization, hardware and system time synchronization, Time Zone settings, linux time zone1. Time Synchronization (manual): date-s "22:13:30" hwclock -- systohc (indicating that the system Synchronizes time to the hardware

One of the Solaris 10 ip address change references, solarisip How to Change hostname and/or IP Address Without Running sys-unconfig-Solaris 10 and below [Video] (Doc ID 1005908.1) This article is not translated. The full text is reprinted:Applies to:

Solaris 10 ip Address Change reference document 2, solarisipRefer to: Cannot change IP address of Solaris [TM] 10 host (Doc ID 1007942.1). This article will not be translated.SymptomsChanging the IP address in/etc/hosts (linked to/etc/inet/hosts)

Hive index, hive 1. Hive index Overview Hive indexes aim to improve the query speed of specified columns in Hive tables. If no index exists, a query similar to 'where tab1.col1 = 10', Hive loads the entire table or partition and processes all the

Access postgresql (using sbt) and scalapostgresql in scala Scala and SBT have been installed by default, and have a basic understanding of sbt, know how to build a project with sbt.Add dependency To use a postgresql database in scala, You need to

Mysql load data command parses and processes error 29 (ErrCode: 13) (In ubuntu environment), errcodeubuntu On the mysql server, run the following command: load data infile 'file_name' into table table_name; Store all data in a text file in a

SQL Study Notes (20) ---------- MySQL INDEX OPTIMIZATION full strategy, mysql INDEX OPTIMIZATION The so-called index is to sort specific algorithms for specific mysql fields, such as Binary Tree algorithms and hash algorithms. The hash algorithm

About Oracle cvu and cvuqdisk, oraclecvucvuqdisk About Oracle cvu and cvuqdisk Download link of cvu:Http://www.oracle.com/technetwork/products/clustering/downloads/cvu-download-homepage-099973.html Cvuqdisk is the installation package on linux.

Error Log switch and view, SqlServer log SQL Server logs and Agent error days are generally automatically switched after the instance is restarted. If the instance has not been restarted for a long time, too many logs may be accumulated, which is

CDC changes data capture technology issues and limitations, cdc capturesThe current cdc function will still disappoint you.The advantage is not mentioned, that is, those written in online books.Disadvantages:1. So far, cdc cannot be associated with

Primary Key and unique constraint of 14-SQLite, primary key of 14-sqliteI. Primary Key Uniquely identifies a row (one table can only have one primary key) Primary keys should be meaningless to users (often used for indexing) Never

MYSQL master-slave replication builds the entire process-explore key parameters that cannot be synchronized in real time, mysql master-slave Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/45873859 1. master

Database Access methods and data access methodsThis part is very basic, but if you are not clear about it, it will affect your future study.SQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------

02. Example of applications for lomboz and JDBC processing DDL statements, 02. lombozddlReprinted please indicate the source: http://blog.csdn.net/u0126375011. lomboz development toolsLomboz is a major open-source plug-in (open-source plug-in) of

MySQL Study Notes _ 8_ SQL BASIC Language review, Study Notes _ 8_ SQL SQL language basic review I. Overview SQL statement comments 1) All contents starting with "#" until the end of the line are comments 2) All content starting with "--" (-- and