Oracle

11g scheduling -- job uses Runtime (www.2cto.com job_name IN VARCHAR2, job_type IN VARCHAR2, job_action IN VARCHAR2, number_of_arguments IN PLS_INTEGER DEFAULT 0, start_date in timestamp with time zone default null, repeat_interval IN VARCHAR2

Converts oracle rac to a standalone database. stop database and CRS on both node $ srvctl stop database-d mydb # crsctl stop crs www.2cto.com 2. turn Off RACSQL> startupORA-29702 error occurred in Cluster Group Service operationRelink with the rac

When "Database Configuration assistant" is used to report "when Database Control is used to configure the Database ,...... Configure listener warning when you click Continue in step 4 of Oracle "Database Configuration Assistant", the message "When

Oracle 11g remote Logon Setting (using plsqldev or sqlplus remote logon) using plsqldev or sqlplus remote logon to oracle configuration: these three configuration files are under your oracle installation directory: 1. sqlnet. ora configuration

Oracle user and permission assignment SQL code -- log on to the database through the console: sqlplus kely/kely @ ORCL_localhost -- user set: dba_users select * from dba_users; -- use the system user to create a new user -- create user username

The test of RMAN as compressed backupset is AIX 5303. The RMAN backup of the ORACLE 10202 database occupies a lot of disk space, and it also increases with the increase of data volume. It now occupies 130 GB, it is 40 Gb higher than the 90 GB in

Remote expdp network_linkEXP imp is often used to export data to oracle databases, but the efficiency and performance are not high. Many auxiliary functions are not powerful,For example, dynamic file segmentation is not good enough.The new expdp and

Oracle Database PL/SQL adaptation for new usersThese two are naive enough to be depressing, for no reason, the 32-bit PL/SQL cannot connect to the 64-bit OracleDatabase. I have already abandoned PL/SQL, but chose Oracle SQL Developer. HoweverOnce PL/

[Oracle Log file recovery] background of corrupted archived and non-current Redo LogFile: today, I want to practice the Incremental backup of rman. The original test database is in non-archive mode. After calling and shutdown the instance, the open

Oracle initial parameter file spfile and pfile 1. When the database instance is started, allocate the memory of the oracle instance and open one of the two initial parameter file types: Server parameter file (SPFILE; text-based files, such as "init .

The oracle Stored PROCEDURE generates the xml file create or replace procedure Pro_OracleToXML (personid varchar2, name varchar2, address varchar2, tel varchar2, ip varchar2, email varchar2) AS isql varchar2 (200 ); -- create a temporary table

Oracle Database Chinese sorting Oracle Database Chinese pinyin Sorting Problem, before NLS_SORT settings (ZZ) Oracle9i, Chinese is sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i. 1. Set the value

Introduction to Oracle nls_sort and nlssort sorting functions (1) Before alter session set NLS_SORT = '', sorting affects the entire SESSION Oracle9i, Chinese is sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added

The binding variables before 11g Adaptive Cursor Sharing 11g have a peek, leading to some binding variables that cause execution plan problems. Study the Adaptive Cursor Sharing [SQL] SQL> select * from v $ version; BANNER Release Oracle Database

PL/SQL usage habits 1. After logging on, the My Objects Tools menu -- Brower Filters will be automatically selected by default. The order window of Brower Filters will be opened and "My Objects" will be set to the default one. 2. when PL/SQL is

Use PL/SQL to connect to other Oracle databases1. Download the Instant ClientOracle official website address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlThe downloaded file is a compressed file. The

The similarities and differences between truncate, delete, and drop are as follows: 1. truncate and delete without the where clause delete and drop both delete the data in the table. Differences: 1. truncate and delete only delete data, and do not

Batch execution of bulk collect and forall usage bulk collect clause will batch search results, that is, one-time bind the result set to a collection variable, and from the SQL engine to the PL/SQL engine. Bulk collect can be used in select into,

RAC statement knowledge 1. check the CRS status crsctl check crscrsctl check hascrsctl check clustercrsctl check cluster-allcrsctl stat res-t crsctl stat res-t-init 2, VOT disk query crsctl query css votedisk 3, Verify the integrity of OCR: ocrcheck

I was a newbie upgrading ORACLE databases from 10.2.0.1.0 to 10.2.0.2.0. Today I tried ORACLE database upgrades on a virtual machine twice, so I found that my initial thought was wrong! The original Database Upgrade requires two parts: 1. Upgrade