Database Administrator

(1) When the header file mysql. h cannot be found,Cd/usr/include/mysql/Cp */usr/include/ (2) When undefined reference to 'mysql _ init' occurs,It is best to use # gcc-o test. c 'mysql _ config -- cflags -- libs'Other compilation commands: # gcc-o

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or

There are many automatically executed jobs in Oracle10g. For example, AUTO_SPACE_ADVISOR_JOB and GATHER_STATS_JOB And so on. These automatically executed jobs will consume a certain amount of system resources while facilitating us. If you do not

1. select d. id, d. outer_code from dict_depts_source d order by outer_code (view duplicate data) 2. select d. id, d. outer_code, row_number () over (partition by outer_code order by outer_code) row_flag from dict_depts_source d (identifies

Problem: The input floating point number and decimal place, Input output ---------------- 0.123 0.12 .. 123 0.12 . 1 0.10 .. 199 0.20 123.199 123.1990 Solution: Create table test_t ( Col_1 number (3, 2 ), Col_2 number (7, 4) );

1. view the tablespace size and maximum value of undo.Select t. file_name, t. tablespace_name,T. bytes/1024/1024/1024 "GB", t. maxbytes/1024/1024/1024 "Max GB"From dba_data_files t where t. tablespace_name = 'undotbs1'Data

1. Install and start mySQL: 1. If mySQL already exists in CentOS /Etc/rc. d/init. d/./mysqld start (start mySQL and run mySQL-root) Edit the rc. local file # vi/etc/rc. d/rc. local Add the following startup command /Etc/rc. d/init. d/mysqld

In linux, the upgrade from 10.2.0.1 to 10.2.0.4 is performed. The main process is recorded below: 1. Download patches Patch: p6810189_10204_Linux-x86.zip can go to Oracle official website download 2. Preparations before Upgrade and Installation 1.

In the Execution Plan, the CARTESIAN cartesian Product sometimes appears. Simply put, What Is CARTESIAN? There are two sets. Any member of each set must be associated with any member of another set... below are some experiments on cartesian: SQL>

Due to accidental deletion of Oracle table data, the data may be very important. How to quickly restore the data so that the supervisor does not discover it can write a stored procedure to restore the data at the previous time of data

Configuration in Oracle 10 GBUse RMAN> show all;The following shows the RMAN configuration parameters: Configure retention policy to redundancy 1; # defaultConfigure backup optimization off; # defaultConfigure default device type to disk; #

Checking Network Configuration Requirements... Check complete. The overall result of this check is: not executed I checked it on the Internet and many of my friends encountered this problem, but it was easy to solve it. You only need to install

Fault Handling when the web server cannot connect to the Oracle database at one time This morning, the maintenance staff called to say that a mobile web server could not connect to the database. The web server reported a lot of jdbc errors and

InOracleIf the modification operation is submitted incorrectly,Then you want to view and modify the original value.,In this case, you can use the query to flash back.(Query flashback ). You can query the flash back based on a time value or a

1. Install unixODBC Download the installation package.UnixODBC-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-devel-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm InstallRpm-Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpmRpm-Uvh

When learning Oracle date functions, there are several examples in the Tutorial: Months_between ('01-sep-95 ', '11-jan-94 ') Result: 19.6774194 Add_months adds the expected month to the specified month. For example: Add_months ('11-jan-94 ',

A few times ago, Oracle Clusterware 10.2.0.1 was installed on RHEL5 or oel5. the main reason was that RHEL5 was not released when Oracle RAC 10.2.0.1 was released, and RedHat was RHEL4, the same problem occurs in SUSE Linux SLES10. The problem

Select ID, name, zi, hao into outfile "zuozhe.txt" fields optionally enclosed by '"" 'terminated ',' From gushizuozhe Load data infile "zuozhe.txt" into table gushizuozhe fields optionally enclosed by '\ "'terminated ',' (ID, name, zi, hao ); Grant

[DDL] Create table Alter table Drop table delete table Truncate table delete all rows in the table Create index Drop index Delete index When a DDL statement is executed, Oracle submits the current transaction before and after each statement.

(1) copy the table structure and copy the data in the table at the same time. Create table 1 as select * from table 2; (2) copy the table structure. Create table 1 as select * from table 2 where 1 <> 1; Of course, the where clause can also be: 1