I have a set of nightly, weekly, semi-annually scripts that I need to convert to Shell scripts, then automate them. Please help in anyway possible. First, I...
Phillip Small
psmall57@...
Sep 7, 2004 3:38 pm
586
Hi, Has anyone created a database for a Secure Messaging Center (SMC). I am looking for an Oracle data model for SMC. Thanks....
Eng, Robert
reng@...
Sep 7, 2004 3:51 pm
587
Psmall57, Hi. I can not answer system syntax questions but there are two things to be done. 1) Any text file can be a shell script - it does not have to have a...
Allen Shepard
ashepard@...
Sep 10, 2004 11:29 am
588
As Allen said, there is nothing special about a script file, you can call it anything you want. What you should do is work out all the commands you need to...
+ Interjection by listserv moderator: + Oracle Corporation has asked us to forward the following + Internet seminar to our membership. Looks like a good +...
Hi, I am using Oracle 9IDS (Form & Reports). I am not able to call reports from the forms. I am executing the application from the browser. Anybody has faced...
Aliment,Venkat
pnv@...
Sep 15, 2004 12:32 pm
591
need more details.... what technique are you using to call the forms? sample code? how/where are you running the form? oc4j locally or via 9iAS? what errors...
Mark C. Stock
mcstock@...
Sep 16, 2004 8:39 pm
592
Hi, Thanks for the response. Please find below the details: The forms are running locally (Not with 9iAS). Error message :- FRM- 41219 Can not find report...
Aliment,Venkat
pnv@...
Sep 17, 2004 1:20 pm
593
Venkat, If you look up the error in on-line help you'll find: FRM-41219: Cannot find report: invalid ID. Cause: The user has specified an invalid report object...
Mark C. Stock
mcstock@...
Sep 20, 2004 6:39 pm
594
Folks, Has anybody used the dbms_job feature to schedule an Oracle report to run in batch? I cannot use windows scheduler to do this because of security...
i believe you're referring to Steven Feuerstein's packages i have reviewed them, but am not currenltly using them. however i would strongly recommend anythin...
Mark C. Stock
mcstock@...
Oct 29, 2004 6:11 pm
597
Hi, We have upgraded our database to 10g from 8i. The front end is Form 6i / Reports 6i. Some of the forms & reports are giving "Internal Error" when compiling...
Aliment,VenkatNew
pnv@...
Oct 29, 2004 6:48 pm
598
I have two customers that are similar in size, both running 8.1.7 on Windows (the old running 2000 advanced, the new running 2003 advanced). I'm doing a count...
Using Oracle 8.1.7.4.9 on a Windows NT Server with Service pack 6. I am maintaining a standby database for a client and would like to automate the recovery of...
We had similar issues with some of our Oracle Applications tables after upgrading to 11.5.9 on 8.1.7. If you are not already, try running stats at 90%...
Gary Turnbull
turnbulg@...
Oct 29, 2004 10:31 pm
601
Greg, Hi. I am guessing you will get a lot of different answers because there are so many possible problems. You say the new database does table scans and...
Allen Shepard
ashepard@...
Oct 29, 2004 10:31 pm
602
Bill: Expect is your friend here: http://expect.nist.gov/#windows...
I'm working on a MS SQL to Oracle migration project for a Perl-based system. This system makes use of the INFORMATION_SCHEMA metadata implementation in MS...
check out jim melton's paper "Database Catalog Tutorial -Open Forum 2003 on Metadata Registries" at ...
Mark C. Stock
mcstock@...
Nov 1, 2004 7:23 pm
605
I did rebuild the indexes over the weekend and that did not help. I have reloaded a copy of the database that is about a month old on a server that I can test...
Hi, My production database 8.1.7.4 is on solaris 2.6 box. I have to upgrade my OS to 2.9. OS and Oracle (8.1.7.4 32 bit) have been already installed on target ...
Roshy, Hi. I think you have most of it but am not sure it will work. Oracle create other processes. I would recommend trying: 1. shutdown production database....
Allen Shepard
ashepard@...
Nov 3, 2004 1:34 am
608
No, this is not possible. Oracle binaries are different. Thanks HM ... From: "roshykum" <roshykum@...> Reply-To: VOUGlist@yahoogroups.com To:...
HIMANGSHU DEY
hdey@...
Nov 3, 2004 1:35 am
609
I am sure this will work. Although the Oracle binaries are compiled as 64 bit vs 32 bit and they are different, oracle database files (datafile, redologs and...
Kumar, Subodh
subodh.kumar@...
Nov 3, 2004 2:33 am
610
Can anyone tell me if it's worth using 64 bit oracle on solaris? We're presently using 32 bit on 64 bit machines. Will there be any benefits ? Thanks. ...
Steff Gonos
steff_gonos@...
Nov 4, 2004 3:53 pm
611
Having 64 bit Oracle run on 64 bit solaris is supposed to give you performance boost as your wordsize is 64bit. In short, it will take one pass to move 64 bit...
Kumar, Subodh
subodh.kumar@...
Nov 4, 2004 6:51 pm
612
Subodh, Yes 64 bit should be faster. When moving from 8 to 16 bit and then the last big change of moving from 16 bit to 32 bit there where some problems. Data...
Allen Shepard
ashepard@...
Nov 4, 2004 9:28 pm
613
When we moved from 32 to 64 bit, the only issue we faced was of memory. The memory requirement went up significantly. We have PA_RISC chips. No AMD experience...
Kumar, Subodh
subodh.kumar@...
Nov 5, 2004 10:00 am
614
Hi guys, I've been away from Oracle for awhile but have a job op. next week. I just installed 8i Lite on my laptop to brush up a little and am having trouble...