Database Administrator

PL/SQL basics-Exception Handling Exception HandlingI. Exception typeThere are two types of Oracle exceptions: system exceptions and custom exceptions.System exceptions are classified into pre-defined exceptions and non-pre-defined exceptions.1.

MySQL copies the table data or table structure to the new table. How to copy data from a MySQL table to a new table. 1. MySQL copies the table structure and data to the new table Create table new_table SELECT * FROM old_table; 2. Only copy the

MariaDB master-slave Replication MySQL Replication: NySQL Replication. MySQL Replication adopts asynchronous working mode by default. The replication function of mysql is built in mysql. After it is installed, mysql replication is a basic tool for

Install Oracle 11gR2 on Ubuntu 14.04 (amd64) After a week of trouble, I finally got it. Although there are many online tutorials, most of them are just a few words. In addition, the individual installation situations vary, and many places still need

How to set the ASH buffer size Ash Buffer is a memory area used in a loop in SGA to store the active session information captured by MMON. MMNL dumps the content of Ash buffer to AWR every 60 minutes after filtering, the corresponding view is

Oracle 11gR2 uses gpnp profile to store the spfile path of ASM Since Oracle 11gR2, GI has integrated ASM, and OCR/VOTEDISK has also been stored in the ASM disk group (which must be stored on bare devices before 11gR2 ), at the same time, the

Create and modify temporary oralce tablespace, oralce SpaceA temporary tablespace is a disk space used to store the temporary data generated when you execute the order by lamp statement for sorting or summarizing. By default, all users use temp as

Oracle view, oracle view Creation Oracle ViewSimple View View a virtual table that contains a series of columns and row data with names, just like a real table.However, the view does not store the actual value in the database. The database only

Quick Solution to Error 45 initializing SQL * Plus Error, initializingplus Recently, sqlplus is often used to run SQL scripts in the background, so it encounters Error 45 initializing SQL * Plus Error.   The PL/SQL file I run test. SQL is as

Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1, goldengateConfiguration environment: Source：OGG：11.2.1.0.1Name:zbdba1Target:OGG:11.1.1.1.2Name:zbdba2 Upgrade Target to the same version as the source. Backup Target ogg installation directory: [Root @

OGG-01496, OGG-01031 The pump process reports the following error: 01:20:49 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, ext2.prm:./dirdat/sa000000, at RBA 2295. The tail file does not exist on the target end. It may be because the

[DAO] database three paradigm description, dao Database paradigm**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** ***

Query the number of fields (columns) in a table in Oracle. If a table contains many fields and we want to know the number of fields in the table, it is very troublesome to use the following method to calculate the number one by one. The

Oracle Advanced query over (partition by...), advanced query .. To facilitate learning and testing, all examples are created under Scott, an Oracle user. create table EMP(  empno    NUMBER(4) not null,  ename    VARCHAR2(10),  job      VARCHAR2(9),

Auto increment of ID fields in the SQL _Oracle table and SQL _oracle Field Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Oracle startup and shutdown, oracle startup and ShutdownOracle004 oracle-related program startup and shutdown: Disable: EM, ISQLPLUS --> listener --> database isqlplusctl stop, emctl stop dbconsole --> lsnrctl stop --> there are two ways: 1. dbstop 2

Use the alter system check datafiles command, alterdatafiles The alter system check datafiles command seems to have been seen in the White Paper, so I searched for it in the SQL reference in the official document. The description of this statement

About LUN queue depth (max_q_depth) in HP-UX operating systems, hp-uxmax_q_depthOriginally I don't know how to view the LUN queue depth under the HP-UX operating system, then I consulted a buddy in the white eel group-network neighbors, he gave the

Summary of common Redis commands and common redis commandsService command:• BGREWRITEAOF asynchronously rewrite the append object• BGSAVE asynchronously saves the dataset to the disk• Client kill ip: port closes CLIENT Connection• Client list to

[Mysql] add, delete, modify, and query Mysql Databases in Java, Java System class, And javamysql This part is also the content of the so-called JDBC and website data sources. It makes the name very similar. In fact, it is only the content of adding,