Database Administrator

I am writing a small website job today. I can use jsp to insert data to MySQL in Ubuntu 8.10. Both English and numbers can be inserted, but Chinese characters won't work. I used all the jsp Chinese characters. I tried to use mysql query browser (a

Operating System: Linux Fedora 11Development Environment: Eclipse, CDT, and MySQL5.1.32 (the header file uses MySQL5.1.35)Preparations:1. Run the following command to view the MySQL version installed in Linux:$ Rpm-qa mysql2. Check whether

Not long ago, the machines used for the company were really slow. I was so angry that I had formatted Windows and installed the Ubuntu operating system. However, a problem occurs in the Java program: 1. Default Character Set settings for MySQL:

There are two ways to restrict the IP address used to log on to Oracle 1. Edit $ ORACLE_HOME/network/admin/sqlnet. ora and addTcp. validnode_checking = yes# Tcp. invited_nodes = () # list of IP addresses that can be accessed, separated by commasTcp.

1. Create a tablespace for the experiment. Create tablespace block datafile size 1 M extent management local;-because it is 11 GB, AMS is used. Alter user ff default tablespace block; Alter user ff quota unlimited on block; 2. corrupt data

1. The LONG data type stores variable-length strings with a maximum length limit of 2 GB. 2. For text that exceeds a certain length, the LONG type can only be used for storage. Many objects in the data dictionary are defined as LONG. 1. The LONG

MySQL compilation and Installation notesThe premise is that your Linux system should build the GCC compiling environment.If CentOS is used, you can:Yum-y install gccYum-y install gcc-c ++Add MySQL user groups and usersGrounadd mysqlUseradd-g

MySQL service basics: MySQL is an open-source relational database server software. It is currently developed and maintained by Oracle. MySQL features multiple threads and users. It is based on the C/S (Client/Server) architecture. It is easy to

Oracle and SQL server both follow SQL-92 standards: see here, but there are also some differences, the difference is as follows: In Oracle, the table name, field name, stored procedure name, and variable name cannot exceed 30 string lengths. The

Grant select any dictionary to scott;Create table t1 as select * from emp;Insert into t1 select * from t1;-- Check the storage partition records whose segments are T1 under scott.Select segment_name, extent_id, file_id, block_id, blocksFrom

In essence, a view is only an SQL statement, but MySQL does not store the SQL statement.Instead, we save the view definition in the form of a file like a table, and use. frm to exist.The SQL statement displayed with show create view is

Question: Oracle 11g Rac is more difficult to maintain than 10g, and more commands are provided, this section summarizes the Votedisk, OCR, and some commands used for resource maintenance of 11g rac for future reference. Recommended reading: Oracle 1

One reason for triggering ora-01200 errors [Oracle @ oracle ~] $ Oerr ora 1, 0120001200,000 00, "actual file size of % s is smaller than correct size of % s blocks"// * Cause: The size of the file as returned by the operating system is smaller//

In projects, tasks that need to be completed regularly, such as regularly updating data and defining statistical data to generate reports, can be completed using Oracle jobs. The following section describes how to automatically create a table in an

There are four types of Oracle index scans based on different index types and where restrictions: 3, 4, which can be normalized.(1) unique index scan (index uniquescan)(2) index range scan)(3) full index scan)(4) index fast full scan)(5) index skip

1. Mysql Database Installation Introduction: Mysql is a platform-independent open-source database that can be built on Windows, Linux, Unix, and other platforms. This article mainly explains how to install Mysql databases on the Linux platform,

Environment: AIX 6.1, Oracle11g ASM After the ASM instance is installed and started properly, the ASM disk group can detect it. Oracle software is installed normally. Then, when creating a database in DBCA, select the ASM disk until the file storage

When using mysqldump for backup, if the storage engine is MyISAM, you can only implement warm backup, and you need to use the option -- lock-all-tables to lock all tables. If the storage engine is InnoDB, The -- single-transaction option can be

Host A and host B are installed in the testing environment respectively.Operating System: linux 6.4,Database: Oracle 11g r2Host A: Install the oracle 11g r2 DatabaseHost B: Only oracle 11g r2 software is installedStep 1: run the following rman

Data Guard Master/Slave switchover1. view the status Master database: SQL> SELECT SWITCHOVER_STATUS FROM V $ DATABASE; SWITCHOVER_STATUS------------------------------------------------------------To standby // can be converted TO a slave