Oracle

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.

There are two very small processes in the Oracle database, but their role is very huge. Because it is relatively small, it is often ignored by the database administrator. This time I will remind you not to ignore the role of these two processes. If

Method 1: Add Set define off before the SQL statement to be inserted; when we run the SQL> show all command under SQL * PLUS in batches with the original SQL statement, we can find a parameter: define "&" (hex 26 ), as shown below ...... concat ". "(

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) --------------------------------------------------

PMON failed to acquire latch, see PMON dump solve the problem phenomenon: Database listening crash handling process: Database exception, after receiving the alarm, immediately log on to the server, lsnrctl status found that listener is dead, hurry

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

ORA-24816: when the actual LONG or LOB column is followed by an extended non-LONG Binding data solution to add an announcement, an error is reported when the content is entered too: ORA-24816: after the actual LONG or LOB columns, the extended

[Oracle] common wait event db file scattered read for tables that are frequently accessed, if no index is created or an appropriate index is not created, Oracle can only scan the entire table, this will cause a large number of waiting events. During

The ORA-01187 ORA-01110 error was encountered during data import, the most recent data import (IMP), because the database was restored using hot standby and the recovery was successful, because the database can be opened successfully, what are the

[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

Backup and recovery of KingbaseES 1. the database that backs up and recovers KingbaseES databases uses its command line tool sys_dump.exe. Its usage is as follows (): sys_dump.exe-h server_name-p 54321-U user_name-W password-B-f backup_file_path

Trouble shooting: FRM-30425 resolution keywords: Oracle Form buider FRM-30425 summary error information: [plain] FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. item: CNT_CON

EXP/IMP data migration recently, all data of a user in a small database needs to be migrated to another one. Now, we first simulate that the data volume is not large, use exp to export all data objects of the User: [SQL] [lubinsu @ localhost orcl] $

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

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

Differences between SYS and SYSTEM, DBA and SYSDBA: SYS and SYSTEM: 1. the role of sys is sysdba system and sysoper 2. sys has the create database permission. system does not have this permission. 3. sys can create and modify the base table and view

The difference between Oracle Schema and User can be seen from the definition that Schema is a set of database objects. In order to distinguish each set, we need to name this set. These names are the nodes with similar user names that we see in the

Oracle-RMAN backup (iii) I. concepts related to Incremental Backup 1. the preceding section describes the complete backup of RMAN. The full backup is the block used for the backup, but not the block that has not been used. The Incremental Backup

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