Running Solaris8.
I have cron jobs set to run every hour from 6am till 7pm, as oracle user, which transfers archive log files to my standby system. This job ran ok till 7:00pm yesterday evening.
Since 6am this morning it fails.
Here is the line in the crontab:
00 6-19 * * *...
Thanks for the replies guys.
Just to update. Yes I can monitor connections from the listener log and am working on a way to get notified automatically if a connection is made to the database other than via the application. We have already stripped odbc from all workstations and I am having the...
Hi,
here is my dilemma. I have a database with hundreds of users. The database is oracle 8.1.7.2 on solaris 8. The database runs a financial application (banking). All the users connect to oracle through the application. All users have insert update and delete privileges on the main schema...
When you say that "the whole thing goes bonkers" what do you mean?
Do you get an error message? does the select statement return any data, and if so, what?
Also you say
"I thought I'd be able to get
select min(row_added), workorder_no, workorder_desc
from workorder_def
group by workorder_no...
Interesting.
As I said previously I have a workaround but discovered the following while testing it.
The app is designed to be user friendly. basically you open the database, are presented with a form, press a button and everything is done in the background and your reports are sent to the...
Thanks for the replies.
I have managed to come up with a work around for the problem. It's not perfect but at least management are getting their reports again.
Hi,
The mdb file imports data from an oracle database on our production server and generates a report for management.
I have run this against our test database with no problems, and also against our development database with no problems.
It only fails on production. The prod, test and dev...
Hi,
I'd be grateful if someone could help me out here.
I am getting an error message from Access which says
'MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program.
An error log is being created'
What error log? Where is it? I cant find anything...
Hold on
In your third post you said
The view should only show:
REF_NUM TRAN_DATE TRAN_NUMBER
10921671 13/01/2003 000377
0224529015 14/01/2003 000018
Yet your sample data shows
A new sample of data:
REF_NUM TRAN_DATE TRAN_NUMBER
10921671...
Yes sorry! should have seen from your sample data
Each transaction has a number. Although will only work if the max tran_number corresponds to the latest transaction.
Ok try jee's original script on the same sample data in your third post.
ie.
SELECT ref_num, tran_date, tran_number
from table1 t1, (
SELECT MAX (to_char (TRAN_DATE, 'dd Mon YYYY HH24:MI:SS')) max_date, ref_num
FROM table1
GROUP BY ref_num) t2
WHERE t1.tran_date =...
OK, When the tran_date is recorded is there a time element involved. Can you manipulate to read the max tran_date in the format DD-MON-YYYY HH:MI:SS
example
SELECT to_char(sysdate,'dd Mon YYYY HH24:MI:SS') from DUAL
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.