Database Administrator

Oracle databases have three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup. 1. Export/Import (Export/Import) The Export

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

When tomcat is started, the system prompts that port 8080 is in use. After searching, it finds that the Oracle, tomcat, jboss, and other servers occupying port 8080 are installed on one machine, port 8080 is occupied.I. first check the usage of port

Oracle has set up a dedicated apt source server for Ubuntu users. You only need to add a line in/etc/apt/source. list: Deb http://oss.oracle.com/debian unstable main non-free You can. Before running the apt-get update command, you must add the

You can take the following steps:Query the latest service packageMake sure that you always have the latest service package. For SQL Server2000, this is SQL/downloads/2000/SP3.asp "> SP3a. Remember that there are multiple service packages. If you use

The principle of user authentication is simple: first, you need to enter the user name and password on the page. Of course, users who are not registered must first register. Then, you can call the database to search for users. If yes, confirm it. If

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

I haven't written anything for a long time. On these days of work, I got some methods to install Mysql. This method can install multiple Mysql on a Linux service at the same time. The source code of mysql. the serial number is mysql-5.0.20a.tar.gz.

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,

Table creation statementDeclareV_ SQL varchar2 (32767 );BeginV_ SQL: = 'create table test (';For I in 1 .. 500 loopV_ SQL: = v_ SQL | 'name' | I | 'varchar2 (2000 ),';End loop;V_ SQL: = substr (v_ SQL, 1, length (v_ SQL)-1 );V_ SQL: = v_ SQL |

PL/SQL 9.2 cannot connect to the Oracle database. When the system is installed with Oacle 11 GB and the client is installed with Oacle 10 Gb, when pl/SQL is used to connect to the database, the connection fails. The reason is that the oracle home

Question 1:ERROR at line 1: ORA-29538: Java not installedSolution1. Check whether JAVA components are installed.Select * from v $ option t where t. PARAMETER = 'java ';If the returned row is installed, run Oracle Universal Installer to install the

Set the mysql installation directory to system environment variables to facilitate direct execution on the command line terminal. After mysql is installed in linux, the default root password is blank. You can directly log on to mysql. Normal logon

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

RAC creates a DBlink and uses impdp to extract data from the source database. Grant permissions and create dblink [Plain] view plaincopyprint?[Oracle @ zhongwc1 ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Mon Feb 4 10:26:45 201

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

Some netizens recently mentioned why the historical execution plan of SQL statements cannot be viewed in dba_hist_ SQL _plan. This problem is due to the fact that the threshold value set by Oracle does not capture all SQL statements by default,

Every day, Internet companies collect log files to find desired information, such as the installation volume and activity of a software. All the information must be stored and displayed. The following describes the implementation process. The

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,

In the absence of visual tools to monitor database performance, common scripts come in handy. Below are a few scripts related to Oracle performance for your reference. The following scripts are successfully tested in Oracle 10 Gb, and Oracle 11 GB