RE: Archive log full

2002-06-03 Thread sam d
thx a lot all , for the info. (I'll look out for book Oracle9i for Windows 2000 Tips Techniques) -Original Message- From: Michael P Sale [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 7:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: Archive log full

RE: Rollback Segment tuning

2002-06-03 Thread Stephane Faroult
Hi all,=0D =0D How to find out the smallest (minimal) transaction size from Dictionary vie= w or base tables =0D I try to set my OPTIMAL rollback segment base on smallest transaction size = to prevent ora-1555. since shrinking rollback segments may cause ora-1555.= =0D =0D =0D Thanks =0D =0D

Re: How to grant privileges on all the tables of owner1 to owner2?

2002-06-03 Thread farkasb
If you don't want to grant select any table to owner2, try this : select 'grant select on '||table_name from all_tables where owner = 'OWNER1' It selects all grant statements, you have to execute them. For this, you may write a pl/sql block or just execute it as script. Balazs Farkas On

Pkg Body variables

2002-06-03 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

RE: Rollback Segment tuning

2002-06-03 Thread Sinardy Xing
Thanks man, I mean the minimum optimal size base on the maximum transaction size, So the HWM is the answer ? Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L Hi all,=0D =0D How to find out the smallest (minimal) transaction size from

RE: Pkg Body variables

2002-06-03 Thread Ganesh Raja
Pkg Variables are Presistent for the session. They Get Deallocated once the session dies. So It will not be available for the next SQLLDR Run. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019

Re: Pkg Body variables

2002-06-03 Thread Alexandre Gorbatchev
Package is initialized when user first time access it on the session level. Think about it like each session has a copy of package. Does not matter which user access it. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 03, 2002

RE: Rollback Segment tuning

2002-06-03 Thread Sinardy Xing
Hi Stephane, I run the script and I have OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* sys.ts$.blocksize / 1024 the result is 0 K for my optimal. : ) regards, Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L

RE: Pkg Body variables

2002-06-03 Thread Stephane Faroult
Hi, I am calling a packaged function in sql loader control file. I 've declared a variable in pkg body to hold old value . I am comparing this with current value obtained from sql ldr and also storing last value in the old value variable. My question is will the package variable declared

RE: RE: Rollback Segment tuning

2002-06-03 Thread Stephane Faroult
Thanks man,=0D =0D I mean the minimum optimal size base on the maximum transaction size, So th= e HWM is the answer ?=0D =0D =0D Sinardy=0D =0D Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can be fairly confident with the value). If somebody has run a big

Re: * Certified Oracle DBAs Needed in the Dallas area..

2002-06-03 Thread Yechiel Adar
So, If I am working a long time why should I now quit and move to work with them? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 31, 2002 4:19 PM Great Company located in Greater Dallas, Texas area (Richardson)

Problem on shadow process

2002-06-03 Thread Frédéric MAJOR
Hi, OS : AIX 4.3.3.0 RDBMS : 8.0.6.2.0 We have a Unix daemon write in Pro*C that wake up every X minutes (I think it's about 1) to look at one table on an AS400 via dblinks and transparent gateway from the AIX server. Our problem is that the shadow process constantly increase his consomation

RE: Pkg Body variables

2002-06-03 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

Re: Jr.DBA, Mid level DBA, Sr.DBA

2002-06-03 Thread Yechiel Adar
Hello Itiu You wrote: Most people use it : We have a saying: zillions flies can not be wrong, eat shit. BTW - We use NT servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 2:43 AM What's wrong

RE: RE: Rollback Segment tuning

2002-06-03 Thread Stephane Faroult
Hi Stephane,=0D =0D I run the script and I have =0D =0D OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* sy= s.ts$.blocksize / 1024 =0D =0D the result is 0 K for my optimal. : )=0D =0D regards,=0D Sinardy=0D Probably not enough significant activity. It tries to set

RE: Problem on shadow process

