Database Administrator

Hibernate is an open-source object relationship ing framework that encapsulates JDBC objects in a lightweight manner, so that Java programmers can use the object programming thinking to manipulate the database as they wish. Hibernate can be used in

I. gap sequence SQL> alter database open;Alter database open*Row 3 has an error:An error is reported when the slave database recovers from open to the standby database at the same time: ORA-16004: backup database recovery requiredORA-01152: File 1

A manual database creation was implemented and OEM was enabled to manage the database. The following operations use the Oracle user group: 1. Create the text initialization parameter file init $ SID. ora and the corresponding dump directory Vi $

HBase adopts the master/slave Mode in distributed deployment. It consists of three major functional components: RegionServer, MasterServer, and ClientLibrary. Hadoop HDFS sub-framework is used in distributed storage. Distributed computing functions

Oracle PL/SQL query statements sometimes convert the number type field to the varchar2 typeReports or pages are frequently displayed:. 440. 4411.010.100It is very disturbing to say that the 0 before the decimal point is removed by the to_char or

The default redo log file size of Oracle10g is 50 MB. in use, it is often found that there are a large number of Checkpoint not complete problems in alter log. We should all know what this problem is. To solve this problem, we only need to increase

Hive is an open-source query tool based on the Hadoop framework of facebook. That is to say, if you need hive, you must first install hadoop. This is a summary of recent experiences and experiences with hive. After installing and configuring hadoop,

A colleague asked me to help write a function and get a time period by inputting the number of minutes or seconds. Although it is very simple, I still paste it out when a backup is needed and use it directly: Create or replace function get_time (I

In Oracle, the Number type can be used to store 0, positive, negative, or floating point numbers. The data range can be 1.0*10 (-130) -- 9. 9... 9*10 (125) {38 9 followed by 88 0} digits. When the value of the mathematical expression in Oracle is

How to SetOracle11gImport backup10g 11g Export Statement: expdp userid ='Facial/Facial@OrclAs sysdba 'schemas = facial directory = DATA_PUMP_DIRdumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0   The red text is rewritten as needed. For

When installing Oracle on the command line, the rpm package in the configuration file will not be repeat, and the problem is not very serious. Several problems will be encountered. 1. If your machine is red-hat 5.6 and Oracle 10g only recommends 3

I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and

Oracle 11g has added the system information backup and recovery functions at the system level, user level, and table level! When we collect statistics on oracle system objects, we can useDbms_stats.export _ (database/schema/table) _ stats export

Problem:ORA-00257ORA-16014 log 1 sequence #1085 not archived, no available destinationsORA-00312 online log 1 thread 1 'usrapporacleoradatawanyanredo01. Log'Cause:2 GB of the flash recovery area of the archived logs is full. Check Procedure: SQL>

This article is a by-product study of Mongodb distributed data storage. Through the relevant steps in this article, we can distribute data in a large table to several mongo servers. In MongoDB 1.6, the auto-sharding function is basically stable and

1. Use the view to test the database cache size: If your enterprise opens a new business and develops a new application for this purpose, a new database is required as the background. You are responsible for regulating this new database. So how do

Partition maintenance operations include:Add PartitionDelete PartitionPartition TruncationMerge partitionsShard1. Add a partition-Add a new partition after the last partition ALTER TABLESALESADDPARTITION P4VALUESLess than (4000 ); 2. delete a

I. Basic Concepts MongoDB is a high-performance, open-source, and non-pattern document-based database. It is currently the most popular NoSQL database product. It can be used in many scenarios to replace traditional relational databases or key/value

We know that every RDBMS has its own characteristics in SQL. So today, let's take a look at the characteristics of Oracle, which deserves our attention. Feature 1:Oracle analysis functions and window functions:Syntax: FUNCTION_NAME (, ...)OVER (

Installation environment Linux Server: SUSE10 sp2 64-bit Oracle Server: Oracle11gR2 64-bitSystem Requirements Requirements for installing Oracle in Linux System Requirements Description Memory Physical memory must be