Managing Temporary Tablespace
First we will discus about use of temporary tablespace. We use it to manage space for database sort operation. For example: if we join two…
Category: Managing Database
Managing Redo Log Files
Redo logs consists of two or more pre allocated files that store all changes made to the database. Every instance of an Oracle database has…
Managing Control Files
A control file is a small binary file that records the physical structure of the database with database name, Names and locations of associated datafiles,…
How to drop a datafile from a tablespace
Important : Oracle does not provide an interface for dropping datafiles in the same way you would drop a schema object such as a table…
Managing Data Files
What is data File? Data files are physical files of the OS that store the data of all logical structures in the database. Data file…