Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files

This is a collection of FAQ for Oracle DBA on creating and managing tablespaces and data files. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

1. What Is an Oracle Tablespace?
2. What Is an Oracle Data File?
3. How a Tablespace Is Related to Data Files?
4. How a Database Is Related to Tablespaces?
5. How To View the Tablespaces in the Current Database?
6. What Are the Predefined Tablespaces in a Database?
7. How To View the Data Files in the Current Database?
8. How To Create a new Oracle Data File?
9. How To Create a New Tablespace?
10. How To Rename a Tablespace?
11. How To Drop a Tablespace?
12. What Happens to the Data Files If a Tablespace Is Dropped?
13. How To Create a Table in a Specific Tablespace?
14. How To See Free Space of Each Tablespace?
15. How To Bring a Tablespace Offline?
16. How To Bring a Tablespace Online?
17. How To Add Another Datafile to a Tablespace?

----->Answers