TAILIEUCHUNG - Oracle Built−in Packages- P129

Oracle Built−in Packages- P129: 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. | Appendix A What s on the Companion Disk Exceptions The CREATE_SNAPSHOT_REPGROUP procedure raises the following exceptions Name Number Description commfailure -23317 Unable to communicate with master dbnotcompatible -23375 Attempt to use SYNCHRONOUS propagation in database duplicaterepgroup -23374 Replication group gname already exists nonmaster -23312 The master parameter is not a master site norepoption -23364 Replication option not installed typefailure -23319 propagation_mode not specified correctly Restrictions Note the following restrictions on calling CREATE_SNAPSHOT_REPGROUP You must be connected to the replication administrator account typically REPADMIN to call the CREATE_SNAPSHOT_REPGROUP procedure. The snapshot group name must match the name of the master replication group. The offline snapshot instantiation procedure The procedure for performing offline instantiation of snapshots in an advanced replication environment using the CREATE SNAPSHOT command and the DBMS_OFFLINE_SNAPSHOT and DBMS_REPCAT packages follows 1. Create a snapshot log for each master table if one does not already exist. 2. Create a snapshot of each master table in the master database and in the same schema as the master table. Of course the name of the snapshot will have to be different from the name of the master table. The CREATE SNAPSHOT statement must also include a loopback database link qualifier. CREATE SNAPSHOT snp_countries AS SELECT FROM countries@ 3. Perform user exports of all schema that own master tables. You should be logged on to the schema owner account for these exports. The only tables that you need to export are the snapshot base tables that is those whose names begin with SNAP _ . 4. Copy the export dump file s to the new snapshot site s . 5. Use CREATE_SNAPSHOT_REPGROUP at the snapshot sites to create a new snapshot replication object group. The name of this object group should be the same as the .

• 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