Database Administrator

SQL> select * from v $ version where rownum BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production Create index I _test_owner on test (owner ); SQL>

The following is the official Oracle Database, which is listed here. We hope to reduce the search time. Download it now ~ Oracle Database 11g Release 1 (11.1.0.6.0) Standard Edition, Standard Edition One, and Enterprise Edition

Control the SQL * Plus environment and Data Dictionary 1. Control the SQL * Plus Environment A) SET environment variable value B) SHOW environment variable | ALL   SQL> show all Appinfo is OFF and set to "SQL * Plus" Arraysize 15 Autocommit

Many problems occurred when installing RAC. The summary is as follows: 1. During installation, ohasd cannot be started because root. sh is running at the same time at two nodes and an error occurs. Then delete and reinstall the disk. The previously

Description:Originally, one-way transmission of Streams was directly configured on two database servers,The original source database is two clusters of 64-bit HP-UNIX Oracle11gR2 database,The original target database is a 64-bit Linux Oracle11gR2

A key improvement of FORALL statements, which greatly simplifies code and significantly improves performance for programs that want to update many rows of data in PL/SQL programs.1:Use FORALL to enhance DML processing capabilitiesOracle introduces

We know that the Flashback Table can restore the drop Table from the recycle bin, but not everything about the Table can be returned by Flashback, such as foreign key constraints. Duzz $ scott @ orcl>Create TableD (deptno numberPrimary Key,

This document describes how to install a MySQL management tool on Ubuntu 11.04 and connect to a remote host. This article describes most of the operations on the Debian operating system. Install MySQL Administrator.First, find the software and run

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

The scott/tiger user is not installed when the Oracle10.2.0.1 database is installed. The following table lists how to create a scott user and the user: You can find this script in $ ORACLE_HOME/rdbms/admin/scott. SQL to create it, Dlp->

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

For more information about PowerDesigner, see: PowerDesigner 15 Overview This article mainly describes the CDM model and its usage. 1. Overview of concept data model (CDM)Conceptual Data Model: Conceptual Data Model, which is based on the

1. Oracle 11g has a feature. If exp/imp is used to import and export the database, no data table cannot be exported, I have also encountered this problem. After research, I think it is best to use expdp/impdp to export and import data to avoid this

The operating system is Linux as5 and the database is 10 Gb. After the machine is restarted, @ connecct_string cannot be used to connect to the database. You can only use the user/password. Summary later: this problem occurs when two databases are

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

Refer to Oracle official installation documentation: http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html 1> Installation preparation 1.1> download oracle Installation program on the oracle official website download

1. When Oracle UCM is started, the console reports an error.The following exception occurs when you view logs: ------ #### Java. SQL. SQLException: ORA-28001: the password has expired ------ Java. SQL. SQLException: ORA-28001: the password

RAC asm restored to a single instance Rac source server: Rac1: 192.168.100.201 Rac2: 192.168.100.202 Target Server: 192.168.8.201 The recovery procedure is as follows: Restore the initialization parameter file-> modify the parameter file-> restore

The number of records in the database table is as follows: SQL> select count (*) from table_name t; COUNT (*)----------6873 1. Statistical results using count: SQL> alter session set nls_language = "American "; Session altered. SQL> set timing

DBAs often hear that archiving logs and master databases are not synchronized because of inadequate monitoring of mongouard. what's even worse is that the master database usually has RMAN backup, Archive logs are usually deleted after full-database