Oracle

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to

  Installation Process 1. hardware resources: Brief description: The system memory should be larger than 1 GB, And the swap space should be at least GB, which is twice the physical memory, and the temporary space should be larger than MB. (The

Objective: To access the database by iSQL * Plus DBAEnvironment: oracle 10gTutorial steps:1. start the iSQL * Plus service: isqlplusctl start2. Enter http: // host name: 5560/isqlplus/dba in the address bar of the browser.The following dialog box is

The db_buffer_pool of oracle consists of three parts:Buffer_pool_defualtBuffer_pool_keepBuffer_pool_recycleIf you want to pin the table to the memory, that is, pin the table to the keep area.Related commands:Alter table... storage (buffer_pool keep )

1. view the maximum number of Oracle cursorsC: \ Documents ents and Settings \ Administrator> sqlplus "sys/admin @ test151 as sysdba" (sys logs on to the test151 service as dba)SQL * Plus: Release 9.2.0.1.0-Production on Thursday November 5 09:08:04

3.1 basic oracle Stored Procedure syntax3.1.1 Basic StructureCREATE OR REPLACE PROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) ISVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND stored procedure name 3.1.2 SELECT INTO STATEMENTSave the select

Basic StructureCREATE OR REPLACEPROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) ISVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND stored procedure name --- Query data and return a listDrop procedure mrr. get_risk_assessment_by_status;Create

The ORACLE database is divided into logical regions called tablespaces-forming the logical structure of the ORACLE database. One ORACLE database can have one or more tablespaces, while one tablespace corresponds to one or more physical database

1. Change Database downtime to archive ModeSQL> archive log listSQL> shutdown immediateSQL> startup mountSQL> alter database archivelog;SQL> alter database open; 2. Point the database archive to ASMSQL> alter system set db_recovery_file_dest_size = 2

The PROFILE file of ORACLE is a method to restrict the resources used by database users. For example, you can control the CPU that can be used by sessions or SQL statements, and control your password management policies.After the database is created,

An Oracle temporary table can have two types of temporary tables1. Session-level temporary tableSaves the data used by the current session, which exists during the data session. After each submission, ORACLE truncates the table (deletes all rows).

Analysis and Handling of CRS-2409 alarm information problems reported by crs oracle 11.2.0.3 1. Check the CRS alert log of 1st nodes and find the following exception information 19:27:17. 609 [ctssd (18809056)] CRS-2409: The clock on host XXXdb1 is

Simulate a failover 1. Stop the listener of the standby database [oracle @ rhel132 ~] $ Lsnrctl stop2. the master database needs to be restarted. (If the listener is disabled in the slave database, the communication between the master database and

How can I display pl/SQL query data in Chinese? Solution: 1. Open the installation directory of PLSQL Developer, see the directory of plsqldev.exe, create the "PLSql_run.bat" file in the PLSQL Developer folder, and enter the following content in the

Perform full backup for recovery of the dg slave database: RMAN> run{ allocate channel a1 type disk; backup full database include current controlfile for standby plus archivelog ; release channel a1; } rman target sys/oracle@orcl auxiliary /

Partition index note (3) -- global partition index (2) -- local partition Index http://www.bkjia.com/database/201308/238634.html A global partition index contains keys from multiple table partitions in an index partition. The partition key of a

Oracle multi-row record merging user-defined functions (udfs) are used to merge fields in oracle databases. You can use the wm_concat (column) function. However, this method is not recommended by Oracle, because WMSYS users are used for Workspace

Repair ora-01578 after data block corruption if the database runs in archive mode with backups, you can use RMAN block recovery. You can run RMAN> blockrecover datafile 1 block 28618 when the data file is online. If no backup, archive logs are lost,

The basic operation procedure for flushing data from ora10g to 8I master: oracle 10 gsnapshot site: oralce 8i Materialized View in oracle 8i is called snapshot, oracle 8i snapshot creation SQL commands are still compatible with oracle10g. On master

Query, create, and expand the tablespace & impdp ---- the key to the successful import of the tablespace by schemas is: the size of the tablespace In the imported environment and the source data environment, and the tablespace name, which must be