Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import question

Re: import question

From: John Darrah <jdarrah_at_veripost.net>
Date: Thu, 10 Jan 2002 04:36:15 +0000 (UTC)
Message-ID: <4b2776582caeda49ff7f0377d62996ba.36240@mygate.mailgate.org>


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.ORG
Received on Wed Jan 09 2002 - 22:36:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US