Oracle

1.1.1. ORA-19573Date: 2014-05-21 17:25Environment: Test environment"Scenario description"The database instance is in the open state (READ WRITE), and the database restore, recovery operation encountered an error in Rman."Error Message"Rman> Run {2>

16:20 2013/7/7Oracle LoginAdmin login Sqlplus sys/root as SYSDBA (password Authentication) This root is the first password you enter to install the database Sqlplus/as SYSDBA (host authentication requires that the system user is the DBA user)Normal

Motivation:You want to do insert/update directly with an SQL statement in Oracle.DescriptionWhen writing SQL statements, we often encounter a large number of simultaneous insert/update statements, that is, when there is a record, it is updated

In Oracle, if you commit the modification incorrectly and then want to see the value before the change, you can use the query flashback.The query flashback can be based on a time value or a system change number (SCN).To perform a flashback operation,

1, manually change the size of the data fileSql>conn/as SYSDBASql>createtablespace exampletb datafile ' e:\ examp01.dbf ' size 10M;Sql>alter database datafile ' E:\examp01.dbf ' resize 20m;Sql>alter database datafile ' E:\examp01.dbf ' resize 9m;2.

A Process classification:1. Server process: Completes the work according to the customer request. such as receiving and processing the SQL statements sent by the application2. Background processes (background process): Starts with the database and

Services that Oracle needs to start and shut down:1, Oracleoracle_hometnslistener corresponding to the database of the Listener program2, oracleservicesid corresponding to the database of the routine3. Oracledbconsolesid corresponds to Oracle

There are two ways to respond to Oracle real-participation parameters1. One is the location mode, and the object-oriented language parameter transfer is similar;2. The other is "=" as a formal parameter corresponding, because the position

Command statements in three modes and key differences (red font markers) are as follows:1. Full-Library mode export / import :Exp ' user/[email protected]/oracle_sid ' file= '/data/backup/datafile1.dmp ' log= '/data/backup/datafile1_exp.log ' Full=y

Learning the design pattern has been a while, the first contact design mode, although the example is simple, vivid, but still feel is very abstract. Today also learned the design pattern of decorative mode, that is, the decoration mode to understand

1. CPU consumptionSELECT A.cpu_time,--cpu time one out of 10,000 (μs)A.optimizer_mode,--Optimization methodA.executions,--Execution timesA.disk_reads,--Read Disk countA.sharable_mem,--The amount of memory occupied by the shared

For more details, refer to Http://www.objectdb.com/api/java/jpa/annotations/sqlThe following are examples of reference users Create or Replace procedure Findperson (my_cursor out Sys_refcursor, param in string) As Begin Open

Oracle user is a database object, the user all operations by default in their own mode, the schema is a user owned database objects collection, each user has his own mode, the user and the mode is one by one corresponding to the pattern of the same

Brieflydrop table tmp_qry_cus_186mcc_highuser_d;Create global temporary table Tmp_qry_cus_186mcc_highuser_d(USER_ID Number (15)) on commit preserve rows;This temporary table does not occupy the table space, and the different sessions can not see

Just learned the basics of Oracle, so I want to find some SQL problems to practice practiced hand, so I chose this 50sql statement, because the found version is not Oracle, so try to use Oracle to achieve.This blog post is mainly to record the 50

It is difficult for programmers who have worked with SQL Server to understand the table space of Oracle. Let me just say it briefly,The table space in Oracle is equivalent to an instance in SQL Server, and the user is equivalent to a library in SQL

Oracle pipeline functions are a special class of functions, and the Oracle pipe function return value type must be a collection, which describes the syntax of the Oracle pipeline function.In a normal function, the information that is output using

Transactions 1 transactionSet the save point: savepoin; Rollback: rollback to; Roll back all transactions: rollback; Note: After a save point is created, the saved point does not exist once it is submitted (commit ). 2 read-only transactions A

I recently attended 4 or 5 interviews to summarize the most common questions about competing for oracle development jobs: 1. What is the difference between delete and truncate? 1) truncate is a DDL statement and delete is a DML statement; 2)

[Overview] Those who frequently write SQL statements may use the union and union all keywords. You may know that they can be used to merge the result sets of the two queries, What is the difference between the two? The following is a simple analysis.