Database Administrator

Install software using Oracle Universal Installer (OUI)You can use Oracle Universal Installer (OUI) to install your Oracle software. OUI is a GUI tool that allows you to view the Oracle software installed on your machine, install new Oracle software,

Requirement Description Because the LOGRETAIN = ON database configuration is used, the database log files will not be automatically deleted or recycled by the database from the active log directory, and more log files will be stored in the active

From the perspective of most system application instances, query operations account for the largest proportion in various database operations, and the SELECT statement based on query operations is the most costly statement in SQL statements. For

I. Software Environment 1. windows nt4.0 + oracle 8.0.4 2. oracle installation path: c: \ orant Ii. Meaning   Iii. Usage 1. Compare the size Select decode (sign (variable 1-variable 2),-1, variable 1, variable 2) from dual; -- smaller value

Why View A view is a convenient method. It only gives users access to a part of a table. The view can restrict the returned records and available fields. Therefore, users are authorized to access this view rather than the table itself to restrict

You need to query the content of the uploaded file as required by the project. By using MSDN, we learned that the Windows Index Service can retrieve the full text of a file and query it through SQL Server. The project combines the two to achieve

I. Database Name It is the name of the database you created when installing the oracle software, or the data you created after installation. It is mainly used to install multiple databases in an oracle database, The distinction between them. A

This article is intended for database administrators who want to learn about Oracle. It is hoped that this article will give you a deeper understanding of the time, numbers, and character formats in Oracle. BKJIA database also recommends the Oracle

Recently, I encountered the problem of "how to connect SQL to remote MySQL", and now the problem is finally solved. I posted the method: (my operating system is Win7, and the database is SQL2005 .) 1. Install the mysql odbc driver on the SQL SERVER;

The question of 'how MySQL connects to a remote SQL 'has been considered for more than half a month, previously, I had been struggling to find a direct method similar to how I made 'SQL connection to remote mysql' and find a suitable

BKJIA exclusive Article] I recently upgraded MySQL from an earlier version of MySQL 5.0 to Percona Server 5.1. This is a classic upgrade scenario. Some exceptions may occur during the upgrade process. The master server and several slave servers must

1. How to analyze LogMinerCurrently, the only way to analyze Oracle logs is to use the LogMiner provided by Oracle. All changes to the Oracle database are recorded in the log, however, we cannot understand the original log information at all, and

PrefaceMost Oracle Database performance problems are caused by unreasonable Database design. Only a small number of problems are rooted in the unreasonable configuration of memory modules such as Database Buffer, Share Pool, and Redo Log Buffer, and

Oracle recovery management (RMAN) has many features that can be used to help Backup and Restore processes. The tool has command line and GUI versions. Oracle recovery management (RMAN) has many features that can be used to help Backup and Restore

The following steps demonstrate how to port the master device to a different disk. While executing this task, please refer to SYBASE's related documentation Technical Documents #1324 entitled "Segment Remapping with Load database When Moving a

First of all, I am talking about the conversion between ACCESS2000 and SQL2000, and I have not tried any other products yet. I hope you can experiment more and there is definitely a solution. Conversion Method 1. Open "database source" in

I. Necessity With the development of database technology in recent years, Informix Dynamic Server represented by Unix platform and ms SQL Server represented by NT platform have been widely used. In a public environment, there are a large number of

1. Start and close the database 1) Start the database $ SvrmgrlSVRMGR> connect internal (instance startup)SVRMGR> startup 2) shut down the database $ svrmgrlSVRMGR> connect internalSVRMGR> shutdown [immediate/abort]

The following is an example of backing up a database: 1. Tables involved in pre-Backup read locks Mysql> lock tables tbl1 READ, tbl1 READ ,...If you use the -- lock-tables option in the mysqldump utility, you do not need to use the preceding SQL

BKJIA quick translation] in order to achieve a successful success, I will take some preparatory steps and they will be required to check what happened, these steps include running the plustrce SQL script, creating an "EXPLAIN_PLAN" table, granting