2002-06-03 Thread Stephane Faroult
Hi, OS : AIX 4.3.3.0 RDBMS : 8.0.6.2.0 We have a Unix daemon write in Pro*C that wake up every X minutes (I think it's about 1) to look at one table on an AS400 via dblinks and transparent gateway from the AIX server. Our problem is that the shadow process constantly increase

Re: Problem on shadow process

2002-06-03 Thread Tim Gorman
Frederic, Please ask the PRO*C programmer if they are making any use of the C malloc() library at all in that program, or anything similar. If so, then the most likely problem is that they are not properly freeing memory after grabbing some more. This is a very common mistake when writing

Re: Jr.DBA, Mid level DBA, Sr.DBA

2002-06-03 Thread Tim Gorman
...and what makes you think that we all don't? Do you know anything about how wine and beer are made? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 03, 2002 5:43 AM Hello Itiu You wrote: Most people use it : We have a saying:

Functions

2002-06-03 Thread Sherrie . Kubis
Hello all. I am seeking opinions of experienced database folks on this issue: I am implementing a replication environment between IBM DB2 and UNIX Oracle using DataMirror's Transformation Server (TS) product. TS replicates and transforms data between disparate databases. (Right now I am

Setting Up EXTPROC

2002-06-03 Thread John Weatherman
Hi all, I've recently been asked to set up an extproc listener and as this is the first non-apps one I have had to deal with, I was hopping somebody could give some pointers. I have RTFM, and sarcasm it's oh so clear /sarcasm. Anyway, how does one go about figuring out the LISTENER_KEY? Is the

Re: Setting Up EXTPROC

2002-06-03 Thread Igor Neyman
In address_list to listen for extproc connection through IPC protocol use EXTPROC0 as a KEY. SID_NAME for extproc is always PLSExtProc. ORACLE_HOME is your regular oracle_home directory. Here is an example: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =

Re: dblink mysql to oracle

2002-06-03 Thread Igor Neyman
Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 8:08 PM i want to be

Re: Oracle and Tru64

2002-06-03 Thread Hemant K Chitale
I'd never heard that Oracle has stopped or is stopping support for Tru64. We have more than 35 production databases on Tru64 and have no intention of moving out of Alpha-Tru64 in a hurry. We're even looking at upgrading a mission critical 8iOPS cluster on Tru64 to 9iRAC on Tru64. Hemant K

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread DENNIS WILLIAMS
Pat Excellent summary. I have only a few points to add. I must point out that I am an RMAN novice, just getting brief spurts of time between other people's priorities. - If you use RMAN to back up to disk, I haven't figured an advantage to backing archive logs up with RMAN. If anyone

Re[2]: Oracle and Tru64

2002-06-03 Thread dgoulet
Well, from a browse of Metalink, if your on a version of TRU64 = 5.0 you are desupported. Dick Goulet Reply Separator Author: Hemant K Chitale [EMAIL PROTECTED] Date: 6/3/2002 6:53 AM I'd never heard that Oracle has stopped or is stopping support

RE: Oracle and Tru64

2002-06-03 Thread DENNIS WILLIAMS
Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would

RE: dblink mysql to oracle

2002-06-03 Thread Gogala, Mladen
I dunno about MySQL, but from oracle you can have external procedures accessing MySQL and returning data into oracle. There is also a TNS API which allows you to write your very own transparent gateway and select data from MySQL. -Original Message- From: Gabriel C Millerd

RE: Oracle and Tru64

2002-06-03 Thread Michael P Sale
I can confirm that Tru64 is quite alive and well at Oracle, no desupport seen in the future. In fact there are new efforts going into Tru64 RAC. Even when the alpha goes away there is an effort to port Tru64 to the intel platform, but who knows where that is going with the merger :) Regards,

Upgrade Question

2002-06-03 Thread Hamid Alavi
Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch

Solution to Microsoft Transaction Server/Standby database problem

2002-06-03 Thread Miller, Jay
Some of you may recall a question I posted on a problem with MTS connection pooling. MTS continued to try to connect to our old IP address after switching between production and standby. This happened even though we switched the IP address the DNS Name was pointing to. Well, we finally managed

