Database Administrator

1. Summary of Character Set and Export Import Problems First, ensure that the Oracle database server is consistent with the client character set to ensure data encoding consistency. When the database server selects ZHS16GBK, when exporting and

Recently, we have been porting SQL to Oracle. Since Oracle does not have the same Identity column as in SQL, we have encountered a lot of trouble, recently I encountered a stored procedure for deleting data based on the values of the

-- Oracle paging statements-- Id of each recordSelect t1. *, rownum rn from (select * from emp) t1;-- Retrieve the first 10 recordsSelect t1. *, rownum rn from (select * from emp) t1 where rownum -- Extract 6th to 10th records. This statement can be

1. Start the database server (posgres user ): [S @ localhost bin] $ postgres-D/opt/postgresql/data/>/opt/postgresql/log/pg_server.log 2> & 1 & [1] 4508 Of course, if environment variables are set PGDATA=/Opt/postgresql/data Export PGDATA You

Retain the data files, control files, and redo log files of the original database on Windows. Reinstall the Windows system and redo the database. 1. Install Oracle database software 2. Use Oracle dbca to create a database with the same name as the

1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard

By installing rac 10g for RedHat as 4 and rac 10g for redhat as 5, it is found that the self-starting configuration of bare devices is different. The configurations of the two versions are listed below 1. linux redhat as 4 Edit

When the data file of a database reaches the maximum tablespace, an error of ORA-1653: is reported. As follows: ORA-1653: unable to extend table TEST. COMM_DTTR_SVR_LOG by64 in tablespace TEST_SPACE Solution: You can add a data file to the

To change the non-archive mode of an Oracle database, you must restart the database and modify it in mount mode. 1. Shut down the database in shutdown immediate Mode 2. Start the instance to the mount status. 3. Change the non-running mode and open

Single Replication sets design: , 10.9.3.228, only Mongos and config services are started. Pai_^ [root @:/usr/local/mongodb/bin] # cat runServerConfig. sh ./Mongod -- configsvr -- dbpath = ../data/config -- logpath = ../data/config. log -- fork

Description:The source database is the Oracle11gR2 database with two clusters of 64-bit HP-UNIX,The target database is a 64-bit Linux Oracle11gR2 database,Transfers the data of a user in the source database to the target database. 1. Both the source

When talking about the Gap Processing Mechanism of dataguard, the measure most people can say is to set fal_server and fal_client. From 9i, Oracle provides two types of log gap detection and processing mechanisms. For gap processing, the fal _ *

-- Obtain the SQL Execution Plan and statistics without displaying Query InformationSQL> set autotrace traceonly;SQL> select * from test;Execution Plan----------------------------------------------------------Plan hash value: 1357081020--------------

Problem: execute a piece of code to reverse a string, which is to execute multiple SQL statements. How to make it pass in Oracle. I want to think about dynamic SQL. execute immediate is a syntax for parsing and Executing standard SQL statements. You

I. Check swap partitions Grep SwapTotal/proc/meminfo Please make sure it is 4 GB or above. If not, use the following method to add swap partitions: It is best to disable swap partition: swapoff- The partition size, in KB. Run the command:

Environment Introduction:Operating system version: RHEL5.4 32-bitOracle version: 10.2.0.1 32-bitOracle_SID: orclThe operating system of the source server and target server is consistent with that of oracle. Source server: 192.168.227.20Target Server:

After installing MySQL 5.6 with rpm on RedHat5.5, see The following message is displayed when you use mysqladmin to change the password (mysqladmin-u root password "mysql "). Mysqladmin: Can't turn off logging; error: 'Access denied; you need the

How to Use the sys as sysdba permission to connect to the database for Exp/Imp: Windows:Exp 'sys/change_on_install @ instance as sysdba 'tables = scott. emp Unix or Linux (you need to 'escape 'the single quote ):Exp/'sys/change_on_install @

We often hope to unify data stored in different regions for application. Now we can use the replication technology to solve this problem. However, Database Replication also requires some conditions. First, the database must have the Advanced

I. Oracle database data migration:A. Data Migration Method1、import and export exp.exe/imp.exe;Advantage: strong compatibility. You can export custom objects;2、data pump Import and Export (oracle10g.pdf to upload expdp.exe/impdp.exe;Advantage: Faster