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

1 PrefaceStarting from the basic principles of Oracle databases, this article discusses in depth the basic principles of online ORACLE database backup and provides a method for remote replication of ORACLE databases, that is, the implementation of

Oracle beginners often ask this question. Here is a unified answer.1. If you have a certain database foundation and know what SQL is going on, you can skip to 2 even if you cannot write simple SQL statements. Otherwise, let's take a look at the

My current project contains a table with 62 million rows and more than 500 columns. The data comes from outside SQL Server. The tables they arrive at have a primary key, and all the remaining columns are saved in varchar (50) format. Problem Solving

Shutdown database (do not use shutdown abort to force shutdown), implement a file-level backup, back up all Oracle related files, including Windows system files, system status and Oracle program files and data files. This cold backup is critical for

Tora is a database tool similar to toad in unix/linux.In Ubuntu (Dapper Drake), Tora installed with apt-get has only one provider of PostgreSQL. Method to add Oracle Support to Tora. The general steps are as follows (there are several differences

As the company's website traffic grows, MySQL naturally becomes a bottleneck. Therefore, I have been studying MySQL optimization recently. The first step is to naturally think of MySQL system parameter optimization, as a database system for a

No one would deny that Oracle is one of the most influential database products in the world; but good things do not seem to be so useful (it seems at first ), even a bit heartless-it always gives layman a heartless error number. My personal summary

Installing and configuring PostgreSQL in Ubuntu is relatively simple, but you need to pay attention to some details. The installation steps are as follows: You need to pay special attention.1-$ sudo apt-get install postgresql-8.1 # Apt-get install

Mysql> set @ SQL _text: = 'select count (*) from test ';Query OK, 0 rows affected (0.00 sec)Mysql> prepare stmt from @ SQL _text;Query OK, 0 rows affected (0.04 sec)Statement preparedMysql> execute stmt;+ ---------- +| Count (*) |+ ---------- +| 0 |+

If the table file or index file in mysql is corrupted, the error code 144,145 is displayed when you operate on the table. You can fix the error as follows:(1) Use repair table table_name to modify the mysql command line;(2) fix the problem in the

Reset the root user password of the MySQL database 1. Stop the running MySQL process In Linux, run killall-TERM mysqld In Windows, if it is written as a service, you can run: net stop mysql. If it is not loaded as a service, you can directly

1. decompress the Oracle9204 Installation File 1. Oracle 9iR2 (9.2.0.4) (1) simplified process (log on to oracle, release installation files, and use less disk space, faster) When installing LINUX, it is best to divide it into one partition/orasetup.

Note that the mysql rpm package can be successfully installed on the linux Personal Edition, but installing mysql on enterprise as4 is a little troublesome. Even if it is installed, there are problems. Therefore, I personally recommend that you

The following describes how to back up a DB2 database: Operate Under db2inst1. Run the following command in the current directory where you want to save the data: $ Db2stop force (stop database) $ Db2start (start database) * Run the following

I. Overview Object statistics describe how data is stored in the database. For example, how many rows of data exist in a table and the maximum value of a column. This information helps the query optimizer find the correct and efficient execution

Mysql may have different codes installed on windows and linux. If garbled characters occur during data import and export from these two databases, therefore, we can add a forced encoding to import and export databases: 1. mysql-uuser-p --

Manage password security and parameters in the resource profile (configuration file) configuration file 1. Resource Restriction Parameters Session-level resource restrictions   Invocation-level resource restrictions   2. password management

Like many netizens, today encountered a ora-01882 problem, checked matelink solved! Environment:Oracle server version:SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle Database 10g

Lab instructions 1. In non-archive mode: SQL> archive log listDatabase Log mode non-archive ModeDisable automatic archivingArchiving end point USE_DB_RECOVERY_FILE_DESTOldest online log sequence 2491Current Log sequence 2493 Use the sys user to