Database Administrator

New Features of Oracle 11g: User rename Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :" 1. Export data from exp

Oracle 11g update PSU detailed steps Oracle releases the latest patches every quarter. For production O & M personnel, regular system upgrade and patching are indispensable in daily work. Compared with the previous versions, Oracle patching has

Oracle GoldenGate causes imp to have a ORA-32588 Error The customer said that the following error was reported when importing data to the source database after GG was implemented: From this error, we can see that adding logs of all column type to

MySQL online backup and recovery tools --> XtraBackup 1 Overview of Xtrabackup principles Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to

Oracle 10g quick manual database creation procedure Step record of Oracle 10g quick manual database creation: 0. Modify Environment Variables [Oracle @ ocm1 ~] $ Vi. bash_profile Add the following content:Export ORACLE_SID = PRODExport ORACLE_BASE =/

SQL Server automatic backup, automatic compression, automatic deletion of old backup, SQL Server backup Compression Preparation tools:SqlServer2008WinRar 1. Set a scheduled backup for SqlServerThis operation is relatively simple. Simply add a

Installation and uninstallation of Oracle11g and use of common tools, oracle11g installation and uninstallation Installation and uninstallation of Oracle11g and use of common tools Purpose: (1) master the installation and uninstallation processes of

Data cleansing Note: correct English date conversion reports "invalid month", note English Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have

The Oracle time format and integer format are converted to each other, and the oracle time format is integer. If the time field of the Oracle database is set to the "NUMBER" type, the query Time column is displayed as a numerical value, such as the

Oracle -- SQL syntax summary and oraclesql syntax Summary -- Statement block declare v_name varchar2 (30): = 'jack' -- defines the variable begin select v_name from dual; exception when others then dbms_output.put_line ('exception occurred '); end;

Error Code: 1318. Incorrect number of arguments for PROCEDURE student. new_procedure; expected 0, got, procedure 1. Error description 13: 58: 20 call new_procedure ('20160301', 'hangsan') Error Code: 2000. Incorrect number of arguments for

Tips for improving PostgreSQL Performance In a (poor) PostgreSQL query, only a small change is required (ANY (ARRAY [...]). to ANY (VALUES (...))) the query time can be reduced from 20 s to 0.2 s. From the simplest use of explain analyze, to the use

SQL is required. Note: Chapter 1 Join a table. SQL is required.12.1 connections One of the most powerful functions of SQL is to join a table during execution of data queries.12.1.1 relational table The appearance of the same data multiple times is

Use scripts to implement dynamic data sources for reports and dynamic data sources for reports Some reports in the report system often need to connect different data sources according to the conditions to complete report presentation. This kind of

Description of PK, NN, UQ, BIN, UN, ZF, and AI fields in mysql workbench, and workbenchuq When using mysql workbench to create a table, the fields include PK, NN, UQ, BIN, UN, ZF, and AI basic field type identifiers. They respectively mean: PK:

Excel uses ADO to call SQL Server Stored Procedures and ado stored procedures Test environment: SQL Server 2014, Excel 2013 Excel example File Download: http://download.csdn.net/detail/zhanghongju/8533555 In the early stage, I made a small software

How does one count the number of online users per hour ?, Count the number of online users The system has a table that records user logon and logout logs. Now, the number of online users is measured in an hour. This is a mathematical problem. Case 1:

Relational Database V. S. Non-relational database, relational database v. sThe most important feature of a relational database is transaction consistency: The read and write operations of a traditional relational database are transactions and

Basic Database SQL syntax and basic SQL syntax Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Basic Database SQL syntax 1. Create a SQL database, Open SQL Server Management Studio, click "new query", and enter the following

Shang Silicon Valley-mybatis Quick Start,-mybatis Quick Start1. Introduction to Mybatis (ibatis) MyBatis is an excellent persistent layer framework that supports common SQL queries, stored procedures, and advanced mappings. MyBatis eliminates the