Oracle

11g scheduling -- scheduler use CREATE_SCHEDULE Procedure www.2cto.com This procedure creates a schedule. DBMS_SCHEDULER.CREATE_SCHEDULE (schedule_name IN VARCHAR2, start_date in timestamp with timezone default null, repeat_interval IN VARCHAR2, end_

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

Oracle 11g import and export table method summary also said, the above method: Export: www.2cto.com Fang Yi: 1. first set oracle_sid. 2. find the bin directory. my options are D: \> cd D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN 3.

When Data Guard uses alter system archive log current to maintain Archive Log Routine Maintenance Data Guard, we can use Archive Log management: www.2cto.com ① alter system switch logfile ② alter system archive log current what is the difference

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

How to deal with oracle tablespace insufficiency -- 1. view the table's select tablespace_name, table_name from user_talbes where table_name = 'test'; -- 2. Obtain the user's default tablespace select username, DEFAULT_TABLESPACE from dba_users

Using Oracle Data Pump to create an external table 1, Create an external table and generate dump file1, Create a directory and assign related privilege (create any directory) SQL> create directory test as '/home/oracle'; Directory created. SQL>

PL/SQL block definition part-LOB type in earlier versions of Oracle, use the LONG and LONG RAW types to store and enlarge data. Oracle introduced the LOB data type since version 8i, and Oracle recommends that developers use the LOB data type instead

[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 session count and connection count configure ORACLE session count and connection count parameters log on to sqlplus sys/xxxx as sysdba; view maximum connections: show parameter processes; show parameter sessions; view the current maximum

You can use the command line to manually uninstall Oracle Database 11gR2. One is to use DBCA to automatically uninstall the Oracle Database, and the other is to manually uninstall the Oracle Database using the command. The following describes the

Summary of typical Oracle SQL statements @ SQL-plus key functions in series and SQL statement cases @ Chinese sorting details) 1. classic select SQL statement // note: the result obtained by a mathematical expression containing null values is a null

Statement [SQL] USE MyTargetDB go IF object_id ('wfp _ before_add_password_backup ') IS NULL SELECT o. name AS proc_name, s. definition INTO tempdb. dbo. wfp_before_add_password_backup FROM sys. SQL _modules s, sys. objects o WHERE o. object_id = s.

Oracle 11g RAC cannot use deinstall to automatically uninstall the grid. The manual uninstallation Method for oracle 11g RAC cannot use deinstall to automatically uninstall the grid. Manual uninstallation is great! 1. the root user is included in

Oracle exchange partition Exchange partition provides a way for you to migrate data between a table and a table, or between a partition and a partition. Note that it is not in the form of converting a table into a partition or non-partition, instead,

Notes for oracle learning-create table stu (id number (6) primary key, // primary key name varchar (20) constraint stu_name_nn not null, // enter sex number (1), age number (3), sdate date, grade number (2) default 1, // The default value is "1"

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,

Background of a temporary tablespace full problem: in our company, we have a dedicated demonstration environment. During pre-sales, we can use the above system for demonstration. Problem: today, when our manager demonstrated to the customer, the

11g -- statspack install statspack in 11g2, preferably sys user installation. The installation process is as follows: 1. First, create a tablespace for storing the data generated by statspack: create tablespace perfstat datafile