Oracle

ORACLE11G cloning An instance by DBCA:1. ModelingDbca-silent (silent mode)-createclonetemplate (create clone template with existing database)-sourcedb (target data source)-templatename (template name)Cases:Dbca-silent-createclonetemplate-sourcedb

Adding a NOT null field before 11g is very slow, very fast after 11g, let's do a test first and then explore the principle.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g

1:oracle SQL Developer 4.0.2 download Link:Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html2: The downloaded file is sqldeveloper-4.0.2.15.21-1.noarch.rpm, RPM installation package cannot be installed directly on

Nothing to do, want to re-install Oracle 11g, recorded as follows:(1) First stop all Oracle services in the service;(2) Start, oracle-oradb11g_home1, Oracle installation products, Universal Installer, click "Uninstall Product"-"Expand All" After

1 environmentUbuntu 12.04 32-bit system in VMware virtual machines2 Specific installation steps① Download the latest JDK packageNote that the JDK distinguishes between 32-bit and 64-bit versions and is compatible with

Points of knowledge involvedA, the use of substitution variables with a &b, substitution variable usage with two &C,define command usaged, accept command usageE, custom Sql*plus environmentF. Save custom results in the Glogin.sql fileG,sqlplus Edit

The Decode function is one of the most powerful functions of Oracle PL/SQL, and it is currently available only to Oracle companies, and the SQL implementations of other database vendors do not yet have this function. What is the use of decode? Let's

A certain sequence of operations is required when the Oracle system processes the monthly-knot business.These operations involve the corresponding modules, including: Coping module, purchasing module, Inventory module, receivable module, payroll

Hot patches: Overview For bug fixes or diagnostic patches on Oracle instances, hot fixesyou can perform the following actions:? Installation? Enable? Disable Hot patches: Overview Use hot fixes to install, enable, and disableis runningOfActive

After the installation of Oracle (64-bit), PL/SQL, the following error occurs when you run PL/sql:According to the online data, my PL/SQL is incompatible with Oracle, that is, PL/SQL does not support 64-bit Oracle, so the next 32-bit Orcale client

Oracle roles, permissions, and users[Repost 2010-1-25 10:29:45]size: big medium small Oracle built-in role Connect and resource permissionsFirst give the user the Connect role and the resource role with a command:Grant Connect,resource to

I. Classification of databasesUsually according to the characteristics of the data model, the traditional database system is divided into three kinds of mesh database, hierarchical database and relational database.1. Mesh DatabaseAs the name implies,

Oracle EBS R12 file system structure (learning and summarizing online materials), ebsr12 The file structure of Oracle EBS R12 on the server is as follows: The top-level directory is divided 1) inst --- configuration information related to the

[Oracle] adds a new node to RAC Add nodes to RAC: Environment: OS: OEL5.6 RAC: 10.2.0.1.0 The original rac1 and rac2 nodes need to be added now: Procedure: Modify the/etc/hosts file on the three Nodes 192.168.90.2 rac1 192.168.90.5 rac2 192.168.90.6

Oracle System Variable Function Usage Guide, oracle Variables Oracle functions are diverse. System variable functions are one of the three most common system variable functions. Oracle System variable functions: 1) SYSDATE This function returns the

Oracle Performance Analysis 1: Enabling SQL tracking and obtaining trace files When there is an issue with Oracle query efficiency, we often need to understand the problem so that we can provide a solution to the problem. Oracle provides the trace

ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], [], ora-00600kcblasm_1 This error has been shown in the alarm log for the past two days: ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [],

Windows sqlplus/assysdba report the ultimate solution of ora-12560Windows sqlplus/as sysdba report the ultimate solution of ora-12560Windows, sqlplus/as sysdba often report ORA-12560: TNS: protocol adapter error, solve this error, there are multiple

There are two ways to ensure database security: one is to prevent security events through permission access control, that is, to prevent security events through pre-control; the other is database audit, that is, to track and record database

Basic PL/SQL entry cursor PL/SQL: a programming Language combined with a Structured Language (Structured Query Language). It is an extension of SQL and supports multiple data types, such as large objects and Collection types, you can use control