Re: oracle 9 export all without 1 table

From: SEJ <>
Date: Sat, 28 Feb 2009 17:34:51 +0100
Message-ID: <49a9a102$0$90265$>

"hehehe" <m_at_m.ccc> skrev i en meddelelse news:goatio$207q$
> 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


you can put tables=(table1, table3999)
something like this..

spool exp_without_one.par

select 'userid=joe/joespass" from dual;
select 'file=exp_without_one.dmp' from dual;
select 'log=exp_without_one.log' from dual;
select 'tables=(' from dual;

select table_name||',' from all_tables where owner='JOE' and table_name !='JOES_ARCHIVE_TABLE';
select ')' from dual;
select 'and so on' from dual;

perhaps you should create the archive in antohter sceme in the future ?


SEJ remove komma after last tablename Received on Sat Feb 28 2009 - 10:34:51 CST

Original text of this message