import constraints and indexes only

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 4 Dec 2002 10:12:43 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70300C34B@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 - 04:12:43 CST