Re: Database Extents - Export and Import

Hi David

On Sat, 19 Jan 2002 06:40:29 +0000 (UTC), "David Williams" <david484_at_hotmail.com> wrote:

>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?

You will need to recreate your table and index DDL before you re-import (use the ignore=Y option) otherwise the export will just try and recreate the DDL with the same storage and tablespace options.

Grab the Freeware DBATool - it was specifically designed to clean up/remove/replace the strorage and tablespace information of Oracle schema DDL. The DBATool just reads an export file (created with the ROWS=N option) and displays the DDL of the schema. You can then just apply rules to modify the storage information as you wish - save the DDL to disk - and run it.

The DBATool can be found at: http://www.databee.com/dt_home.htm

Regards
Dale Edgar
Net 2000 Ltd
Dale_at_DataBee.com Received on Sun Jan 20 2002 - 20:14:05 CET