Re: ORACLE-L Digest -- Volume 2002, Number 152

2002-06-03 Thread chris blais
All, For what its worth, I believe Rachel has the best approach to the SA / DBA relations dilemma. -). Another approach, I developed, consists of a matrix that helps delineate SA, DBA, lead and Architect responsibilities. Please feel free to download it and use at will. The on-line version

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
Ron, Thanks for replay, But still don't know what I have to do to solve the problem, do I have to change some thing or what? Can you please explain more? Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this

Re: Upgrade Question

2002-06-03 Thread Ray Stell
Oracle database patchsets for UNIX are cumulative. Applying the latest patchset will include all of the fixes in previous patchsets for the same baseline version. (i.e. The 8.1.7.4.0 will include the fixes in 8.1.7.3). Unless otherwise noted, you can apply the latest patchset with out applying

Re: Upgrade Question

2002-06-03 Thread Ron Thomas
You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To:

RE: rman duplicate dbid? AND rman catalog config options

2002-06-03 Thread Pat Brenda Howe
Dennis : Good point. It was not clear in my note - but yes we are going with a server that is dedicated to RMAN and OEM. Instead of using the 'cross-mount architecture' we decide to backup the Oracle Database (RMAN and OEM) that reside on this server using a manual script based hot backup

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread Pat Brenda Howe
Dennis ; You are absolutely right - the DISK option has a big down side that I did not catch : In a disaster (computer room fire) the daily archive logs would be lost leaving you without the ability to roll forward your database - and thus the loss of data. Therefore if you were to go with

RE: Stubborn Table Resolution

2002-06-03 Thread kkennedy
Thanks for all the helpful suggestions. Here is what worked: Query: SELECT Record_Type, Archive_Input_File FROM MDMA_Input_File GROUP BY Record_Type, Archive_Input_File I modified the record_type column to not null. This allowed an index FFS which the optimizer wisely selected. The update

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
I couldn't find/var/opt/oracle/oraInst.loc I am on solaris which directory I have to look for looking at this file -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file

Oracle 8i on Terminal server

2002-06-03 Thread Streeter, Lerone A LBX
http://metalink.oracle.com/oracleinstall/oracle8i/windows.html this and a couple other links i've read, give the impression that oracle with terminal server/services is not supported. is there a work around to allow you to user terminal services and oracle? i'd like to use sqlplus and connect

RE: Upgrade Question

2002-06-03 Thread Ron Thomas
This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one

RE: Oracle 8i on Terminal server

2002-06-03 Thread Jamadagni, Rajendra
It works fine ... the problem is when you go in for support. But if you can reproduce the error in normal environment (i.e. without terminal server) they will support you. YMMV Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot

RE: Oracle 8i on Terminal server

2002-06-03 Thread Seefelt, Beth
Yes, there is a workaround. I use terminal services for everything, including installs and have not had any issues. You have to force everything to go through sqlnet by using @sidname, and never use the bequeath adapter. SVRMGRL connect internal@yoursid SQLPLUS username/pwd@yoursid or c:\

RE: Upgrade Question

2002-06-03 Thread Ron Thomas
Someone from the list will need to respond. I work on HPs here and I haven't done a Sun install in a few years. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats.

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread Orr, Steve
You mentioned disk management issues... A problem with disk is that you are probably limited to only doing level 0 backups. If your recovery spans multiple RMAN backups then it could be a real bear trying get everything you need to recover if you're staging from disk to tape. You'd have to be

RE: Upgrade Question

2002-06-03 Thread Gogala, Mladen
That file is the pointer for the installer to know where to look for things. It's usually in the same place as oratab. As for the SUN install, let me quote the girl from the original Jurassic Park: It's a Unix system! I know how to use that! -Original Message- From: Ron Thomas

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread Jay Hostetter
Where is your tape during the computer room fire? We have a script that copies archivelogs to a remote server. This way, when the computer rooms burns, we can recover up to the last log switch (which we also force via a script a few times a day). We only keep 1 day's worth of archive logs

