Re: Database Extents - Export and Import

David Williams wrote:
>
> "David Williams" <david484_at_hotmail.com> wrote in message
> news:c43100d67ba014d8128c7b3016ff0296.36554_at_mygate.mailgate.org...
>
> > I am trying to clean up an ongoing extent problem with Oracle. I would like to
> > export all of the tables, clean up the extent issues and then import the
> > tables. I have never gone through this process. Is there anybody out there that
> > can walk me through this process?
> >
> > Thank you,
> >
> > David Williams
>
> My 'Extent issues' are in the tens of thousands. Do you have any
> suggestions
> for
> a simple cleanup.
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

[Quoted] [Quoted] export, use imp indexfile= to get the DDL, edit to reasonable extents, re-create objects, import using ignore=y. Next time, make sure to use compress=n while exporting.

[Quoted] Simple, very effective - but time consuming!

-- 
Gtrz,

Frank van Bortel