Database Administrator

Microsoft Excel is a frequently used tabulation tool. It can use ODBC to conveniently obtain DB2 data on AS/400. The procedure is as follows: (the procedure is described in the WIN2000 + Office2000 environment. you have configured the ODBC Data

To import the user accounts and passwords in the blog into the FTP database, you can directly use the blog account to log on to FTP. I decided to use python in Linux to help me deal with it. This log is a brief introduction, using python to connect

Today, a 32-bit Linux is installed on a server with a blade failure, and a 32-bit Oracle is installed on it, the physical data guard of a 64-bit Oracle instance is successfully configured. The same-digit data guard configurations of the same version

The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of

1. Find SQL Server Profiler and log on Location: Click start -- program -- Microsoft SQL Server -- performance tool -- SQL Server Profiler Or find the location after Logon: 2. Then, enter the following interface: Enter relevant information and

ScenarioA module on machine A connects to MySQL on machine B and works normally in the lab network environment. Similarly, A and B are two machines, the network environment is switched to A small LAN environment isolated from the outside world. The

I. Preparation knowledgeConstraints are placed in tables. There are five constraints:Not null the column specified by the non-NULL constraint C cannot be NULL.UNIQUE has no duplicate values in the column specified by the UNIQUE constraint U, or each

Enables users to write quota in the tablespaceThe user on the tablespace to create tables, insert data these basic operations, sometimes will also report ORA-01950: no privileges on tablespace 'system', then, how to do it at this time?9i library,

There are still many steps to generate a shared disk and mount it to asm when Oracle VM builds Oracle RAC. Record it. The premise is that a linux has been installed in the VM.1. here I create five disks, cd C: \ Program Files \ Oracle \

SQLite has no restrictions on the Authorization protocol and supports most of the standard SQL 92 statements. We believe more and more people will use this database.The combination of PHP and SQLite is just like the combination of ASP and ACCESS in

Why is there a master-master replication of mysql. In some highly available environments, mysql Master/Slave cannot meet some practical needs. For example, if there is a bottleneck for access to some websites with high traffic, two or more mysql

Note: All operations in this article are performed under the root user. 1. Install sqlite3 Install sqlite3 in ubuntu and run the following command directly on the terminal:# Apt-get install sqlite3View version information:# Sqlite3-version2. Common

• List table space recovery at execution time (TSPITR) operations that will occur • Definitions of terms used by TSPITR • determining the appropriate conditions for using TSPITR as a solution • determining the correct target time for time point

Environment Description:OS: aix 6.1DB: bare Oracle 10gR2 Device An error occurred while using rman to back up the entire database. If the 71 Data File fails to be backed up separately$ Rman target/ Recovery Manager: Release 10.2.0.1.0-Production on

Oracle online log files record the logs of data block changes during database operation. After the database becomes corrupted or fails abnormally, you must use online logs (or archive logs, repeat the changes in the database. When the log file

MySQL is an open-source relational database system. Replication is a process that replicates data from a MySQL database server (master server) to another server (slave server slave. Configure the master server) 1. Edit the database configuration

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. You can also connect to the ASM instance from a client. However, Oracle does not provide a tool for us to complete the configuration. We

Someone asked me how to differentiate whether RAC is Admin or Policy managed after it is created.First, we should look at the definition: Administrator-managed: Database administrators define the servers on which databases resource run, and place

-- ==================================== -- Backup and recovery of read-only tablespace -- ==================================== I. Features of read-only tablespaces Use read-only tablespace to avoid frequent backup of static data When alter

This article was sponsored by 51cto.com and first launched in the dark world. To be honest with SQLServer2005, I am not very familiar with it. I will share my research results this afternoon. Use the Navicat for SQL Server tool to manage databases.