[Oracle] Data Pump detailed tutorial (1)-Overview starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for Data import and export, old exp/imp can be used, but it is not recommended. Note: expdp/impdp AND ex
For non-Data Guard patch installation tutorials, refer to [Oracle] CPU/PSU patch installation detailed tutorial. Data Guard requires both Primary and Standby patches, so the steps are more complex, the main steps are as follows:1. Stop the log transmission service in Primary;2. Shut down the Standby database, patch the
Oracle Tutorial: Move all data files. Recently, there is a shortage of hard disk space in a development library. A new disk is added to move all the data files to the new disk.
Oracle Tutorial: Move all
I deleted the database by mistake. The boss was very upset. I had to recover the database within 30 minutes. In a hurry, I wrote a stored procedure, which is suitable for deleting the table on the day of recovery without remembering the table name.
I deleted the database by mistake. The boss was very upset. I had to recover the database within 30 minutes. In a hurry, I wrote a stored procedure, which is suitable for deleting the table on the day of recovery without remembering the table name.
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:
1. Stop log transfer service in primary;
2. Close the standby dat
Oracle Data Warehouse creation tutorial. How to create a data warehouse, create an example, think of graduation design requirements, recently began Oracle's Warehouse modeling practice, detailed records of the graphical interface Oracle database 12C
The following is the data Guard CPU/PSU patch installation method for a detailed analysis of the introduction, the need for friends can refer to the next
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data
[Oracle] Data Pump detailed tutorial (3)-impdp [Oracle] Data Pump detailed tutorial (2)-expdp http://www.bkjia.com/database/201307/230731.html The import mode is the same as the export mode. The following five modes are also mutua
Non-Data guard patch installation tutorials refer to the [Oracle] cpu/psu patch installation tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:
Stop log transport service at primary;
Close the standby database, stand
market and enterprise development needs.Oracle Data integration solution
Oracle Data integration solutions are used to build, deploy, and manage real-time data-centric architectures in SOA, BI, and data warehouse environments, it includes all the elements of
Oracle Cluster Concepts and principles (ii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev
. Oracle provides a completely unified enterprise-level real-time data solution, Oracle Data Integration, to meet the market and enterprise development needs.
Oracle Data integration solution
Label:For the needs of market and enterprise Development, Oracle provides a relatively unified solution for enterprise-class real-time data solutions, Oracle data integration. The following article is mainly about the specific description of its solution, I hope you will have something to gain.Oracle
How RAC Works and related components (iii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This document is
Oracle tutorial pl/SQL introduction, oracle tutorial plsql
This example describes Oracle pl/SQL. We will share this with you for your reference. The details are as follows:
I. What is pl/SQL?
Pl/SQL (procedural language/SQL) is an extension of
Cache fusion Technology and main background process (iv)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. Th
Tags: NFS Install listen recommended move configuration between trading Geo Mic
Directory
Cache Fusion principle
What is Cache Fusion?
What is high availability
The difference between FAILSAFE and RAC
RAC and OPS differences
Differences between hot standby, RAC, and Data guard for dual machines
Communication between nodes (interconnect)
Lock
Consistency management
OCR structure
Oracle Database Programming, oracle Database tutorial
1. How to learn about Oracle
1. Database Administrator
Manage Oracle (Start and Stop, database fault recovery)Improves Oracle performance (allocates memory) and optimizes the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.