TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 13

Oracle Database Administration for Microsoft SQL Server DBAs part 13 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 102 Oracle Database Administration for Microsoft SQL Server DBAs A new role with the select permissions could be created for each of the represented DBA roles which would limit full access to the database based on responsibility. Even if there is only one DBA creating a different user with some of the basic permissions for a DBA would be better than always logging in as SYSDBA. Summary In this chapter we first looked at some database terminology used by the different platforms. You saw that the SQL Server database is more similar to the Oracle schema than to the Oracle database. Since there is one Oracle database server for an Oracle instance creating an Oracle database requires a good bit of configuration and planning. Several assistants are available to create a database upgrade a database create a listener create scripts and templates for the database and set up the OEM. The assistants provide an interface to be able to walk through the different steps and allow for configuration and customizations along the way. Database scripts and templates can be used to re-create the same database or to clone the database in another environment. The scripts can also be modified to create a new database with similar characteristics. The DBCA is a good tool for creating a database for a new Oracle version and taking the defaults to see what some of the new default parameters and configurations might be. This could help in planning upgrades and acceptance of new features. Security is another important topic when it comes to databases and setting up permissions for least privilege is a database standard. Users are added only to the Oracle database server and then granted permissions to create objects in their schemas or have access to other schema objects. There are some system roles for just the DBAs to use with caution. Access to the database can be handled in several different ways. Also determining who has permissions to create objects and manipulate data can be based on .

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên