Oracle

1. Oracle users addedCopy codeThe Code is as follows:Create user lisi identified by lisi; Note: create user is the database user created, followed by the user name, and identified by is the user password set 2. Grant the "connection" database

A brief summary of Oracle Database query performance optimization. Database optimization is always an arduous task. Optimization is particularly important for systems with large data volumes and frequent access. Due to the flexibility, complexity,

Oracle Move command Summary Starting from 8i,OracleStart to provide the Move command. We usually use this command to move a table segment from one tablespace to another. Moving is actually a physical copy of data between blocks, so we can reduce the

--- Indicates flashing back to the database --- Use a flashback table to restore the table content to a specific time point in the past --- Restore from the deleted table --- Use the flashback query to view the database content at any point in time -

Create a tablespace: Create tablespace nameLoggingDatafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ tablespace name. dbf'Size 100 mAutoextend onNext 2 mExtent management local; Create a user: Create user Login Name Identified by

Index categoryOne Binary tree Index, or B-tree indexes, is the most widely used index. by default, all indexes we create are B-tree indexes. b-tree index based on binary tree principles 2. Binary tree clustering index (B-tree Cluster indexes) is

Execute four scripts during RAC installation. 1) $ ORACLE_BASE/oraInventory/orainstRoot. sh (executed when clusterware ends) 2) $ CRS_HOME/root. sh (executed when clusterware ends) 3) $ CRS_HOME/bin/vipca. sh (this script is automatically called

Delete crs 1. stop resources: Disable crs resources: crsctl stop resources Disable crs: crsctl stop crs 2. Run the following Script: root. delete. sh and rootdeinstall. sh nodes. 3. Delete the startup Item: Rm/etc/oracle /* Rm-f/etc/init. d/init.css

Optimize Oracle SQL using oracle EM Enterprise Manager (automatically generate indexes) # There are a large number of SQL statements in the Application Scenario project, especially when statistical reports are involved, there are many table

  Bytes -------------------------------------------------------------------------------------------------------- When connecting to the Oracle database using PL/SQL on the server, a problem occurs, prompting: Initialization error Cocould not load "F:

If someone uses it: Select t. * from table name t where field = xxx for update Instead: Select t. rowid, t. * from table name t where field = xxx for update This is the case when you update data. For update does not contain rowid. It is a silly

(1) view character sets (all three are equivalent)Copy codeThe Code is as follows:Select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET'Select * from nls_database_parameters where parameter = 'nls _ CHARACTERSET'Select * from props $

1. Copy the table structure and data:Copy codeThe Code is as follows:Create table table_name_new as select * from table_name_old2. copy only the table structure:Copy codeThe Code is as follows:Create table table_name_new as select * from

Oracle Cursor details and examples Abstract: describes in detail the definition and use of cursors in oracle databases. You can use instance operations to gain an in-depth understanding of the usage and usage of cursor.I. Related Concepts 1.

Clear Shared pool: Alter system flush shared_pool; However, to clear the entire memory, we had to shut down the instances and databases in the entire Oracle RAC environment and restart them. You can clear the buffer cache: Alter system flush

1. Forget the logon password of a user except SYS and SYSTEM. Log On with the sys or system user and modify the Database Password. # Sqlplus sys/oracle @ "sid" as sysdba use the following statement to modify a user's password: SQL> alter user

The role of Data Gurad is not much said. Here, we will talk about the building steps of physical standby.There are roughly three ways to create a standby DatabaseMethod 1: Use rman to generate standby. (use rman's duplice method for direct creation

After logging on to the database for a small test today, I forgot to use the command to delete the tablespace and deleted the data file in Linux, As a result, the tragedy begins. (I figured out how to work out study together) Lab

Create Table space tyger2 in the database and delete the data file tyger2_01.dbf in the linux system file. An error is returned when the database is started, Re-create the file named tyger2_01.dbf. The database starts normally, but the data in the

Cache of ORACLE read/write disks Cache and Buffer are two different concepts. Simply put, Cache accelerates "read" while buffer is "write". The former solves the read problem, save the data read from the disk. The latter solves the write problem and