Database Administrator

Using Netback to back up Oracle Reports ORA-27206 error handling Today, my colleague encountered a problem with Oracle database backup. The error message is as follows: Channel ch01: starting piece 1 at 2015-01-12: 22: 06: 56RMAN-03009: failure of

Oracle DML Error Log notes DML error log is an error log function introduced by Oracle 10gR2 similar to SQL * Loader. The basic principle is to transfer any records that may cause statement failure to an error log table. The specific usage is as

Oracle 11gR2 Database UNDO tablespace usage remains high The customer's Database is a standalone Database of Oracle Database 11.2.0.3.0 for AIX 6.1 64bit. The customer queries DBA_FREE_SPACE and finds that the UNDO tablespace usage is as high as 98%

Log File mode in oracle and oracle Log File Mode There are two log modes in oracle Database: Non-archive log mode and archive log mode. In the oracle database system, to prevent the contents of log files from being overwritten during cyclic use, the

Database integrity and constraints, database integrity constraints Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Database integrity and constraints 1. Data Integrity: three types of constraints are commonly used to ensure

GOLDENGATE installation and Data Replication flow setup configuration _ excluding DDL extraction version and goldengateddl GOLDENGATE installation and Data Replication flow configuration (The source database is an instance and supports ASM,

IIS installation and configuration, IIS installation Configuration This tutorial applies to win7 Systems 1. Install IIS (1) If the IIS server is not installed in the operating system, open the control panel and click Start Program and function

Oracle uses a cursor to query a string that combines the names of all fields in a specified data table. oracle cursor Application Scenario: refer to the Code for querying all field names of a data table on the Internet, and use a cursor to generate

Cascade, no action, Restrict, set null, cascaderestrict in MySQL foreign key settingsAttribute meanings in MySQL foreign key settings:Cascade ModeWhen updating/deleting records in the parent table, synchronize update/delete matching records in the

ORA-14099: all rows in table do not qualify for specified partition, ora-14099qualify 1.Create a partition table Create table range_part_range (id number, deal_date date, contents varchar2 (1000 )) Partition by range (deal_date) ( Partition p1

What is ETL? SDE: Source Dependent Extract SDE mappings -- extracts the data from the transactional Source System and loads into the data warehouse staging tables. SDE mappings are designed with respect to the source's unique data model. SDE _ *

Store data outside the database or file system to improve the performance and performance of the report system. In report applications, the proportion of reports queried for historical data is large. Such reports have the following features: first,

Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2), connectmysql. sock When mysql is installed in linux, the following error occurs: Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2) This error occurs,

BUG: mysql 5.6 Invalid use of GRANT/REVOKE command breaks replication, revokereplication Bug Description: When the revoke and grant commands are used to revoke the permission, an error occurred while granting the permission (except for syntax errors)

PL/SQL Developer customizes the case-sensitivity conversion icon to the toolbar. pldeveloper For case-insensitive conversion shortcuts, see http://blog.csdn.net/itmyhome1990/article/details/41363633 You can add the case-insensitive conversion icon

Rollup and cube, oralcerollup of Oralce advanced SQLIn oracle SQL query, oracle provides some advanced functions to simplify SQL query statements and improve query performance. The following describes the usage and difference of rollup and cube.1.

MySQL database backup and recovery methods, mysql Database BackupMySQL database backup and recovery methodsMysql-uroot-pShow databases;1. Export the database1). MySQL command line to export the entire database (including data)The exported files are

ORACLE error 1658, oracle1658 When importing data to oracle, the following error is reported multiple times: IMP-00003: encountered ORACLE error 1659ORA-01659: unable to allocate MINEXTENTS greater than 1 (in tablespace ZSTA_DATA_TBS) IMP-00003:

T-SQL time format CONVERT (), t-sqlconvertFunctionReturns the expression converted to the provided data type.Syntax CONVERT (data type, expression [, format-style]) Example: convert(varchar(10),getdate(),112) Parameters The data type expression

MySQL (9) -- string function (2), mysql string(8) Delete the TRIM (s1 FROM s) function of the specified string) TRIM (s1 FROM s2) deletes all substrings s1 at both ends of string s. S1 is an optional direction. If no direction is specified, spaces