Database Administrator

This article describes several methods to quickly find duplicate records in Oracle databases. As an Oracle database developer, you often need to create indexes for one or several columns of tables to provide direct and fast access to rows. However,

Appendix: The following are additional steps. If you want to run the MySQL database on this server, perform the following steps. If you only want PHP to support MySQL extension libraries and connect to MySQL Databases on other servers, you do not

Install Oracle 10.2.0.1 on RHEL5DownloadYou can download it from the Oracle homepage:Oracle Database 10g Release 2 (10.2.0.1) SoftwareDecompress the fileDecompress the downloaded file:Unzip 10201_database_linux32.zipThe configuration before

One thing that should have been simple and smooth, but encountered a lot of trouble in the actual process. For a new linux user, it is very easy to get stuck, so simply write it down, in this way, we can make progress every day! There is a

The ROWID (also called restricted Rowid) below Oracle 8 is: FFFF. BBBBBBBB. RRRR occupies 6 bytes (10bit file # + 22bit + 16bit). However, to expand the data file, change the Rowid to OOOOOOFFFBBBBBBRRR, occupies 10 bytes (32bit + 10bit rfile # +

Oracle has four types of constraint enabling and disabling: enable validate; enable novalidate; disable validate; disable novalidate. Enable constraints: Enable (validate): enable constraints, create indexes, and execute constraints on existing

# Su-Oracle$ Sqlplus/nologSQL> connect/as sysdba-- // Create a temporary tablespaceCreate temporary tablespace test_tempTempfile '/data/oracle/oradata/test/test_temp01.dbf' -- // File System in LinuxSize 64 mAutoextend onNext 64 m maxsize 2048

In Linux/UNIX operating systems, mysql or Oracle is generally used to use databases. This article describes how to install mysql in RHEL4. Other unix-like systems are also applicable. Token) 2. Decompress mysql to/usr/local.# Tar zxvf

Due to a problem with the stability of Fedora 14 in my current version, I decided to change it to Ubuntu 10.10, just because I had used this version for a while and felt that it was superior in performance, stability is also good (for Linux, you can

Last time I sorted out some concepts of DB2 database logs (basic knowledge of DB2 logs (1 ), however, it is difficult to manage and prevent archiving logs in the production environment and prevent log loss in case of disaster, because when the DB2

1. Forget the root user logon password for the mysql database. The solution is as follows: A. Reset the password. #/Etc/init. d/mysqld stop # Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & # Mysql-u root mysql Mysql>

Follow Finally, the Oracle installation is complete: Check the dependency package before installation: Rpm-q gcc make binutils setarch compat-db compat-gcc-c ++ compat-libstdc ++-devel unixODBC-devel libaio-devel sysstat There are missing yum

Impdp fail with ORA-31623 FYI: Data Pump import and export job use queues, streams and java objects. If we see any job component is invalid (e.g. dbms_java, queue dictionary scripts not run, rdbms/admin/utlrp. SQL not run) we may see the ORA-31623

Oracle 10g r2 installation clusterware ocr specified/dev/raw/raw1 Error The following error is reported:That is to say, the permission is incorrect or the owner is not an oracle/Dev/raw:Total 0Crw-rw ---- 1 oracle oinstall 162, 1 Feb 7 raw1Crw-rw ---

Change CentOS 6.4 to a Chinese Environment/Etc/sysconfig/i18n# LANG = "en_US.UTF-8"LANG = "zh_CN.UTF-8" Restart.----------------------------------------------------------------------- 1. Modify the Host Name and IP address of the system (this is a

In MySQL5.5, if you want to modify the size of the ib_logfile (redo log) file, follow these steps: 1. set global innodb_fast_shutdown = 0; Ii. mysqladmin shutdown 3. Modify the innodb_log_file_size parameter value in the my. cnf file. Iv. mv

System: Ubuntu 12.04 LTS MySQL version: 5.5.35-0ubuntu0. 12.04.2 (Ubuntu) Step 1: Download MySQL Workbench : Http://dev.mysql.com/downloads/tools/workbench/ After selecting the system version at the bottom of the page, you can download it. Step

Today is. During the database performance tuning process, I suddenly moved to the previous email with the following information: From the log, it is found that there is a row-level exclusive lock contention, resulting in a deadlock. Problem

The default Character Set of installed MySQL is latin1. To change the character set to what you need (such as utf8), you must change the related configuration file; in linux, the default installation directory of MySQL is distributed in different

Archive log is fullORA-00257: How to Handle archiver error. Connect internal only, until freed error1. Log On with the sys userSqlplus sys/pass @ tt as sysdba2. Check the location of the archiv log.SQL> show parameter log_archive_dest;NAME TYPE