Database Administrator

How to downgrade an Oracle database from 11.2 to a previous version This document can be used to downgrade the upgraded database from Oracle 11gR2 to the following guidelines and checklists: Oracle 10gR1, Oracle 10gR2, and Oracle 11gR1. This

While I was unable to upgrade my laptop to 1 GB of memory, I was suffering from installing Sun Solaris 10 U3 + Oracle 10g R2 in my current book, I got a laptop for the competition, haha ...... Comfortable. The following is my Installation Record

Summary of Oracle parameter viewing methods and oracle parameter Summary Oracle provides a large number of system parameters. The following is a summary of the query methods.Current System Parameter The current system parameters involve these views:

Use kettle to batch download files and kettle to batch download files Use kettle to batch download files In the latest projects, you need to download files in batches and import the results into the data. kettle is indeed competent through some

It may be an ignored update Statement (update technique) or an update statement Well, I 've written a simple article again, and I hope you will not be enlightened. This time I want to talk about the update statement in SQL. Speaking of this, there

Today, when I used exp/imp for a small backup and recovery operation, I encountered a problem. Many empty tables cannot be expressed. I didn't understand it at the beginning, later, I went to the Oracle official website and read Oracle data. I sent

After the Oracle manufacturer recently installed the monitoring plug-in for OEM 12C in the primary database in the production environment, an exception occurred to the Oracle GoldenGate instance that has been synchronized to more than a dozen

Requirements for installing oracle database 12c on RHEL7 or OL7, rhel7ol7 This article comes from: Requirements for Installing Oracle Database 12.1on RHEL7 or OL7 64-bit (x86-64) (Document ID 1961997.1)   This article is not translated and is only

1. view the local node directory In the command window, enter db2 list node directory. 2. cataloguing a TCP/IP Node Command window: db2 catalog tcpip node Remote Server Ostype 3. Cancel node

A pivot table is a method for analyzing data. It contains a powerful data pivot function in Excel. What is data pivoting? It may be easier to give an example. Assume there is a data table: Sales volume of books ---------------------------------------

An Introduction to the Data Science series at the University of johnkins In the past few months, I have taken Andrew Ng from Stanford University as a reference for his machine learning handout, on the CSDN blog, I wrote some summary notes related to

Characters corresponding to the ASCII code value and ascii characters Chr (9) tab space chr (10) newline chr (13) carriage return Chr (13) & chr (10) carriage return newline chr (32) space character chr (34) double quotation marks chr (39) single

Percona-toolkit installation and introduction, percona-toolkit MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many

Logon database Tiger causes the slave uard to be not synchronized. tigerdataguard When the slave uard upgrades the CPU, it finds that the master and slave databases cannot be synchronized and the log reports an error. Therefore, the script "@

Informix IDS databases are widely used in various industries such as finance, telecommunications, and postal services. It is a multi-threaded relational database server that adopts symmetric multi-processor technology and single-processor

1. The string connection in db2 is available "| ". 2. How to quickly delete a large number of data tables (test is a database table) The most common and most commonly used statement: delete from test. However, this method is inefficient and takes

Materialized views are similar to indexes in many aspects: materialized views are used to improve query performance, while materialized views are transparent to applications, adding or deleting materialized views does not affect the correctness and

In the process of using the Sybase database, we often encounter locks in the Sybase Database System. In most cases, users must log on to the system as Super Users to process the process. To ensure the security of the Sybase Database System, the

If you deploy an Oracle database system on a Windows operating system, the startup process is written to the service list of the operating system. And some major services will be set to auto start. In this case, the database is automatically started

This article will discuss the similarities and differences between simple nested queries and non-nested queries in SQL, through which you can better understand SQL statements. One day's work was to fix the bug of a project, and then we found that