Database Administration (MOSC)

MOSC Banner

SPACE IS NOT RELEASING FROM OS AFTER TABLESPACE IS DROPPED.

edited May 24, 2010 4:58AM in Database Administration (MOSC) 2 commentsAnswered

** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community members can add their perspective, experience or knowledge. This will further enhance all knowledge bases including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling richer solution searches.**


Hi,

ISSUE SUMMARY
============
Space is not releasing from os after tablespace is dropped.

==================================

Session1:
----------------

create tablespace test1 datafile '/oracle/data/L550/TEST1.DBF' size 10240M extent management local uniform size 512M;

create table t_drug_item_Prc_test tablespace test1 as select * from ol01.t_drug_item_prc where rownum <1000;

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center