Oracle Tablespace Group

Summary: in this tutorial, you will learn about Oracle temporary tablespace group and how to use the tablespace group effectively to optimize internal Oracle operations. Introduction to Oracle tablespace groups A tablespace group typically consists of multiple temporary tablespaces. A tablespace group allows a user to consume temporary space from multiple temporary tablespaces, instead of a single temporary … Read more Oracle Tablespace Group

Oracle Temporary Tablespace

Summary: in this tutorial, you will learn about the Oracle temporary tablespaces and how to manipulate the temporary tablespaces effectively. Introduction to Oracle temporary tablespaces A temporary tablespace, as its name implied, stores the temporary data that only exists during the database session. Oracle uses temporary tablespaces to improve the concurrency of multiple sort operations which do … Read more Oracle Temporary Tablespace

Oracle DROP TABLESPACE

Summary: in this tutorial, you will learn how to remove a tablespace from the database by using the Oracle DROP TABLESPACE statement. Introduction to Oracle DROP TABLESPACE statement The DROP TABLESPACE allows you to remove a tablespace from the database. Here is the basic syntax of the DROP TABLESPACE statement: In this syntax: First, specify the name of the tablespace that you want to drop … Read more Oracle DROP TABLESPACE

Oracle CREATE TABLESPACE

Summary: in this tutorial, you will learn how to use the Oracle CREATE TABLESPACE statement to create a new tablespace in a database. Introduction to the CREATE TABLESPACE statement The CREATE TABLESPACE statement allows you to create a new tablespace. The following illustrates how to create a new tablespace named tbs1 with size 1MB: In this statement: First, specify the name of the … Read more Oracle CREATE TABLESPACE

Oracle Tablespace

Summary: in this tutorial, you will learn about the Oracle tablespace and how Oracle uses tablespaces to logically store the data in the database. What is an Oracle Tablespace Oracle divides a database into one or more logical storage units called tablespaces. In other words, Oracle logically stores data in the tablespaces and physically stores data in datafiles associated … Read more Oracle Tablespace