Database Administrator

Oracle elastic cloud and data warehouse provide obvious advantages. First, a single vendor provides all the basic components: Oracle's one-stop approach helps simplify licensing, support, upgrade, and integration, all these transactions are handled

When using HibernateDaoSupport in spring-framework-3.2.4 and hibernate-release-4.3.5, an exception occurs in java. lang. classCastException: org. springframework. orm. hibernate4.SessionHolder cannot be cast to org. springframework. orm.

When creating an index, we add parallel indexes to build the index quickly. After adding parallel indexes, this column will be in parallel. When accessing an index with a degree of parallelism, CBO may consider parallel execution, which may cause

Database linke is the object that establishes the path from one database to another. database link allows you to query remote tables. In my understanding, it can be regarded as a distributed database usage. Database link is a one-way connection.

Zookeeper When learning VB. NET videos, several of them talk about the database design and connection of. NET. We are no stranger to database connection. We have been in touch with the redbooks and data center charging systems. However, in my

It is normal for programs to encounter exceptions during execution, and exceptions during programming are inevitable. However, an exception handling server is required. To ensure the normal execution of the program. An error occurs during the

PL/SQL Introduction PL/SQL is also a program Language called Procedural Language/SQL ). PL/SQL is an Oracle database pair SQL statement extension. The features of the programming language are added to the use of common SQL statements. Therefore,

Zookeeper One: He backup set holds a backup of a database other than the existing 'xxdb' databaseSometime when you try to restore the backup file on an existing database and receive the following error message: Restore failed for Server'SQL Server

InfiniDB cannot create a table. The following error is returned when creating a table: First error: Constraint is not supported by InfiniDB. This is a constraint in SQL statements, which is not supported by infiniDB. For example Create table

This note is used to learn constraints, which are everywhere in the table. For example, data in a table cannot be empty or the table id must be set as the primary key. Constraint type: Primary key: The primary key represents a unique identifier in

String functions perform different operations on binary data, strings, and expressions. This type of function applies to CHAR, VARCHAR, BINARY, and VARBINARY data types, and data types that can be implicitly converted to CHAR or VARCHAR. I.

Some enterprises are using non-relational databases such as mongodb in Kunming. Therefore, they must have basic knowledge of non-relational databases in any case, this time I sorted out some of the most basic operations for adding, deleting,

When I set up physical standby the day before yesterday, the previous steps were all correct (in fact, they were wrong). When I verified whether the archived logs were synchronized to the standby database, I found: ORA-16047: DGID mismatch between

There is no separate Boolean Storage Class in the sqlite database. The Booean value is stored as 0 (false) and 1 (true). After my short-term test, it is shown that there are three statuses of boolean, 0 (false) 1 (true) and null, as shown in, The

Statistical information is very useful. Without it, the SQL optimizer is like a clever man! A good and efficient SQL Execution Plan depends on real statistics. However, in some cases, for example, to compare the execution plans of the production

The ASKTOM website provides the remove_constants function to check the SQL running status in the shared pool. The solution is to change the query condition value to a common tag, for example: replace select * from t where object_id = 1 with select *

Sqlldr is a recommended method for processing large data volumes. It has many performance switches to minimize redo and undo generation, control Data Processing Methods (insert, append, replace, truncate) Because the project needs to compare the

System Environment: CentOS release 5.10 Application Environment: Oracle 10.2.0.5 + php5.2.17 Hard parts: DELL R720, 1 T * 3 7200r, raid5 Business Environment: sqlload is written into the database every five minutes for effective data within five

1. the Oracle 10g Stream table-level replication configuration () was previously implemented. If a replication environment already exists, you need to clear the existing replication environment before configuring other types of replication,

1. Modify the table fields: Modify the Data Type of a column (generally, the length is limited and there are many restrictions when you change it to a different type ): Syntax: alter table name MODIFY (column name data type ); Eg1: alter table skate_