Database Administrator

SQL Server itself has data import operations. However, if you want to import data from a backup file, you need to perform other operations. The following is an example. There is already a DOE database on the SQL Server and there is a large amount of

1. Several simple concepts to be understoodAdaptive Server:A relational database Server generally includes Adaptive Server, Backup Server, Monitor Server, XP Server, Adaptive Server utility, scripts, and configuration files.Backup Server:Backup

Mssql is the Microsoft SQL Server that runs on windows and platforms.Mysql is an open-source database Server that runs on windows and unix \ linux platforms. Its Standard Edition is free of charge. You can visit www.mysql.comAsp \ php is just an

The following error occurs when the official component (mysql-gui-tools-5.0r12-linux-i386.tar.gz) fails to run in Ubuntu 7.10:Unexpected character '@', expected string constantDownload source code (mysql-gui-tools-5.0r12.tar.gz.Libraries to be

The company relocated, freeing up a dell sc1420 Linux server. We are ready to move tomcat6 from window server2003 to RedHat as5, so we thought the speed would change qualitatively. After installation, it is found that the speed is much slower before,

Some Linux database servers use low-end storage. Due to service changes, some Luns are required. Must I restart a Linux server after adding a LUN? Use the QLogic fc hba lun Scan Utility script to identify newly added Luns without restarting the

I remember when I got the WIKI website during my internship, the time displayed on the server was Greenwich Mean Time (eight hours slower than Beijing time, data collection on the Internet has not been resolved. Later, I found some information on

In Windows, sqlplus is completely normal, but in Linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved? The solution is as follows: In fact, it is easy to set exit sqlplus and set the

Environment Description: Source database: 192.168.0.10 Target Database: 192.168.0.11   Source database backup: RMAN> run { 2> allocate channel c1 device type disk; 3> allocate channel c2 device type disk; 4> backup database

The SELECT statement can be used to search the full text of the CLOB field. However, if you must use the dbms_lob.instr () function when using the WHERE clause, the command is as follows: First, create a TEST table:SQL> create table TEST3 (a clob, B

1: Create a tablespace on the catalog Database:Export Oracle_SID = ORCL Create tablespace rmants datafile '/home/oracle/rman/rmants. ora' size 20 M; Note: The tablespace name must not be rman. If it is rman, an error will be reported in the next

After the jar file of the hive udf udaf udtf function is developed, you must put the jar file into the hive environment. You can add the following three methods: 1. Use the add jar path/test. jar; Method to add The disadvantage of this method is

Edit the SQL statement in the current SQLPLUS Buffer For example, ed is short for editing the SQL statements in the buffer zone using the editor specified by our environment variables. Of course, it is the buffer zone of SQLPLUS. We can prove that,

The for loop in Oracle is easy to use. However, when a for loop containing the select statement is used, you still find something you didn't pay attention to before. My code is as follows: Declare Val1 date;Val2 date;BeginFor I in (select empno from

MongoDB Master-slave replication (Master-Slaver) Experiment 1. Create a Master/Slave directory [Root @ bakdbservermongo] # mkdir dbs/master/ [Root @ bakdbserver mongo] # mkdir dbs/slave/   2. Configure the Master node [Root @ bakdbserver mongo]

MySQL Semisynchronous Replication In addition to the built-in asynchronous replication mechanism, MySQL5.5 also provides interfaces to support semi-synchronous replication. Disadvantages of asynchronous replication: MySQL replication is asynchronous

Recently, in the project, because the system needs to provide the database backup function, after some online searches, I think the simple mysqldump is used. Using mysqldump in Linux to back up a MySQL database as an SQL File Use mysqldump in Linux

Source database RHEL4.5: 192.168.137.199 GLOBAL_NAME = WENDING. LK Oracle_SID = WENDING Clone database RHEL4.5: 192.168.137.200 GLOBAL_NAME = STRM. LK ORACLE_SID = STRM 1. Full backup source database $ Sqlplus '/as sysdba' Write down the SCN before

Those of us who use Rails will not be surprised when they see 5. weeks. from_nowor3.days.ago + 2. hours. Similarly, PostgreSQL can also achieve the same functionality by simply calling the built-in functions of PostgreSQL. PostgreSQL deletes

I have nothing to do with MVCC. I have read a bunch of Chinese on the Internet, and each statement is different. I searched on google and found that there is a description in the MySQL User Guide. I 'd like to translate the original text for