Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import constraints and indexes only
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 - 04:47:07 CST