How to successfully execute dmesg command from Oracle account??

2002-06-03 Thread Janardhana Babu Donga
Dear List, When I run dmesg command from oracle account on HP-UX 11.0, it responds as can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x. Could someone tell me what needs to be done in order to execute dmesg command successfully from oracle account. Thanks, --Babu -- Please

Re: Rollback Segment tuning

2002-06-03 Thread Jared . Still
I find that not setting OPTIMAL seems to be optimal. Jared Sinardy Xing [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/02/2002 09:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Rollback Segment

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
Hello All Again, I just find the OraInst.loc and here is the content of the file: inventory_loc = /opt/home/rcosme ...don't know what's this mean? inst_group= This is all about this file, Is any body know what contenet this file must have, Do I have to put Oracle userID address here or

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread DENNIS WILLIAMS
Steve, Pat In our experiments so far, we had enough space to leave the level 0 backup on disk. The other incremental backups are so small compared with the level 0, that they aren't a problem. We keep a couple of weeks of archives on another disk anyway. All these can be backed up to tape

Re: How to successfully execute dmesg command from Oracle account??

2002-06-03 Thread Suzy Vordos
To read kernel memory requires root privs, so don't think there is a way to do that from the oracle account without some undesirable hack. Janardhana Babu Donga wrote: Dear List, When I run dmesg command from oracle account on HP-UX 11.0, it responds as can't read kernel memory. The

RE: How to successfully execute dmesg command from Oracle accou

2002-06-03 Thread Sherman, Edward
/etc/dmesg: 'can't read kernel memory' - must be root http://welcome.hp-ww.com/country/img/arrows/a_ff9900.gifprintable http://support2.itrc.hp.com/service/cki/docDisplay.do?printable=truef_Pass

RE: How to successfully execute dmesg command from Oracle accou

2002-06-03 Thread John Kanagaraj
Babu, This should be possible if your SysAdmin sets the SUID bit for dmesg. I see no harm in doing this, but it is essentially upto your SYsAdmin. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life

General RMAN Configuration Recommendations

2002-06-03 Thread Pat Howe
I have compiled a list of 'rman configuration recommendations' that I have based my RMAN deployment on. I am sending this out to the list for general discussion. If you have anything to add let me know - I am learning as I go. PS : Either CC me on all question responses or I will get back to you

RE: Upgrade Question

2002-06-03 Thread Freeman, Robert
1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real

RE: How to successfully execute dmesg command from Oracle accou

2002-06-03 Thread Janardhana Babu Donga
Suzy, Thanks for your reply. I needed it because Oracle has supplied a script: InstallPrep.sh on Metalink which check the server to ensure that it has adequate resources to successfully install Oracle9i database software. It should be run as oracle user only, but it executes dmesg command. It is

RE: 9iR2 Install Problem

2002-06-03 Thread Toepke, Kevin M
All: Remember this? Well, after losing an support analyst, we finally got the java stuff to work with 9iR2...the problem was the inventory_loc=/opt/oracle entry in /var/opt/oracle/oraInst.loc. it should have been inventory_loc=/opt/oracle/oraInventory The installer did not complain that it

RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-06-03 Thread Freeman, Robert
but many (and especially older hands) Oracle DBAs consider M$ systems to be for wimps, just good for running Access and possibly SQL Server. Yea... and I'm sure that there are those older hands that would prefer the days of the card punching return :-)) Old habits and ways are hard to

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread Freeman, Robert
There are several solutions to this that I can think of besides just going to tape... Duplexing the backups to different disks in different physical locations is one, or using some sort of remote mirroring strategy is another. If you have an offsite DR location that you can duplex to (on disk)

RE: RMAN - Disk vs Tape backups

2002-06-03 Thread Jared . Still
Dennis, Which MML and how much $$? The Oracle client for Veritas is about $3500. Small change for a piece of a backup system. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/03/2002 12:33 PM Please respond to ORACLE-L To: Multiple recipients of list

Re: How to successfully execute dmesg command from Oracle account??

2002-06-03 Thread Stephane Faroult
Janardhana Babu Donga wrote: Dear List, When I run dmesg command from oracle account on HP-UX 11.0, it responds as can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x. Could someone tell me what needs to be done in order to execute dmesg command successfully from oracle

Re:RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-06-03 Thread dgoulet
Ban M$, run Linux. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 6/3/2002 12:08 PM but many (and especially older hands) Oracle DBAs consider M$ systems to be for wimps, just good for running Access and possibly SQL

RE: General RMAN Configuration Recommendations

2002-06-03 Thread Orr, Steve
this way you are not writing unnecessary information to the RMAN dictionary. Isn't the data that goes to the RMAN repository so small that this is moot? take one step back and begin by configuring RMAN to backup to disk first. I've used the sbttest utility that comes with Oracle to test the

RE: 9iR2 Install Problem

2002-06-03 Thread Miller, Jay
Oracle really seems to have messed up considerably with the oraInventory directory. I've had several problems and from reading various threads it seems that I'm far from the only one. -Original Message- Sent: Monday, June 03, 2002 3:59 PM To: Multiple recipients of list ORACLE-L All:

trial version of Oracle Financial ??

2002-06-03 Thread Leslie Lu
Hi, Does anyone know where to get a trial version of Oracle Financial, or other components of 11i? Thank you! Leslie __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks,

Re: trial version of Oracle Financial ??

2002-06-03 Thread Ron Rogers
Leslie, Go to the Oracle web site and click on the store icon and check out the CDPACKS for $40 each. You can get anything for your own play evaluation purposes. Ron ROR mô¿ôm [EMAIL PROTECTED] 06/03/02 04:58PM Hi, Does anyone know where to get a trial version of Oracle Financial, or other

RE: trial version of Oracle Financial ??

2002-06-03 Thread Murray, Margaret
Ron, That's fine for everything BUT E-Business Applications (and isn't that what most people want?) from the web page - * We do not offer trial licenses for our E-Business Suite Applications. Leslie, Be prepared to spend at least $40 and LOTS of learning time to install to try. I don't think

