Category: Making Read-Only Tables

Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions NVARCHAR2 and NCHAR Oracle Certification
18 Jul by Leondre Morris

Making Read-Only Tables- Tables and Constraints

You can place individual tables in read-only mode. Doing so prevents any INSERT, UPDATE, or DELETE statements from running against a table. An alternate way to do this is to make the tablespace read-only and use this tablespace for the tables that are static for read-only.There are several reasons why you may require the read-only […]
Making Read-Only Tables NVARCHAR2 and NCHAR Oracle Certification
18 Nov by Leondre Morris

Understanding Table Types- Tables and Constraints

The Oracle database supports a vast and robust variety of table types. These various types are described in Table 7-1. Table 7-1. Oracle Table Type Descriptions This chapter focuses on the table types that are most often used: heap organized, index organized, and temporary tables. Partitioned tables are used extensively in data warehouse environments and […]
Dropping Users Making Read-Only Tables Managing Default Users Oracle Certification
18 May by Leondre Morris

Assigning Default Permanent and Temporary Tablespaces- Users and Basic Security

Ensuring that users have a correct default permanent tablespace and temporary tablespace helps prevent issues of inadvertently filling up the SYSTEM or SYSAUX tablespaces, which could cause the database to become unavailable as well as create performance problems. The USERS tablespace is normally the default tablespace. When maintaining a database, you should verify the default […]
Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions Oracle Certification
18 Apr by Leondre Morris

Understanding Schemas vs. Users- Users and Basic Security

A schema is a collection of database objects (such as tables and indexes). A user is an account to connect to the database with the username and password. Users can also own objects, which then the owner is the schema of the objects. Already discussed was how there are default schemas created to own database […]
Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions NVARCHAR2 and NCHAR Oracle Certification
18 Mar by Leondre Morris

Configuring a Centrally Managed User- Users and Basic Security

A centrally managed user is considered to be a user in one place, such as Active Directory or another LDAP service. The user can be managed for authentication and authorizations centrally, such that a user in Active Directory will have authentication managed via password or another type of key and, with the use of security […]
Dropping Users Making Read-Only Tables Oracle Certification
18 Sep by Leondre Morris

Enabling Archivelog Mode- Managing Control Files, Online Redo Logs,and Archivelogs

After you have set the location for your archive redo log files, you can enable it as SYS with the following: You can confirm archivelog mode with this query: You can also confirm it as follows:  Disabling Archivelog Mode Usually, you don’t disable archivelog mode for a production database. However, there might be a reason […]