Re: import constraints and indexes only

Dale_at_DataBee.com (Dale Edgar) wrote in message news:<3def02cc.2087711_at_news.btclick.com>...
> Hi Tom
>
> On Wed, 04 Dec 2002 09:35:47 GMT, "Tom" <tomNOSPAM_at_teameazyriders.com>
> wrote:
>
> >I had a large import that timed out and left a few tables out which i have
> >now added with a selective imp. How can i make sure all constraints and
> >indexes are present also? Can i do an im= user/pass rows=n indexes=y
> >constraints=y file=x ?
>
> Grab the freeware DBATool - among other uses it can generate the DDL
> re-creation scripts for the constraints and indexes in a schema (or
> schemas). Just generate the scripts - then run them.
>
> http://www.DataBee.com/dt_home.htm
>
> Regards
> Dale_at_DataBee.com

I have found myself in a similar situation a couple of times. Surely a preconfigured tool may be the way to go but if you do not have one This are the steps I have been following so far 1)After finishing the imports select table_name (dba_tables)and order them, 2)select index_name(dba_indexes and order them) for both instances
use the unix comm command (If you are on a unix system) This should list the differences if any

Michael Tubuo Ngong(OCP DBA) Received on Thu Dec 05 2002 - 08:50:35 CST