Re: oracle 9 export all without 1 table
From: SEJ <sejprv_at_hotmail.com>
Date: Sat, 28 Feb 2009 17:34:51 +0100
Message-ID: <49a9a102$0$90265$14726298_at_news.sunsite.dk>
select table_name||',' from all_tables where owner='JOE' and table_name !='JOES_ARCHIVE_TABLE';
select ')' from dual;
select 'and so on' from dual;
Date: Sat, 28 Feb 2009 17:34:51 +0100
Message-ID: <49a9a102$0$90265$14726298_at_news.sunsite.dk>
"hehehe" <m_at_m.ccc> skrev i en meddelelse
news:goatio$207q$1_at_news2.ipartners.pl...
> 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
>
hi
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 ?
regards
SEJ remove komma after last tablename Received on Sat Feb 28 2009 - 10:34:51 CST