Re: Database Extents - Export and Import

"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

You can use the FULL=Y export option (do the export as 'SYS'). Then you can clean up the database and create the tablespaces with the new storage parameters and then import the data.

Hope this helps,

Regards,

Rajesh Received on Sat Jan 19 2002 - 10:36:36 CET