Found it.

Check out the /* APPEND */ hint at

http://www.dba-oracle.com/oracle_tips_data_load.htm

Apparantly makes it 100 times faster.

Keith

I have had a similar problem where a bulk load of data was taking three to four minutes in Oracle and the equivalent in SQL Server 7 was 10 seconds....

Does the error message show a job name or a long string of characters that is the ID of the job? If it is the latter then it may be...

Just found this on another item on this site:

blanksapwd=1

I think you use this instead of upgradepwd

I have not checked this out but do you need to put the blank password in single or double quotes?

UPGRADEPWD='' or UPGRADEPWD=""

It is possible it is not picking up...

On the point of trick questions, isn't it important that there are these types of trick questions to test you guys?

If you have ever spent two hours on a...

I don't have any script to this in VB but I have scripted this type of thing using a product called WS_FTP (http://www.ipswitch.com/products/file-transfer.html)

It is very simple to set up...

I tried to use Mozilla/5.0 to reply to a message and I got a single line text box to enter in the reply message, with none of the fancy formatting...

That works a treat , thanks for that.

Those Iif statements are a pain, and the best way I can think of doing this is to create a table called PersonCodeArea with two columns called SalesPersonCode and Region.

Fill...

As an additional check from the VB side, check the errors collection of the connection object. This will return far more information regarding the error than VB's error object.

Below is...

I'm with all of these guys. You can't create a primary key clustered index on the LAST_ORDER_DT as it won't be unique.

Unless you have had one order a day...

Good question! Shows how many people out there actually use 'contains' in their databases....

For clarification of why it returns what it does, I am assuming that the contains statement searches...