Database Administrator

If you have installed Oracle9I and then installed ORACLE10G, you can use TOAD or PLSQL Developer When you select a tool, the SERVICES Service of 9I Database is blocked. So how can we make two ORACLE databases coexist peacefully? Let's take a look

Database environment: Oracle 11G Function spfile Improvement In 11G, Oracle also made some minor improvements to protect spfile. For example, when spfile cannot be deleted during runtime, you can directly read the values of all parameters from

I believe many users have met Oracle's data files. You can check them here. In this process, use sqlplus to log on with sys and perform the following steps: 1. offline the data file:Alter database datafile 'd: \ Oracle \ PRODUCT \ 10.2.0 \ DBFILES

RAID, a Redundant Array of cheap disks, is a method of storing the same data in different locations on multiple hard disks. RAID has many different types (called RAID "level"). Each type has its own advantages and disadvantages.　　For Oracle9i

In addition to the well-known Chinese characters, mysql instances on Linux may encounter the following problems: You use mysql5x and configure the database to use the UTF-8 character set, you use the linux Standard jdk environment, you use a high

MySQL5.0 version of the installation of graphic tutorial is FOR beginners to learn, first download MySQL-5.0.22 (source package) FOR Linux address: Ghost (Installation Package) can go to the official website http://dev.mysql.com/downloads/ The

1. InstallationCheck whether MYSQL is installed in Linux.Rpm-qa mysql Mysql-4.1.7-4.RHEL4.1 Click add/remove mysql detail in programe.Check mysql-server 2. StartTo check whether mysql has been started.Service mysqld status We can start Mysql in

Example: transfer data from MySQL4 to MySQL5. The data format is utf8. 1. Export the data table structure first. First create a database in MySQL5, set the encoding to utf8_general_ci, and then import mysql5. 2. Export the data, use UltraEdit to

When backing up a logical database, you may want to add a date variable to the dmp file to differentiate backup files of different dates and avoid accidental overwriting. Referring to eagle's book "sequential Oracle", we have tested some scripts as

PhpMyAdmin is a PHP program that can be used to manage MySQL-server and a single database. It is a convenient management tool for those who are not familiar with MySQL Command column commands. PhpMyAdmin is a set of PHP programs that can be used to

The following describes how to use common data dictionaries for Oracle users by category. I. Users View the current user's default tablespace SQL> SELECT username, default_tablespace FROM user_users; View the role SQL of the current user> SELECT *

Let's first look at the Python connection MySQL code: #! /Usr/bin/env python#-*-Coding: UTF-8-*-# This statement tells python to use UTF-8 Encoding#===================================================== =======================================

Export in Windows and run the following command in the mysql \ bin directory of the command line: Mysqldump-uroot-p password-a> mysql_data. SQL Copy the file mysql_data. SQL to Linux. Run in Linux: Mysql-uroot-p password The above method is

I recently studied MySQL 5.6 and found that I cannot log on to MySQL with a blank password after installation. The installation process includes the following sentence: A random password has been set for the MySQL root USER! You will find that

Oracle is successfully installed on Redhat 5. The archive mode is not enabled during database creation. SQL> select name, open_mode, log_mode from v $ database; NAME OPEN_MODE LOG_MODE-----------------------------------------SZPDCORA READ WRITE

For Chinese, database encoding has always been a big problem, but in Linux mysql we can initially set all the encoding to UTF-8, the operation is as follows: 1. Modify the/etc/mysql/my. cnf file, sudo gedit/etc/mysql/my. cnfAdd

The first time I came into contact with the Server version of Linux: Ubuntu Server 12.04, it was also the first time I installed binary mysql with command lines. It took two days and one night to get started. Leave for memo! First download the

Introduction: in the past few days, the RAC built on the two servers run a few extremely high-computing jobs, so I am very concerned about the performance of the database's Linux server. In Linux, I used the TOP command to monitor the overall

We can view all session information in the current database through the Oracle view v $ session. The view has a column indicating the session status. The Oracle official documentation defines this column as follows: STATUS VARCHAR2 (8)

Procedure and function programming in PL/SQLProcedure: Stored procedure eg: create or replace procedure p -- here is the difference with plsql iscursor cisselect * from emp2 for update; -- v_temp c % rowtype; begin for v_temp in cloopif (v_temp.sal