Database Administrator

Introduction: the parallel technology belongs to the big data field and is suitable for OLAP systems. It is widely used in scenarios such as task division, data block division, and abundant resources, this article focuses on six points, including

Oracle Database Connection and calling of Stored ProceduresCreate table chengji (id number, xing_ming varchar2 (25), yu_wen number, shu_xue number)-- Query All Information select * from chengji-- Stored procedure with no return value typeCreate

// The extract () function in Oracle is introduced from oracle 9i to extract specific parts from a date or interval Type// Syntax:EXTRACT ({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND}| {TIMEZONE_HOUR | TIMEZONE_MINUTE}| {TIMEZONE_REGION |

A. Use impdp and network_link 1. Create a db link in the target databaseCreate public database link hrtestdb connect to system identified by 1234 using 'hrtestdb '; Impdp system/1234 network_link = hrtestdb schemas = BMCCZHPUSR; 2. Create a

Recently, due to the need to migrate the Oracle database, UTL_FILE_DIR settings (oracle11g, linux) are involved ). It is mainly used to output logs for executing stored procedures. At that time, the following operations were done: Create directory

After Postgresql is installed using the Fedora package management tool, it cannot be automatically started by the random device. Today, I spent some time reading some related documents and finally found a solution. In fact, it is also very simple.

Step 1: view the Oracle tablespace usage: Select dbf. tablespace_name, Dbf. totalspace "Total (M )", Dbf. Total number of totalblocks as blocks, Dfs. freespace "total remaining amount (M )", Dfs. freeblocks "remaining blocks ", (Dfs.

Mysql replication is completed asynchronously by default. The semi-Sync Mode is a patch developed by google for mysql. This function has been integrated in Mysql 5.5 or later versions. Semi-sync means that the MASTER only needs to receive the

Environment: CentOS 5.5 32-bit Oracle 10g Preparations before installation: Download epel Source Http://dl.Fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm [Root @ localhost ~] # Rpm-ivh epel-release-5-4.noarch.rpm [Root @ localhost ~] #

When a friend encounters a problem today, the following information appears in the alarm log: ORA-1591: lockheldbyin-doubtdistributedtransaction1.92.66874 Query the dba_2pc table and no distributed transaction information is

Master database:-- Check whether archiving is enabled for the master databaseArchive log list; -- If archive is not enabled for the master database, archive is enabled.-- Set the archive pathAlter system set log_archive_dest_1 = 'location

It has been several months since reids was studied and used. I have summarized a lot of documents and related materials. In the next time, I will share some relevant materials, this article also describes how to use it in our applications. The

The solution for forgetting the MySQL root Password in Linux is based on Ubuntu 12.04 LTS. Forget the mysql password. The solution found on the internet is recorded here. Edit the mysql configuration file/etc/mysql/my. cnf and add a line "skip-grant-

Fault symptom: In Linux, where all Chinese characters appear in Oracle? Alternative, or directly garbled. Sometimes the error message is garbled. Solution: I. temporary solution Switch to the Oracle user and run [SQL] view plaincopyprint?

Error: [Oracle @ prudentwoo admin] $ sqlplussystem/oracle @ PRUDENTWOO SQL * Plus: Release 11.2.0.1.0 Production onWed Dec 12 03:23:29 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved.   ERROR: ORA-12514: TNS: listenerdoes not currently

Background Master-slave switchover is a necessary step for the high-availability MySQL architecture (that is, the use does not occur, but must be prepared ). Generally, it is set to double M (M1, M2). If the current status is M1 and M2 is read-only,

When the tablespace is expanded in the field, the environment is: solaris 10 cluster 3.2 + Oracle 10g RAC after expansion, execute sqlplus/as sysdba and then query the table space: SQL> select file_name from dba_data_files; The following error

1. create any directory ): SQL> create user Oracle identified by oracle; The user has been created. SQL> grant dba to oracle; Authorization successful. SQL> grant create any directory to oracle; Authorization successful. SQL> conn

RedHat 6.3 source code installation MySQL-5.5.29 details. From MySQL5.5, you need to use cmake to install and so. Here cmake is also used. 1. Install the compilation tool Yum install gcc-c ++ Yum install ncurses-devel Ii. Install cmake and bison 1.

The fields used in this article are the emp table under scott, the default user in the Oracle database. sal represents the employee's salary, and deptno represents the Department number. I. Aggregate functions Aggregate functions are also called