What is the difference between Tablespaces and Data Files?
I need to know about the difference between tablespaces and data files.
Posted Answers
The Oracle database stores data logically in tablespaces and physically in data files.
•Tablespaces:
– Can belong to only one database
– Consist of one or more data files
– Are further divided into logical units of storage
• Data files:
– Can belong to only one tablespace and one database
– Are a repository for schema object data
Answer by: Anonymous