Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Locally managed tablespace / truncate BUG ?

Locally managed tablespace / truncate BUG ?

From: G Dahler <yellow-shark_at_spamex.com>
Date: Tue, 13 Apr 2004 14:14:09 -0400
Message-ID: <P5Wec.6384$2Z6.556128@news20.bellglobal.com>


I've imported a table into a locally managed tablespace with automatic allocation of extents. It created 22 extents of 1 mb each. The table was exported with compress=N from a dictionnary managed tablespace;

I have truncated the table with the "drop storage" clause.

According to the user_extents view, I still have 22 extents and the table still uses 22 mb of storage.

What's wrong ? Received on Tue Apr 13 2004 - 13:14:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US