Database Administrator

First, Oracle dictionary tables and views can be divided into three layers. 1.1 X $ table This table is the basis for running Oracle databases. It is dynamically created by Oracle Applications When the database is started. These sub-tables are

130: the file format is incorrect. (The error is not clear yet)145: the file cannot be opened.1005: An error occurred while creating the table.1006: An error occurred while creating the database.1007: the database already exists and creation failed.1

In Oracle 9i, you can easily export data as files or import data from files. The Oracle Management Server (OMS) can be easily implemented. Many instructions are needed throughout the operation, but there are not many complete guidance materials.

RHEL AS4 (CentOS4.4) kernel version:[Xujg @ centos: ~] $ Uname-r2.6.9-42.ELOracle version and patch:10201_database_linux32.zip1. Create users and groupsGroupadd oinstallGroupadd dbaUseradd-g oinstall-G dba oraclePasswd oracle2. Create a directory

When logging on to phpPgAdmin: If you always get a "Login failed" and confirm that you have used the correct username and password and can log on normally in pgadminIII! Solution: Modify php. in the ini configuration file, set extension = pgsql. so

Introduction:Oracle10g is often used. We can find that a large number of junk tables appear in the database for previously deleted tables, as shown in the following example:BINjR8PK5HhrrgMK8KmgQ9nw =This type of table cannot be deleted and cannot be

1. Explain the differences between cold backup and hot backup and their respective advantagesAnswer: Hot Backup is applicable to databases in the archive mode. When the database is still in the working state, it is backed up. Cold backup refers to

1. install LINUXI installed LINUX 4.4 compiled by Oracle (5 is also available, but it does not support Chinese characters and garbled characters)1. If the most important role of this server is to install ORACLE, allocate a file system directly to

MYSQL command:Mysql-h host address-u user name-p password to connect to MYSQL; If MYSQL is just installed, the Super User root has no password.(For example, mysql-h 110.110.110.110-Uroot-P123456)Note: u and root do not need to add spaces. The same

It is relatively simple to uninstall the Oracle software in linux. You can simply delete the relevant directories and then clean up the oracle-related files in/etc. But it is still necessary to know how to uninstall it through tools. 1. Configure

In front of this article, a lot of such articles are searched on the Internet. Why should we write it out? The reason is that most articles on Oracle 9i on the Internet are incorrect, and no matter what the sender is, the installation method

Recently I plan to study the Linux bare device, so I tested it in linux to create an Oracle 10g Database Based on the bare device. Follow these steps: I. Partitioning Partition steps are not mentioned. The hard disk is divided into the following

After using MySQL for a long time, some problems may occur in the database. Most problems can be solved quickly through simple operations. The following describes two types of quick maintenance. MySQL database method. 1. myisamchk To use

When the mysql database is installed in Ubuntu and cannot be linked with the Navicat client, the following error ERROR is reported: error 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 1) you can log on to mysql-uroot-p123456 on

Oracle executes SQL statements to open, parse, execute, and close a cursor. After learning about the several phases of the cursor, We have figured out the SQL Execution process. This is the first content to be introduced in this article. In java

As the business volume increases, the amount of data to be stored also increases. If all data is stored in a database, it will inevitably increase the performance consumption of the database. This will eventually lead to user unfriendly feelings. In

Trace file:Each service process and background process can write some special information into the corresponding operating system file during the running process. This operating system file is called a tracking file.Each service process and

After the RegionServer node is expanded, You need to migrate some of the original Region to the new RegionServer to enable Load Balancing for each RegionServer. To improve the HBase write performance after one node is added, You need to evenly

Data Recovery after data is accidentally deleted in Oracle and committed Background: Table A is deleted due to data misoperations. -- 1. Back up the current data of Table A first. -- 2. query the SCN number before a certain time point Select max

Configure Mysql: 1. Install mysql in the specified directory and use the source code package. [Root @ localhost media] # tar-zxvf