TAILIEUCHUNG - Oracle Built−in Packages- P128

Oracle Built−in Packages- P128: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Oracle Built-in Packages SEARCH Chapter 14 Snapshots NEXT DBMS_OFFLINE_SNAPSHOT Performing Offline Snapshot Instantiation The DBMS_OFFLINE_SNAPSHOT package allows you to instantiate snapshots without having to run the CREATE SNAPSHOT command or the procedure over the network those methods are described under DBMS_REPCAT later in this chapter . Doing offline instantiation in this way is particularly useful in cases where you wish to instantiate a snapshot site with a large amount of data in an advanced replication environment. Offline instantiation refers to the population of snapshots with the import and export utilities as opposed to using the procedure. This technique is less time-consuming and less taxing on your network and it minimizes the time your environment must be quiesced. You will typically use DBMS_OFFLINE_SNAPSHOT s BEGIN_LOAD and END_LOAD procedures in conjunction with the DBMS_REPCAT package s CREATE_SNAPSHOT_REPGROUP procedure this procedure creates a new replicated snapshot group. The following sections summarize the syntax of the calls to BEGIN_LOAD and END_LOAD. See the later section Section DBMS_REPCAT Managing Snapshot Replication Groups for a discussion of the DBMS_REPCAT procedure and how these procedures work together to instantiate snapshots in an advanced replication environment. Getting Started with DBMS_OFFLINE_SNAPSHOT The DBMS_OFFLINE_SNAPSHOT package is created when the Oracle database is installed. The script found in the built-in packages source directory as described in Chapter 1 contains the source code for this package s specification. This script is called by which must be run to install the advanced replication packages. The wrapped sql creates the public synonym DBMS_OFFLINE_SNAPSHOT. No EXECUTE privileges are granted on DBMS_OFFLINE_SNAPSHOT only the owner SYS and those with the EXECUTE ANY PROCEDURE system .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản