Re: import, please help.

In article <953760998.8916.0.pluto.d4ee154e_at_news.demon.nl>, postbus_at_sybrandb.demon.nl says...
> apparently you have exported with compress=y.
> You should never do that. compress=y simply calculates all currently
> allocated space for an object and makes sure the the initial extent for the
> target object is as big as the allocated space. The newly calculated initial
> extent may not fit in your tablespace.
>
>

Interesting. I'm fairly new to Oracle and I was exporting with compress=y, dropping the tables and importing in an effort (successfully) to reduce the number of extents tables were using.... I guess I dodged a few bullets in that my tablespace was large enough to handle the new extent size.
Question: will a export (without compress)/drop table/import unfragment the tables?

Thanks,
Karen Received on Fri Mar 24 2000 - 00:00:00 CST