Re: oracle 9 export all without 1 table

From: jgar the jorrible <joel-garry_at_home.com>
Date: Mon, 2 Mar 2009 11:28:49 -0800 (PST)
Message-ID: <34b1561b-1bd3-4aa0-a03c-ba148fdb9473_at_v1g2000prd.googlegroups.com>

On Feb 28, 12:45 am, "hehehe" <m..._at_m.ccc> 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

Just thinking out loud here, haven't tried it, may not have thought it through.

Perhaps you can put this table in its own tablespace, and take it offline.
Perhaps you can use the transportable tablespace option to move it away from the db, then reattach it after export. Perhaps you can use the transportable tablespace option on everything except for the archived table.

I would tend to put archived table in their own tablespace anyways, so that's why I think of these things. But I've wound up keeping everything live in this century, so I haven't dealt with this for a while. I keep thinking about it though, whenever I find something full scanning, including some silly cube-generation stuff.

jg

--
_at_home.com is bogus.
Bitchen' Camaro:  http://seattletimes.nwsource.com/html/localnews/2008790918_webbigbill27.html

Received on Mon Mar 02 2009 - 13:28:49 CST