Recent content by htran

I believe that I found the solution for this. Under Exchange 2007, go to "Global Settings" --> "Hub Transport" --> "Remote Domains" --> "Defaults * " and then right click on "Properties". Select the following option: "Allow external out-of-office messages, and out-of-office messages set by...

We have Exchange 2007 and MS Office 2007 here. One day while setting up the "Out Of Office Assistant", I noticed that it did not work properly. With Outlook 2007, this feature (Out of Office Assistant) is greatly enhanced, however, it did not work as it should. There are 2 parts of this new...

Hi all, So the correct code should be: SELECT field_name FROM my_table WHERE add_date BETWEEN TRUNC(sysdate - 2) + (18/24) AND TRUNC(sysdate) + (18/24) - (1/86400); Meaning replacing the 19/24 with 18/24. Please reconfirm.

Hi Carp, I will try your code tonight and then compare the output tomorrow. Thanks...

Hi Mufasa, I manually compared the time of the data (orders) coming to us and can confirm that the query does not pick up every thing. Hi Bill, I need to go back 48 hours so the codes should look like this: SELECT FIELD1 FROM TABLE1 WHERE ADD_DATE between trunc(SYSDATE-2) + 19/24 and...

I am running a query to capture data in the last 48 hours and wonder if someone can shed some lights for me on this: This is part of the query.... SELECT FIELD1 FROM TABLE1 WHERE ADD_DATE > SYSDATE-2 The query runs every day at 7:00 PM. For example, when it runs at 7:00 PM today, I want to...

I found the solution for this anyway. I had to load the Microsoft Access Utility Add-in. The "Sendkeys" command then works like a charm....

I create a query and would like to export it to Excel format. I would like to automate this process so it will run by itself. I created a Macros so this can be done automatically. While creating the query, the process needs to access two separate databases to gather the data. One is Oracle...

I forgot to mention that those two tables are the second instance in my database. Therefore, it is not possible to do the ALTER TABLE TABLE_NAME STORAGE (MAXEXTENTS UNLIMITED); Also, I do not want to change the maxextents to unlimited due to the performance issue of my database. I thought...

Hi all, I have two tables which were initially created to hold temp data. When those two tables were created, we did not define any of the max extents size. Today, the business requirements have changed and we are adding more data into those two tables more than ever before. As a result, I...

Does anyone know how to backup the configuration file for this switch using an Internet Browser (Internet Explorer or FireFox)? A step by step instruction is appreciated.... I need to back it up before making a change to it so I can reverse the change if I need to. Thanks...

Thanks for the quick reply... It was my mistake... it is Friday afternoon and I am looking toward the weekend already.... Yes, the spool command must be placed before the select statement!!!!! Once again... Thanks.....

Hi all, I am running a query which will pull approx 35,000 rows of record. The script is very simple as shown below: ****************************** set echo off set feedback off set pages 0 set heading off set flush off set trimspool on SELECT SKU, MANUFACTURERSKU,RETAILSKU,ALTSKU FROM SKU...

1) Yes, Oracle is running on Windows. 2) Yes, Oracle is running as a system user. 3) Yes, shared folder is on Windows. However, I know that it is not a permission issue on the folder as I managed to copy the files to and from that folder using DOS command. I will write another script to move...

Hi all, I am executing an SQLLDR command to load data into a table on my Oracle 8i database. The control files are located on the Oracle server, however, the dat files are located on another NT server. I am getting the following error message every time: SQL*Loader-500: Unable to open file...