Oracle

Quickly install Oracle Database 10 GB on RedHat AS3: Su-root Dd if =/dev/zero of = tmpswap bs = 1 k count = 900000 Chmod 600 tmpswap Mkswap tmpswap Swapon tmpswap Check the tmp space and run the command: $ df/tmp If the temporary space is

The main content of this article includes: Implement Auto-incremental ID in Oracle and delete repeated records in the data table. I. Auto-incrementing ID 1. First create sequence Create sequence seqmax increment by 1 2. Get an ID Select seqmax.

Common Oracle commands for creating users, tablespaces, and role commandsThe following articles mainly introduce how to view the table structure in common Oracle commands. If you are interested in the actual operating solution of how to view the

Oracle materialized view generally uses a materialized view because there are a large number of query summaries and the speed is taken into account. I simply sorted out what I used. First look at the simple creation statement: create materialized

Rac creates a data file in a non-shared location. oracle 11g 11.2.0.1linux server 64-bit 5.4 node1: Creates a data file '/tmp/rman. dbf' is not stored in the shared disk. Then, a table casd is created and data is added. In this case, the following

An SQL statement is used to query the names of students whose scores are greater than 80 in each course. There are three tables: S, C, and SC S (Sno, Sname) C (Cno, Cname) SC (Sno, Cno, grade) --------------------------------------------------

The method for querying the encrypted string of a password in Oracle is also rewritten based on the results of the online cool-man. The original requirement of the author was to verify that the user name and the plaintext Password Match. At that

In Oracle, The TO_DATE format and other date functions are in the TO_DATE format (take the time: 13:45:25 as an example) Year: yy two digits two-Year display value: 07 yyy three digits three-Year display value: 007 yyyy four digits four-digit year

If the oracle paging value is greater than or equal to the paging critical point, the SQL code SELECT * FROM (SELECT. *, rownum rn from (select * from t_agent t where t. agent_parent = 20020 and t. agent_state = 0) a where rownum 0; Incorrect: only

[Oracle] database security-audit Oracle audit is an afterthought task. After a database security problem occurs, you can trace the source of the problem to locate and discover it. Oracle audit mainly includes the following three parts: Trigger-based

[Oracle] Data Guard-Redo applications physical Standby and logical Standby Log application services are divided into two types, one is physical Standby Redo applications, similar to media recovery, its advantage is that the speed is fast, but in 10g

[Oracle] role switching between Data Guard-Switchover and Failover Data Guard master/Slave databases can be divided into the following two types: 1) SwitchoverSwithchover is generally artificially scheduled for role switching, such as upgrading. It

[Oracle] Data Guard-Create physical Standby experiment environment Primary: Host: jabdw1241SID: O01DMS0DB_UNIQUE_NAME: O01DMS0Standby: Host: jabdw1242SID: O01DMS0DB_UNIQUE_NAME: O01DMS0DR 1. primary configuration and operations 1) confirm that

ORA-01548: active rollback segment XX found, terminate dropping tablespace execution statement: drop tablespace name error: "ORA-01548: active rollback segment '_ SYSSMU11_4270384673 $ 'found, terminate dropping tablespace error cause: to delete the

[Oracle]-[sort aggregate]-count and index Oracle10g: create table t_count as select * from dba_objects; create index t_count_ I on t_count (object_id): select count (*) from t_count; select count (object_id) from t_count; select count (object_name)

Oracle cold backup and Hot Backup scripts cold backup scripts: set feedback offset heading offset verify offset trimspool offset echo offset time offset timing offset pagesize 0set linesize 200define dir='/backup/cold/mike';define

Command to create an oracle tablespace and user this article describes how to use commands to create an oracle user. SQLPLUS login system user! -- Create an instance: Database Configuration AssistantCreate a database Partition 1: query the

Encountered ORA-01078, LRM-00109, ORA-27046 SPFILE file File Corruption solved today when starting the database encountered $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.4.0-Production on Tue Jul 16 21:28:03 2013 Copyright (c) 1982,200 7, Oracle.

The role and description of password file orapwd in Oracle before the database is started, database built-in users are password files that cannot be verified by the database. The usernames and passwords of sysdba/sysoper users can be verified by

Load: oracle tool: sqlldr consists of four steps: creating a table with a source data file (test.txt) and creating a control file (test. ctl), create a bat file (or shell file) focuses on: If the table has the number type, or the date data type can