Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |