Oracle

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the local DMP file, and the IMP command can import the DMP file from the local to

Data concurrency means that many users can access data at the same time. Data Consistency means that the data seen by each user is consistent, including the changes made to data by the current user transaction and other user transactions. Data

Reset the Oracle administrator password in WINXP To modify the Oracle administrator password in windows, follow these steps. This step is successfully performed under winxp5.1 and oracle92. After the change, you must restart your computer and

In the actual working environment, many people always need to change the IP address frequently to adapt to the customer's environment. However, after the IP address is changed, Oracle cannot start at 10 Gb. Technology related to online

Oracle lpad functions: Copyright Notice: Mark the reprinted object with a hyperlinkArticleOriginal Source and author information andThis statementHttp://soysky.blogbus.com/logs/43623642.html The Oracle lpad function fills the string on the left

In Oracle, the remainder is obtained using the MOD (numer1, number2) function, and the returned value is the other values. For example: Output 1 ~ All integer values in 13 that are not multiples of 3. Declare -- I number; begin for I in 1 .. 13

SQL statements for Oracle database monitoring 1. Waiting for monitoring cases:　　Select event, sum (decode (wait_time, 1) Prev, sum (decode (wait_time, 0) curr,　　Count (*) from V $ session_wait group by event order by 4;　　2. rollback segment

  After you modify the computer name or the configuration of Oracle when using the Oracle 10g Database, the Oracle Enterprise Manager fails, causing the Database Control Service to fail to start normally, this will cause a lot of trouble. The

The following table collects almost all views or aliases in the Oracle Data Dictionary. Use the 'describe' statement to query the fields of each view or Alias. Description: In the Oracle Data dictionary, the object names are mostly "user. "," All. ",

Install Oracle 10g in Windows 7. The orcale version used is 10 Gb. Step 1: Download from the orcale official website, for: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip You can directly copy it to thunder

My RAC Virtual Machine reported that diskgroup space was insufficient during Backup yesterday, so I added asmdisk to my schedule. When installing RAC, I had 2 ASM diskgroups + DG, respectively, + recoverydest: Now + recoverydest has insufficient

SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * LoaderWe can use

1. Absolute Value: ABS () Select ABS (-2) value from dual; 2. Take the entire function (large): Ceil () Select Ceil (-2.001) value from dual; (-2) 3. Take the entire function (small): floor () Select floor (-2.001) value from dual; (-3) 4. Take the

TIPS: How to relink Oracle 9iAS on UNIX platform You can relink the majority of the 9iAS components by running the command 'relink all' from $ ORACLE_HOME/bin. For the latest 6i components in an enterprise install, I 've pulled the relinking

The Oracle database server is the core of the entire system. Its performance directly affects the performance of the entire system. To adjust the performance of the Oracle database server, we mainly consider the following aspects: 1. Adjusting the

The previous sections mainly focus on some features and management methods of Oracle software. Oracle is a large set of system software. It is about Oracle installation and deployment. I will not describe how to deploy configurations first, because

Many people, especially those who do not like Oracle, must learn from Oracle and think that Oracle occupies a lot of memory.I really don't like installing oracle on a physical machine. Most of them are Windows users, and most of them are

Source: Network/Editor: getting started with programming: Unknown I. About ado In a client/server-based database environment, you can use the ole db interface to access data. However, it defines a low-level COM interface, which is

This method is similar to method 2. It only uses PREPARE statements and cursors, so that dynamic SQL statements can process query statements that return multiple rows. In fact, if the dynamic SQL statement to be processed is a query statement that

The interface developer reports that many duplicate data are in the user permission table. Then I deleted the table data Delete mode and modified the corresponding stored procedure so that the table data is not duplicated! Later, we found that the