Oracle

Check the settings in the Tnsnames.ora file as if there is no problem, with Sqlplus can also operate normally ORCLProblem found, in fact, can be simple, https://localhost:1158/em/console/logon/logon#, I use is IE8 open this address, and later notice

First, the experiment shows:Operating system: Rhel 5.4 x86Database: Oracle 11g R2Second, the operation steps:2.1, first create a table T_btree, and create a B-tree index, the index key is object_name:Sql> CREATE TABLE T_btree as SELECT * from

Then the second article http://www.cnblogs.com/myrunning/p/3996183.html4. Installing the Cluster Software 4.1 verifying the installation environmentAfter inspection, the following 3 package checks were found to have

A similar test environment is installed because the customer database needs to be patched. You need to install 10.2.0.1 before upgrading to 10.2.0.5. Because I have a lot of articles about the installation, so this article only say the key steps, as

Nohup./command.sh > Output 2>&1 &　　SQL Migration to Oracle instanceIn daily operations, we often have different types of migrations of databases, much of which is migrating from SQL Server to Oracle, with a similar project in the previous phase, and

1. Download XE rpm package to your website2. Unzipunzip oracle-xe-11.2. 0-1.0. x86_64.rpm. Zip3. Convert RMP Package to Deb package, alien install Apt-get if not alien. To install or update libaio1, you must. 1 cd Disk1 2 alien--scripts

To view a table in the Recycle BinSelect Object_name,original_name,partition_name,type,ts_name,createtime,droptime from RecycleBin;Recovery tableSql>flashback table Test_drop to before drop;Sql>flashback table "Bin$b+xkko1rs5k10uko9bfmua==$0" to

1. Software versionMemsql 3.1Pivotal Sqlfire 1.1.2Oracle 11g XE2. Test environmentHomestay HostOs:windows 7 64-bit Professional Editioncpu:i7-3770 3.4GHzMemory: 16GHDD: Greater than 800GVMware virtual MachinesOs:centos 6.3 64-bitMemory: 16GWhere

1. Download Oracle 11gHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html2. System environmentFree-hFile mode to add swap handover partitionDD If=/dev/zero of=/swapfile bs=1m count=2048 &&mkswap/swapfile

0. Table SpaceSql>Select Username,default_tablespace from User_users;View the role of the current userSql>SELECT * from User_role_privs;View system and table-level permissions for the current userSql>select * from User_sys_privs;Sql>select * from

The execution plan of SQL actually represents the specific execution steps of the target SQL within the Oracle database, and as a tuning, only know if the execution plan chosen by the optimizer is the best execution plan in the current situation,

We know that you need to know four parameters to connect to a database:1. Login Username: User;2. Login Password: password;3. The server address (SERVER_IP) and Port (Server_port) that holds the database;4. Database name (db_name);If we want to

This article is original, reproduced please indicate the source.The calculation method of checkpoint lag of Oracle GoldenGate (OGG) OGG end rep ProcessBackground: The following is the display of the process of the rep of Ogg destination, at that

Oracle has a number of functions, which are sorted out:Absolute value of ABS (m) mMoD (m,n) m is removed after n remainderPower (M,n) m n-Th SquareRound (M[,n]) m rounded to the value of n bits after the decimal point (n defaults to 0)Trunc (M[,n])

In Oracle 10g, the Flash back family is divided into the following members:Flashback DatabaseFlashback DropFlashback TableFlashback Query (sub Flashback query,flashback Version query,flashback Transaction query)Here's a look at Flashback Drop and

The Oracle EBS R12 server-side file structure is as follows:The top level directory is divided into1) inst--– configuration information and other information related to the entire EBS instance (instance)2) DB ——-Primary storage DB layer Information3)

DBAs do not know the storage technology is the DBA is in vainThis network course, aims at in-depth discussion storage technology, the detailed explanation raid0, RAID1, RAID3, RAID5, the Raid6 and so on the characteristic, the emphasis compares the

Collect statistics from ORACLE Link: http://blog.itpub.net/2317695/viewspace-1226138/Today, I saw an article on Statistics Collection on the Internet, which is not bad. 1. Understand what is statistical information Optimizer statistics are a set of

An example of the character location (instr) retrieved by the oracle character truncation (substr) is as follows: substrinstr I. Theory Oracle truncation character (substr), search character location (instr) case when then else end statement use

Data Migration notes from ms SQL to Oracle, sqloracle Data Migration notes from ms SQL to Oracle I. Task background The old system uses the ms SQL Server database and the new system uses the Oracle database. Now we need to migrate the data in the