From the course: Oracle Database 12c: Administration
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Storage: Tablespaces and datafiles - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Storage: Tablespaces and datafiles
- [Instructor] The physical manifestation of the Oracle database storage system for user data is data files. All database data is stored inside data files. However, when a user creates a table, the users specify which table space that table should be created in. A table space is a collection of data files used for storage. Let's see the names of existing table spaces we already have defined in our database. In order to do that let's open a sqlplus prompt from the sysdba user, and log on to our database. We can use the dba_tablespaces data dictionary view to view information about existing table spaces. Let's start off by describing the structure of the dba_tablespaces view. Remember, no need for a semicolon at the end of this command, because the describe command is not a sql statement, it's an internal command for sqlplus. Once we know the structure of the dba_tablespaces data dictionary view, we can view the names of existing table spaces by writing select tablespace_name from…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.