import question

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 9 Jan 2002 15:42:49 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA77D7CBA@lnewton.leeds.lfs.co.uk>

Ed,

not that I know of, except build a parameter file of a list of all tables except the one you don't want, as in :

tables=(

table_a, 
table_b, 
table_x,

...)

Then supply that filename as the parfile parameter on the imp command line.

Works for me.

Regards,
Norman.

---

---

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

---

-----Original Message-----

From: ed zappulla [mailto:zappullae_at_rcn.com] Posted At: Wednesday, January 09, 2002 3:17 PM Posted To: server
Conversation: import question
Subject: import question

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 Received on Wed Jan 09 2002 - 09:42:49 CST