Database Administrator

I have always been used to learning C ++ through source code. Last month, I made a fuss about the SGI's STL source code. After all, the configuration process was smooth under Win, you can refer to the STL source code of Hou Jie. I will go deep into

Linux:[Root @ rac1 ~] #Lsb_release-LSB Version: core-4.0-amd64: core-4.0-ia32: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-ia32: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-ia32: printing-4.0-noarchDistributor ID:

Database creation script:   Drop TablePerson Create TablePerson ( IdVarchar(32)Not Null Primary Key, NameVarchar(20)Not Null, PasswordVarchar(20)Not Null, SexVarchar(20 ), EmailVarchar(30)

Oracle 10g Installation Summary under RedHat Enterprise Linux 5. Two figures are shown first: DBA is the direction of hard work. Oracle DBA is all-encompassing. It cannot even be used in Linux/UNIX. What Oracle should I do. Two parts: 1.

By default, the RPM package or source code package of MySQL does not provide a graphical management tool. phpMyAdmin is the most famous among these tools. PhpMyAdmin is a PHP-based MySQL database management tool. PhpMyAdmin allows administrators to

Open the/etc/my. cnf file and modify the following settings. If not, add it manually. # Cancelling the external lock of the file system Skip-locking # Do not perform domain name anti-resolution, pay attention to the resulting

RANK () OVER ([query_partition_clause] order_by_clause) DENSE_RANK () OVER ([query_partition_clause] order_by_clause) You can group and sort the results set of the same group fields by specified fields, Where partition by is the grouping field,

Normal equal connections:Select * from a, B where a. id = B. id;This is an internal connection.For external connections:"(+)" Can be used in Oracle, and 9i can use LEFT/RIGHT/full outer join.Left outer join: LEFT OUTER JOINSELECT e. last_name, e.

I plan to play with RAC on a virtual machine. I made a google call and found that most of the information is based on this post (). I used VMware Server to create shared storage based on bare devices, oracle official information

1 move ExperimentSQL> create table my_objects_move tablespace ASSM as select * from all_objects where rownum Table created   SQL> select value 2 from v $ mystat, v $ statname 3 where v $ mystat. statistic # = v $ statname. statistic # 4 and v $

If you want to create a table with a known table structure in db2, you can use: (1) create table a as select * from B where 1 <> 1; ---- only create a table without importing data. (2) create table a as select * from B ---- create table a, and

A table is knownTThe structure is as follows: TableT Name Subject Score Varchar2 (10) Varchar2 (10) Number (3) Cannot be blank Cannot be blank 　 (1)Create a table named according to the

Here is a test of rman backup and recovery: The database is in the mount status and cannot be connected by other users:SQL> select status from v $ instance; STATUS------------MOUNTED SQL> conn scott/OracleERROR:ORA-01033: ORACLE initialization or

1 about undoThe database can have more than one undo tablespace;Undo segments can automatically grow, shrink on demand 2 about Oracle Data Dump export and importYou can change the table name during the import operation;You can override an existing

Specific installation and configuration:1)Preparations:Six machines with IP addresses192.168.0. (231-236)MGM node: 192.168.0.231 (232) SQL node: 192.168.0.233-234NDBD node: 192.168.0.235-236The system is RedHat AS 5.0The basic components are

(UR) UNDO_RETENTION in seconds(UPS) Number of undo data blocks generated per second(DBS) Overhead varies based on extent and file size (db_block_size) UndoSpace = [UR * (UPS * DBS)] + (DBS * 24) In the above formula, 1st and 3 parameters can be

It is mainly 2 points. First, createSequence;Then, when the insert statement is run, the position of the auto-increment field is writtenSequence name. nextval.The following describes how to create a table, then create a sequence, and write an insert

Recently, I was working on an Oracle project for a database. It was also my first project module. It felt a lot of pain, but there were a lot of GAINS. The following are my problems and solutions. I am a cainiao-level expert. If you find any errors,

Hibernate is usually used in three types: hql query, QBC query, and QBE query:1. QBE (Qurey By Example) Retrieval Method QBE is the simplest, but its function is also the weakest. It is not very powerful and only useful in some scenarios. A typical

ERROR-ORA-12541: TNS: No listener 1. If it is on this machine, it means that the Oracle client and the oracle server are on one machine. This problem occurs because the service and listener are not started. Computer --- management ---- Service