Re: Compact a Tablespace?

From: Bob <meyer_b_at_my-deja.com>
Date: Tue, 07 Sep 1999 19:57:40 GMT
Message-ID: <7r3qnd$202$1@nnrp1.deja.com>

Lewis:

I saw your post in deja-news, and have a question, if you don't mind:

By import and export, do you mean to export the objects, then delete and reallocate the tablespace, and the import the objects? Or is there a simpler way than that?

Thanks much,

Bob

In article <7prfpp$thr$1_at_duke.telepac.pt>, "Luis Campos" <lcampos_at_cpcis.pt> wrote:
> Import and Export the objects from that tablespace back again is your
only
> chance. If you have foreign keys ponting towards other tablespaces...
then
> you're skrewed.
>
> Adrian Harrison wrote in message

<37c11549.81624820_at_news.globalnet.co.uk>...
> >Using Oracle 7.3.4
> >
> >I have a tablespace (size = 30 meg), that I've just deleted probably
90% of
> the contents.
> >
> >Using the Navigator Tool that comes with Personnel Oracle the "Used
Space"
> & "Free Space" hasn't
> >changed at all for this tablespace.
> >
> >All the deletions were definetely committed so what I'm wondering is
if I'm
> supposed to do some sort
> >of "compact" to free this space up!
> >
> >Any ideas?
> >
> >Thanks
> >
> >Adrian Harrison
>
>

--
Bob M.

Step outside. The graphics are AMAZING!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 14:57:40 CDT