Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Create a New Data File

By: FYIcenter.com

(Continued from previous topic...)

How To Create a New Oracle Data File?

There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database.

(Continued on next topic...)

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 Tablespaces in the Current Database?
6. What Are the Predefined Tablespaces in a Database?
7. How To View 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 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?
18. What Happens If You Lost a Data File?
19. How Remove Data Files before Opening a Database?