Oracle

1. Common commands 1) linesize the number of characters displayed per line 2) pagesize: number of lines displayed per page 2. Basic oracle usage, user management, and table management Advanced: Table query, permissions and roles, functions,

Index rebuilding is a topic that is constantly under discussion. Of course, Oracle also has its own opinions. Many of our DBAs follow this rule to rebuild indexes, that is, we recommend that you re-create an index when the index depth exceeds 4 and

1.1 symptom: the database cannot be logged on after it is shut down abnormally. Check and close all Oracle processes, and then log on to the database again. Logon Failed. the following error message is displayed:% Sqlplus/as sysdba SQL*Plus: Release

At the beginning, I used the following method for searching online: Update tbl1 Set (a. col1, a. col2) = (select B. col1, B. col2 From tbl2 B Where a. key = B. key) Then, after using it, I am miserable. After the operations I did directly on

The primary and Foreign keys have two major features: 1) The primary key itself is a unique index, ensuring the uniqueness of the column where the primary key is located; 2) The foreign key column must have corresponding records in the primary key

When I set up physical standby the day before yesterday, the previous steps were all correct (in fact, they were wrong). When I verified whether the archived logs were synchronized to the standby database, I found: ORA-16047: DGID mismatch between

1.1 symptom Description: Data Import failed. The system displays the following error message: SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real

The installation of Oracle in Linux may be a common operation in the eyes of many people, but it actually contains a large number of operating systems, Oracle, Linux Command operations and other knowledge points. Because I am too busy at ordinary

SelectThe_week,Sunday,Saturday,To_char (Sunday, 'yyyymmdd') | '-' | to_char (Saturday, 'yyyymmdd') week_descFrom (select Sunday. the_week,Decode (sign (Sunday. the_day-Saturday. the_day ),-1,Sunday. the_day,Sunday. the_day-7) Sunday,Saturday.

1.1 symptom Description: failed to log on to the database. The system displays the following error message:% Sqlplus/as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 5 14:42:29 2009 Copyright (c) 1982, 2007, Oracle. All rights

See Oracle BUG: error message about the alert of Rman backup.Symptom:During database backup, the alert Log prompts an error message and provides a trc file with detailed error information. Alert. logTue May 7 10:23:19 2013Errors in

A session can start multiple transactions. A session is a session and refers to a connection.A transaction is an operation unit, either successful or failed, with no intermediate state.The session can complete multiple transactions.For example:A

Our previous queries are all based on one table. How can we query data from two or more tables? This note is used to learn multi-table queries. Basic syntax: Select * | (specific column name, column name 1, column name 2) From table 1 alias 1,

[Oracle @ TEST02 lib] $ make-f ins_rdbms.mk/oracle/app/11gR1/db/rdbms/lib/bbed Linking BBED utility (bbed)Rm-f/oracle/app/11gR1/db/rdbms/lib/bbedGcc-o/oracle/app/11gR1/db/rdbms/lib/bbed-L/oracle/app/11gR1/db/rdbms/lib/-L/oracle/app/11gR1

In Oracle database development, you can use the Partition Table exchange technology to transfer this type of big data. Even if you transfer hundreds of millions or even billions of data at a time, the transfer time is still within milliseconds. The

In the previous query, the result is all records in the table. If you want to only display records that meet certain conditions, you must use conditional query or a restricted query. Basic Syntax of conditional query: SELECT * | (specific column

Declare partial logic part other exception handling part; PL/SQL block syntax Common Oracle Exception Handling Name Description Other Including all exceptions (maximum exceptions)

1. Install centos 2. Install the library required by ora 3. Modify the centos Kernel 4. create user groups and directory structures 5. Install ora11g2r 6. Install the SQL plus paging program and help patch 7. self-starting script 8. Common commands #

According to an experiment in Zhou Liang's oracle dba practice.Environment Description: node 2 is down in the 10g rac environment at two nodes. In this case, the client cannot connect to the database through the VIP address of the original Node 2.

1. Install centos 6.5 2. Install the library required by ora 3. Modify the centos Kernel 4. create user groups and directory structures 5. Install ora11g2r 6. Install the SQL plus paging program and help patch 7. self-starting script 8. Common