Database Administration (MOSC)

MOSC Banner

Reclaiming OS disk space after truncating partitions. Has a step-by-step process been created?

in Database Administration (MOSC) 3 commentsAnswered

Oracle Database v19c on Linux RHEL 8 system.

We have a few 2-3 TB tables in our database. We have only 10% DATA ASM space available. We have been told no new space can be purchased and we must find a way to reduce the amount of space used by this database.

The 2-3TB tables are partitioned. Partitions and tablespaces were designed in a very odd way by previous DBAs. They created tablespaces that would only store data for a specific year and quarter. For example: 2010_q1 stores JAN, FEB, MAR data from 2010 and 2011_q2 stores data for 2011 APR, MAY, JUN. I personally would never do this but they did. We have identified these few very large tables with old data the customer wants deleted. Customer needs at least 1 TB of OS disk space free.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center