Database Administrator

Show tables or show tables from database_name;Explanation: displays the names of all tables in the current database. Show databases;Explanation: displays the names of all databases in mysql. Show processlist;Explanation: displays all processes

The following describes database objects such as tables, views, synonyms, and sequences. 1. Table. Create, delete, and modify tables in Oracle in the same way as other databases. However, the database types of oracle databases are different from

I. Environment Description:Original Server 192.168.1.110 Windows Server 2003 system character set: ZHS16GBKThe new ECS 192.168.1.120 RedHat Enterprise Linux system character set is WE8ISO8859PI. Ii. Problem description:1.110 The database on the

1. Start and Stop a database 1. Start the database 1.1 log on. XX-laptop :~ $ Sqlplus "scott/tiger as sysdba" The following Connection database information is displayed: SQL * Plus: Release 10.2.0.1.0-Production on Mon Aug 9 15:30:16 2010 Copyright (

REGEXP_LIKE (matching)REGEXP_INSTR (included)REGEXP_REPLACE (replace)REGEXP_SUBSTR (extract) For example, the expression of the mobile phone number: ^ [1] {1} [35] {1} [[: digit:] {9} $You can query customer information tables (tKHXX) that contain

RMAN is a backup and recovery tool provided by Oracle. It can be used to back up and restore database files, archive logs and control files. It can also be used to perform full or incomplete database recovery. RMAN can be controlled by the command

If your machine already has an Oracle database, it is very simple. Navicat can be directly connected to Oracle. If it is not installed, Navicat will prompt you to install the Oracle client. If it is not necessary, do not install the Oracle client.

Due to development needs, I want to implement some common prompts. For example, the prompt message content is: "The XXX value YYY is incorrect. Please check and enter it again !", Then, the general information should be: "{0} value {1} is incorrect.

The scott/tiger user is not installed when the Oracle10.2.0.1 database is installed. The following table lists how to create a scott user and the user: You can find this script in $ ORACLE_HOME/rdbms/admin/scott. SQL to create it, Dlp->

Method 1: Use sqlplus 64-bit: [Oracle @ qs-wg-db2 ~] $ Sqlplus/as sysdba;   SQL * Plus: Release 10.2.0.5.0-Productionon Sun Sep 25 08:57:22 2011   Copyright (c) 1982,201 0, Oracle. All Rights Reserved.     Connected: Oracle Database 10g Enterprise

Today, we will introduce the entire process of installing Oracle 10 Gb in Red Hat Enterprise Linux AS 5.4. 1. Download Oracle 10g First, describe in detail my environment, system: Virtual Machine Red Hat Enterprise Linux AS 5.4, Database: Oracle

Oracle RAC clusterRAC, short for real application clusters, is a new technology used in the new version of Oracle Database, It is a type of high availability and the core technology that Oracle databases support the grid computing environment. An

The following is a description of parameters in the my. cnf configuration file: [Client] Port = 3309Socket =/home/mysql/tmp/mysql. sock [Mysqld] ! Include/home/mysql/etc/mysqld. cnf # contains the configuration file and stores the user name and

DSG SnapAudit database audit software Next-generation database Audit solution-Oracle Database 1 core issues and requirements of Database Audit 1.1 Analysis of Main Causes of Database Security Vulnerabilities There are three main causes of database

1. Oracle scheduled task: Crontab-e * ***/Home/oracle/workspace/scripts/bk_main.sh>/home/oracle/workspace/log/bk_err.log 2> & 12. Main Control Program /Home/oracle/workspace/scripts/bk_main.sh #! /Bin/bash   Dat = 'date + '% m''   If ($ dat = 0

To configure a Cluster, you must at least configure1 MGM (Management node) + 1 SQL node + 2 Data NodeMGM can share a machine with the SQL node, and the data node occupies a server separately.This requires at least three servers. Sometimes it will be

Recently, the company needs to switch the Oracle database to another server and use EXP and IMP to export the import tool. After a long period of time, an error is returned... All kinds of tangle... Therefore, a simple cold Backup recovery mechanism

Oracle 11g online recovery temporary tablespace -- Database versionSQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit

Two days ago, the leader gave a live migration to the database. The original system was using the Oracle database and now it was going to be changed to MySql. At that time, I did not think much about it. The original system used the Frame Type SSI,

After the rac has been installed some time ago, You need to verify whether the Rac is correctly installed and how to start and close the Rac. Start learning Rac today and record your notes again! First: Verify RAC: Verification listening: Node