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...
Alan Kirchner
akirchner@...
Nov 5, 2004 10:04 am
615
Akirchner, Hi. You are welcome. Yes, adding the new oracle will require adding it to TNS names. As a security feature new databases are not automatically...
Allen Shepard
ashepard@...
Nov 5, 2004 7:18 pm
616
Subodh, Hi. You are welcome and thank you for the information from a real life experience, Memory - I would have missed that one. Metalink has some articles on...
Allen Shepard
ashepard@...
Nov 5, 2004 7:18 pm
617
Alan: I think it is not the password problem. You are not getting connected to your instance because of some problem in TNSNAMES.ORA file. You have to edit...
Mano Devamanoharan
devamanp@...
Nov 5, 2004 7:18 pm
618
Hey Allen, Are you specifying a host name at login? If there is only one db on the system, you should be able to login without it. A TNSNAMES error usually...
Robertson Ludwig H CO...
robertsonlh@...
Nov 5, 2004 7:18 pm
619
Does anyone have a good tuning script for Oracle 9i databases that they would share with me? Thanks, Bill Buker, M.D.B.A. Total Resource Management 1435...
Hey Bill, Tuning is such a broad area, that it's difficult to "can" scripts for it. I used to use a bunch of scripts to watch tablespace growth, shared pool...
Robertson Ludwig H CO...
robertsonlh@...
Nov 11, 2004 4:53 pm
621
Hey, I need some advice on how to encrypt the database password and possibly the username within an shell script. Right now, I have it hardcoded and need to...
Phillip Small
psmall57@...
Nov 12, 2004 6:54 pm
622
Look into using an account that is externally identified. This is a lot easier than trying to encrypt or hide the password. ...
Brett Ogletree
bretto97@...
Nov 12, 2004 10:31 pm
623
Phillip, if you are using unix there are a couple of ways to do this. For instance in a csh/tcsh script that reads the information from a file and passes it...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
