Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import question
A trick I've used is to create a dummy table with the same name as the one you
want to avoid importing and then import with ignore=n. When imp tries to
import that table it will get "object already exists" and move past it. Once
the import is done drop the dummy table.
"ed zappulla" <zappullae_at_rcn.com> wrote in message
news:a1hmo8$r7i$1_at_bob.news.rcn.net...
> Is it possible to import all the tables from a user except 1? Oracle 8.1.6
>
> imp touser=aUser fromuser=bUser rows=y constraints=y grants=y indexes=y
> file=x.dmp
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Jan 09 2002 - 22:36:15 CST
![]() |
![]() |