Database Administrator

How to obtain Oracle patch announcement information and download patches Oracle Releases security-related patches four times a year, namely, Critical Patch Updates. How do we know whether the latest CPU is required? Here we will show you how to

Create an Oracle database link (DBLINK) You can run the following command to check the Global Database Name: SELECT * FROM GLOBAL_NAME; You can use the following statement to modify the parameter value: Alter system set GLOBAL_NAME = TRUE/FALSE;

PentahoReport Designer getting started tutorial (2), powerdesigner tutorial PentahoReport Designer getting started tutorial (2) Pentaho Report Designer5.1 is the latest version. I. Installation and introduction This section describes how to install

Exploration of Access database migration and access database migration Background: The Access database architecture was previously designed for business information system software. After a period of operation management, it was found that Access

For the first time, I installed DB2 on Linux. I have referenced a lot of online resources, But I mainly used "detailed steps for installing DB2 version 8.1 in Linux ".At the same time, I kept a record of my problems for learning. VMWARE uses VMware

Kettle series tutorials 1. kettle series tutorialsIntroduction to kettle Kettle is an ETL (Extract, Transform and Load extraction, conversion, and loading) tool. It is frequently used in data warehouse projects. kettle can also be used in the

[Translated from mos] modify the dbsnmp password in the DB (10g and 11g) monitored by the db Control, mosdbsnmp How to modify the dbsnmp password in the DB (10g and 11g) monitored by db Control Reference Original:How to Change DBSNMP Password in

Reading: docker container and container cloud (2); reading docker Summarize the learning and building process of dockerI read the 3.1 kernel, which is quite awesome.After reading the plug-ins on the internet, I tried them based on python and

The SQLServer remote server does not exist. It is not specified as a valid Publishing Server, or you do not have permission to view available publishing servers. sqlserver does not exist. When a transaction release is created and an error occurs

Mysql login & Exit, create & Delete & select database, basic data type, create & Delete table, mysql Login Log on to the database and run the following logon command: shell>mysql [-h host] -u user -p [-D database]Enter password: -H specifies a

In the data warehouse project, ETL is undoubtedly the most tedious, time-consuming, and unstable. If the data source and target are both Oracle and meet certain conditions, you can use the oracle tablespace to improve ETL efficiency.To use a

Learn SQLSTATE, sqlstate08001 1. What is SQLSTATE? Shell> SELECT * FROM no_such_table; ERROR 1146 (42S02): Table 'test. no_such_table 'doesn' t exist Display after an error occurs in the preceding SQL statement. 1146 is the error code defined by

Comprehensive Sqlite Learning (1), sqlite Learning Finally, CSDN was chosen to sort out the knowledge points published over the past few years. This article was migrated to CSDN in parallel. Because CSDN also supports the MarkDown syntax, it's

Tutorial on installing and using the extension module on PostgreSQL, postgresql extension module Installation Module Note: My runtime environments are Ubuntu 10.04 and PostgreSQL 8.4. First, install the postgresql-contrib package and restart the

Use Bucardo5 to implement master database replication of PostgreSQL, bucardo5postgresql The next generation of asynchronous primary database replication system Bucardo 5 is released. This version removes the restrictions on two database sources in

First, the table below describes the ing relationship with the DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed for specific issues. Note: The DATE in Oracle contains the year, month, day,

ORACLE Installation./runInstaller reports "You are attempting to install 64-bit Oracle on a 32-bit operating system., yuminstalloracle Prepare to install the oracle database, see: http://blog.csdn.net/mchdba/article/details/43086037 1. solution (1):

Oracle technology _ 5 minutes will use stored procedure _ simple example of stored procedure (including loop, condition, add and modify query, parameter input, variable assignment, java call, etc.), oracle_5 Example business functions: 1. query the

Migrate the oracle database from the 32-bit platform to the 64-bit, oracle32-bit The disk of the customer's 32-bit oracle database system is damaged. Fortunately, the oracle database is intact. The customer requested that the database be migrated to

Analysis of Three-tier architecture, analysis of three-tier architectureThree-tier architectureLet's take a preliminary look at the three-tier architecture through several questions.1. What is a three-tier architecture?2. Application Scenario-why