Database Administrator

There are dual virtual tables similar to those in Oracle in mysql: the official statement is purely to satisfy select... from... mysql ignores the reference to this table. You can pay attention to the following: Select * from dual; mysql will

It is very convenient to use the trigger in SQL Server for the first time today. This article will briefly introduce the trigger in SQL Server and its simple use. I will describe the definition, principle, and usage of this document.Definition A

As a high-speed database, redis must have a corresponding security mechanism on the Internet for protection. 1. The safer method is to bind an IP address for control.Copy codeThe Code is as follows:Bind 127.0.0.1Allow access only through the IP

Action Before doing so, I hope you can take a look at the above learning resources and learn about the basic operations. Initial account password for Data Connection Account: admin Password: admin  First, create a file: mongodb. php, set the account

The check_mysql script is required for mysql slave monitoring and an error is reported during check:Error while loading shared libraries: libmysqlclient. so.18: cannot open shared object file: No such file or directory1. The error message is as

Reprint please indicate the source: http://blog.csdn.net/u012860063? Viewmode = contents Problem description: As China's economy is developing rapidly, the amount of vehicle ownership has also increased significantly, and the congestion in cities is

The preceding two figures show the normal operation of scott user and test data after inserting c ~~~ Start the process.   1. Start -- run -- cmd   Input: sqlplus/as sysdba connecting to database 2. Create a c # scott user CREATE USER c##scott

Directory: Pg_buffercachePgfincorePg_prewarmDstatLinux ftoolsUse pg_prewarm to pre-load the relationship/index:Pgfincore output:How to refresh the relationship/index in the operating system cache?Use the range Function of pg_prewarm to pre-load

As a widely used database, Oracle runs stably on the AIX database and is widely used in some key departments and industries. As a special data storage medium, bare devices can directly operate data, saving the first level of the operating system and

Use SSH or XShell to access remote Linux. The SSH logon interface is as follows: The Host Name is the IP address of the remote server. User Name is a User Name of the server. The default port number is 22. You can enter the server password after

Abstract: A ORA-01591 error is reported when accessing specific rows of some tables Select * from BF_INCOME_EXPENSES_T Where account_id = 36816153 And user_id = 39964213 And city_code = '000000'  ORA-01591: locking allocated transactions that have

Delete an Oracle database in a Linux operating system in detail: 1. Disable oracle server and background processesPs-ef | grep oraTurn off the databaseShutdown immediate  2. Disable the listener.Lsnrctl statusIf it is enabled, execute lsnrctl stop

8.2 Opening a Standby Database for Read-Only or Read/Write Access8.2 When a standby database is open for read-only access, users can query the standby database but cannot update it. thus, you can reduce the load on the primary database by using the

The concept of DBLINK is not described in this article. This article mainly introduces the creation of DBLINK. 1. Create an environment descriptionThis article will create and test DBLINK on two virtual machines with a red hat 5.5 operating system

You can use exec or call to call a written stored procedure in Oracle data, but you can only use call to call the stored procedure in db2. Pay attention to parameter issues and parameter issues.   Exec proc_pay_idv ('20140901 ',?); The execution

The customer requested that hive be used to implement the decode function similar to orale. Okay, start work. Oracle decode function Syntax: DECODE (value, if1, then1, if2, thne2, if3, then3,... else ). The first problem involved is the dynamic

When migrating an Oracle stored procedure to the HIVE platform, you will inevitably encounter Syntax problems related to table Association. This article compares various table Association syntaxes of ORALCE and HIVE in detail, including internal

Building Database Clone objects is a common daily O & M requirement. During actual development and testing, you often need to quickly copy a database environment containing business data. Previously, we have introduced how to use the RMAN Duplicate

Linux and AIX are the most common server operating systems in our O & M environment. Ideally, the configured application runs in a stable cyclic environment. Generally, there will be no excessive configuration changes. However, if you do not

Complete steps to manually create a database in Oracle 1. Create a directory for storing database files and log-Related Files Create the NEWDB directory in the $ ORACLE_BASE \ oradata and $ ORACLE_BASE \ admin directories respectively. Use commands