Database Administrator

Oracle synonym + dblink Application Oracle synonym + dblink Application Business Requirements: original database (10.2.0.4.0), new database (11.2.0.3)Due to program requirements, you need to map a user in the new database to the user in the old

Install MySQL 5.6.23 in Linux Install MySQL 5.6.23 in Linux Create userLog on as a root user and create a mysql user to maintain the mysql service. [Root @ localhost ~] #[Root @ localhost ~] # Groupadd mysql[Root @ localhost ~] # Useradd-g

Solve the Problem of mysql stop fail in Ubuntu I recently encountered a MySQL stop fail problem when I was studying mysql. Here I will write down the problem and the solution process, not how difficult it is, however, I did not find a valid Chinese

ASM management-how to rename diskgroup The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup. If the renamed diskgroup is

Install MySQL Binary Package for RedHat Linux Enterprise 6.4 Download MySQL and upload it to the server 1. Download the mysql binary installation package from the Mysql official website. Https://edelivery.Oracle.com/osdc/faces/SearchSoftware? _

MySQL InnoDB table-Basic BTree Data Structure MySQL InnoDB table is an index organization table. This should be the first thing that anyone who learns MySQL will learn. This means that the data in this table is stored in the primary key order, that

Solution for Oracle 11g forgetting SYS and SYSTEM passwords Oracle 11g forgets the SYS and SYSTEM passwords. The answer is simple: change the password! 1. First, log on to the SYS account using the operating SYSTEM authentication method and change

Oracle Big Table cleanup truncate... reuse storage Recently, a large table needs to be cleaned up, which requires no impact on performance. In MySQL, we can minimize I/O by using coreutils and hard links. Oracle can also minimize I/O by recycling

Error code: 1109 Unknown table 'ename' in multi delete, 1109 ename 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: delete. ename from emp error code: 1109 Unknown table 'ename 'in multi delete execution time: 0

Oracle (4) --> advanced subquery (it is difficult to explain multiple examples, but I really don't believe it ~), Oracle Introduction This section will discuss the more complex application of instant queries, mainly to simplify SQL and improve

[Data center cooperation]-SqlHelper we have another appointment. Data Center cooperation sqlhelper1. What is it? SqlHelper is a database operation component based on · NET Framework, which contains database operation methods.2. Why? Why use the

Xin Xing sorts out some common non-SQL operations in postgresql. Xin Xing postgresql The operations mentioned here are performed after we use psql to enter the postgresql client. They are not SQL statements, but they are usually important. Below

Forcibly obtain the next value of the sequence/current value (oracle function), oracle Function Http://blog.csdn.net/qq525099302/article/details/47146393-For more information about how to use a function to obtain the sequence value, see here. --

High Table space usage in SYSAUX The SYSAUX tablespace is an auxiliary tablespace of the system tablespace. It mainly stores EM-related content and table statistics, AWR snapshots, and audit information, if SYSAUX tablespace is not configured by

Mysql syntax errorError message: MySQL server version for the right syntax to use nearPossible cause 1: The Database Name, table name, and field name cannot contain the mysql keyword.For example, 1) desc or asc2) group2. Database Name, table name,

DM Database Installation and Use1. Download from the official website Select Download based on the computer operating systemNote: Linux kernel versions must be 2.6.32 or later, and rhel must be at least 6.0 (libdmutl. so cannot be found)2. List

ORA-16014 and ORA-00312, ora-16014ora-00312 Scenario: SQL> alter system archive log current;Alter system archive log current*Row 3 has an error:ORA-16014: log 2 sequence #34 Unarchived, no available destinationORA-00312: Online log 2 thread 1: '+

Solution for slow SQL query caused by custom functions, function SQL During the report process, one report queries the exchange rate of the corresponding currency, and the exchange rate is in another table, the condition for querying the exchange

Install and use phpMyAdmin. Set up phpMyAdmin on CentOS and centosphpmyadmin in CentOS Required components: apachephpmysqlphpmyadminapache0.yum install httpd1. confirm the version $ httpd-v2. start apache $ sudo service httpd start

Error Caused by tablespace _ temporary tablespace: ora-01652 small example, ora-01652 Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46888243 Error Reporting temporary tablespace