RE: So, What is a 'Production DBA'?

2002-06-03 Thread Paula_Stankus
Title: RE: So, What is a 'Production DBA'? Guys, In my experience there are so many issues that come up in design that eventually affect the quality of life for a production dba that I have real concerns splitting the role. In my world as much as possible I do both starting with design I

RE: foreign key what???? help!!

2002-06-03 Thread Paula_Stankus
Title: RE: foreign key what help!! Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data

Re: Upgrade Question

2002-06-03 Thread Suzy Vordos
There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above). A single oratab file is used by all versions of

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
Thanks, So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused and looking for a installed patch? What the content of oratab should be? I have the following values in my oratab: STAR:/u01/app/oracle:Y 8.1.6 CQST:/u01/app/oracle:Y 8.1.6 HMS:/u01/app/oracle:N8.1.6

linux vs any other os

2002-06-03 Thread Bill Conner
Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: foreign key what???? help!!

2002-06-03 Thread Magaliff, Bill
Title: RE: foreign key what help!! are you loading more than one table? could you be loading child records b4 the parents are inserted? -bill -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 6:13 PMTo: Multiple recipients

RE: Upgrade Question

2002-06-03 Thread kkennedy
Hello Hamid, I don't think your problem with the patch has anything to do with the oratab file. I had an identical problem upgrading a server from 8.1.7.0 to 8.1.7.3 where the installer insisted that no patch was needed. I had this happen on two different servers. In my case, predecessors

RE: Upgrade Question

2002-06-03 Thread Hamid Alavi
Hi List, I just find this on Metalink: If an inadvertent attempt is made to apply this Patch Set to a non-8.1.7 release, then a warning dialog box entitled Dependencies is displayed which contains the following error message: There are no patches that need to be applied from the patch set

