Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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