Database Administrator

Solution to apply security setting error during MySQL 5.1 Installation1. uninstall MySQL2. Delete the directory C: \ Documents ents and Settings \ All Users \ Application Data \ MySQL.3. reinstall

1. Basic StructureCREATE OR REPLACE PROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) ISVariable 1 INTEGER: = 0;Variable 2 DATE;BEGIN END stored procedure name2. SELECT INTO STATEMENTSave the result of the select query to a variable. Multiple

I. System Environment 1. Operating System: Fedora132. Database: Oracle11g 11.1.0.6.03. Virtual Machine: Oracle VirtualBox 3.2.64. Networking: Host-only Ii. Installation Steps 1. Create dba user groups and oracle usersSwitch to the root account:

A few days ago, when operating the database, you needed to execute SQL statements that took a long time. However, at that time, the LAN network was not good and frequent disconnection occurred. In this case, you need to add the statement to the

1. Obtain the TRACE method from the SESSION.SQL code// Get startedAlter session set TIMED_STATISTICS = TRUE;Alter session set SQL _TRACE = TRUE;// SQL Execution............................................................// End of AcquisitionAlter

The alter database backup controlfile to trace command in Oracle is used to back up the control file as a text file with the. trc suffix. The file name is in the format of sid_ora_pid.trc, which is stored at the location specified by the parameter

SELECT count (expscore) as count, sum (expscore) as sum, max (expscore) as max, min (expscore) as min, round (Avg (EXPSCORE) * 1000)/1000 as avg, a. EXPACTID, B. teachercode, B. expname, c. classid, a. scoresubmit, a. scoreverify, c. schoolid FROM

File: ---- Chinese version: navicat9_mysql_cs.tar.gz ---- English version: navicat9_mysql_en.tar.gz Install: unzip the package and use it. The start_navicat file in the directory is an executable file. Cracking: (I have found several

1. Run the MySQL server as a non-privileged user Before discussing how to start the MySQL server, let's take a look at the user identity to run the MySQL server. The server can be started manually or automatically. If you manually start it, the

Vim/etc/my. cnf add skip-grant-tables/Etc/init. d/mysqld restartMysqlUse mysqlUpdate user set password = password ("XMY_vI105VxV") where user = "root ";Flush privileges;Exit/Etc/init. d/mysqld restartWin is to modify my. ini, and the same Restart

Oracle has five default services: 1. Service Process of OracleDBConsoleorcl oem Console 2. Service Process of OracleJobSchedulerORCL Timer 3. OracleOraDb10g_home1iSQL * Plus isql * plus service process 4. Service Process of

After debugging a program, if the problem occurs, you can check the information and find that Oracle does not allow you to change the NULL field to the NULL field. I had to make a judgment before the modification.Open PL/SQL and write the following

In Oracle databases, varchar2 (4000), a large amount of content, is often helpless. In this regard, we often use large objects for storage (clob), but because the jdbc driver does not support CLOB well, it is often very troublesome to use hibernate

Introduction to Oracle elastic uard  I. Basic principles of DataGuard When a transaction changes the data in the production database, the Oracle database records the change in an online redo log file. You can configure the log Writing Process in the

In DataGuard, the data protection mode should be set as needed In all configurations, performance is used for data security, or the data security level is used for performance. 1. Data protection modeFirst: Maximize Data ProtectionMaximum

A colleague asked me a few days ago whether exp/imp involved the version. I think that as long as it is software, it will involve the compatibility of high and low versions. Oracle is also software, so is it. Simple experiment: Exp tool Version: 10

Install MySQL 5.5.35 in CentOS 6.3 By Using rpm and Source Code compiling. This article uses mysql Source Code compiling and the compiler uses Cmake. Software Release mysql-5.5.35.tar.gzand cmake-2.8.10.2.tar.gz. Please download them by yourself. 1.

Today, mysqldump is used online to import data tables from one database to another. The export speed is very slow. So I searched the internet and found this stuff. After the test, I found it was good. I will share it with you. Brief

For the restoration of accidentally deleted tablespaces, this article discusses the restoration of database-based time points and the recovery of tablespace-based time points respectively. 1. Restore accidentally deleted tablespaces through database-

When a DBA logs on to a local or remote database, it is common to log on to the database using the "sqlplus username/password @ Connection Service name" method to save time, if we replace Oracle SQLPlus with our own implementation, and record its