RE: foreign key what???? help!!

2002-06-03 Thread Fink, Dan
Title: RE: foreign key what help!! It is probably a question of timing when Child records are loaded before Parents. It can be a question of table order or even record order (self referencing relationship). Once the data is loaded, enforcement of the constraint is easy because all of

RE: Upgrade Question

2002-06-03 Thread John Hallas
The Y or N indicate to the dbstart program whether each database will be started on system startup or not I do not think the installer will take any note of these settings. It only uses the oratab file to determine the Oracle_home settings (as well as using the environment/registry settings) HTH

Re: Upgrade Question

2002-06-03 Thread Suzy Vordos
The oratab doesn't look right to me. The second token should have the full path to ORACLE_HOME for each version. Unless of course Oracle is *really* installed under /u01/app/oracle instead of /u01/app/oracle/8.1.6, in which case that doesn't follow OFA standards. STAR:/u01/app/oracle/8.1.6:Y

Re: Upgrade Question

2002-06-03 Thread Ron Thomas
You said: There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the Not necessarily (and not recommended). It is very easy to setup an orainventory file for each installation. Check metalink for details. Ron Thomas

Re: Where is Oracle9i Release README shipped with 9.2.0.1

2002-06-03 Thread Joe Testa
Debi, did you happen to go to technet.oracle.com and see if want you need is there? joe [EMAIL PROTECTED] wrote: I can't find the generic rdbms README anywhere on my server for 9iR2. There are 42 readme.txt files on the server in a variety of formats/cases making it difficult to find:

RE: dblink mysql to oracle

2002-06-03 Thread Gabriel C Millerd
On Mon, 3 Jun 2002, Gogala, Mladen wrote: I dunno about MySQL, but from oracle you can have external procedures accessing MySQL and returning data into oracle. There is also a TNS API which allows you to write your very own transparent gateway and select data from MySQL. is this the

Re: dblink mysql to oracle

2002-06-03 Thread Gabriel C Millerd
On Mon, 3 Jun 2002, Igor Neyman wrote: Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. this seems more like the way to go .. i didnt expect to have to program anything rather configure oracle, a mysql driver, and transport

Re: Where is Oracle9i Release README shipped with 9.2.0.1

2002-06-03 Thread Lyubomir Petrov
What about $ORACLE_HOME/rdbms/doc/README_rdbms.htm? HTH Lyubomir Petrov - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:48 PM I can't find the generic rdbms README anywhere on my server for 9iR2. There are 42 readme.txt

Re: Where is Oracle9i Release README shipped with 9.2.0.1

2002-06-03 Thread Debi
I did find the readme on MetaLink but I need to give the location to others in our office who don't have access...and the readme says it was installed on the server! If I don't find it I will just copy the file from MetaLink, convert it to ascii text, and put it on the server myself. I

Re: trial version of Oracle Financial ??

2002-06-03 Thread MICHAEL.SALE
There is no Trial version of the E-Business suite. Check with your Oracle salesperson to see if you can work something out. Mike Hi, Does anyone know where to get a trial version of Oracle Financial, or other components of 11i? Thank you! Leslie

Re: Where is Oracle9i Release README shipped with 9.2.0.1

2002-06-03 Thread Mladen Gogala
Whaddya mean by run html? HTML files are not run, they are viewed in Galeon, Mozilla or, pardon my French, IE. On 2002.06.03 22:38 Debi wrote: I did find the readme on MetaLink but I need to give the location to others in our office who don't have access...and the readme says it was

Re: Where is Oracle9i Release README shipped with 9.2.0.1

2002-06-03 Thread Mladen Gogala
$ ls -l $ORACLE_HOME/rdbms/doc total 236 rw-r--r--1 oracle dba239804 Jun 2 18:50 README_rdbms.html $ sqlplus scott/tiger SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 4 00:16:33 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: