TAILIEUCHUNG - Oracle Built−in Packages- P138

Oracle Built−in Packages- P138: 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 Restrictions Note the following restrictions on calling GENERATE_REPLICATION_TRIGGER You must call this procedure from the master definition site. The replication group must be quiesced. The GENERATE_REPLICATION_SUPPORT or GENERATE_PACKAGE_SUPPORT must previously have been called for the object specified in the oname parameter. Examples The simplest invocation of the GENERATE_REPLICATION_TRIGGER procedure does the most work this call generates replication triggers for all replicated tables at all master sites BEGIN gname SPROCKET END This next example generates replication triggers for the replicated table at all master sites BEGIN gname SPROCKET oname PRODUCTS END The following call generates replication triggers for all replicated tables in the SPROCKET replication group at the master sites and BEGIN gname SPROCKET master_list END The following call regenerates the replication support for all objects in replication group SPROCKET at all master sites EXECUTE gname SPROCKET For an additional example see the file on the companion disk. The example lists all objects in the database with a status of INVALID and generates the appropriate SQL statements to attempt to validate them. Adding and Removing Master Sites with DBMS_REPCAT Now you have generated replication support for those objects you intend to replicate and you are ready to add master sites to your environment. In advanced replication parlance a master site is a database instance where replicated objects and their replication support triggers and packages exist. Master sites are sometimes called peers because every master site has the same objects and identical or nearly .

• 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