Managing Oracle Tablespaces and Data Files

Q

Where to find answers to frequently asked questions on Managing Oracle Tablespaces and Data Files?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Tablespaces and Data Files. Clear answers are provided with tutorial exercises on creating and dropping tablespaces; listing available tablespaces; creating and dropping data files; setting tablespaces and data files offline; removing corrupted data files.

Oracle Tablespace - Unit of Logical Storage in Oracle

Oracle Data File - Unit of Physical Storage in Oracle

Relations between a Tablespace and Data Files in Oracle

Relation between Database and Tablespaces in Oracle

Show All Tablespaces in the Current Database in Oracle

Built-in Tablespaces in a Database in Oracle

Show All Data Files in the Current Database in Oracle

Create a New Data File in Oracle

Create a New Tablespace in Oracle

Rename a Tablespace in Oracle

Drop a Tablespace in Oracle

Keep Data Files When Tablespace Dropped in Oracle

Create a Table in a Given Tablespace in Oracle

Show Free Space in a Tablespace in Oracle

Bring a Tablespace Offline in Oracle

Bring a Tablespace Online in Oracle

Add Another Datafile to a Tablespace in Oracle

Error: Cannot Identify/Lock Data File in Oracle

Remove Data Files before Opening a Database in Oracle

Sample scripts used in this FAQ assumes that you are connected to the server with the SYSTEM user account on the default database instance XE. See other FAQ collections on how to connect to the server.

⇒ Oracle Tablespace - Unit of Logical Storage in Oracle

⇐ Create a Single Index for Multiple Columns in Oracle

⇑⇑ Oracle Database Tutorials

2019-04-17, 1572👍, 0💬