The data of each object is physically contained in one or more of the tablespace's datafiles.
is a collection of logical structures of data, or schema objects.
A schema is owned by a database user and has the same name as that user. Schema objects can be created and manipulated with SQL and include the following types of objects: Schema objects are logical data storage structures.
Schema objects do not have a one-to-one correspondence to physical files on disk that store their information.
However, Oracle stores a schema object logically within a tablespace of the database.
You can control the allocation and use of space for a table's data segment in the following ways: Oracle stores data for a clustered table in the data segment created for the cluster instead of in a data segment in a tablespace.
Storage parameters cannot be specified when a clustered table is created or altered.The storage parameters set for the cluster always control the storage of all tables in the cluster.You can also specify table columns for which data is encrypted before being stored in the datafile.Encryption prevents users from circumventing database access control mechanisms by looking inside datafiles directly with operating system tools.After you create a table, insert rows of data using SQL statements.Table data can then be queried, deleted, or updated using SQL. When you create a table, Oracle automatically allocates a data segment in a tablespace to hold the table's future data.