RE: multiple oracle homes

2003-03-02 Thread John Blake
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Rownum

2003-03-19 Thread John Blake
no, rownum is a sequential number whereas rowid is a pointer to the row of the table within the database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Santosh VarmaSent: Wednesday, March 19, 2003 4:44 AMTo: Multiple recipients of list

RE: Force to use a tablespace

2003-03-19 Thread John Blake
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: [Q] how to make Develper 6i talk to ORACLE 8i client??

2003-07-25 Thread John Blake
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Antw: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1

2003-07-27 Thread John Blake
a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network

RE: Problems creading a Index

2003-10-02 Thread John Blake
The duplicate keys message is stating that there are multiple rows containing the same values for the specified elements in your index (COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM) thus the index can not be a unique index. -Original Message-From: [EMAIL PROTECTED]

Clone db 9.2 on AIX 5L

2003-10-27 Thread John Blake
Title: RE: Query Tuning Help Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John

RE: Clone db 9.2 on AIX 5L

2003-10-27 Thread John Blake
John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine

RE: Clone db 9.2 on AIX 5L

2003-10-28 Thread John Blake
the error? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create

RE: Clone db 9.2 on AIX 5L

2003-10-28 Thread John Blake
? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup

RE: Clone db 9.2 on AIX 5L

2003-10-29 Thread John Blake
, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat

problem with mult datafiles and local mng tblspaces

2003-12-19 Thread John Blake
to be able to create the tablespaces with multiple data files but it seems whenever I add a datafile the performance of the load degrades. Any ideas?? Thanks in advance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network

RE: oracle client on PC's

2004-01-06 Thread John Blake
we have a standard desktop or laptop image whichwe install the client and create a package containing the change, we then push to the pc's that require the oracle client. We use onames with a primary and secondary name server. -Original Message-From: [EMAIL PROTECTED]