Oracle - What Is an Oracle Tablespace in Oracle

What Is an Oracle Tablespace in Oracle

Q

What Is an Oracle Tablespace in Oracle?

✍: FYIcenter.com

A

An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.

Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.

⇒Oracle Database Basic Concepts

⇒⇒Oracle Database Tutorials

2018-10-15, 493👍, 1💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3335👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 582👍, 1💬

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLESPACE clause in the CREATE TABLE statement. Here is a... 2019-01-08, 573👍, 1💬

💬 2019-01-08 Bvm: Help :)

Keep Data Files When Tablespace Dropped in Oracle
What Happens to Data Files If a Tablespace Is Dropped in Oracle? If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you delete the data files using OS commands, if they are no... 2019-01-01, 403👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.