Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!border1.nntp.ash.giganews.com!nntp.giganews.com!newshosting.com!nx02.iad01.newshosting.com!63.218.45.203.MISMATCH!newsfeeds.sol.net!216.9.137.72.MISMATCH!news.kiva.net!news.indiana.edu!news.er.usgs.gov!news From: Brian Peasland Subject: Re: import without views X-Nntp-Posting-Host: edc-cv-60-102.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <4050EABE.64AD4E33@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: Mime-Version: 1.0 Date: Thu, 11 Mar 2004 22:39:58 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 26 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256866 Tudor wrote: > > Hello > > I'am trying to import an export file from a oracle 8i database to > another 8i database from a user xxx to user xxx. I want to import > everything _without_ views. The syntax i use is imp > system/manager@mydb file=export.dmp fromuser=xxx touser=xxx but this > syntax tries to import everything from xxx to xxx including the views > which i do not want. > > Can anyone help me please. > > Thanks. > > /tudor There is no option to import everything but views. Your options to import are FULL (import everything in the dump file), FROMUSER (import everything a user owns in the dump file, and TABLES (import selected tablespace from the dump file). Can't you import everything with FROMUSER and then go in later and drop the views? HTH, Brian