Database Administrator

OraToolKit is a tool used to support and quickly deploy various Oracle software environments and support different versions of databases and operating systems. This toolkit also contains a more practical rlwrap. Everyone knows that sqlplus in linux

Pfile The pfile (ParameterFile) file is a text-based parameter file that contains database configuration parameters. Oracle 9i creates a pfile for each database during installation. The default name is "init + routine name. ora", which is a text

Friends who use Oracle 11G may have struggled with this problem. The data exported by the exp command may be inexplicably missing some tables, during the analysis, we will find that these tables are empty tables with no records inserted. The cause

The new feature of Oracle 11g r2, delay segment creation, that is, the default table created from 11GR2 does not set and allocate segment, and does not occupy disk space, which sounds reasonable, space is allocated only when the first data is

1. Concepts of Data Dictionary * Data dictionary is an important logical structure in Oracle databases. It is composed of read-only basic tables and views. All information about the Oracle server is stored in these basic tables. The information

Let's look at the example. To delete data from the game_pg_getpoint table, you need to associate it with the getpoint table. Delete from game_pg_getpoint USING getpoint WHERE (getpoint. fixflg = 1 OR game_pg_getpoint.immediately_flag = 1) AND

1. Introduction to PDM The Physical Data Model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be

1Alter database: Modify data files Alter database datafile 4 offline; Alter database datafile '/opt/Oracle/datafile/users01.dbf' offline; Alter database datafile '/opt/oracle/datafile/users01.dbf' resize 100 M; Alter database datafile

Move data objects between tablespaces I. BASIC script Moving objects between tablespaces in the Oracle database involves multiple types of data objects.Move Table: Alter TableT_aMoveTablespace tbs_a; Mobile index: Alter IndexI _a rebuild

Connect to the Hibernate configuration file of the Oracle databaseThe Hibernate configuration file connected to Oracle has two formats: xml and Java attribute file. The codes of the configuration files in these two formats are given below.1.

Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement.The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they

1. Use rman to back up Oracle Data in the open state Rman backup must be in archive Mode Check whether the archive mode is used. SQL> archivelog list; Change to archive Mode Shutdown immediate Startup mount Alter database archivelog; (alter database

Oracle archive logs are certainly not unfamiliar to everyone. The following describes how to modify the size of Oracle archive logs, hoping to help you learn about Oracle archive logs. Method: Add a new large log file and delete the old small log

Use Crontab in RedHat Linux to implement Oracle 10 Gb scheduled backup (including SFTP download instructions ). This is to say that regular backup is a hot backup, that is, writing a shell script. The syntax is oracle10g, and 9i is slightly modified

In an application environment, all servers use and manage the same database to distribute the workload of each server. The hardware requires at least two servers, A shared storage device is also required. At the same time, two types of software are

MySQL database errors caused by power failure or abnormal shutdown are very common problems. There are two methods: one is to use the check table and repair table SQL statements of mysql, and the other is to use multiple myisamchk and isamchk Data

If the database contains a federated primary key, such as Vcode and Vcompany (view method, right-click the Oracle database table and then view the key information to find the UK Information) Verify whether the Vcode and Vcompany are associated

The error is as follows:SQL> conn system/test @ testERROR:A ORA-01034: Oracle not availableORA-27101: shared memory realm does not existLinux Error: 2: No such file or directory 1. Check the environment variables and check whether the monitoring

In a large text (more than 1.5 GB), when there are both carriage return line breaks and carriage return end characters, if the size of the line feed end is greater than sqlldr's default buffer of 1048576, an error is reported. SQL * Loader-510: the

Today, the Oracle SQL driver plug-in is compiled on Mac. The compilation process is recorded here for your reference. First introduce the compiling environment: Mac OS X 10.7.3, install Qt SDK 1.2 for Mac, XCode 4.2.1. 1. first, download the