Re: Export/Import Data Only

Don Mark wrote in message <35200BBE.1927_at_telis.org>...
>What is the SQL syntax to 1) export and 2) import just the **data** of a
>table?

1. Pre-create the (empty) table first: CREATE TABLE mytable......
2. import with ignore=y: IMP USER/PASSWORD TABLE=mytable IGNORE=Y

Chris Bigenwald Received on Tue Mar 31 1998 - 00:00:00 CST