It's TOAD by Quest
www.toadsoft.com
"Anurag Varma" <avdbi_at_hotmail.com> schrieb im Newsbeitrag
news:uurvookhneai59_at_corp.supernews.com...
> A less than perfect way to compare indexes and constraints would be to
compare the user_indexes and user constraints tables of the
> two schemas.
> A better way would be to get hold of a schema compare utility (There one
by Quest that I know of ... schema manager) .... to see if
> the
> two schemas are same structurally.
>
> Anurag
>
> "Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message
news:L2lH9.2969$FZ5.21650638_at_news-text.cableinet.net...
> > Hi Norman,
> >
> > Yeah thats what i did..
> >
> > imp user/pass tables=theonesthatweremissing file=x
> >
> > this went fine - is there any way to check that the tables that were
> > imported before the imp timed out have all their correct constraints and
> > indexes?
> >
> > thanks
> >
> > Tom
> >
> > "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> > news:E2F6A70FE45242488C865C3BC1245DA70300C34B_at_lnewton.leeds.lfs.co.uk...
> > > Hi Tom,
> > >
> > > when this happens to me, I simply set up a TABLES=xxx,yyy,zzz import
and
> > > that puts the indexes and constraints back on for me too. You have
> > > nothing more to do - unless you got an error message telling you that
> > > creating and index or a constraint failed.
> > >
> > > Cheers,
> > > Norman.
> > >
> > > -------------------------------------
> > > Norman Dunbar
> > > Database/Unix administrator
> > > Lynx Financial Systems Ltd.
> > > mailto:Norman.Dunbar_at_LFS.co.uk
> > > Tel: 0113 289 6265
> > > Fax: 0113 289 3146
> > > URL: http://www.Lynx-FS.com
> > > -------------------------------------
> > >
> > >
> > > -----Original Message-----
> > > From: Tom [mailto:tomNOSPAM_at_teameazyriders.com]
> > > Posted At: Wednesday, December 04, 2002 9:36 AM
> > > Posted To: server
> > > Conversation: import constraints and indexes only
> > > Subject: import constraints and indexes only
> > >
> > >
> > > Hi,
> > >
> > > 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 ?
> > >
> > > thanks
> > >
> > > Tom
> > >
> > >
> >
> >
>
>
Received on Wed Dec 04 2002 - 07:31:29 CST
