Oracle

Why is it so difficult to find a good Oracle DBA? This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from Oracle training courses go?

Oracle 9i provides 16 scalar data types, as shown in Table 7.4.Table 7.4 scalar Data Types of Oracle 9i Name Description Char Used to describe

When handling exceptions, pay special attention to the use of when others then, because when others then will eat all the exceptions. If no information is thrown after when others then, that is, when others then null, this may greatly increase the

Without authid CURRENT_USER, The definer permission (definer rights) is executed as the definer identity; If authid CURRENT_USER is added, the caller permission (invoker rights) is executed as the caller.   Example:   1. Create two users: xxpo and

  RAC was accidentally interrupted during installation, and the clusterware software was re-installed. There was no problem during the installation process. An exception occurred when the root. Sh script was last executed. The script ran through and

  An export from an Oracle9i database fails:.... Exporting triggersEXP-00056: Oracle error 6550 encounteredORA-06550: Line 1, column 26:PLS-00201: identifier 'xdb. dbms_xdbutil_int 'must be declaredORA-06550: Line 1, column 14:PL/SQL: Statement

   1. DBV description DBV is a common tool. An article on oraclemos introduces DBV: [ID 35512.1].   The main purpose of the dbverify tool is to check the physical structure of the data file, including whether the data file is damaged, whether there

C: \ Documents ents and Settings \ Administrator> oradim-startup-Sid testbas C: \ Documents ents and Settings \ Administrator> set oracle_sid = testbas C: \ Documents ents and Settings \ Administrator> sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4

Problem:[Root @ rac2 ~] #/U01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script... The following environment variables are set:Oracle_owner = OracleORACLE_HOME =/u01/APP/11.2.0/Grid Enter the full pathname of the local bin directory:

--. SQL script-- The only note is that F: \ dropobj. SQL is the operated. SQL;-- Your computer does not have a drive F. Replace it with drive D or E.-- Used to delete all objects of the current user-- Use for drop all objects in current user;Set

Objective: to move an oracle tablespace file from one location to another. Detailed operation steps: 1. enable the media recovery mode:A. Shutdown immdiate;B. startup Mount;C. Alter database archivelog;D. Alter database open; 2. unmount the

This content is searched from Baidu and modified: Uninstall Oracle 1. The process is as follows: You can use the Oracle installer to delete the required products from the Windows NT box, but this may be a bit difficult.If you do not want to

Because I like new things, my computer development tools are basically the latest. Oracle also has 11g R2, but my colleagues are either 11g R1 or 10g, the DMP files exported from me are exported to them, all of which are shown as follows: Imp-00010:

Two effective methods for creating Oracle dblinkTwo different database servers read data from one user on one database server from another database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database.

How to back up one or more users separately: D: \> exp Scott/tiger file = Export File D: \> exp system/manager owner = (user 1, user 2 ,..., User N) file = Export File 2. How to back up one or more tables separately: D: \> exp user/password tables =

A statement failure occurs when the SQL statement is processed. When a statement fails, Oracle server automatically rolls back the failed SQL statement and returns the error code and message to the user. 1. application logic error Application logic

Windows is a very fragile system. It may crash in a few days after it is installed. If you have Oracle installed in windows, how can you restore the database? One method is to use IMP to import the original data after reinstalling the database, but

On Thursday's European version of The Wall Street Journal, Oracle published a large number of front-page ads to talk to Sun Microsystems customers. This advertisement promises to increase investments in Sun's hardware and Solaris software, but it

The query date is an operation that you often encounter when using the Oracle database. The following lists some Oracle query date statements. If you are interested, take a look. Oracle query date statements are frequently used when we use

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or