Re: import/export: use of sqlldr??.exe

If I'm interpereting your question correctly, you want to export certain rows out of your tables depending on what is in a particular date column within the table. If this is the case, you won't be able to use exp to accomplish this until you upgrade the database to version 8.1.x. In the mean time, you can download a script called unload.sql off of www.evergreen-database.com which will create a sqlload.dat file that you can use sqlldr to import. The downside of using the script vs exp is that it does not support LONG,LONGRAW or BLOB fields. Also, its speed will vary depending on the number of long VARCHAR or CHAR columns in the table.

Hope this helps

-- 
Posted from [63.83.225.245] 
via Mailgate.ORG Server - http://www.Mailgate.ORG