Oracle

Oracle 11g RAC Production environment Deployment detailsTian Yi ([email protected])Basic planningEquipment selection1, server: Dell R620 two units. CPU 8 core, Memory 64g,600g 15000-turn SAS hard drive, dual power supply, HBA card piece, connect

Each group of queries can get its result set, and if you want to combine multiple query results into a single result set, you can use the set operation to implement.such as the Union, set, and do not remove duplicate rows (unoin all), intersection

Beginners often confuse terminology such as Oracle instances, Oracle databases, and Oracle servers.Typically an Oracle database can be divided into two parts1. Example (instance)An instance is a non-fixed, memory-based, basic process and memory

Download zip package Oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip Oracle-instantclient11.2-jdbc-11.2.0.1.0-1.x86_64.zip Oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip Oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.zip

Use on DELETE cascade and on delete set NULL in Oracle to establish foreign keysThe surface we describe the creation of a foreign key constraint when using the Oracle default creation method, when deleting the referenced data will not be deleted,

Transferred from: http://lorry1113.javaeye.com/blog/513851Keywords: Oracle stored procedures1. Basic structure CREATE OR REPLACE PROCEDURE stored procedure name (parameter 1 in number, parameter 2 in number) is variable 1 INTEGER: = 0; Variable 2

It seems that some people still do not understand the true meaning of the schema, and now I have to tidy up a bit, I hope to be helpful to everyone.Let's start by looking at their definition:ASchemais a collection of the database objects (used by a

1 PackageOracle;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 ImportJava.sql.ResultSet;6 Importjava.sql.Statement;7 8 //Connect to Oracle using JDBC9 Ten Public classtestoracle { One A Public Static voidMain (string[] args) {

Create user MCC identified by manager; Note here that the password should not be extended with single quotes. Drop  user  mcc  cascade; Direct Delete user Create user MCC identified by manager D Efault tablespace mcc01 temporary

Logical backup and Recovery of database (table)--ExportSystem can export any scenario, for example:Exp System/[email Protected] Owner (System,scott) file=d:system.dmp;//Note: Two scenario system scenarios and Scott scenarios can be exportedexp

I. OverviewUndo saves the old data. For example, if you modify a record to modify the A-column ABC to Def, then undo holds ABC. There are two purposes: 1. If your transaction is not committed, but the column A has been modified, then someone reading

Oracle Two time subtraction default is the number of days Oracle two time subtraction default is the number of days* -The number of hours for the difference Oracle two time subtraction The default is the number of days* -* -number of minutes for

IMP and the EXP CommandOracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import the DMP file from a local

Common execution time for Oracle job 1. Execute Every Minute TRUNC (sysdate, ' mi ') +1/(24*60) Www.2cto.com 2, daily scheduled execution For example: Performed 0 o'clock in the morning daily TRUNC (sysdate+1) Performed 1 o'clock in the morning

Oracle provides a number of system parameters, the following is a summary of query methods.System Current ParametersThe current parameters of the system relate to these views: V$parameter, V$parameter2, V$system_parameter, V$system_parameter2, and V$

Oracle Data Import Export IMP/EXPFunction: Oracle data import and export imp/exp is comparable with Oracle data restore and backup.In most cases, the data can be backed up and restored with Oracle data import and export (no loss of data).Oracle has

How can i use PL/SQL without installing Oracle? Oracle is hundreds of M, and in today's machine configuration, of course, space is not a problem, but sometimes some of the services that are launched have a small performance impact. Use Instantclient

1. What is an exception?A: Exceptions are errors that occur when the program is running! Short run-time error. After an exception occurs, the statement stops executing and control shifts to the exception handling section.Some exceptions are

After a large number of records are deleted in Oracle, the data block space used in the tables and indexes is not released.Table move frees up the data block space occupied by the deleted records table and organizes the fragments. If you defragment

[Oracle] PSU upgrade processThe following is the content in the PSU's readme file: 3.2 Patch Installation InstructionsFollow these steps:If you are using a Data Guard Physical Standby database, you must install this patch on both the primary