Oracle

1. What is the Oracle character set?The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language

You cannot log on to the TSP platform .. Later, we restarted tomcat, but still could not log on. After checking, there is a problem with the database. Go to the top of the oracle server. The oracle process occupies a large amount of resources, the

SQL single-row functions in Oracle databases-continued character FunctionsI practiced some character functions in the previous blog, and then I went to the next blog to read the relevant materials.The character function has not been practiced yet.

Oracle Data Guard (iv) Failover 1. check for missing logs in the Standby database. Run the following command to check for missing logs: SQL> select thread #, log_sequence #, high_sequence # from v $ archive_gap; copy the missing log file from the

Oracle Data Guard (iii) Switchover 1. check the status of the Primary database SQL> select switchover_status from v $ database; Role Switching can be performed only when the status is "TO STANDBY" or "SESSIONS ACTIVE. 2. switch the role SQL of the

About Oracle Data Guard Role Switching 1. Overview Oracle database uses its Data Guard technology to implement a remote security mechanism for Data in Oracle databases with real-time remote Data over the network. The implementation process is

The FAL gap problem of Oracle Data Guard logs is found in the OracleData Guard environment. A standby database has a problem and needs to be redone. Because the previously configured environment is good, you only need to back up the full database of

In-depth understanding of Oracle partition (3): Partition table and partition index Overview (I) Partition table technology Overview (1) Range partition ① example create table t (... column definition ...) partition by range (week_num) (partition p1

Oracle and postgresql join methodFirst, we will introduce several oracle multi-Table Connection Methods:Nested loop: nested loop, which is actually a dual FOR LOOP1. The driver table (External table) and search table (internal table) are divided

Oracle inserts a CLOB field of over 4000 bytes. You can create a separate OracleCommand to insert the specified clob field. Here, we only describe how to insert CLOB data, blob is similar to this. We will not introduce it here. The following two

[Oracle problem set 3] ORA-12543: TNS: destination host unreachable Description: [oracle problem set] is the problem encountered by the bloggers usually operate the database and the solution. Statement execution: Indicates An error occurred while

ORACLE table partition and partition index Partition Table, partition index, and global index: When a table contains more than 20 million data entries or occupies 2 GB of space, we recommend that you create a partition table. Create table ta (c1 int,

Materialized View and job timed update example -- create test table create table test_dm_rep_m_gw_user as select * from dm_rep_m_gw_use t where t. month_no

Oracle string comparison --- null in ORACLE, the NULL String is treated as NULL, and the comparison result of any value and NULL is null. In this way, an exception occurs when comparing two strings. See the following example: DECLARE I VARCHAR2 (10):

Basic syntax and example of Oracle exp and imp usage: 1. EXP: There are three main methods (complete, user, table) 1. Complete: exp system/manager buffer = 64000 FILE = C: \ FULL. dmp full = Y if you want to perform FULL export, you must have

Lost modifications, non-repeated reads, dirty reads, Phantom readsCommon concurrency consistency problems include: Lost modifications, non-repeated reads, dirty reads, and Phantom reads (Phantom reads are often classified as non-repeated reads in

ORA-02069: global_names parameter must be set to TRUE for this operation database suddenly has the following error: ORA-02069: global_names parameter must be set to TRUE for this operationhttps: // forums.oracle.com/thread/472482 answers to this

Manual Oracle Uninstall manually Uninstall oracleA number of people have contacted me regarding problems uninstalling Oracle products. the two methods listed below shocould only be used as a last resort and will remove * all * Oracle software

Oracle 11g remote export database 1. Create a TNS string: zqxt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora11g) ))  2. query the

Oracle12c (oracle12.1.0.1.0) Installation Guide -- Measure OEL5.9 (RH5) [root @ oel ora12c] # uname-aLinux oel 2.6.39-example #1 SMP Thu Jan 3 18:31:38 PST 2013 x86_64 x86_64 x86_64 GNU/Linux [root @ oel ora12c] # cat/etc/ oracle-release Oracle