Oracle

The following articles mainly focus on the migration solution from Oracle SQL to DB2 SQL. Migration from Oracle SQL to DB2 SQL has become very popular, if you want to know more about its practical application, you can browse the following articles

After a long time learning about remote login to the Oracle database, I have some tips. Now I will share with you the remote login and authentication of the Oracle database. After reading this article, you will certainly have a lot of GAINS, I hope

This article mainly describes several tips for connecting Oracle databases through JDBC, and connecting JDBC with a Java Database) APIs are a series of practical interfaces that allow Java programmers to access the database correctly, different

Oracle mandatory access control is a basic security feature that must be implemented by B1-level security products. We all know the mandatory access and control functions of DM-related database security edition, it studies and draws on some security

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from Oracle2.0 (no 1.0) to Oracle7.3.4, it is a relatively simple version of Oracle, starting with Oracle8, the identifier of a database

The following articles mainly introduce the differences between different versions of Oracle databases: Oracle Database Standard Edition One, which is the most basic commercial version, it includes the basic functions of the Oracle database. Oracle

We all know that Oracle SQL Trace and 10046 event are common tools used to diagnose Oracle database performance. However, when the level is over 1, 10046 events are generally called extended SQL trace. It is mainly used to diagnose the performance

The following articles mainly describe three different types of Oracle optimizer and the related conditions of different types of optimizer, under what circumstances should we avoid using the optimizer? The specific content of this article is

Method 1: Use the script that comes with oracle to start and close... 1 1. oracle user modify the/etc/oratab file:... 1 2. oracle users modify the $ ORACLE_HOME/bin/dbstart file:... 1 3. Test and run dbshut and dbstart 1. 3.1. Execute the

Oracle Database AdministratorThe workload is very large, from the daily responsibilities, there is a week of work, as well as the monthly work, we have already introduced you to explain the daily responsibilities of the Oracle database administrator,

On April 9, June 2013, Oracle officially released Oracle Database 12C release 1. It is as follows: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html According to Sina Weibo, a well-known Chinese DBA, guobiao,

  When learning about the basic architecture of Oracle databases, I have learned about the storage structure of Oracle. Logically, Oracle data is stored in tablespaces and physically stored in datafiles. A tablespace can belong to only one database (

Possible problems: 1. windows Firewall. 2. The environment variable PATH does not contain % ORACLE_HOME % \ bin, which leads to many ORACLE connection setting methods. Four methods are provided here, however, it is mainly about the remote connection

Take a look at the following example: Use a sys account to connect to the database: SQL> conn sys/test as sysdba; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as SYSThe following query shows that only the sys account has the

The WMS warehouse management system implements the "sending and receiving daily report" data query function. SQL statement: Oracle [SQL] www.2cto.com SELECT AA. PRODUCT_CNAME, AA. PRODUCT_ID, AA. PRODUCT_CODE, AA. MODEL, AA. MASTER_UNIT, AA.

How to count the number of Chinese characters in a field in data (ORACLE)How to count the number of Chinese characters in a field in the data table www.2cto.com dept has the following data:In Oracle, length is the length of characters, lengthb is

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a database, there are some

Using RMAN for full database backup I. backup database operations under rman: 1. in rman, you can disable, enable, convert from non-archive to archive, and enable RMAN> shutdown immediate; RMAN> startup mount; RMAN> run (SQL 'alter database

Almost all changes that occur in oracle online redo log files are recorded in online redo log files. oracle uses these redo log groups to restore the database, therefore, they are very important. The main work of online redo log files is to back up

SQL loader data import problems encountered when using oracle SQL loader tool to import data, the specific shell script is as follows: 01 #! /Bin/bash02 03 04 export LANG = zh_CN.GBK05 export NLS_LANG = export ORACLE_BASE =/u01/oracle07 export