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 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 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...
Hi Santa,
It is true that if I get rid of the entire line "and orderdetail.adddate > trunc(sysdate)", the result will still be the same.
Can someone shed some lights on this for me.
Thanks...
Hi BJCooperIT,
The command ">trunc(sysdate)" did produce the result I was expecting.
I have a Scheduler runs the script every night at 19:10 which would go back to 19:10 the night before. What I need is the last order from the 24 hour time frame so we could determine how many orders are...
Hi Mufasa,
Thanks for the info. I figured it out last night. The correct code should be:
select max(orderdetail.orderkey) from orderdetail,orders
where orderdetail.orderkey=orders.orderkey
and orderdetail.status = '0'
and orders.type = '0'
and orderdetail.adddate > trunc(sysdate)
and...
Hi all,
I am creating a query which will run every day at a specific time. My database is Oracle 8i. I need to know the last unique key the system used the previous day. My script looks like this:
select max(orderdetail.orderkey) from orderdetail,orders
where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.