I agree with Phillip Small, SQL*LOADER is the way to go and do it all at once. Processing would have to be done after the files are loaded into the table. If...
bbuker@...
Feb 3, 2003 7:32 pm
366
Well one way is using Pro C/C++ and declaring a host variable record structure with each element being an array of say 2000. #define MAX_BATCH_SIZE 2000 static...
Bob Barrett
bbarrett@...
Feb 3, 2003 7:32 pm
367
it has been just a little while since i've done VB/Oracle interfaces, but if I recall properly, this is the way it should work for you (hopefully my VB...
Mark C. Stock
mcstock@...
Feb 4, 2003 6:39 pm
368
It is time to upgrade our client's 8.1.5 database running under Windows NT 4.0 Server Service Pack 6. Looks like we have three choices: 8.1.7.4 9.0.2 or 9.2...
John Flack
johnf@...
Feb 7, 2003 12:18 am
369
Does anyone know anything about 3G Technology? Will it work with Oracle 8i or 9i database? We have a customer experimenting with a 3G connection to our Oracle...
Greg Shockey
gshockey@...
Feb 7, 2003 12:19 am
370
have not had in problems on 9.2.0.2.1 on same platform as you, however there is a little bit of a learning curve as default tablespace are now locally managed...
ken kline
ken@...
Feb 7, 2003 3:40 pm
371
I haven't upgraded any of our databases to 9i - yet - so can't comment on that version. We have found 8.1.7.4 to be very stable on our AIX servers. Some...
Blizard, Robert
robert.blizard@...
Feb 7, 2003 3:41 pm
372
John, You may want to go to at least 9.0.2 , you will soon be in the same boat with 8.1.7.4 as you were with 8.1.5 . Look up the support matrix on Oracle's...
Terry Gould
tgould@...
Feb 7, 2003 4:54 pm
373
John, I did experience some problems with updatable views in 9.0.2 -- some views which 8.1.7 considered updatable were not considered updatable in 9.0.2, but ...
Mark C. Stock
mcstock@...
Feb 7, 2003 10:56 pm
374
+ Interjection by listserv moderator: + An excellent response to the post, with a good bit of + helpful info to those running Oracle on NT/2000... You should...
Michael Robison
mrrobison@...
Feb 7, 2003 11:53 pm
375
Thank you all for your responses - it's always great to hear from those who have already been through the mill that you are about to enter. I recommended that...
John Flack
johnf@...
Feb 11, 2003 7:51 pm
376
Hello.. I was wondering if anyone is running Oracle databases on a Hitachi 9500 series SAN box? We are looking to get rid of our Netapps Box which has HORRIBLE...
Noelle Stimely
nstimely@...
Feb 17, 2003 1:43 pm
377
Hi All Is there is any way to get a random number using select statement ? any hint can help . thanks...
ahmad abusaleh
ahmadabusaleh@...
Feb 17, 2003 1:43 pm
378
Noelle, One thing to consider when purchasing a Storage Area Network (SAN) is the personnel that will be managing the Storage. If you have people in-house...
G Dixon
gdixon@...
Feb 18, 2003 1:34 pm
379
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: Vaibhav Dani <vdani@...> Hi ! This function should...
Hi, I am also intersted in random number selection. I cannot find the DBMS_RANDOM package on my Oracle 8.1.7, however. How can I install this package? Thanks...
Yrd. Doc. Dr. Kemal T...
kturhan@...
Feb 19, 2003 3:03 pm
381
Hi, I am having a problem where web.show document will not bring up a browser when I make a call from a web enabled 6i form. When I click the button, nothing...
Hunter Stair
hunter.stair@...
Feb 19, 2003 4:48 pm
382
Does anyone know how to install gnumake for use with Oracle 11i? The readme and install files are generic and rather confusing. I am attempting to install the...
Simon Gorton
simongorton@...
Feb 19, 2003 6:55 pm
383
Hi Everybody, I have a situation where I need to process 10 M to 20 M rows in a Data Warehouse environment in a process cycle. There are two steps such as...
If you are using 9i, you can take advantage of new features designed to "optimize" the DB for use as a data warehouse. You may also want to consider the Oracle...
Bob Barrett
bbarrett@...
Feb 24, 2003 6:41 pm
385
I have just finished my rapidinstall on 11i (vis database on 11.5.7). Installed on Windows 2000 SP1. I finally got all the pre-install checks to pass (green)....
Simon Gorton
simongorton@...
Feb 24, 2003 7:21 pm
386
Hi, The DBMS_RANDOM package is available in oracle 8.1.7 too. i was able to execute these statements why not u. SELECT DBMS_RANDOM.VALUE(0,100) from dual ; ...
I am pulling my hair out with Portal Release 2, hope someone can help.... Things were going fine with my W2k install of Portal2, and then the next day day I...
Palmer
miles.palmer@...
Feb 27, 2003 8:08 pm
388
Hi, Has anyone had experience with migrating an Oracle 11i system from Oracle's Outsourcing group to another hosting center? They are only supplying an export...
Ellen Tice
ETice@...
Feb 27, 2003 8:09 pm
389
Hi, Maybe someone can help me out with this procedure below. I'm writing a program that involves OLS system tables. Let me tell you what I am doing. I'm...
Prescribed@...
Feb 27, 2003 8:10 pm
390
+ Interjection by listserv moderator: + Anyone who wishes to respond to this posting should contact + Sean directly. Please, do *not* reply to the list. ...
Sean M O'Keefe/AC/VCU
sokeefe@...
Feb 27, 2003 8:21 pm
391
Hi, I cannot see my icons on the Forms 9i buttons, when running Forms on a browser. Where should I place my icon files? Thanks for your help...
Yrd. DoƧ. Dr. Kem...
kturhan@...
Feb 27, 2003 8:22 pm
392
VOUG Membership - We just wrapped up the SEOUC conference down in Charlotte last week, and the attendees I spoke with were very enthusiastic about the training...
Ram, There is no need to stage the data in intermediary tables. iWay has some very good tools which are fast and efficient to extract out of any data ...
marty_nelson@...
Mar 3, 2003 12:44 pm
394
You could try my List package - it is well tested by now. Get it at http://www.smdi.com/employee/JohnF/orastuff.htm ... From: Prescribed@......
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.
