Chapter 7
Loading Data into Your Database
In This Chapter
Making tablespaces
Understanding users and schemas
Understanding database object types
It’s no secret that databases hold data: typically, lots of it. However, data isn’t just loose in the database; data lives in structures, which are owned by users. Furthermore, this isn’t a random collection of data and objects; it supports a specific application.
In this chapter, we focus less on the actual data itself and more on the structures that hold the data and control access to that data. We explain tablespaces and their role in object storage. Objects must have an owner, and we explain how users have schemas that contain objects. Database objects that a user can own include — but are not limited to — tables, indexes, and views.
A database application includes the tables, indexes, PL/SQL code, and other objects executing the program logic inside the database. Depending on the application’s size and nature, building an application structure within a database can be complex.
Here is the general order of operations for building an ...
Get Oracle® 12c For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
