This video presents how you can view existing tablespaces, view their datafiles, as well as create and delete a tablespace.
- [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 dba_tablespaces,…and we can see we have six table spaces…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.