Oracle

rhel6.3 x64bit, Oracle 11.2.0.4 x64bit[Email protected] test]$ pwd/u01/app/oracle/diag/rdbms/test/test[[email protected] test]$ chmod u-x trace[[email Protected] test]$ lltotal 100drwxr-x---. 2 Oracle Oinstall 4096 alertdrwxr-x---. 2 Oracle

2 issues encountered during the installation process1) Hard RAID disk not recognized during installationT4-2 's 2 local disks do hard raid, the hard RAID disk is not recognized with Jumpstart installation, the error message is as follows: {0} OK

in the Oracle In the development and use, often need to use a variety of functions, this chapter summed up the simple string, mathematical functions, the need to use it later also convenient point, but also to make the students less go a little

Lpad 1. Grammar lpad (STRING,PAD_LENGTH,[PAD_STR])2. ExplanationThe function represents the padding of the specified character from the left of the string to the specified length. The space of the string is also counted into the length.String

Restoring Oracle one-to-one G to Oracle 10G today, there was a problem with version mismatch first.This problem can be resolved by using the workaround in http://hundage.blog.51cto.com/3779401/1285465.After resolving a problem with a header file

1 overview Most of the time when designing pl-sql programs, we follow these steps:Open cursor, start loop, fetch value from cursor, check that row is returned----close the cursor with a closed loop, 2 Format: Copy content to Clipboard/program

Query optimization methods and Gather_plan_statistics hint:after 10g we can use gather_plan_statistics hints to learn more about SQL execution statistics, using the following methods:If the Statistics_level parameter is set to all, or if the SQL

My SQL is very poor, half a day response to, was a colleague joke. Oh, ah ah. Must surpass him later!!Table ShopPk_shop PRIMARY KeyName Commodity Shop Pk_shop Name 001 Down 002

Original link http://blog.csdn.net/oscar999/article/details/16839417Preface Trunc is a shorthand for truncate. The Chinese translation is "truncate" or "truncated". On the surface, it should be a string or a number to intercept. There are actually

1. Recently, some problems with Oracle have been encountered in the company. For example, after installation, after importing the backup file, it is found that the datetime display format is not normal (2014-02-12:00 00:00). Once this happens, you

The mode of the HASH joinHash join has three kinds of working modes, namely optimal mode, OnePass mode and Multipass mode, respectively, there are corresponding statistic information in V$sysstat:Sql> select name, value from V$sysstat where name is

In Oracle 12c, the CDB and PDB, their startup and shutdown operations are organized as follows.1 Container Database (CDB)For CDB, startup and shutdown are the same as in previous traditional ways, with the following syntax:Startup[nomount | MOUNT |

1, if you use the table or view of other libraries, be sure to create a view in the current library to achieve cross-library operation, it is best not to use "Databsevv.dbo.table_name", because sp_ Depends cannot display the cross-Library table or

Starting and shutting down Oracle listeners is a fundamental task for DBAs, but Linux system administrators or programmers sometimes need to do some basic DBA work in the development database, so it is important for them to understand some basic

We often encounter situations that require table duplication, such as copying a partial field of a Table1 data into table2, or copying the entire table1 to table2, when we are going to use the SELECT INTO and INSERT into select tables to copy the

Linux time synchronization configuration.I. Using the Ntpdate command1.1 When the server can link to the extranet# CRONTAB-EAdd a line:*/1 * * * * ntpdate 210.72.145.44210.72.145.44 is the China National Time Service Center server address, so that

Oracle basic user management and oracle basic user management I. Users When you create a data instance, Oracle creates some default database users, such as SYS, SYSTEM, and SCOTT. Both SYS and SYSTEM users are oracle system users, while Scott users

Explore Oracle Database Upgrade 4 11.2.0.4.0PSU11.2.0.4.3 Explore Oracle Database Upgrade 411.2.0.4.0 PSU 11.2.0.4.3 1. Check the current database PSU Number: [oracle@db01 ~]$ cd/DBSoft/Product/11.2.4/db_1/OPatch/[oracle@db01 OPatch]$ lscrs docs

ORA-14450: attempt to access a transactional temp table already in use, temptable ORA-14550 errors may occur when modifying session-level temporary tables in ORACLE data, so why does the session-level global temporary table report a ORA-14450 error,

Oracle tablespace query and maintenance command Book II (undo tablespace)-- Undo tablespace Summary-- View All tablespace namesSelect name from v $ tablespace;-- Create a new UNDO tablespace and set automatic expansion parameters;Create undo