Re: export all tables except one

On Tue, 02 Aug 2005 23:48:28 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>On Tue, 02 Aug 2005 16:30:55 GMT, netcomradeNSPAM_at_bookexchange.net
>(NetComrade) wrote:
>
>>If you'd like to exclude a certain table from import, just create a
>>dummy table with the same name but different columns
>>
>>e.g. create table my_table_to_exclue as select * from dual;
>>
>>and use IGNORE=y
>
>IMO this does result in an error message for every individual INSERT.
>You are not saying you are actually using this hack, don't you?

Um, don't recall.. . You're correct about inserts.. (just tested).. bad advice.. thanks for pointing this out. .......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Aug 03 2005 - 15:31:39 CDT