Oracle

In previous articles, we introduced the actual Oracle RMAN backup operations and some common commands. We all know some commands in Oracle RMAN backup. In the actual environment, it is impossible for DBAs to require one command for each

This article provides an indirectExcelData Import inOracleMethod: UseSQL ServerClose relationships with Excel. in SQL Server, use the OpenDataSource method to read Excel and spell the data into an oracle-compliant SQL statement. Run the following

InOracleDatabase,Control FileIs very important. It is used to record and maintain databases. When the database is restored, the server process and background process need to read various backup-related information from the control file. If the

Handle bare devices on Unix systems: 1. What is a bare device? A bare device, also called a raw partition, is a special character device that is not formatted and not read by Unix through a file system. It is read and written by the application. It

Common SQL * PLUS commands:Conn system/rr: log on to the databaseDisc: disconnectShow user: displays the current userExit: exit the system.Clear: clear screenStart d: \ aa. SQL [arg1 arg2 arg3]: run a script and specify parameters. Replace the

My linux version is centos5.5 and the kernel version is 2.6.18-194. el5. in linux, it is best to install the oracle System with 1 GB memory and 2 GB swap space. The hard disk requires at least 4 GB space.1. Download oracleGo to the oracle official

The company just launched a set of Oracle 11gR2 RAC. When MEMORY_TARGET memory is set to 12 GB, an error is reported during startup:ORA-00845: MEMORY_TARGET not supported on this system  00845,000 00, "MEMORY_TARGET not supported on this system"// *

1. After logon, My Objects is automatically selected by default. After PLSQL Developer logs on, All objects is selected in Brower. If the user you log on to is dba, expand the tables directory, in normal cases, Wait takes several seconds, and the

PL/SQL USE INSERT... to INSERT multiple rows in a SELECT statement, we usually use the INSERT command to INSERT rows into a table. Sometimes, you need to add specific data to the target table based on the records of existing tables and views, you

Oracle 11g Release 1 (11.1) tablespace -- create and expand (permanent) tablespaces this article content create (permanent) tablespaces view tablespaces extended tablespaces www.2cto.com creation (permanent) tablespace Oracle manages tablespaces by

Without third-party tools, view SQL Execution plans SQL> connect sys as sysdba -- create the table SQL used by the execution plan> @? \ Rdbms \ admin \ utlxplan grants the Autotrace permission to each user by using the following methods. If you need

The Schema SQL code www.2cto.com in Oracle DB is officially defined as follows: A schema is a collection of database objects (used by a user.). schema objects are the logical structures that directly refer to the database? S data. A user is a name

Oracle learning records: RMAN backup/recovery process oracle learning records, RMAN usage, backup and recovery. (1) create tablespace cata datafile 'cata01. dbf 'size 200 m; -- cata01.dbf is in/oracle/db11g/dbs by default (2) create user kata

When Oracle starts the listening service, error 1067 is displayed: the process is terminated unexpectedly. 1. Scenario Description: The intranet IP address of a Windows Server (dual Nic) is changed and the computer is restarted. After the computer

Data Guard log transmission optimization ------ network transmission optimization practices (I) adequate network bandwidth is the basis for log transmission optimization www.2cto.com experience value budget formula: bandwidth demand = log generation/

Oracle data dictionary introduction and use of Chinese name: data dictionary English name: data dictionary Definition: a set of information about all objects in the database and their relationships. A Data Dictionary defines and describes data items,

Oracle 10g Regular Expression REGEXP_LIKE usageThere are four functions that support regular expressions in ORACLE:1. REGEXP_LIKE: similar to LIKE2. REGEXP_INSTR: similar to INSTR3, REGEXP_SUBSTR: similar to SUBSTR4. REGEXP_REPLACE: similar to

[Oracle] Transparent Data Encryption technology-TDE the full name of Oracle TDE is Transparent Data Encryption. It supports column-based Encryption from 10gr2 and table space-based Encryption from 11 GB. It is transparent to applications and easy to

The query results of the oracle database table name and field information in the table are the table name, field name, field type, field length, and default value. Select col. TABLE_NAME, col. COLUMN_NAME, col. DATA_TYPE, col. DATA_LENGTH, col.

Oracle sequence parameters: nextval and currval. Nextval returns the next avaiable sequence value. it returns a unique value every time it is referenced, even for different users. currval obtains the current sequence value. open the first session