Database Administrator

The robustness after Oracle RAC is installed is a headache. Oracle previously launched a dedicated raccheck tool for it, which makes it easy for us to use these hard-pressed DBAs. Now, Oracle has launched the license HK on the basis of raccheck.

Someone asked me about saiku's Chinese Query: By default, saiku runs in English. Many users enter Chinese Characters in mysql and use SQL to query data. However, if you use the mdx query function of saiku, an error is returned. This is because

SQL Server 2005 databases are used for web projects: the 'id' Column cannot be inserted with NULL values, and the 'weibo. dbo. myfriend' Column cannot have NULL values. INSERT failed. Error message: Com. microsoft. sqlserver. jdbc.

A problem occurs at work: update a data table. This table is created by myself and has seven fields: id, name, package, etc. During creation, because I saved the name and package information in two text files, So I will use the Insert method to

When I first set up a message push server for my company before the Spring Festival, I installed MongoDB 2.4.9 and MongoDB2.6.0 on February 8,. I have made a lot of improvements. Now I am going to upgrade it to the latest version 2.6.0, the upgrade

For Oracle11G EXPDP Data between a month of a table should be required Expdp help = Y QUERYPredicate clause used to export a subset of a table.For example, QUERY = employees: "WHERE department_id> 10 ". So expdp shark/2013 directory = dir_dp

We know that MySQL currently does not support function indexing. Currently, most databases include PostgreSQL and Oracle. What is a function index?Function indexes use a fixed function to generate an index tree based on the function result set. The

What is bitmap index?Bitmap indexes use a single-digit chart to store the visible structure of records.What are the features of Bitmap indexes?Bitmap index implementation method: Use a BIT to indicate whether the value corresponding to this

I started O & M recently. I had an accident for two days. Although I was surprised, I think I was lucky! The fault records are as follows: 1. The new project was launched on November 1,. When executing the DDL command, I forgot to confirm the

According to an experiment in Zhou Liang's oracle dba practice.Environment Description: node 2 is down in the 10g rac environment at two nodes. In this case, the client cannot connect to the database through the VIP address of the original Node 2.

The implementation of a function is simple, but it is not easy to implement a function that meets the user experience. For example, in the evaluation system, in the examination system, in the Course Selection System, or even from the first grade to

Today, a senior student gave me a project, but I couldn't. He told me it was maven, So I studied it. So I added my homework =! I 'd like to share with you, but I 'd like to thank the large number of bloggers. Here I will try again: Maven is an

The SQLite graphical management tools recommended below can be used for free for commercial purposes: SQLiteSpy Web: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index Only for Windows. Authorization: The author says: SQLiteSpy is

I. Start the listener and database 1. Start the listener: [root@JTWF oracle]# su oraclebash-4.1$ lsnrctl start If the result is as follows, the startup is successful: LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014

Previously, I sorted out the GROUPING SETS clause features introduced by Hive 0.10, and performed simple syntax usage experience and data verification. However, I didn't notice a little complicated at the time. Then, I took a proper shot in the

Preface: SQLServer replication technology has emerged at least in the SQLServer2000 era. It was originally for distributed computing, not for high availability. However, replication has become a highly available technology and is widely used. Many

Control Flow Statements in SQL Server   Control Flow Statements in SQL Server: IF... ElSE GOTO WHILE WAITFOR TRY/CATCH CASE   The method for composing blocks by buying on behalf: starts with the begin

There are three sources for Database Design: (1) You can design databases from existing data, such as excel tables. In this mode, you need to consider the normalization of data, (2) design a new database, which needs to build a complete database

This is MySQL SQL optimization Article 2nd. we all advocate Percona, a powerful branch of MySQL. Should this be the case? In some cases, the original configuration is reliable, and weisan is not necessarily powerful. Let's take a look at the sar

  3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER in the SH schema of the PROD database. In