dbapath947

10 Oracle DBA interview questions you should know

What are the components of the physical database structure of Oracle database? Three fundamental types of physical files make up an Oracle database: Control files. Datafiles. Redo log files. What are the components of the logical database structure of Oracle database? The logical structure of Oracle database consists of tablespaces and schema objects. What is …

10 Oracle DBA interview questions you should know Read More »

ORA-23515: materialized views and/or their indices exist in the tablespace

When I was trying to drop a tablespace, I got then below error. ORA-23515: materialized views and/or their indices exist in the tablespace The Oracle documentation has given a clear information about the resolution steps we need to perform. According to Oracle ORA-23515 means. Description ORA-23515: materialized views and/or their indices exist in the tablespace …

ORA-23515: materialized views and/or their indices exist in the tablespace Read More »

Oracle audit table example

In this post, we are going to perform an activity on audit table. We are going to explore various auditing types in Oracle 11g. According to Oracle, Auditing is the monitoring and recording of selected user database actions. In standard auditing, you use initialization parameters and the AUDITNOAUDIT SQL statements to audit SQL statements, privileges, and schema objects, …

Oracle audit table example Read More »

Startup shutdown modes oracle database

In this post, we will discuss Startup and shutdown modes of Oracle database. The startup modes include startup open, startup mount, startup nomount and shutdown modes include shutdown abort, shutdown transactional, shutdown normal, shutdown immediate. Startup and shutdown modes oracle database Startup modes nomount state: This stage is only used when first creating a database …

Startup shutdown modes oracle database Read More »

Structure of a Database

In this Structure of a Database post, we will learn about the physical database design. An Oracle database is a set of files that store Oracle data in persistent disk storage. This section discusses the database files generated when you issue a CREATE DATABASE statement: Oracle database is nothing but the physical files, the following are …

Structure of a Database Read More »

How to create temporary tablespace 11g

In this post, we will discuss the step by step guide to create a temporary tablespace and drop existing temporary tablespace. Steps to create a new temporary tablespace. Check the existing temporary tablespace. Create a new temporary tablespace. Make the newly created temporary tablespace as default. Kill the existing sessions which are using existing temporary …

How to create temporary tablespace 11g Read More »