Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Locally managed tablespace / truncate BUG ?
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