Database Administrator

Oracle Temporary Tables (Temporary Oracle table) 1. Create a temporary table syntax A. on commit delete rows defines how to create A transaction-level temporary table Create global temporary table TABLE_NAME ----- (COUMNS ...) ----- As select...

The Tor relay server running Linux has been detected for the first time for more than two weeks. The following records are recorded before the last log crash:Mar 14 16:20:23 gateway kernel: tor invoked oom-killer: gfp_mask = 0 × 40d0, order = 1,

001:Configure: error: no acceptable C compiler found in $ PATHSee 'config. log' for more details.Configure failed for srclib/apr Cause: C compiler is not installed. Solution: Install all the 'development tools' (because I cannot determine which one

1. mysql remote connection is slow or cannot be connected at all 2. log on to the mysql console locally and show processlist. Many processes are displayed, similar | 145 | unauthenticated user | 61.129.57.158: 1672 | NULL | Connect | NULL | login |

Kaj arn', vice president of the MySQL open-source community, posted a formal statement on his blog: "I am very happy to announce that MySQL will give up the decision to disable some functions of the source MySQL Server ". The MySQL Server database

The replication or migration methods and steps are as follows: Uninstall the previously installed Oracle before the transfer (if any) 1. Copy the installation directory of the original ORACLE database to the installation directory of the new machine

1. MySQL can search for the "Mike" value in the name index, and then directly go to the corresponding row in the data file to return the peopleid (999) of the row accurately ). In this process, MySQL only needs to process one row to return results.

Notes on operating MySQL in Linux: 1. Run netstat-nat to check the port number (mysql starts 3306 by default) 2. Several important mysql DirectoriesDatabase Directory:/var/lib/mysqlConfiguration File:/usr/share/mysqlRelated

1. First install Trac in Ubuntu 8.04 2. Create an env directory Sudo mkdir/var/lib/trac // create the trac directorySudo chmod-R 777/var/lib/trac // grant Read and Write PermissionsSudo trac-admin/var/lib/trac initenv // create the env directory The

To write an Oracle Application in Linux, you must install the client. I checked a lot of installation instructions. After testing, I will summarize them below. We thought we could install it according to the Oracle manual, but we found that the

The db2 database provides its own application programming interface (API)-db2 call level interface (called the db2cli programming interface). Currently, it supports C and C ++. Db2cli is implemented based on the MicrosoftOpenDatabaseConnectivity

The preceding method uses the combination of Red Flag DC Server 5.0 and iASP to connect to an independent ms SQL Server 2000 using ASP. The advantage of this method is that you do not need to modify the user's database environment. However, the

During database operations, we may encounter this situation, and the data in the table may be repeated, causing a lot of inconvenience during database operations, so how can we delete the useless data? The deduplication technology can provide a

I. Oracle Control File Content   You can view the contents in the control file in the v $ controlfile_record_section view.   SQL> select type from v $

Rman is a problem for beginners, but it is also true for me. So here I will summarize the problems I encountered during the use of rman and provide a solution. I hope to give some valuable experience to those dishes that are the same as me.  1. The

Oracle error message: SQL> startup > ORA-10997: another startup/shutdown operation of this instance inprogress > ORA-09968: unable to lock file > Linux-x86_64 Error: 37: No locks available > Additional information: 64 Message file error message: (192

In this case, you have previously copied and restored all files under/u01/app/Oracle. to delete an existing database, it is found that the delete database option in dbca is gray. But there is actually a database, so I suspect that the configuration

There are three ways to create a database: 1: use Oracle dbca (database configuration assistant) to create a database 2: Create a database manually (this is complicated and requires manual parameter configuration) 3: Use oracle managed Filed to

The MySQL master-slave replication structure is based on the mysql bin-log. The slave database receives the bin-log incremental information of the master database by opening the IO process and saves it to the local relay log, then, the incremental

The root User Password of MySQL is often easy to forget. It has a mechanism to handle permission errors by skipping the permission check and starting. This article introduces how to forget or reset a MySQL password in Windows and Linux respectively,