Datafiles
Datafiles are the files stored on disk that hold the data in the database. They are the physical structures in which Oracle stores information. Datafiles are created and manipulated indirectly when the CREATE TABLESPACE command or the ALTER TABLESPACE command is issued. A datafile takes up exactly the amount of space specified in the creation statement, regardless of whether a single object is created in the associated tablespace. Any datafile can belong to exactly one tablespace.
Tablespaces
Databases are made up of tablespaces, purely logical constructs that allow you to group related logical structures together. Tablespaces, the primary logical structure of the database, are commonly used as a means to group together all objects ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.
