Database Administrator

How to Learn PostgreSQL SQL syntax We can use the psql command to query the SQL syntax. Switch to the PostgreSQL user, [Doctor @ localhost ~] $ Su-postgresPassword:Su: Fault Identification[Doctor @ localhost ~] $ Su-postgresPassword:-Bash-4.3 $

Use RMAN for data migration Use RMAN for data migration 1. view the SCN and back up the database. Run {Allocate channel c1 type disk;Allocate channel c2 type disk;Allocate channel c3 type disk;Allocate channel c4 type disk;Allocate channel c5 type

Keep these three things in mind and never put them in the database. I have already said in many speeches that the best way to improve your system is to avoid "stupid things" first ". I am not saying that you or the things you develop are "stupid",

An Application of MySQL to compress tables 1. Set server ParametersInnodb_file_per_table = ONInnodb_file_format = Barracuda 2. Create or modify table parametersAlter table sod_song_log_2014_10_12 row_format = compressed key_block_size = 8; The

A bug about database restart in Oracle The drop database operation is a fatal operation in Oracle. This operation has been experienced in the test environment and will completely delete data files. Therefore, this operation is very sensitive but not

MySQL Horizontal Split (Reading Notes)1. Introduction to horizontal split In general, a simple horizontal split mainly refers to distributing a table with extremely ordinary access to multiple tables according to certain rules of a field. Each table

Use API for shipment confirmation and run Interface Trip Stop, apiinterface DECLARE p_sales_order NUMBER: = 1506764295; p_line_number NUMBER: = 1.1; p_org_id NUMBER: = 121; l_shipped_quantity NUMBER: = 1; p_api_version_number NUMBER: = 1.0; init_msg_

Install mysql and linuxmysql in linux 1. Check whether the grep is installed. The-I option of grep indicates that case sensitivity is ignored when matching. [Root @ localhost JavaEE] # rpm-qa | grep-I mysql Mysql-libs-5.1.61-4.el6.x86_64 * It can be

Redis data type: string type, redisstring Web programmer blog: http://blog.csdn.net/thinkercode String type-Features String is the simplest type. You can think of it as the same type as Memcached. A key corresponds to a value, and the

Use LOB Storage, uselobstorageIf LOB storage is not defined and LOB attribute size exceeds 4000 characters the attributes which overflow will automatically be placed in the tables tablespace in default configured LOB storage and index. if LOB

TNS-03505 name cannot be resolved, tns-03505 name resolved TNS-03505 name can not resolve the problem Phenomenon: [oracle@db01 admin]$ tnsping priTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 15-JUN-2015 21:57:52Copyright (c) 1997, 2

Execl data import SQL Server, execl data import SQL You can import execl table data to the database to specify columns or *Note:This statement can only be executed in the local database. If the remote server is connected, the statement should be

Oracle hierarchical query learning summary, oracle levelHierarchical query document directory: 1.1 Summary 21.2 node terminology 21.3 use the connect by and start with clauses 31.4 hierarchical query instance 31.5 query from bottom up 41.6 Delete

Mysql replication delay monitoring script and mysql delay script #! /Bin/sh # ocpyang@126.com # repdelay. sh # view the specific number of replication delays ##### 1. juede the rep slave status export black = '\ 033 [0m' export boldblack =' \ 033 [1;

PreparedStatement and Statement, preparedstatement PreparedStatement is one of the APIs used to execute SQL query statements. Java provides Statement, PreparedStatement, and CallableStatement to execute query statements. Statement is used for

Solution for oracle Database not opened, oracle DatabaseMicrosoft Windows [version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C: \ Users \ Administrator>C: \ Users \ Administrator> sqlplus/as sysdba;SQL * Plus: Release 11.

How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the oracle database, oracleplsql How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the

MongoDB introduction, installation, and setup of a simple mongoDB server (1 ).Related Websites 1. http://www.mongodb.org/official website, you can download the installation program, and doc, and driver. 2. http://www.mongoing.com/domestic

How many bytes does VARCHAR2 occupy? NLS_LENGTH_SEMANTICS, nls_language, nlslengthsemanticsORACLE initialization parameter: NLS_LENGTH_SEMANTICS The initialization parameter NLS_LENGTH_SEMANTICS is used to specify the length definition method for

Simple SQL partially strengthens exercise questions, simple SQL strengthens exercise questions Simple query of some SQL exercises -- Select * from emp where deptno = 30 for all employees in department 30; -- list the names, numbers, and