Database Administrator

The OS version used is CentOS 5.7, and the original Oracle version is 10.2.0.1.0. When upgrading Oracle to 10.2.0.4, the system always prompts that the operating system fails to be checked. Change the/etc/RedHat-release content to Red Hat Enterprise

When you use impdp, you will find that many Parameter options are different from imp. For example, you cannot find the fromuser and touser parameters, you cannot find the ignore parameters, and parameters such as indexes no longer exist.Of course,

Prerequisites: You are advised to install the following software when installing Linux. Otherwise, you cannot pass the prerequisite check during Oracle installation. (The missing software can also be installed after the test, but the dependency

When learning basic knowledge about Oracle, we will understand the concept of Instance Recovery or Crash recovery, sometimes even these two terms share the same meaning in our daily language. In fact, there is a difference between Instance Recovery

After running SQL statements in Linux sqlplus, you can use the up and down keys to find out the historical commands. Follow the steps below to set 1. Download rlwrap from 2. Install rlwrap [Root @ localhost] # tar-zxvf rlwrap-0.30.tar.gz[Root @

I. Master-slave SynchronizationRefer Ii. Incremental Backup:Perform full backup at PM and PM every day, and back up binlog every one hour, that is, Incremental backup. The specific operations are as follows:Enable binlog in LinuxAdd the mysqld

In HQL, the requirements for the count () function are still strict. For example: 1. count (1) ErrorHql code "GetRecordCountById"> Select count (1) As recordCount from Km c Where c. id =: id select count (1) as recordCount from Km cwhere c.

I. Backup 1. Data Backup (executed on the master database)Rman> backup full database format '/u01/rmanbak/port_full_backup % U. bk '; 2. database software backup (executed on the master database)$ Cd/home/Oracle/product/10.2.0/$ Tar

Delete A non-owner jobAn error is reported when you try to use sys to delete a user's job. You should use REMOVE under DBMS_IJOB to process the error.SQL> Exec DBMS_JOB.REMOVE (62 ); Begin DBMS_JOB.REMOVE (62); end; ORA-23421: job number 62 is not a

A customer came up with a strange problem. In a large table with tens of millions of records, SELECT * FROM where rownum 10 minutes later, he sent the TRACE via QQ: SELECT * FROM ttt where rownum   Call count cpu elapsed disk query currentrows ---

First, extract the official document and get a dump content to verify it. I. data block formatData Block Format The Oracle data block format is similar regardless of whether the data block contains table, index, or clustered data. Figure

MongoDB document database provides the master-slave replication mode. In fact, the master-slave replication configuration of MongoDB is very simple, that is, when the MongoDB service process is started, specify -- master, -- slave, and one is

Subroutine introduction: •NamedPL/SQLBlock,Acceptable parameters,Can be called. •Subroutine type Process:Used to perform an operation Function:Used to execute an operation and return values •Standard-basedPL/SQLBlock

To achieve the following goals:A. Enable auto-start of Oracle instancesB. Shut down the Oracle database before shutting down the operating system or restarting the operating system. A. Follow these steps to start an oracle instance:1. modify the

The decode () function is one of the powerful functions of Oracle PL/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. The DECODE function is one of the powerful functions of

When MySQL Workbench is used for batch database update, the following error message is displayed when you execute a statement: Error Code: 1175You are using safe... without a WHERE that uses a KEY column   Because it is the default security

Oracle has the following two tables: update the val value of the row with the same id value in Table tab1 and that in Table tab2 to the val value in table 2.Select * from tab1; Select * from tab2 The most common mistake is: update tab1 set val = (

DBMS (Data Base Management System) database Management System, as its name implies, is a Data Management System. Data must first be available and then managed through instances, an instance is a memory structure and background process. In short, it

12.1.1DEMO:Patch 6678700 For ESA Language Failed For R12.1 Vision [ID 843376.1]FADTXD. xlfStart uploading...[060909_075004671] [] [EXCEPTION] java. io. UTFDataFormatException: Invalid UTF8 encoding.At Oracle. xml. parser. v2.XMLUTF8Reader.

View Current Character Set ReferenceSQL> select * from nls_database_parameters where parameter like '% SET % '; PARAMETER VALUE----------------------------------------------------------------------NLS_CHARACTERSET WE8ISO8859P1NLS_NCHAR_CHARACTERSET