Database Administrator

I. Switching users To control and manage Oracle, you must first switch to the Oracle user. The following command is generally used: Su-oracle Ii. Start the listener To remotely connect to the database, you must start the listener by using the

Developed and used TOMCAT version 5.0.28MYSQL database mysql-5.0.22 for Development and UseMYSQL database development tool Navicat_MySQLJDK1.4 Basic work: 1. Configure the environment variable JDK environment variable: JAVA_HOMETOMCAT environment

The following process is a step-by-step installation step. 1. Install the RPM packageRpm-aq | grep libgcc // check the package fileRpm-Uvh * // install all package filesBinutilsCompat-dbCompat-libstdc ++Control-centerGccGcc-c

When the number of records in the MySQL table exceeds 0.3 million, the following error occurs: "Select * from gll_pro_ru WHERE 1 = 1 order by id DESC Select * from gll_pro_ru WHERE 1 = 1 order by id DESC limit 0,10000 Fatal error: Allowed memory

In Fedora 11, it is difficult to install the source code MySQL. The installation process was recorded here for a long time. Ps: the directory paths involved in this article are all my local directories. You can adjust them by yourself. Ps: I use 5.1.

In database operations, delete, insert, and update databases are often required. When a table changes, other tables can be changed accordingly. Write down below, today I have studied the trigger knowledge in Linux for one day: Delete --> oldInsert --

As we all know, the MySQL InnoDB Storage engine is very similar to Oracle and supports transactions and row-locking. After actual tests, a big difference between innodb and oracle is: the same data, the length of innodb single-row storage is

IDC statement: This article published by does not mean that you agree with it or confirm its description for the purpose of transmitting more information. Today, I finally installed a new Ubuntu 8.10 virtual hard disk in the vbox. It is estimated

Installing rlwrap on Linux is very simple,# Tar-zxvf rlwrap-0.30.tar.gz# Cd rlwrap-0.30# Configure; make install # Vi/home/Oracle/. bash_profileAddAlias sqlplus = 'maid sqlplus' You can also use rlwrap on solaris 10 to add the historical echo

The output formatting of the MySQL client is amazing. I didn't notice it before. I 'd like to share it here:$ Mysql-uroot-e "show global status like 'uptime '"+ ----- + --- +| Variable_name | Value |+ ----- + --- +| Uptime | 2174838 |+ ----- + --- +

Restoration After Oracle Deletion Savepoint; Delete from student; Rollback to; Modify date format in Oracle Alter session set nls_date_format = 'yyyy-mm-dd' Query records with blank or non-empty fields in Oracle Select * from student where

When using the SQL statement generated by powerdesigner to create a table, I do not know how to add a space in the table name. I did not care to directly run it in PL/SQL, it is difficult to use the statement or right-click to delete the file. When

Today, the company purchased a us vps, Linux operating system, which is managed through the Container. The system is pre-installed with MYSQL, And the password is generated randomly (contact the technician over there to obtain satisfactory results)

1. The LONG data type stores variable-length strings with a maximum length limit of 2 GB. 2. For text that exceeds a certain length, the LONG type can only be used for storage. Many objects in the data dictionary are defined as LONG. 1. The LONG

EnvironmentCentOS6.4 _ 64Network Configuration192.168.10.167 OS-14192.168.10.166 OS-13192.168.10.151 OS-1192.168.10.152 OS-2192.168.10.153 OS-3192.168.10.154 OS-4192.168.10.155 OS-5192.168.10.156 OS-6Architecture and resource allocation192.168.10.151

Recently, Oracle data migration was conducted. There was an article about migration ideas. Here we will continue the specific test. The topic is about table space transmission. Oracle transfer tablespace Upgrade Oracle 9i to 10 Gb using a writable

1. Basic data type Character TypeChar can be up to 2000 characters in lengthExample: char (10) 'database' stores 'database' with the first six characters, followed by 4 spaces.Varchar2 () is a string of up to 4000 characters.Char queries are fast

There are four types of Oracle index scans based on different index types and where restrictions: 3, 4, which can be normalized.(1) unique index scan (index uniquescan)(2) index range scan)(3) full index scan)(4) index fast full scan)(5) index skip

See this post mentioned a ORA-12519 problem handling: Oerr explanation: 12519,000 00, "TNS: no appropriate service handler found"// * Cause: The listener cocould not find any available service handlers that// Are appropriate for the client

Host A and host B are installed in the testing environment respectively.Operating System: linux 6.4,Database: Oracle 11g r2Host A: Install the oracle 11g r2 DatabaseHost B: Only oracle 11g r2 software is installedStep 1: run the following rman