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...
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...
In this post, we are going to discuss complete backup and recovery strategies in Oracle database 11g. There are different types we can take a database backup. The reasons why Oracle has introduced so...
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...
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...
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...
In Oracle 11g, each Oracle database has a list of valid database users. To access a database, a user must run a database application and connect to the database instance using a valid user...
What is a control file? An Oracle control file is a binary file necessary for the database to start and operate successfully. oracle scans the content of the control file in the mount state...
In this post, we will discuss one of the important physical files in Oracle database that is Online Redo Log File. The activity for the online redo log file can be found here Oracle...
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...