Re: export all tables except one

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?

--
Sybrand Bakker, Senior Oracle DBA