Database Administrator

Temporary tables, external tables, and partition tables in OracleTemporary table In Oracle, a temporary table is "static". It only needs to be created once like a common data table. Its structure is valid from creation to deletion. Compared with

Oracle 11g Data Loading Methods Data Loading: SQL * LOADER External table Import/Export SQL * LOADER: SQL * LOADER is an Oracle tool that can load data from external data files to databases. The command for running SQL * LOADER is sqlldr. Two

Database Tuning tutorial (2) Prepare slow query data and optimize Databases 1. Slow query found In the previous section, we talked about the definition of slow queries. This section describes how to create a large table and prepare data for slow

[Translated from mos] flashback and flashback database, Flashback zone and flashback database Reference:Flash recovery area and FLASHBACK database (Document ID 369759.1) Applicable:Oracle Database-Enterprise Edition-Version 10.1.0.2 and

How to install mysql database under Ubantu, and how to back up SQL files and run SQL files !, UbantumysqlInstalling mysql on ubuntu is actually easier than installing mysql under Windows. Just enter the password once in the middle of the following

In Linux, MySQL is case-insensitive and mysql is case-insensitive. MySQL in Linux Database Name, table name, column name, alias case-sensitive rules:1. The database name and table name are case sensitive.2. The table alias is case sensitive.3. The

MySQL installation (source code installation mode) and mysql source code installation mode MySQL installation (RPM installation mode) and directory structure MySQL installation (Binary installation mode) MySQL installation (source code installation

One of Oracle asm kfed tools, asmkfed [root@localhost db_1]# su - oracle[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ pwd/u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ ls -lrt

SQL _ write a simple Stored Procedure for deleting employee information, SQL stored procedure Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise,

SQL Server Authentication and user logon, SQL Server During installation, the SQL Server database engine is set to "Windows Authentication Mode" or "SQL Server and Windows Authentication mode ". After installation, you can change the Authentication

The IP address of the Oracle restricted connection, and the ip address of the oracle restricted connectionIn oracle, you can control which IP addresses can connect to the database and which IP addresses cannot connect to the database. In 9i and

MongDB basic learning (7) -- [MongoDB for Java] Java operations on MongoDB and mongdbmongodb [MongoDB for Java] Java operations on MongoDB The developed products are constantly revised for financing purposes. From the first version to the latest

Supports SQL tuning and SQL TUNING A friend of mine found me a few days ago and said that an SQL Performance problem exists to see if it can be optimized. The process is as follows: Snow Leopard 9:35:10 Are you there? Orchid island master 15:07:39 I

ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and

Oracle uses a cursor to add a primary key statement to all user tables. oracle cursor Application Scenario: adding an auto-increment primary key to a data table can speed up data table access, and is the fastest in integer indexing. This program is

Redis Research (17)-SORT sorting, redis research sort sorting 1. Set Operations of Ordered Sets The set type provides powerful set operation commands, but the ordered set type is required if sorting is required. When designing Redis commands, the

Oracle will you really use the ltrim/rtrim function ?, Ltrimrtrim The common usage is to remove spaces. How many people do not know that they can actually remove spaces? It has the ltrim () and ltrim (x, y) methods. ------- Remove spaces on both

Step by step, gathering small streams ------ oracle quick add test data, ------ oracle Some time ago, problems were found during implementation and need to be modified at that time. Because the data in the database is real data, it cannot be

Mysql modifies columns, adds columns, deletes common column commands, and mysql commands Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions. View column: desc table name; Alter table t_book rename to

Overview of the Online Redo Log, overviewredo For oracle restoration, the most important data structure is the online redo log (online redo log). The online redo log contains at least two pre-allocated files used to store database changes. Online