Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!e18g2000yqo.googlegroups.com!not-for-mail From: Maxim Newsgroups: comp.databases.oracle.server Subject: Re: oracle 9 export all without 1 table Date: Sun, 1 Mar 2009 04:35:57 -0800 (PST) Organization: http://groups.google.com Lines: 29 Message-ID: References: NNTP-Posting-Host: 62.245.156.52 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1235910957 22111 127.0.0.1 (1 Mar 2009 12:35:57 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 1 Mar 2009 12:35:57 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: e18g2000yqo.googlegroups.com; posting-host=62.245.156.52; posting-account=zsDGbQkAAAD1xYoviOUF76_8H4WpjP52 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.18) Gecko/20081029 Firefox/2.0.0.18,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 webproxy.loyaltypartner.com:8080 (squid/2.7.STABLE5-20081104) Xref: news.cambrium.nl On 1 Mrz., 13:10, pitufo wrote: > On Feb 28, 5:54 pm, Michael Austin wrote: > > > hehehe wrote: > > > Hello! > > > > I have user name : joe > > > He have 4000 tables. Id like to know if it is possible to export all tables > > > without only one table. Or export all and import all without only one or > > > delete from export dmp file certin table? > > > > Need help > > > > regard : MJ > > > Or - create the new database and user, create a db link on the new > > pointing to the old server/user and create table as select * from dblink... > > Or, open database restricted, move unwanted table to another scheme. > Export, move back unwanted table to joe's scheme again. You got your > export file. Isn't it much simplier then - drop table, export the rest,flashback to before drop? ;-) Best regards Maxim