Recent content by von2

Hello, I am trying to setup localstart.asp as default page that display the IIS page. However, it returns a page not found 400 error. Any idea why localstart.asp is not working?

Thanks. I changed the tcp/ip port to 81. http://localhost:81 gives a page error. It doesn't show anything. I've no clue if the port change is successful. I restarted the service. Still won't work. Any help?

Hello: We have a windows 200 server on which iplanet is running on port 80. i.e http://localhost:80 shows iplanet page. I am planning to install IIS on the same machine and I believe IIS defaults to port 80. Can someone tell how to change IIS to any other port number? Are there any steps? Also...

Hi, I set the linesize to 130, 200 and 500 and trimspool on ... They all gave the same messy output. Any other ideas

I am running a query that spools to a txt file in this manner. 100 320050406 20050325 119090 1 0 345 101 320057806 20050326 112020 1 0 440 whereas it should actually display like 100 320050406 20050325 119090 1 0 345 101 320057806 20050326 112020 1 0 440 I have hard time...

Santa, That's it. This answers all my questions. You are great.

Santa, One last question .. I ran these two queries and inspite of the and exists clause, the second query is updating addresses (with null values) for memberids that do not exist in Address table. I can tell this from "6 rows updated" etc .. message after the queries are run. UPDATE tableB b...

Santa, Appreciate your answer again. Excuse my ignorance, when you say the external table/directory method doesn't create internal table, do you mean it doesn't create an ORACLE internal table? If so, can you detail it little bit? I am using ADDRESS table in the query and it still exists in the...

Thanks for all the help. I just wanted to clarify from you that the directory method will also create an internal table right? You are right, the subquery that I ran resulted in multiple rows and so I got that error ... Also, I made a small change to the original query that you gave. I changed...

Santa, Thanks for the fast reply. It took over a minute (70 secs) to update the records. Could you also address the following? 1. What is the advantage of creating a directory and treating flatfile as table instead of creating a table using sql*loader? Can we drop the directory when we are...

Hello, I have two tables, tableA, tableB. tableA has userid, memberid columns with a total count of 300. tableB has userid, address columns. I have a flat file with memberid and address columns with around 6000 records. I need to update tableB's address column (all rows that currently have...