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.

The following code has been tested and can be run directly.A brief description of Oracle analysis functions, multidimensional functions, and Model functions, mainly for BI report statistics, not necessarily comprehensive, but a few instructions on

Some beginners often do not use the option when creating indexes in Oracle databases. In fact, sometimes you can use some options in a suitable situation to increase the index creation speed. For example, to import data in large batches, we often

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

  The content of this lecture mainly includes: 1. segment shrinkage and table space usage monitoring 2. Perform segment contraction and roll back the high-water line 3. Set session suspension due to space problems 4. Transfer tablespace I. segment

1. oracle optimizer======================================Oracle has three OptimizerRULECOSTCHOOSEThe OPTIMIZER_MODE parameter is used to set the optimizer type. It is a selective optimizer by default and is both a CHOOSESQL> show parameter OPTIMIZER_

How to create an oracle Function IndexAn important new feature of Oracle8i is the addition of the function-based index (hereinafter referred to as the FBI ).With this feature, Oracle DBA can use functions or expressions in the index. These functions

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

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

Manage common Oracle data dictionaries and dynamic performance views 1.v$ version query database version information [sql] select * from v$version; [html] BANNER --------------------------------------------------------------------------------

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

Three methods of Oracle database backup and recovery Oracle database has three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical

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.

Oracle Basic Data Query SELECT * FROM MERs WHERE customer_id not in (2, 3, 4, NULL); SELECT * FROM customers WHERE customer_id BETWEEN 1 AND 4; SELECT * FROM customers WHERE customer_id not between 1 AND 4; -- NAN indicates that it is not a number

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

To quickly find the trc files generated by tracking other sessions, the most fundamental technology is to understand the path where the session tracking files are stored and the naming rules for generating the tracking files. Otherwise, in a

ORA-1157 and ORA-01110 error practices often encounter related ORA-1157OR1110 errors in the backup experiment, related error information, nothing more than data files, log files, and control files and a series of related file problems, in general,