We are planning to take our production database down for an overhaul in the next week. We are currently using an Oracle 8.1.7 database. We would like to...
Kristen Reale
kreale@...
Nov 4, 2002 5:34 pm
297
+ Interjection by listserv moderator: + Many helpful replies to this posting, below... ... From: John Flack <johnf@...> When you say "case insensitive", I...
Good Morning... I am having a tnsnames problem. The SID that one of my users connects to constantly drops from his tnsnames.ora file. He is currently using...
Lee, Deborah L
leede@...
Nov 5, 2002 5:31 pm
299
Has anyone done any studies on the RNG used in O8? There is a bug noted in Metalink that an 8-digit number is normally generated but sometimes you will get a...
Ireland, Sharon M
sharon.m.ireland@...
Nov 5, 2002 5:32 pm
300
We have data stored in our Oracle 8.1.7 database that is a mix of both upper and lower case. Currently, our primary key fields will allow a new add to the...
Kristen Reale
kreale@...
Nov 6, 2002 2:27 pm
301
The only program that writes to that file is the SQL*NET/ or NET8 configuration Assistant. Make sure the you have removed the shortcut to the net8...
Kenneth Kline
ken@...
Nov 6, 2002 2:27 pm
302
+ Interjection by listserv moderator: + I believe this would be specific to Bob Blizard's + suggestion, so I've included only that from the + original message,...
Lipscomb, Princess (C...
princess.lipscomb@...
Nov 6, 2002 2:52 pm
303
Kristin, It seems like you might be mixing two concepts... The primary key column (field) will always be a unique value in and of itself, and should ideally be...
Mark C. Stock
mcstock@...
Nov 6, 2002 4:40 pm
304
Make the file ONLY readable , after correcting it. jim ... From: Kenneth Kline <ken@...> on 11/05/2002 12:46:42 PM The only program that writes to that...
james.smith@...
Nov 6, 2002 4:40 pm
305
I agree with Kenneth that it probably is not an Oracle program. I once had a case where a control file was being restored on top of my changes every night....
John Flack
johnf@...
Nov 11, 2002 5:48 pm
306
Good Afternoon.... I am having a database link problem. I just migrated to 8.1.7 from 7.3.4 using the export/import method. The database link was imported...
Lee, Deborah L
leede@...
Nov 11, 2002 5:50 pm
307
Hi Everyone, Im new to unix and am having a problem connecting a client workstation to oracle. The version of oracle is 7.2.3.2. This will be migrated to 9i in...
Prescribed@...
Nov 11, 2002 5:53 pm
308
Hi all I want to create a slide bar in Developer2000. i.e. in visual basic veritcal and horizontal scrollbar in which we can specify the min value, max value,...
Iruthaya Alexander
alex@...
Nov 11, 2002 5:55 pm
309
When I'm trying to run the application on Oracle Forms Builder (9i) (after connecting to the database (9i as well)) I get the following error: FRM-10142: the...
If this is a server side message then you have to define the server side ORACLE_SID envirnoment variable for whatever o/s user you are using to start sqlplus,...
Kenneth Kline
ken@...
Nov 12, 2002 3:54 pm
311
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: james.smith@... Two things you should...
I came across this same error in 7.3 versions when we renamed a database. Used the following command to correct: Alter database <database_name> rename...
Harrell, Lisa
LHarrell@...
Nov 14, 2002 7:50 pm
313
Hi all, Is there a way I can combine/concatente multi-position of an input file to assing to a table's field (data1)? LOAD DATA INFILE * INTO TABLE tbl_TEST ...
V Truong
t_vu@...
Nov 14, 2002 7:50 pm
315
We are trying to call a web service from with our Oracle Database. We running Oracle 8i 8.1.6 on AIX Unix. We are using GLUE for our XML mappings and to call...
steve.kubik@...
Nov 19, 2002 4:39 pm
316
When we upgraded from 7.3 to 8.0 the PROGRAM parameter in the listener.ora file changed. The ending file name changed from NETV2_<DB_NAME>.COM to ...
sally.moredock@...
Nov 19, 2002 4:40 pm
317
+ Interjection by listserv moderator: + Several helpful replies to this posting have been combined + below to save wear and tear on your email inbox... ... ...
I've just installed the current Windows 9iAS Portal&Wireless option. I am able to navigate from... http://localhost:7778/iASDemos.htm to ...
Palmer
miles.palmer@...
Nov 19, 2002 4:40 pm
320
Try this, it is simple, for field DATA1 you are interested in chunks of data from Position 1 to 11, therefore do following: 1. Define the position for DATA1 is...
Ihtesham Uddin
ihtesham_u@...
Nov 19, 2002 5:10 pm
321
Hi Miles, Have you started SSO Server in your 9iAS Infrastructure? Val...
Val Sorokine
vsorokine@...
Nov 19, 2002 5:10 pm
322
In a previous discussion regarding enforcing case-insensitive uniqueness (i.e., do not allow 'Sales' and 'SALES'), I had suggested that following, which had a...
Does anyone know of a way to check historical schema activity? In other words, if I create an application accessing an Oracle schema, is there any way to see...
Fred.M.Ridgway@...
Nov 21, 2002 11:46 am
324
Hi Fred get current users with select * from v$session in a dba user.... Or you can use the on logon database trigger to insert into a logging table and record...
c.r.farmer@...
Nov 22, 2002 3:02 pm
325
Some possibilites with varying degrees of complexity to use and implement include... [1] Oracle Auditing functionality. [2] Modify application to trigger...
O'Neill, Sean
sean.oneill@...
Nov 22, 2002 3:03 pm
326
I stumbled into a frustrating Forms bug that can be extremely difficult to crack, so I thought I'd pass it on.... Forms (9i and 6i) will hang when attempting...
Mark C. Stock
mcstock@...
Nov 22, 2002 9:39 pm
327
Folks, I am trying to put together a script similar to this: spool m:\trim\enterprise\production_db\before.sql SELECT TO_CHAR(SYSDATE,'MM/DD/YY HH24:MI') FROM...
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.
