Database Administrator

MySQL installation, configuration, usage and JDBC Link Download: URL: http://dev.mysql.com/downloads/mysql/5.5.html#downloads Select No thanks, juststart my download. Mysql-5.5.36-win32.msi 33.7 M Mysql-5.5.36-winx64.msi 35.3 M   Navicat

Describe the MISSING keyword in datafile name Source:Explanation of MISSING keyword in datafile name (Document ID 1050268.1)Applicable:Oracle Server-Enterprise Edition-Version 7.3.4.0 to 11.2.0.1.0 [Release 7.3.4 to 11.2]Information in this

How to purge objects that have been dropped How to purge objects that have been dropped Log on to sqlplus as the user of the drop object Then show recyclebin; F: \ Oracle \ product \ 10.2.0 \ db_1 \ BIN> sqlplus/as sysdba SQL * Plus: Release 10.2.0.4

Use temporary variables in Oracle In Oracle databases, you can use variables to compile general SQL statements. When running SQL statements, input values for variables will replace the variables with these values in SQL statements. Temporary

Oracle Spool commands Use the Oracle spool command to copy the output results of SQL * plus to a specified file, or send the query results to the printer and directly use the spool off command. The spool command syntax is as follows:Spool

Use in Oracle The main purpose of using a package is to modularize the program. The package can combine the relevant stored procedures, functions, variables, constants, cursors, and other PL/SQL programs, in this way, code libraries can be

[Translated from mos] When OGG adds Supplemental Logging, the error message is Block Corruption and mossupplemental. OGG add Supplemental Logging fails, and Block Corruption is reported)Source:Add Supplemental Logging Fails Due To Block upload

SQLCookbook sorting of study notes and impression notesSelect name from emp order by salary;BY default, order by is arranged in ascending ORDER. To do so in descending ORDER, use ordel BY salary DESC.Order by does not have to be based on the column

[Translated from mos] Why does rman not use the unused block compression function during Backup? rmanunused Why does rman not use the unused block compression function during the backup process?Source:Why is RMAN not using Unused Block Compression

In-depth analysis of a complete transaction, in-depth analysis of the complete transactionOracle029 deeply analyzes a complete transaction2. Diagram of the operational process of a transactionUndo segment composition: Segment header and rollback

Oracle Storage Structure and oracle Storage StructureOracle Storage StructureStorage Structure-Table Storage StructureTable space: A table space is composed of one or more files. The space capacity of a table space is the total size of multiple

[Translated from mos] Delete the tablespace if the datafile on the OS does not exist. Source:I want to remove a tablespace and the datafile is already removed from the O.S (Documentation ID 786567.1) Applicable:Oracle Database-Enterprise

Oracle uses the pagesize command and oraclepagesize commandYou can use the pagesize command to set the size of each page to control the data volume displayed on each page. Syntax format of the pagesize commandAs follows:Set pagesize nHere, parameter

Path to mathematics-sas memo (5), path to mathematics-sas memo Import and export data PROC IMPORT DATAFILE = "file name" // specifies the complete path and file name of the file to be imported OUT = logical reference database name. Dataset DBMS =

The NFS mount point that is disconnected on AIX causes the Oracle instance to hang and the aixinstance Oracle instance hang is occupied by NFS mount points disconnected on AIX.From mos: Disconnected NFS Mount Point Causes Instance to Hang on AIX

Install POSTGRESQL on FREEBSD, freebsdpostgresql It took a long time to reinitialize it many times. During installation, run the command pkg search postgresql. Select the latest 9.4 to install the server, and the client will be installed together.

Use Innobackupex to quickly build (fix) the MySQL master-slave architecture, innobackupexmysql There are many ways to build MySQL Master/Slave databases. The traditional mysqldump mode is one of the choices of many people. However, this method is

Article Title, article title Daquan Bug 4352808-Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columns (Document ID 4352808.8) go to the bottom Bug 4352808 Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columnsThis note gives a brief

Oracle's edit command and Oracleedit command Use the edit command to copy the content in the SQL * plus buffer to an afiedt. buf file, and then start the default editor in the operating system to open this file, and the file content can be edited.

Oracle three practical statistics SQL scenarios, oracle statistics SQL scenarios When using oracle for statistics, we often encounter the following scenarios: 1. Convert vertical columns to horizontal Columns 2. Group and merge a column as the