From the course: Learning Oracle Database 19c
Join today to access over 24,700 courses taught by industry experts.
Assign tablespaces to users - Oracle Database Tutorial
From the course: Learning Oracle Database 19c
Assign tablespaces to users
- When you create a table or other database object it needs to reside in a Tablespace. You can be explicit for every database object you create, but Oracle Database 19C supports the concept of a default Tablespace, both for an individual user and, at the database level. I'll show you how to find out what those are and how you can define those yourself. In addition, with most users sharing a small number of Tablespaces, you have to limit how much space each user can allocate in those Tablespaces. The database has a default permanent Tablespace. Since most database operations need temporary space either for temporary tables or for sorting that won't fit into memory, there's also a default temporary Tablespace. To see what those Tablespaces are, you can query the data dictionary view, database properties. In this database, the default Tablespaces haven't changed from when the database was created, users and temp. It's common to move a database application to its own Tablespace and assign…
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.