CROSS TAB QUERY
Hi Gurus, I have a table Monthly_Stats as below: MONTH VARCHAR2(20), ERLANG NUMBER(7,2) CONGNUMBER(5,2) . . CSETUP NUMBER(5,2) A record is inserted in this table every end of month. I would like to write an SQL query to produce output below: MONTH JAN FEB MAR APR MAY . . . DEC ERLANG 777 999 98 66 87 999 CONG9 6 3 4 2 4 CSETUP . . . I do not know the number of months in advance, i.e. if the table has 3 months (JAN, FEB, MAR), these are the only months I need in the report. Any suggestions?? Moses Moya Ngati -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
OEM for Personal Edition cannot connect
Hi, I'm trying using OEM for Oracle's Personal Edition 98, what is the value of Management Server ?, I tried with PC name and 127.0.0.1 both gave me error message VTK-1000: Unable to connect to management server Or perhaps OEM is not for Oracle 8i Personal Edition. Please help Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Delete slowing..
Title: RE: Delete slowing.. Mark, something else to add to your list of things to check Does a FTS of the table take a long time as well? If so I would try re-creating the table to remove the space left by previously deleted rows. John -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: 27 November 2001 19:55 To: Multiple recipients of list ORACLE-L Subject: Re: Delete slowing.. Mark Leith wrote: Hi list people :) We have a customer who has been running a particular delete statement against a table for a while now, which usually ran within minutes. All of a sudden this table has suddenly gone from a few minutes right up to 50! He wants to diagnose why.. Where would you start? I have a few ideas of my own - like stale stats, small rollback segments etc. - but am after some of your advice also before I get back to him tomorrow morning.. Not sure on the Oracle version, OS, or even amount of rows he is deleting or size of the table (yet, I'll find this out tomorrow), but there has to be a pretty standard way of diagnosing this.. All help appreciated. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === 'We have done nothing and suddenly it's slow' is a well known tune. Usual suspects : 1) Stats, computed or deleted 2) Dropped index 3) Newly created trigger 4) Locks. Nobody doing DML on the same table during the delete ? -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). >> This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. >>
RE: OEM for Personal Edition cannot connect
Title: RE: OEM for Personal Edition cannot connect guys, please give more details about this management server in oracle. i tried many times to connect on it... the same error i got vtk-1000..etc. never i succeeded on it thanks. Nirmal. -Original Message- From: Sinard Xing [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: OEM for Personal Edition cannot connect Hi, I'm trying using OEM for Oracle's Personal Edition 98, what is the value of Management Server ?, I tried with PC name and 127.0.0.1 both gave me error message VTK-1000: Unable to connect to management server Or perhaps OEM is not for Oracle 8i Personal Edition. Please help Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Re: Re: ACM SIGMOD-papers of interest #1
Hi! can you please let me know the Publisher and Author's name Thanx On Wed, 28 Nov 2001 Greg Moore wrote : Where can I get a copy of Scaling Oracle 8i please It's a book. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Checking DB Status in NT env.
connect scott/tiger@sid select 'PING' from dual; If you receive an output from the database you can pretty much say it's up and running don't you think? If you get an error anywhere along this path - you have a problem.. Mark -Original Message- Sent: 27 November 2001 19:55 To: Multiple recipients of list ORACLE-L Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Unable to run catalog.sql
Title: RE: Unable to run catalog.sql the catalog.sql Must be run when connected to SYS or INTERNAL. Is it true for ur case? Nirmal., -Original Message- From: Ken Janusz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Unable to run catalog.sql I have tried to run catalog.sql from the sql*plus command line and keep getting this error. sp2-0310 unable to open file catalog.sql. I've use the full path name with the same results. catalog.sql is on my PC and the database is located on a server. I have run other commands from my client machine with no problems. What appears to be the problem? TIA Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Re: Re: ACM SIGMOD-papers of interest #1
http://www.amazon.com/exec/obidos/ASIN/0201325748/qid=1006942220/sr=8-1/ref= sr_8_7_1/107-0449271-4062165 Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Thankappan Sent: Wednesday, November 28, 2001 1:35 AM To: Multiple recipients of list ORACLE-L Hi! can you please let me know the Publisher and Author's name Thanx On Wed, 28 Nov 2001 Greg Moore wrote : Where can I get a copy of Scaling Oracle 8i please It's a book. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Alternatives to Pathworks?
Title: RE: Alternatives to Pathworks? Marc, What transport protocol are you using at the moment if not TCP, Decnet I presume The 2 things that spring to mind are 1) Look at using Samba. That certainly works on VMS and allows file movement between VMS,Unix and NT. I have seen it grab a lot of CPU on VMS systems and I think it requires restarting frequently but that can all be scripted 2) What limits are reached on the VMS server. I cannot imagine UCX or whatever they call it now (services for TCP possibly) radically changing resource usage. Get a 30 day trial from Compaq and see what it affects John -Original Message- From: Blum, Marc [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 07:01 To: Multiple recipients of list ORACLE-L Subject: Alternatives to Pathworks? Dear list, we have a 8.1.7 running on NT4. A NT-service copies flatfiles from a VAX/VMS and starts a batch, which imports the data into the DB. VMS is reached via Pathworks. Now, when Pathworks is installed an the machine running the instance, the instance seems to become instable and dies under some circumstances. Is there any alternative to pathworks? Our customer don't want to install TCP on VMS, because the machine is at it's limit. Thanks in advance Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner Weg 22-24 D-52070 Aachen Telefon: +49 241 / 9 18 79-33 Fax: +49 241 / 15 40 38 mailto:[EMAIL PROTECTED] http://www.soptim.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). >> This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. >>
RE: Unable to run catalog.sql
It might be a PATH issue, try creating an entry in your PATH statement on *your PC* that has the full path to the directory that holds catalog.sql. -Original Message- Sent: 27 November 2001 19:00 To: Multiple recipients of list ORACLE-L I have tried to run catalog.sql from the sql*plus command line and keep getting this error. sp2-0310 unable to open file catalog.sql. I've use the full path name with the same results. catalog.sql is on my PC and the database is located on a server. I have run other commands from my client machine with no problems. What appears to be the problem? TIA Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Oracle8i on WinNT - renaming disc drives
List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Analyze only latest partition
declare
pname varchar2(100);
begin
select partition_name
into pname
from user_tab_partitions
where table_name = ...
and partition_id =
( select max(partition_id)
from user_tab_partitions
where table_name = ... );
execute immediate 'analyze table ... partition
('||pname||')';
end;
or something similar to that..
hth
connor
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote: Hi lists,
Is there a script/command to analyze only the latest
partition of my
table. It has several partitions. For every month
1(one) partititon gets
created to store that months data.
Can anybody throw some script.?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music
Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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).
Re: CROSS TAB QUERY (long)
Hi !
May this complete example can help you:
---
-- File: Cross_Tab.sql
--
--
==
--
==
#
set termout on
--
drop table Sales;
--
create table Sales
(Productvarchar2(30),
Value number(8),
Invoice_Date date);
--
--
-- insert some data for testing
--
alter session set nls_date_format='-MON-DD'; --
just to be sure for the proper date format
--
insert into Sales values ('PAPEL C0NTINUO', 117,
'2001-JAN-01');
insert into Sales values ('TINTA IMPRESSORA', 234,
'2001-JAN-01');
insert into Sales values ('BANDAS SIMPLES', 468,
'2001-JAN-01');
insert into Sales values ('DISQUETTES AMARELAS', 702,
'2001-JAN-01');
insert into Sales values ('TINTA FOTOC0PIADORA', 819,
'2001-JAN-01');
insert into Sales values ('CERVEJA LAGER', 1053,
'2001-JAN-01');
insert into Sales values ('SAIAS DE LA', 117,
'2001-FEB-11');
insert into Sales values ('SAIAS DE SEDA', 117,
'2001-FEB-11');
insert into Sales values ('CAMISAS DE LA', 117,
'2001-FEB-11');
insert into Sales values ('CAMISAS DE SEDA', 117,
'2001-FEB-11');
insert into Sales values ('SAIAS DE ALGODAO', 117,
'2001-FEB-11');
insert into Sales values ('PIJAMAS DE SEDA', 117,
'2001-FEB-11');
insert into Sales values ('PIJAMAS DE ALGODAO', 11.7,
'2001-APR-21');
insert into Sales values ('PIJAMAS DE SEDA', 58.5,
'2001-APR-21');
insert into Sales values ('SAIAS DE SEDA', 234,
'2001-APR-21');
insert into Sales values ('PIJAMAS DE ALGODAO', 11.7,
'2001-APR-21');
insert into Sales values ('PIJAMAS DE SEDA', 58.5,
'2001-APR-21');
insert into Sales values ('SAIAS DE SEDA', 234,
'2001-APR-21');
insert into Sales values ('SAIAS DE SEDA', 117,
'2001-JUN-01');
insert into Sales values ('SAIAS DE ALGODAO', 117,
'2001-JUN-01');
insert into Sales values ('CAMISETES DE ALGODAO', 117,
'2001-JUN-01');
insert into Sales values ('PIJAMAS DE LA', 117,
'2001-JUN-01');
insert into Sales values ('PIJAMAS DE SEDA', 117,
'2001-JUN-01');
insert into Sales values ('CAMISOLAS DE LA', 117,
'2001-JUN-01');
insert into Sales values ('SAIAS DE ALGODAO', 117,
'2001-MAY-05');
insert into Sales values ('SAIAS DE SEDA', 234,
'2001-MAY-05');
insert into Sales values ('PIJAMAS DE SEDA', 58.5,
'2001-MAY-05');
insert into Sales values ('SAIAS DE ALGODAO', 117,
'2001-MAY-05');
insert into Sales values ('SAIAS DE SEDA', 234,
'2001-MAY-05');
insert into Sales values ('PIJAMAS DE SEDA', 58.5,
'2001-MAY-05');
insert into Sales values ('PIJAMAS DE LA', 702,
'2001-JAN-01');
insert into Sales values ('PIJAMAS DE SEDA', 351,
'2001-JAN-01');
insert into Sales values ('CAMISOLAS DE LA', 936,
'2001-JAN-01');
insert into Sales values ('SAIAS DE ALGODAO', 1053,
'2001-JAN-01');
insert into Sales values ('SAIAS DE SEDA', 2574,
'2001-JUL-11');
insert into Sales values ('PIJAMAS DE SEDA', 643.5,
'2001-JUL-11');
insert into Sales values ('SAIAS DE ALGODAO', 1755,
'2001-JUL-11');
insert into Sales values ('SAIAS DE SEDA', 3978,
'2001-JUL-11');
insert into Sales values ('PIJAMAS DE SEDA', .5,
'2001-JUL-11');
insert into Sales values ('PIJAMAS DE LA', 117,
'2001-FEB-21');
insert into Sales values ('PIJAMAS DE SEDA', 2457,
'2001-FEB-21');
insert into Sales values ('CAMISOLAS DE LA', 1404,
'2001-FEB-21');
insert into Sales values ('SAIAS DE ALGODAO', 3627,
'2001-FEB-21');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-FEB-21');
insert into Sales values ('PIJAMAS DE SEDA', 2398.5,
'2001-AUG-01');
insert into Sales values ('SAIAS DE ALGODAO', 14391,
'2001-AUG-01');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-AUG-01');
insert into Sales values ('PIJAMAS DE SEDA', .5,
'2001-AUG-01');
insert into Sales values ('PIJAMAS DE LA', 117,
'2001-MAY-05');
insert into Sales values ('PIJAMAS DE SEDA', 2457,
'2001-MAY-05');
insert into Sales values ('CAMISOLAS DE LA', 2106,
'2001-MAY-05');
insert into Sales values ('SAIAS DE ALGODAO', 4797,
'2001-MAY-05');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-MAY-05');
insert into Sales values ('PIJAMAS DE SEDA', 2398.5,
'2001-JAN-01');
insert into Sales values ('SAIAS DE ALGODAO', 37791,
'2001-JAN-01');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-JAN-01');
insert into Sales values ('PIJAMAS DE SEDA', .5,
'2001-JAN-01');
insert into Sales values ('PIJAMAS DE LA', 117,
'2001-SEP-11');
insert into Sales values ('PIJAMAS DE SEDA', 2457,
'2001-SEP-11');
insert into Sales values ('CAMISOLAS DE LA', 2106,
'2001-SEP-11');
insert into Sales values ('SAIAS DE ALGODAO', 4797,
'2001-SEP-11');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-SEP-11');
insert into Sales values ('PIJAMAS DE SEDA', 2398.5,
'2001-FEB-21');
insert into Sales values ('SAIAS DE ALGODAO', 37791,
'2001-FEB-21');
insert into Sales values ('SAIAS DE SEDA', 3042,
'2001-FEB-21');
insert into Sales values
OOW at 'lesser'
Hi Is there 'some way' whereby 'some goodies' (presentations/papers) presented in OOW can be made available to 'lesser mortals' in 'lesser stations'? Can 'someone' please oblige? Perhaps you could IFS!!! Thanks Cyril On Tue, 27 Nov 2001 Rachel Carmichael wrote : This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her presentation for her Statspack on Monday (I think at 11) Be kind folks, I haven't even SEEN the paper or presentation yet, and I haven't really worked with statspack much. This means it will be a short presentation :) I think they call this a challenge. Rachel __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Script to Disable Constraint, Change Value, then Enable Constrain
How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27 November 2001 21:30To: Multiple recipients of list ORACLE-LSubject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: Accept user input for old data value Accept user input for new data value Disable table constraint Update record with new data value Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
Re: OEM for Personal Edition cannot connect
Title: RE: OEM for Personal Edition cannot connect make sure the OMS is installed and running "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " - Original Message - From: Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:55 Subject: RE: OEM for Personal Edition cannot connect guys, please give more details about this management server in oracle. i tried many times to connect on it... the same error i got vtk-1000..etc. never i succeeded on it thanks. Nirmal. -Original Message- From: Sinard Xing [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: OEM for Personal Edition cannot connect Hi, I'm trying using OEM for Oracle's Personal Edition 98, what is the value of Management Server ?, I tried with PC name and 127.0.0.1 both gave me error message VTK-1000: Unable to connect to management server Or perhaps OEM is not for Oracle 8i Personal Edition. Please help Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: OEM for Personal Edition cannot connect
Title: RE: OEM for Personal Edition cannot connect The management server is the service that communicates between(?) the Intelligent Agent, and the OEM client console. It runs as a service in the background under the NT/2000 services or something like that under 98.. Never used it on 98 before - my recommendation is to *never* run tools of this sort on a 9x platform as the thread management is simply not up to scratch to run the process that these tools like to spawn.. First thing to check is that the service is actually running in background. If so then check the status at a command prompt: oemctrl status oms If not then issue: oemstrl start oms or to start as a background process: oemctrl start oms You could also check the Management Servers logs: OEM_HOME\sysman\log\oms.log If you have any further errors in here (or if you are on NT check the Event Log) then act upon these errors or send them out to the list.. HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nirmal Kumar Muthu KumaranSent: 28 November 2001 09:55To: Multiple recipients of list ORACLE-LSubject: RE: OEM for Personal Edition cannot connect guys, please give more details about this management server in oracle. i tried many times to connect on it... the same error i got vtk-1000..etc. never i succeeded on it thanks. Nirmal. -Original Message- From: Sinard Xing [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: OEM for Personal Edition cannot connect Hi, I'm trying using OEM for Oracle's Personal Edition 98, what is the value of Management Server ?, I tried with PC name and 127.0.0.1 both gave me error message VTK-1000: Unable to connect to management server Or perhaps OEM is not for Oracle 8i Personal Edition. Please help Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Script to Disable Constraint, Change Value, then Enable Constrain
If the old and new data are both intended to be valid - why do you need to disable the constraint? If its a referential integrity issue - maybe a deferrable constraint (8.0+) is what you are after. hth connor --- David Wagoner [EMAIL PROTECTED] wrote: Listers, Does anyone have a script that will do the following: 1.Accept user input for old data value 2.Accept user input for new data value 3.Disable table constraint 4.Update record with new data value 5.Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Crontabs and Oracle
Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Analyze only latest partition
Hi Connor
Thanq for responding.
In dba_tab_partitions there is no such column like partition_id, and I
would like to generate a list at schema level for each table.
That means, this script should capture the latest (last) partitions for
each table (if it is partitioned) for a given schema.
Is there a way?
I tried with the following query. But there is some bug in that. It is
not capturing the last partition (in a whole database):
select object_name,owner ,subobject_name from dba_objects
where data_object_id in (select data_object_id from
dba_objects where created in(select max(created)
from dba_objects ) and data_object_id is not null);
Can anybody debug this.?
Thnx and Regards,
Srinivas
-Original Message-
Sent: Wednesday, November 28, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L
declare
pname varchar2(100);
begin
select partition_name
into pname
from user_tab_partitions
where table_name = ...
and partition_id =
( select max(partition_id)
from user_tab_partitions
where table_name = ... );
execute immediate 'analyze table ... partition
('||pname||')';
end;
or something similar to that..
hth
connor
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote: Hi lists,
Is there a script/command to analyze only the latest
partition of my
table. It has several partitions. For every month
1(one) partititon gets
created to store that months data.
Can anybody throw some script.?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email
and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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).
RE: Script to Disable Constraint, Change Value, then Enable Const
Well said Mark. David, you could also re-able the constraint 'novalidate' if you wanted to ignore the validity of any new input. If that was the case then why have an integrity constraint in the first place? John -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: 28 November 2001 10:20To: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27 November 2001 21:30To: Multiple recipients of list ORACLE-LSubject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: Accept user input for old data value Accept user input for new data value Disable table constraint Update record with new data value Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. >> This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. >>
RE: Crontabs and Oracle
Does this run from Oracles crontab ?? I would suggest that you need to set up some environment variables in the script. Export your ORACLE_HOME in the script and add the following to your path variable export PATH=$PATH:$ORACLE_HOME/bin HTH Lee -Original Message- Sent: 28 November 2001 11:00 To: Multiple recipients of list ORACLE-L Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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
RE: Object Invalid
Seema, if these invalid objects are things like triggers or procedures that your system will call at some point, then these will fail. You can find scripts that can revalidate these objects on many of the Oracle sites or if you want I can send you one. Dave -Original Message- Sent: Tuesday, November 27, 2001 9:15 PM To: Multiple recipients of list ORACLE-L Hi What could be impact if objects are having status INVALID? Thanks Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Crontabs and Oracle
Title: RE: Crontabs and Oracle I don't know if it is relevant but on Compaq Tru64 we have to su - oracle even within the oracle cron so a sample entry looks looks as follows. 10 19 * * * su - oracle -c '/usr/local/bin/tidy_listener_log.sh' etc etc Your message_is mentions Sun in which case I am sure this does not need to be done (nor HP). Hope it is useful, probably not John -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 11:00 To: Multiple recipients of list ORACLE-L Subject: Crontabs and Oracle Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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
RE: Crontabs and Oracle
Thanks John. Unfortunately I can't do an SU either :o( Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 28 November 2001 11:42 To: Multiple recipients of list ORACLE-L I don't know if it is relevant but on Compaq Tru64 we have to su - oracle even within the oracle cron so a sample entry looks looks as follows. 10 19 * * * su - oracle -c '/usr/local/bin/tidy_listener_log.sh' etc etc Your message_is mentions Sun in which case I am sure this does not need to be done (nor HP). Hope it is useful, probably not John -Original Message- mailto:[EMAIL PROTECTED] ] Sent: 28 November 2001 11:00 To: Multiple recipients of list ORACLE-L Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: Crontabs and Oracle
You need to set the profile. In the beginning of the script call your .profile to set the path and variables. Then set your SID if necessary. . /opt/oracle/.profile . envora SID sqlplus / @somesql.sql exit Michael Koniszewski D.B.A. FairPoint Communications 518-242-5922 -Original Message- From: Thomas, Kevin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:01 AM To: Multiple recipients of list ORACLE-L Subject: Crontabs and Oracle Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
RE: Problem Starting SQL Loader
This appears to be working. Thanks, Ken -Original Message- Sent: Tuesday, November 27, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Subject:Re: Problem Starting SQL Loader Ken, Sqlldr is a stanalone utility, it doesn't run from inside SQL*Plus, it runs from the OS command line. Take a look at the utilities manual for the docs on sqlldr. Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Problem Starting SQL Loader [EMAIL PROTECTED] om 11/27/01 02:00 PM Please respond to ORACLE-L I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at the command prompt I get this error: SP2-0042: unknown command sqlldr - rest of line ignored. I'm calling it from my client PC and the DB is located on a separate server. How do I get this to work? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Listers meeting at OOW
good tequila too -Original Message- Sent: Tuesday, November 27, 2001 8:05 PM To: Multiple recipients of list ORACLE-L Chevy's was good, we will need a reservation -- and it's loud but everything will be loud --- John Kanagaraj [EMAIL PROTECTED] wrote: Hi all, I don't know the SF restaurants well enough, but Chevy's seems good enough. Howard and 3rd is close enough to Moscone. I will also be attending only the vendor exhibits, but will certainly meet the listers if all agree to this location/date/time. (I am hoping y'all will!!) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Molina, Gerardo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 1:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listers meeting at OOW Chevy's at Howard and 3rd is a good spot. I'll probably be attending only the vendor exhibits but I'll try to make the list get-together. Gerardo -Original Message- Sent: Tuesday, November 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L To continue the discussion on getting together at Openworld: How about Tuesday evening, around 7:00? Someone who knows downtown SF want to suggest a place? My preference is not too loud or too smoky. Call out on the list if you are going to come, so we can keep track of how many chairs to steal from nearby tables. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Loughmiller, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
RE: Problem Starting SQL Loader
I tried it from the command prompt and got in. Thanks, Ken -Original Message- Sent: Tuesday, November 27, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject:Re: Problem Starting SQL Loader sqlldr is not a sqlplus command - it needs to be called from the OS command line. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 5:00 PM I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at the command prompt I get this error: SP2-0042: unknown command sqlldr - rest of line ignored. I'm calling it from my client PC and the DB is located on a separate server. How do I get this to work? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Crontabs and Oracle
Also, in the crontab entry, make sure u have an entry somewhat like this : 20 8 * * * su - oracle -c '/path of the script/name of the script' /dev/null 21 which means that the script will run at 8:30 every morning on all days of the week. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 28 November 2001 11:35 To: Multiple recipients of list ORACLE-L Does this run from Oracles crontab ?? I would suggest that you need to set up some environment variables in the script. Export your ORACLE_HOME in the script and add the following to your path variable export PATH=$PATH:$ORACLE_HOME/bin HTH Lee -Original Message- Sent: 28 November 2001 11:00 To: Multiple recipients of list ORACLE-L Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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
RE: Oracle/UNIX vs. Oracle/NT
Here are my comments, speaking from personal experience as an Oracle DBA for 3 years on Tru64 UNIX and NT databases. I am also doubling as the NT administrator now. There is another Oracle DBA (more experienced than me), and there are 3 UNIX system administrators. 10 NT servers (2 old OWS 3.0.1.1., 2 iAs 9i, 1 used to have 5 7.3.4.4. instances on it, one has 3 8.1.7. instances on it), with 5 Digital (sorry, Compaq) Tru64 UNIX servers, with 1-3 instances on them). This is my perception at this point. Microsoft marketing is very strong. Managers use Windows9x/ME, so they think WindowsNT/2000 is easy too. Heck they know little about computers and they can run MS Office and Outlook no problem, imagine what the techies downstairs could do with the server OS from Microsoft! Most managers don't use computers - they need the latest laptops etc. for office status purposes, but they don't use them for much more than running MS Office and Outlook. They read ComputerWorld and they see PC Magazine and PC World in the pharmacies, that's about it. They also notice that none of the UNIX vendors ever advertise on TV (what's up with that?). The people who decide where to spend the money are not the people who have to work with the systems. In a good shop they would consult the people below, but often they end up deciding first and arguing (or delaying purchase indefinitely) if the techies down below question their decision). Do they take into account replacing all their servers to keep NT/2000 running? I imagine their existing machines can't run NT or Windows2000. The point someone else made about training is a valid one, management may be thinking that training is not required at all for NT because it's a Windows OS and the techies can do anything, or that MCSEs are a dime a dozen now so staff costs will be lower. Problem is, they will need more staff to keep the NT servers going than for an equivalent number of UNIX machines - once a UNIX box runs, it runs reliably. UNIX machines are not affected by the likes of NIMDA, BackOrifice and other tools out there. Most hackers don't have grudges against UNIX systems, but they certainly do against Microsoft. Have you updated your virus files lately? If using McAfee, is your engine up to date? Have you checked your Event Viewer security log? Has auditing even been enabled on your system? You realize that auditing is shut off by default on NT. (also not taught in the NT4 MCSE classes). Anyone with a copy of a server's ERD can crack the passwords of all the user accounts that server has seen since the OS was installed. If someone gets the ERD from your BDC or PDC, you are royally screwed. How many ERDs are lying around in your computer room? Do contractors / term / casual employees ever go in there, and do any of them have any reason to be unhappy with the way your company is treating them? If one ERD is missing, how long will it take for anyone to notice? The attitude that NT is just Windows doesn't help security at all, the OS has to be taken seriously. If your machines have to be secure, get ready to spend time doing it. More time than if it was a UNIX host. Web servers should use something other than IIS, IIS is popular because... it's freeware. The Gardner Group earlier this year advised people not to use IIS, because it is not secure. iAS went with Apache on Windows, which is a bit of an oxymoron, Apache should be running on UNIX. iAS made the right decision, but it illustrates that the OS ends up running a UNIX web server ported to NT. Like it is used to run a UNIX-based database (Oracle) on NT. Why not just use UNIX? To do remote admin, they will have to purchase a 3rd party tool like PC Duo if they are using NT. NT assumes an administrator would be at the server. You can't telnet to NT systems because NT behaves like a home operating system, it assumes you are sitting at the machine (may be possible with Windows2000, not sure). You can purchase 3rd party telnet software, but you won't have access to the desktop. Scripting on NT is not as user-friendly as it is in UNIX. Retrieve from archives those old DOS scripting books. NT and Windows2000 offer more commands, but at the core the scripting is still the same. The AT command used to run scripts on schedule in NT 4.0 is 99.9% reliable, but not 100% reliable. I ended up having to install a 3rd party utility called crontab for Windows to keep my backup scripts running reliably. The time clock keeps slipping back, esp. if your CPU is busy. So you will have to hook up the machine to a time server somewhere. Every time there is a new version, you have to purchase it and upgrade the hardware. Much of your 3rd party and your in-house applications will have to be ported to the new version. I don't know if this is the case with UNIX variants. NT carries along with it a huge kernel, and a thick layer of graphics on top of it. To make all that work at a speed equivalent to UNIX, it
Re: guess I'm presenting at OOW
and as long as Gaja or Kirti are in the room, it's cool :) --- Connor McDonald [EMAIL PROTECTED] wrote: You just open up with: This is statspack. You install it with spcreate, collect stats with a pl/sql call, and report with spreport.sql. Then you interpret the myriad the results - but of course, that is a tuning discussion not a statspack one...Questions anyone? :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her presentation for her Statspack on Monday (I think at 11) Be kind folks, I haven't even SEEN the paper or presentation yet, and I haven't really worked with statspack much. This means it will be a short presentation :) I think they call this a challenge. Rachel __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Problem Starting SQL Loader
It appears to be running from the command prompt. Ken -Original Message- Sent: Tuesday, November 27, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Subject:Re: Problem Starting SQL Loader Hi Ken, SQlldr is not a sqlplus command. It will need to be run from the OS like sqlplus. Good Luck [EMAIL PROTECTED] wrote: I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at the command prompt I get this error: SP2-0042: unknown command sqlldr - rest of line ignored. I'm calling it from my client PC and the DB is located on a separate server. How do I get this to work? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Oracle 7.2 32 bit Oracle Ole Objects
Hi, Does anyone know how I can get a copy of 16 bit Oracle 7.2 Oracle Ole Objects to install? I know probably next to impossible to find but any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Crontabs and Oracle
sounds like the path got overwritten in cron try to do the full path specification to the sqlplus binary and see if that fixes it --- Thomas, Kevin [EMAIL PROTECTED] wrote: Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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
Re: Checking DB Status in NT env.
How about oem using the dbupdown predefined event. [EMAIL PROTECTED] wrote: connect scott/tiger@sid select 'PING' from dual; If you receive an output from the database you can pretty much say it's up and running don't you think? If you get an error anywhere along this path - you have a problem.. Mark -Original Message- Sent: 27 November 2001 19:55 To: Multiple recipients of list ORACLE-L Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Analyze only latest partition
Title: RE: Analyze only latest partition
Hi
Why not you can try with partition related dictionary views:
Here is my query:
[EMAIL PROTECTED] select table_name, partition_name, high_value,
partition_position from dba_tab_partitions a where partition_position =
(select max(partition_position)
2 from user_tab_partitions b where a.table_name=b.table_name)
3 ;
TABLE_NAME PARTITION_NAME
-- --
HIGH_VALUE
PARTITION_POSITION
--
EMP_PART P4
maxvalue
4
EMP_PART1 P4
maxvalue
2
EMP_PART2 P2
9000
3
[EMAIL PROTECTED] ALTER TABLE EMP_PART2 ADD PARTITION P4 VALUES
LESS THAN(1);
Table altered.
[EMAIL PROTECTED] select table_name, partition_name, high_value,
partition_position from dba_tab_partitions a where partition_position =
(select max(partition_position)
2 from user_tab_partitions b where a.table_name=b.table_name)
3 ;
TABLE_NAME PARTITION_NAME
-- --
HIGH_VALUE
PARTITION_POSITION
--
EMP_PART P4
maxvalue
4
EMP_PART1 P4
maxvalue
2
EMP_PART2 P4
1
4
[EMAIL PROTECTED]
RGDS,
nIRMAL.
-Original Message-
From: Tatireddy, Shrinivas (MED, Keane) [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Analyze only latest partition
Hi Connor
Thanq for responding.
In dba_tab_partitions there is no such column like partition_id, and I
would like to generate a list at schema level for each table.
That means, this script should capture the latest (last) partitions for
each table (if it is partitioned) for a given schema.
Is there a way?
I tried with the following query. But there is some bug in that. It is
not capturing the last partition (in a whole database):
select object_name,owner ,subobject_name from dba_objects
where data_object_id in (select data_object_id from
dba_objects where created in(select max(created)
from dba_objects ) and data_object_id is not null);
Can anybody debug this.?
Thnx and Regards,
Srinivas
-Original Message-
Sent: Wednesday, November 28, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L
declare
pname varchar2(100);
begin
select partition_name
into pname
from user_tab_partitions
where table_name = ...
and partition_id =
( select max(partition_id)
from user_tab_partitions
where table_name = ... );
execute immediate 'analyze table ... partition
('||pname||')';
end;
or something similar to that..
hth
connor
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote: Hi lists,
Is there a script/command to analyze only the latest
partition of my
table. It has several partitions. For every month
1(one) partititon gets
created to store that months data.
Can anybody throw some script.?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California -- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email
and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access /
Audit vs Logminer
8i Database, W2K server. Apps team looking for audit trail functionality. I've outlined the pros and cons of Oracle Audit vs using Logminer to extract audit info from archived redo logs as below: - Archiving of Redo Logs will be carried out in any case. - All required auditing data as far as I can determine would be captured in redo logs. - Using Logminer to investigate them looks like it would be more difficult than using Oracles Auditing features. - Introducing Oracle Auditing has limited functionality and has a performance overhead. - Oracle auditing would require programming of triggers to capture before and after values which in turn has another potential performance hit. - Oracle audit data needs to be monitored and requires additional management time. I've not used Oracle Auditing or Logminer so the above is based upon some reading I've done. If I've missed any important points please give me feedback on same. Also anyone any opinions, or better still experience, as to which is better from performance POV. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
enable the partitioning option in database?.
Title: enable the partitioning option in database?. hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE Parallel Server FALSE Java FALSE Rgds, Nirmal.
RE: Unable to run catalog.sql
Title: RE: Unable to run catalog.sql I am connected as sys. Ken -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 4:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unable to run catalog.sql the catalog.sql Must be run when connected to SYS or INTERNAL. Is it true for ur case? Nirmal., -Original Message- From: Ken Janusz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Unable to run catalog.sql I have tried to run catalog.sql from the sql*plus command line and keep getting this error. sp2-0310 unable to open file catalog.sql. I've use the full path name with the same results. catalog.sql is on my PC and the database is located on a server. I have run other commands from my client machine with no problems. What appears to be the problem? TIA Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Oracle Finacials and pdf report generation
Hi! Unfortunately or maybe fortunately :-)? this is a problem of my friend, no my own, so I don't know more details, at least now. It is following: There are two servers running Oracle Financials production and test, they both produces reports in pdf format. And the problem is that test database generates font names all in lowercase and of course Acrobat reader doesn't understand these fonts and replaces them with default ones. When font names are changed to appropriate case (using some text editor) all is OK. In the same time in the production database all is OK, reports are generated correctly. Their skills are too limited to find any differences. Where could be problem? Any ideas? If you need more details let me know. TIA, Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Oracle8i on WinNT - renaming disc drives
Sonja, It is a complicated process to rename disk drives in the Oracle environment. Depending in the drives that Oracle uses and what are changes(renamed) could really cause you frustration. The initxxx.ora lists the current location of the controlfiles, logfiles, dump dirs, trace dirs, etc. You will have to startup the database (if it can find the controlfile) and alter database rename .. to .. for each of the effected datafiles. It can be a long and detailed process. These are just a few thoughts off the top of my head. Make notes and document everything to CYA. Good Luck ROR mª¿ªm [EMAIL PROTECTED] 11/28/01 05:20AM List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: OEM for Personal Edition cannot connect
Title: RE: OEM for Personal Edition cannot connect the Management server cannot run on windows 9x. [EMAIL PROTECTED] wrote: guys, please give more details about this management server in oracle. i tried many times to connect on it... the same error i got vtk-1000..etc. never i succeeded on it thanks. Nirmal. -Original Message- From: Sinard Xing [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: OEM for Personal Edition cannot connect Hi, I'm trying using OEM for Oracle's Personal Edition 98, what is the value of Management Server ?, I tried with PC name and 127.0.0.1 both gave me error message VTK-1000: Unable to connect to management server Or perhaps OEM is not for Oracle 8i Personal Edition. Please help Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: guess I'm presenting at OOW
Rachel, Don't worry, if you want, I will bring Don's book with me... Tuning with Statspack (I think that's what it's called). And btw, I liked Conner's idea very much.. just keep it a QA session after those opening remarks. I will write up a good review for you.. - Kirti -Original Message- Sent: Wednesday, November 28, 2001 6:55 AM To: Multiple recipients of list ORACLE-L and as long as Gaja or Kirti are in the room, it's cool :) --- Connor McDonald [EMAIL PROTECTED] wrote: You just open up with: This is statspack. You install it with spcreate, collect stats with a pl/sql call, and report with spreport.sql. Then you interpret the myriad the results - but of course, that is a tuning discussion not a statspack one...Questions anyone? :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her presentation for her Statspack on Monday (I think at 11) Be kind folks, I haven't even SEEN the paper or presentation yet, and I haven't really worked with statspack much. This means it will be a short presentation :) I think they call this a challenge. Rachel __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Connection question?
Title: RE: Connection question?
Hi Deepak
Here's what the doco says
The Bequeath protocol glossary.htm enables clients that exist on the same machine as the server to retrieve information from the database without using the listener. The Bequeath protocol internally spawns a dedicated server process for each client applications. In a sense, it does the same operation that a remote network listener does for your connection, yet locally.
Bequeath is used for local connections where an Oracle client application, such as SQL*Plus, communicates with an Oracle server running on the same machine
Tell me if I'm wrong but here's my take on it: When I connect from my pc, there's a process on my PC and there's a corresponding process on the database, say on a Unix server. Though the connection was initiated remotely, the process itself on the db server is still a local process that exists to communicate with the database.
Am I wrong? If so let me know.
-Original Message-
From: Deepak Thapliyal [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Connection question?
hey lisa
Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)
thoughts ..?
Thx
Deepak
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?
Hi
WHen I execute ps -ef |grep LOCAL on Solaris
server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California -- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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).
RE: Oracle/UNIX vs. Oracle/NT
Patrice, Thank you very much for the time you spent putting this together. It is VERY informative, and I am keeping it forever! thanks again! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, November 28, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Here are my comments, speaking from personal experience as an Oracle DBA for 3 years on Tru64 UNIX and NT databases. I am also doubling as the NT administrator now. There is another Oracle DBA (more experienced than me), and there are 3 UNIX system administrators. 10 NT servers (2 old OWS 3.0.1.1., 2 iAs 9i, 1 used to have 5 7.3.4.4. instances on it, one has 3 8.1.7. instances on it), with 5 Digital (sorry, Compaq) Tru64 UNIX servers, with 1-3 instances on them). This is my perception at this point. Microsoft marketing is very strong. Managers use Windows9x/ME, so they think WindowsNT/2000 is easy too. Heck they know little about computers and they can run MS Office and Outlook no problem, imagine what the techies downstairs could do with the server OS from Microsoft! Most managers don't use computers - they need the latest laptops etc. for office status purposes, but they don't use them for much more than running MS Office and Outlook. They read ComputerWorld and they see PC Magazine and PC World in the pharmacies, that's about it. They also notice that none of the UNIX vendors ever advertise on TV (what's up with that?). The people who decide where to spend the money are not the people who have to work with the systems. In a good shop they would consult the people below, but often they end up deciding first and arguing (or delaying purchase indefinitely) if the techies down below question their decision). Do they take into account replacing all their servers to keep NT/2000 running? I imagine their existing machines can't run NT or Windows2000. The point someone else made about training is a valid one, management may be thinking that training is not required at all for NT because it's a Windows OS and the techies can do anything, or that MCSEs are a dime a dozen now so staff costs will be lower. Problem is, they will need more staff to keep the NT servers going than for an equivalent number of UNIX machines - once a UNIX box runs, it runs reliably. UNIX machines are not affected by the likes of NIMDA, BackOrifice and other tools out there. Most hackers don't have grudges against UNIX systems, but they certainly do against Microsoft. Have you updated your virus files lately? If using McAfee, is your engine up to date? Have you checked your Event Viewer security log? Has auditing even been enabled on your system? You realize that auditing is shut off by default on NT. (also not taught in the NT4 MCSE classes). Anyone with a copy of a server's ERD can crack the passwords of all the user accounts that server has seen since the OS was installed. If someone gets the ERD from your BDC or PDC, you are royally screwed. How many ERDs are lying around in your computer room? Do contractors / term / casual employees ever go in there, and do any of them have any reason to be unhappy with the way your company is treating them? If one ERD is missing, how long will it take for anyone to notice? The attitude that NT is just Windows doesn't help security at all, the OS has to be taken seriously. If your machines have to be secure, get ready to spend time doing it. More time than if it was a UNIX host. Web servers should use something other than IIS, IIS is popular because... it's freeware. The Gardner Group earlier this year advised people not to use IIS, because it is not secure. iAS went with Apache on Windows, which is a bit of an oxymoron, Apache should be running on UNIX. iAS made the right decision, but it illustrates that the OS ends up running a UNIX web server ported to NT. Like it is used to run a UNIX-based database (Oracle) on NT. Why not just use UNIX? To do remote admin, they will have to purchase a 3rd party tool like PC Duo if they are using NT. NT assumes an administrator would be at the server. You can't telnet to NT systems because NT behaves like a home operating system, it assumes you are sitting at the machine (may be possible with Windows2000, not sure). You can purchase 3rd party telnet software, but you won't have access to the desktop. Scripting on NT is not as user-friendly as it is in UNIX. Retrieve from archives those old DOS scripting books. NT and Windows2000 offer more commands, but at the core the scripting is still the same. The AT command used to run scripts on schedule in NT 4.0 is 99.9% reliable, but not 100% reliable. I ended up having to install a 3rd party utility called crontab for Windows to keep my backup scripts running reliably. The time clock keeps slipping back, esp. if your CPU is busy. So you will have to hook up the machine to a time server somewhere. Every time there is a new version, you have to purchase it and upgrade the
For You Telnet Experts
I cannot get svrmgrl to run at the Command Prompt or sql*plus prompt. I keep getting an error - unrecognized command. When I try to get Telnet to connect to the server it won't. Could this be the problem of why svrmgrl won't work? I need svrmgrl to run my cat scripts. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Oracle/UNIX vs. Oracle/NT
Thank you very much to all that responded and contributed their time. I'll be saving this thread! I got more anecdotal evidence than I thought I might. Can it be true that few more-formal reports have been written on this subject? It sure seems like a hot-button issue. Thanks again, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 9:15 AM Patrice, Thank you very much for the time you spent putting this together. It is VERY informative, and I am keeping it forever! thanks again! Tom Mercadante Oracle Certified Professional Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Off Topic - Windows XP Dialup connection
This is off topic but I am trying to find someone with experience on Windows XP. I am trying to use a dial up connection to connect to my office network from home. I get connected but my NT logon proc doesn't execute so I cannot see the all of the network domains. This connection worked under Windows 98 and ME. Any suggestions? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
OT: SqlSever 2000 question
Hi All, Sorry for OT but I am very new(few hours) to sql server and need help with constructing a query. I have 2 tables Table1 Table2 id id name, county state There is 1 - many from table1 to table2 I want to retrieve each record in table1 along with all the counties in table2 for that ID in one record For ex. 1,SmithJ,TN,county1 | county2 | county3 | countyN Any ideas, Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
OCP tests
Tom, Am thinking of taking the OCP tests early next year..could u please suggest me a really good and comprehensive guide book for the same ?? There r quite a few of them available on Amazon but I am confused now as to which of these is really good. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Oracle8i on WinNT - renaming disc drives
Ron, When you say log files in the init.ora I assume you mean archive log files. (Mr. P. Dantic) Anyway, getting back to the task at hand, a far easier way to do it is to issue a backup controlfile to trace. Change the location of the files in the trace file you have generated, shutdown the DB, move the files to the new locations you have specified in the trace file. Run the trace file you have edited and open your DB. This is a very simplistic explanation of the process but it is foolproof, it is widely documented on the web and in my experience works everytime, I have had to do this many times without any issues. BACK IT UP FIRST, do the process and BACK IT UP AGAIN ! HTH Lee -Original Message- Sent: 28 November 2001 14:05 To: Multiple recipients of list ORACLE-L Sonja, It is a complicated process to rename disk drives in the Oracle environment. Depending in the drives that Oracle uses and what are changes(renamed) could really cause you frustration. The initxxx.ora lists the current location of the controlfiles, logfiles, dump dirs, trace dirs, etc. You will have to startup the database (if it can find the controlfile) and alter database rename .. to .. for each of the effected datafiles. It can be a long and detailed process. These are just a few thoughts off the top of my head. Make notes and document everything to CYA. Good Luck ROR mª¿ªm [EMAIL PROTECTED] 11/28/01 05:20AM List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
OpenWorld dispatches
I'll be attending OpenWorld this year, and, as in years past, I'll be writing daily dispatches from the show. If you're interested, you can read my preview dispatch at the following URL: http://oracle.oreilly.com/news/openworld_preview_01.html Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Oracle/UNIX vs. Oracle/NT
I forgot to mention, two years ago I tried to use the NT Performance Monitor to track usage of five Oracle 7.3.4.4. databases on one NT server, and learned that Performance Monitor only lets you monitor one database at once. I don't know if this is still the case with 8i and Win2K, but it tells me that NT wasn't written to track multiple copies of the same program, it was designed to run one copy of each program. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle/UNIX vs. Oracle/NT Here are my comments, speaking from personal experience as an Oracle DBA for 3 years on Tru64 UNIX and NT databases. I am also doubling as the NT administrator now. There is another Oracle DBA (more experienced than me), and there are 3 UNIX system administrators. 10 NT servers (2 old OWS 3.0.1.1., 2 iAs 9i, 1 used to have 5 7.3.4.4. instances on it, one has 3 8.1.7. instances on it), with 5 Digital (sorry, Compaq) Tru64 UNIX servers, with 1-3 instances on them). This is my perception at this point. Microsoft marketing is very strong. Managers use Windows9x/ME, so they think WindowsNT/2000 is easy too. Heck they know little about computers and they can run MS Office and Outlook no problem, imagine what the techies downstairs could do with the server OS from Microsoft! Most managers don't use computers - they need the latest laptops etc. for office status purposes, but they don't use them for much more than running MS Office and Outlook. They read ComputerWorld and they see PC Magazine and PC World in the pharmacies, that's about it. They also notice that none of the UNIX vendors ever advertise on TV (what's up with that?). The people who decide where to spend the money are not the people who have to work with the systems. In a good shop they would consult the people below, but often they end up deciding first and arguing (or delaying purchase indefinitely) if the techies down below question their decision). Do they take into account replacing all their servers to keep NT/2000 running? I imagine their existing machines can't run NT or Windows2000. The point someone else made about training is a valid one, management may be thinking that training is not required at all for NT because it's a Windows OS and the techies can do anything, or that MCSEs are a dime a dozen now so staff costs will be lower. Problem is, they will need more staff to keep the NT servers going than for an equivalent number of UNIX machines - once a UNIX box runs, it runs reliably. UNIX machines are not affected by the likes of NIMDA, BackOrifice and other tools out there. Most hackers don't have grudges against UNIX systems, but they certainly do against Microsoft. Have you updated your virus files lately? If using McAfee, is your engine up to date? Have you checked your Event Viewer security log? Has auditing even been enabled on your system? You realize that auditing is shut off by default on NT. (also not taught in the NT4 MCSE classes). Anyone with a copy of a server's ERD can crack the passwords of all the user accounts that server has seen since the OS was installed. If someone gets the ERD from your BDC or PDC, you are royally screwed. How many ERDs are lying around in your computer room? Do contractors / term / casual employees ever go in there, and do any of them have any reason to be unhappy with the way your company is treating them? If one ERD is missing, how long will it take for anyone to notice? The attitude that NT is just Windows doesn't help security at all, the OS has to be taken seriously. If your machines have to be secure, get ready to spend time doing it. More time than if it was a UNIX host. Web servers should use something other than IIS, IIS is popular because... it's freeware. The Gardner Group earlier this year advised people not to use IIS, because it is not secure. iAS went with Apache on Windows, which is a bit of an oxymoron, Apache should be running on UNIX. iAS made the right decision, but it illustrates that the OS ends up running a UNIX web server ported to NT. Like it is used to run a UNIX-based database (Oracle) on NT. Why not just use UNIX? To do remote admin, they will have to purchase a 3rd party tool like PC Duo if they are using NT. NT assumes an administrator would be at the server. You can't telnet
RE: enable the partitioning option in database?.
Title: RE: enable the partitioning option in database?. Go through the installer again and install the partitioning option. By the way you have to be running Enterprise Edition. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: enable the partitioning option in database?. hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE Parallel Server FALSE Java FALSE Rgds, Nirmal.
RE: Connection question?
Afternoon Lisa,
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
Thanks,
Harry Lowes
Database Administrator,
npower Northern Limited
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L
Hi Deepak
Here's what the doco says
The Bequeath protocol glossary.htm enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally.
Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine
Tell me if I'm wrong but here's my take on it: When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server. Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.
Am I wrong? If so let me know.
-Original Message-
Sent: Tuesday, November 27, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L
hey lisa
Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)
thoughts ..?
Thx
Deepak
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject:Connection question?
Hi
WHen I execute ps -ef |grep LOCAL on Solaris
server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
FAX: (858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1 http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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).
E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree to be bound
by its terms.
The information contained in this e-mail
Re: enable the partitioning option in database?.
Nirmal, That option is loaded and installed from the source CD using the GUI installer program. I think it is only available on the EE and there is a co$t. ROR mª¿ªm [EMAIL PROTECTED] 11/28/01 08:55AM hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE Parallel Server FALSE Java FALSE Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Oracle8i on WinNT - renaming disc drives
If by "rename disk drives" means changing the drive letter where Oracle is installed. You may have to re-install Oracle since the regisry will now have the wrong values. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 11/28/01 9:55:31 AM Ron,When you say log files in the init.ora I assume you mean archive log files.(Mr. P. Dantic)Anyway, getting back to the task at hand, a far easier way to do it is toissue a backup controlfile to trace. Change the location of the files in thetrace file you have generated, shutdown the DB, move the files to the newlocations you have specified in the trace file. Run the trace file you haveedited and open your DB.This is a very simplistic explanation of the process but it is foolproof, itis widely documented on the web and in my experience works everytime, I havehad to do this many times without any issues.BACK IT UP FIRST, do the process and BACK IT UP AGAIN !HTHLee-Original Message-Sent: 28 November 2001 14:05To: Multiple recipients of list ORACLE-LSonja,It is a complicated process to rename disk drives in the Oracleenvironment. Depending in the drives that Oracle uses and what arechanges(renamed) could really cause you frustration.The initxxx.ora lists the current location of the controlfiles, logfiles,dump dirs, trace dirs, etc.You will have to startup the database (if it can find the controlfile) and"alter database rename .. to .." for each of the effected datafiles. It canbe a long and detailed process. These are just a few thoughts off the top ofmy head.Make notes and document everything to CYA.Good LuckROR mª¿ªm [EMAIL PROTECTED] 11/28/01 05:20AM List hi!Oracle 8.1.7 on WinNT.Our Windows guys want to rename disc drives for some administration reasons.I'm really in UNIX so I'm wondering could you give me some advices on thismatter.As far as I know, I have to recreate control files, with new drives. Isthere anything else I should do? Some Windows stuff?TIA, Sonja-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: For You Telnet Experts
Assuming this is Unix of some kind: Are the binaries (svrmgrl/sqlplus) in your path ($ORACLE_HOME/bin) and environmental variables set (ie. $ORACLE_HOME)? Is the telnetd daemon running to receive telnet requests (ps -ef | grep telnetd)? Problems connecting with telnet and using svrmgrl or sqlplus from the console are unrelated (separate issues). Best, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 8:10 AM I cannot get svrmgrl to run at the Command Prompt or sql*plus prompt. I keep getting an error - unrecognized command. When I try to get Telnet to connect to the server it won't. Could this be the problem of why svrmgrl won't work? I need svrmgrl to run my cat scripts. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: enable the partitioning option in database?.
Nirmal - Don't forget that partitioning is an extra-pay item beyond EE licensing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Destination address unreachable
The utility is not included with Solaris until 2.8. You'll have to get it from http://www.sunfreeware.com/ Solaris 2.6 - http://www.sunfreeware.com/programlist.html#gzip Solaris 2.7 - http://www.sunfreeware.com/programlistsparc7.html#gzip -Original Message- Sent: Tuesday, November 27, 2001 4:47 PM To: Multiple recipients of list ORACLE-L -- From: Baker, Barbara Sent: Tuesday, November 27, 2001 4:42 PM To: '[EMAIL PROTECTED]' Subject: FW: unzip utility information You might have a pathing problem (i.e., unzip is there, but you have to specify the full directory path to execute it.) at the command line, type which unzip This should find the unzip utility down the correct path. If it returns a result, try specifying the full path name, for example /usr/bin/unzip OEM204_1.zip Good luck! Barb -- From: hari babu gottipati[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: unzip utility information hi friends if anyone knows about the unzip command in solaris 2.6/2.7 .please mail me.ex.OEM204_1.zip file.and i am not getting unzip command by using man pages.can i needed to down load any unzip file. pl. mail command as early thanking to all -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: enable the partitioning option in database?.
Title: RE: enable the partitioning option in database?. In addition, one needs to have License to use Partitioning. - Kirti -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 9:31 AMTo: Multiple recipients of list ORACLE-LSubject: RE: enable the partitioning option in database?. Go through the installer again and install the partitioning option. By the way you have to be running Enterprise Edition. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: enable the partitioning option in database?. hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETERVALUEPartitioningFALSE Parallel ServerFALSE JavaFALSE Rgds,Nirmal.
RE: Script to Disable Constraint, Change Value, then Enable Const
I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: Unable to run catalog.sql
Kurt: Thanks I'll give this a try. Ken -Original Message- Sent: Wednesday, November 28, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject:RE: Unable to run catalog.sql Ken, I went out to metalink and did a search on SP2-0310; this is the result. I hope it proves useful. Kurt Wiegand IBM Global Services Cable Wireless Communications 703 760-3619 Bookmark Fixed font Go to End Doc ID: Note:121371.1 Type: PROBLEM Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-OCT-2000 Last Revision Date: 02-FEB-2001 * This article is being delivered in Draft form and may contain errors. Please use the MetaLink Feedback button to advise Oracle of any issues related to this article. * Problem Description --- You have created a SQL script and saved it to a directory on your PC hard drive (for example c:\script). You are able to execute this script in SQL*Plus by entering the following command: SQL@C:\script\myscript.sql However, when you try to open the script file in the SQL*Plus session, via Top Menu Bar -- File -- Open -- you receive an error: SP2-0310: unable to open file c:\script\myscript.sql Solution Description This error can be eliminated by doing one of the following workarounds: 1. Within the SQL*Plus window, enter the following command: SQL set editfile C:\script (directory where scripts are saved) NOTE: This will allow you to open the myscript.sql file without encountering any errors, but the setting will only be retained for the current session. If you would like to make this a permanent change, add the above command to the login.sql file on your PC. 2. Update the Windows Registry to add, or edit, the SQLPATH variable: On Windows PC, go to Start -- Run -- Regedit -- HKEY_LOCAL_MACHINE -- Software --- Oracle --- desired Home (could be HOME0, HOME1, etc.) and add/modify new string value for SQLPATH. Once the string is added, you can edit it to specify the directory where your SQL scripts are stored. You can have multiple directories, but each directory must be separated by a semicolon (;). Explanation --- The SP2-0310 is an abnormal error condition. In a default Windows installation, this error should not occur when trying to open a file in the manner described. By setting the editfile or SQLPATH, the errors is resolved. The SQLPATH variable is used as the search path when SQL*Plus executes scripts. By default, SQL*Plus, will first search in the Oracle_Home\bin directory and then any directories specified in the SQLPATH variable. References -- Other Related documents or causes for this error: Bug 883193, SP2-310 CANNOT SPECIFY A DIRECTORY WITH SPACES IN BETWEEN Bug 935869, SLDEXT FUNCTION DOES NOT RECOGNIZE ? AS A ORACLE Note 105052.1, Does SQL*Plus not recognize files in directories with spaces in their names? Additional Search Words --- path,plus80, script, plus81, SP2 . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. -Original Message- Sent: Wednesday, November 28, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I am connected as sys. Ken -Original Message- Sent: Wednesday, November 28, 2001 4:05 AM To: Multiple recipients of list ORACLE-L the catalog.sql Must be run when connected to SYS or INTERNAL. Is it true for ur case? Nirmal., -Original Message- Sent: Tuesday, November 27, 2001 10:00 PM To: Multiple recipients of list ORACLE-L I have tried to run catalog.sql from the sql*plus command line and keep getting this error. sp2-0310 unable to open file catalog.sql. I've use the full path name with the same results. catalog.sql is on my PC and the database is located on a server. I have run other commands from my client machine with no problems. What appears to be the problem? TIA Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). --
RE: Unable to run catalog.sql
Another idea would be to set the SQLPATH variable in your registry (remember if you do this to TAKE A BACKUP OF THE REGISTRY FIRST). First of all map the network drive (it looks like you already have anyway) so that it is assigned a drive letter (D:\ in your case), as you don't really want to use the absolute path.. Open regedit or regedt32, and navigate to HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/ORACLE_HOME and then either modify (if it is already there) or create a SQLPATH string, with a value of: D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql Maybe this will work? Mark -Original Message- Sent: 28 November 2001 16:23 To: 'Mark Leith' Mark: This was a typo and I tried it again and got the same error message. The absolute full path name is: My Network Places\Entire Network\Microsoft Windows Network\Tech net\Proteus\ Oracle\Ora81\RDMS\ADMIN\catalog.sql The server name is Proteus. I have run scripts to generate tablespaces referencing the D:\ drive and they worked OK. Any ideas? Ken -Original Message- Sent: Wednesday, November 28, 2001 10:20 AM To: Ken Janusz Subject:RE: Unable to run catalog.sql Ken, Taking a look at what you are trying to run, you have the path wrong: @D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql should be: @D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql ^ | Will this work? Mark -Original Message- Sent: 28 November 2001 13:16 To: 'Mark Leith' Mark: This is what I have tried at the SQL*Plus prompt. nic13 @D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql SP2-0310: unable to open file D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql Still get the error. Would this have anything to do with Telnet working or not? My Telnet connection between my client PC and the server doesn't work. Thanks, Ken -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 4:20 AM To: Multiple recipients of list ORACLE-L Subject:RE: Unable to run catalog.sql It might be a PATH issue, try creating an entry in your PATH statement on *your PC* that has the full path to the directory that holds catalog.sql. -Original Message- Sent: 27 November 2001 19:00 To: Multiple recipients of list ORACLE-L I have tried to run catalog.sql from the sql*plus command line and keep getting this error. sp2-0310 unable to open file catalog.sql. I've use the full path name with the same results. catalog.sql is on my PC and the database is located on a server. I have run other commands from my client machine with no problems. What appears to be the problem? TIA Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Siebel.
Hi Gang, Does anybody use Siebel - I believe it's a CRM package? I'm trying to find out of the Siebel application enforces RI within the database or the application? Anybody know? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Oracle8i on WinNT - renaming disc drives
If the path to ORACLE_HOME changes, you will need to reinstall the software to correct the jar files in oraInventory. Otherwise the wonderful OUI will get confused the next time you need to apply an rdbms patch. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] sonja.sehovic @pbz.hr To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Oracle8i on WinNT - renaming disc drives com 11/28/01 03:20 AM Please respond to ORACLE-L List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Connection question?
Title: RE: Connection question?
Hi Harry,
I admit ignorance. Networking was never my strong point. IN fact sometimes I wonder if I still have one.
Thanks for your response.
Lisa
-Original Message-
From: Lowes, Harry (NESL-IT) [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Connection question?
Afternoon Lisa,
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
Thanks,
Harry Lowes
Database Administrator,
npower Northern Limited
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L
Hi Deepak
Here's what the doco says
The Bequeath protocol glossary.htm enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally.
Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine
Tell me if I'm wrong but here's my take on it: When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server. Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.
Am I wrong? If so let me know.
-Original Message-
Sent: Tuesday, November 27, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L
hey lisa
Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)
thoughts ..?
Thx
Deepak
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?
Hi
WHen I execute ps -ef |grep LOCAL on Solaris
server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California -- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1 http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, 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
Re: Oracle8i on WinNT - renaming disc drives
If they're just renaming the disks where the datafiles reside, then the backup controlfile is the way to go. However, if they're renaming the disk where the Oracle Home resides, then you need to go edit the registry. Be sure and make a backup of the registry before you start the edit. Unasked, of course, is the question of why they would need to rename the disks? Changing network drive numbers is reasonably common but since Oracle8i on WinNT doesn't support network mounted drives this couldn't have any impact on the database. Changing the internal drive letters either involves spoofing the CMOS or the OS so that it thinks that drives are mounted in a different order or actually changing the controller connections. Maybe there's some reason to do this but I can't think of it. Rodd Holman rodney.holmaTo: Multiple recipients of list ORACLE-L n[EMAIL PROTECTED] @lodgenet.comcc: Subject: Re: Oracle8i on WinNT - renaming Sent by: rootdisc drives 11/28/2001 10:50 AM Please respond to ORACLE-L Ron, You're making this way too dificult. To reorg the drive names on NT/2000: 1. Backup your database (just a good thing to do) 2. ALTER DATABASE BACKUP CONTROLFILE TO TRACE; - Generates a script with all the datafiles listed in it. 3. Edit initsid.ora and any ifile linked configs that point to drive paths. (Backup originals first). 4. Edit the controlfile script generated in #2 to show the new paths. 5. Shutdown the database 6. Rename the devices at the NT/2000 level 7. in svrmgrl or sqlplus (8i or 9i) run the script from #4. 8. Recover database if necessary. May need to do a recover until cancel and cancel it as soon as it asks for archived logs. We recreate instances doing this all the time to create dev and test systems. By recreating the controlfile you can rename all the dbfiles at once. If you can't take the system off line, it will be very tedious as Ron mentioned. Also if you want to change the location of SYSTEM tablespace, you have to take the system off line. Rodd Holman On Wed, 2001-11-28 at 08:05, Ron Rogers wrote: Sonja, It is a complicated process to rename disk drives in the Oracle environment. Depending in the drives that Oracle uses and what are changes(renamed) could really cause you frustration. The initxxx.ora lists the current location of the controlfiles, logfiles, dump dirs, trace dirs, etc. You will have to startup the database (if it can find the controlfile) and alter database rename .. to .. for each of the effected datafiles. It can be a long and detailed process. These are just a few thoughts off the top of my head. Make notes and document everything to CYA. Good Luck ROR mª¿ªm [EMAIL PROTECTED] 11/28/01 05:20AM List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
Re: Script to Disable Constraint, Change Value, then Enable Const
Not good approach. Instead, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed "illegal" data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 5:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27 November 2001 21:30To: Multiple recipients of list ORACLE-LSubject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left "off" after updates, allowing "illegal" data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
OT: Win2K Drive Mapping Question
Anyone know how to map more than 26 drives on Win2K workstation? I trying to map 36 servers to a workstation. mkb __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
doubts reg : Tablespace
hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
LISTENER CONFIGURATION?
Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Longest SQL statements!!!
Are there any implications on how long the SQL statement is? The current SQL statements that I am inheritting, is really long. tons of embedded sub queries etc. My first question is are there any known issues with haveing very long SQL statements and if yes what has been a good length other than the fact that it may depend on your SGA. Thanks Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Script to Disable Constraint, Change Value, then Enable Const
OK. Here's what I do in that situation: Here's the main driver -- disable foreign keys on parent_table.column alter table CHILD1 disable constraint FK1; alter table CHILD2 disable constraint FK2; --run the detail_update.sql for each pair of values, ie, the current value and the -- value that it will be set to @ex_detail_update -- re-enable foreign keys on parent_table.column alter table CHILD1 enable constraint FK1; alter table CHILD2 enable constraint FK2; Here's the ex_detail_update.sql - basically it will replace parameter 1 with parameter 2 @detail_update 1012 1013 @detail_update 1011 1012 @detail_update 1010 1011 @detail_update 1009 1010 Here's where the nitty gritty happens -- detail_update.sql update table CHILD1 set FK_ID = 2 where FK_ID = 1; update table CHILD2 set FK_ID = 2 where FK_ID = 1; update table PARENT set PK_ID = 2 where PK_ID = 1; COMMIT / When it's done it falls out to the next set of pairs. When you run out of pairs then the top level script will re-enable your constraints. David Wagoner dwagonerTo: Multiple recipients of list ORACLE-L @arsenaldigit[EMAIL PROTECTED] al.com cc: Sent by: rootSubject: RE: Script to Disable Constraint, Change Value, then Enable Const 11/28/2001 11:24 AM Please respond to ORACLE-L I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message- ner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L ain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I
Re: Script to Disable Constraint, Change Value, then Enable Const
As far as I remember, there is such a script at http://www.oriole.com, in the X-rated section - as the name implies, not full-heartedly recommended. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: OT: Win2K Drive Mapping Question
Double letters, eg., AA, BB mohammed bhatti To: Multiple recipients of list ORACLE-L mkb125 [EMAIL PROTECTED] @yahoo.com cc: Sent by: rootSubject: OT: Win2K Drive Mapping Question 11/28/2001 12:03 PM Please respond to ORACLE-L Anyone know how to map more than 26 drives on Win2K workstation? I trying to map 36 servers to a workstation. mkb __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Script to Disable Constraint, Change Value, then Enable Const
I have had the same type of requirement and decided to use deferrable constraints. Works great! Rick -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Script to Disable Constraint, Change Value, then Enable Const Not good approach. Instead, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed "illegal" data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 5:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27 November 2001 21:30To: Multiple recipients of list ORACLE-LSubject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left "off" after updates, allowing "illegal" data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: enable the partitioning option in database?.
Assuming you have installed the Oracle Partitioning option, there may be an extra step required to enable it, and that is to make sure you relink with the correct option. See the following excerpt taken from MetaLink: To enable the Partitioning Option you must relink the rdbms executable. Ensure that the database is shut down and relink as follows: cd $ORACLE_HOME/rdbms/lib For 8.0.x: make -f ins_rdbms.mk part_off (to disable) make -f ins_rdbms.mk part_on (to enable) make -f ins_rdbms.mk ioracle For 8.1.x: make -f ins_rdbms.mk part_off ioracle (to disable) make -f ins_rdbms.mk part_on ioracle (to enable) HTH Gerardo -Original Message- Sent: Wednesday, November 28, 2001 5:55 AM To: Multiple recipients of list ORACLE-L hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE Parallel Server FALSE Java FALSE Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Doubts reg :Export and import
hi list, what is the exact use of mentioning 'compress' yes or no while exportingwill this store the .dmp file in compressed format in system,if given 'yes'. while importing the dumpfile why is it necessary to give 'fromuser',is 'touser' not enough. sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Doubts reg :Export and import
compress=y means all the extents will be compressed into a single extent. It has nothing to do with compressing .dmp file. Rick -Original Message- Sent: Wednesday, November 28, 2001 12:16 PM To: Multiple recipients of list ORACLE-L hi list, what is the exact use of mentioning 'compress' yes or no while exportingwill this store the .dmp file in compressed format in system,if given 'yes'. while importing the dumpfile why is it necessary to give 'fromuser',is 'touser' not enough. sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: doubts reg : Tablespace
sangeetha, It's time to Read The Fine Manual. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 12:10 PM hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Win2K Drive Mapping Question
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 19:03 Anyone know how to map more than 26 drives on Win2K workstation? I trying to map 36 servers to a workstation. U can't type NET HELP USE and u'll see something like devicename Assigns a name to connect to the resource or specifies the device to be disconnected. There are two kinds of devicenames: disk drives (D: through Z:) and printers (LPT1: through LPT3:). Type an asterisk instead of a specific devicename to assign the next available devicename. Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Siebel.
We use Siebel and no it does NOT have RI. Mark Leith [EMAIL PROTECTED]@fatcity.com on 11/28/2001 10:56:07 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi Gang, Does anybody use Siebel - I believe it's a CRM package? I'm trying to find out of the Siebel application enforces RI within the database or the application? Anybody know? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Connection question?
Harry, you say that IPC and BEQ both use the listener to spawn a server-side process -- but the docs say that BEQ ...enables clients that exist on the same machine as the server to retrieve information from the database without using the listener. Which is correct? --- Koivu, Lisa [EMAIL PROTECTED] wrote: Hi Harry, I admit ignorance. Networking was never my strong point. IN fact sometimes I wonder if I still have one. Thanks for your response. Lisa -Original Message- From: Lowes, Harry (NESL-IT) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: Connection question? Afternoon Lisa, I thought that BEQ and (for example) IPC protocols both used the listener to spawn a server-side process. The difference is in the protocol used in the communication between the remote and local processes. IPC uses Unix Domain Sockets to communicate between the client-side and server-side processes, where BEQ uses Unix pipes. I had assumed that this was why BEQ connections had to be local. This is the view expounded in Note: 1014940.6. If I've got it wrong, it'd be nice to know. Any comments, Gurus? Thanks, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: LISTENER CONFIGURATION?
Seema, It is explained in the manual. Please read it. Anjan Seema Singh wrote: Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
AW: Terminal Server / svrmgrl
Title: Nachricht I'm running 8.1.6 SE on W2K with terminal services enabled. svrmgrl and sqlplus are running fine, no problems. If your connect internal doesnt't work try "connect internal@your_instance". What are the error messages you get? regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 27. November 2001 22:00An: Multiple recipients of list ORACLE-LBetreff: Terminal Server / svrmgrl ZP? As in Zip It? Just really really frustrating. Thanks Ross and Michael Lisa -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: RE: ok, as much as i think MS could use a major kick in the fundament, if you think of "terminal server client" as "rsh client" (please no niggling corrections of the rough analogy!:-) then you'll not be so vexed at the lack of functionality. Sad that this doesn't work, true, but...shrug...maybe in XP? YP? ZP? -Original Message- Sent: Tuesday, November 27, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server Client do not work. I used PC Anywhere, everything went fine. HTH, Michael From: Koivu, Lisa [EMAIL PROTECTED] Subject: svrmgrl and W2k Date: 27 Nov 01, 03:25 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -- Original message -- OH MY GOSH this sucks. Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and the listener, for that matter) via Terminal Server and it keeps erring out with ORA-12560 protocol adapter error. I look on Metalink and it just plain says, Go to the console. WHAT? Are you KIDDING! Here's the note: * fact: Oracle Server - Enterprise Edition * fact: RDBMS * fact: MS Windows 2000 * fact: MS Windows NT * symptom: Cannot connect to SVRMGRL * symptom: ORA-12560: TNS:protocol adapter error * symptom: Cannot connect to SVRMGR30 * symptom: ORA-12203: TNS:unable to connect to destination * cause: Bequeath protocol is not supported with Microsoft Terminal Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on Oracle8i. fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is not available using an MS Windows 2000 Terminal Server Client. To startup the instance, use the the Windows 2000 console to connect to the SVRMGRL. I can do this with W2k, Terminal Server and Standard Edition. Has anyone else seen this ? I am so irked I could scream. (But it could be the hormones). Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Netrusov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Longest SQL statements!!!
Murali: The only issue that I know of is in Oracle that the SQL statement must be less than 64K. I've written 3-page SQL statements that returned in the sub-0.1 second range. However, from a human standpoint, the longer the SQL is, the harder it is for a new developer to pick up and tune/debug/tweak/etc. In general, I try to keep my SQL to under 1/2 page. But I DO NOT sacrifice readability in order to keep my SQL Under 1/2 page. Most of the time, when I'm asked to tune or debug a SQL statement, my reformatted, revised SQL winds up being longer than the original -- but much easier for a human to read -- reformatting it makes it easier for me to tune or correct. HTH Caver -Original Message- Sent: Wednesday, November 28, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Are there any implications on how long the SQL statement is? The current SQL statements that I am inheritting, is really long. tons of embedded sub queries etc. My first question is are there any known issues with haveing very long SQL statements and if yes what has been a good length other than the fact that it may depend on your SGA. Thanks Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
NAS and SAN
I am evaluating a solution for LAWSON, and in the requirements I need a server with at least 450 GIGs of hard drive, 3 GIGs of RAM, 8 Intel Based Processors. I am proposing to buy Compaq Servers, and 14 slots external units to fulfill these requirements, but I have some questions to see if someone can help me?? 1) Will my application suffer a lot if I decide to buy 72Gigs hard drivers or should I buy 36Gigs hard drives. My problem is that for future grow, the 72 will allow me more data on my external 14 slots storage unit 2) Is someone using NAS Network Attached Storage Units? How well do they perform? What about SAN Storage Attached Network units? 3) A company told me about this NAS that mirrors data changes over LAN or WAN, they claim it is a great product and that in case of emergency recovery, I will be able to recover in minutes?? Is it true?? Please Help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Brenes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: enable the partitioning option in database?.
what do you do for NT ? -Original Message- Sent: Wednesday, November 28, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Assuming you have installed the Oracle Partitioning option, there may be an extra step required to enable it, and that is to make sure you relink with the correct option. See the following excerpt taken from MetaLink: To enable the Partitioning Option you must relink the rdbms executable. Ensure that the database is shut down and relink as follows: cd $ORACLE_HOME/rdbms/lib For 8.0.x: make -f ins_rdbms.mk part_off (to disable) make -f ins_rdbms.mk part_on (to enable) make -f ins_rdbms.mk ioracle For 8.1.x: make -f ins_rdbms.mk part_off ioracle (to disable) make -f ins_rdbms.mk part_on ioracle (to enable) HTH Gerardo -Original Message- Sent: Wednesday, November 28, 2001 5:55 AM To: Multiple recipients of list ORACLE-L hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED] SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE Parallel Server FALSE Java FALSE Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Prakriteswar Santikary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Connection question?
But were these not both BEQ one in Caps and the other in lower case (BEQ
and beq) ..
Anjan
"Koivu, Lisa" wrote:
Hi Harry,
I admit ignorance.
Networking was never my strong point. IN fact sometimes I wonder
if I still have one.
Thanks for your response.
Lisa
-Original Message-
From:
Lowes, Harry (NESL-IT) [SMTP:[EMAIL PROTECTED]]
Sent:
Wednesday, November 28, 2001 10:31 AM
To:
Multiple recipients of list ORACLE-L
Subject:
RE: Connection question?
Afternoon Lisa,
I thought that BEQ and (for example)
IPC protocols both used the listener to
spawn a server-side process. The difference
is in the protocol used in the
communication between the remote and
local processes. IPC uses Unix Domain
Sockets to communicate between the
client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed
that this was why BEQ connections
had to be local. This is the view
expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any
comments, Gurus?
Thanks,
Harry Lowes
Database Administrator,
npower Northern Limited
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]>
-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L
Hi Deepak
Here's what the doco says
The Bequeath protocol glossary.htm>
enables clients that exist on the same
machine as the server to retrieve
information from the database without
using the listener. The Bequeath protocol
internally spawns a dedicated
server process for each client applications.
In a sense, it does the same
operation that a remote network listener
does for your connection, yet
locally.
Bequeath is used for local connections
where an Oracle client application,
such as SQL*Plus, communicates with
an Oracle server running on the same
machine
Tell me if I'm wrong but here's my
take on it: When I connect from my pc,
there's a process on my PC and there's
a corresponding process on the
database, say on a Unix server.
Though the connection was initiated
remotely, the process itself on the
db server is still a local process that
exists to communicate with the database.
Am I wrong? If so let me know.
-Original
Message-
Sent: Tuesday, November
27, 2001 5:25 PM
To: Multiple
recipients of list ORACLE-L
hey
lisa
Thats
what i was temted to reply as well {lol} .. but
if you look closely .. both her conn
are bequeth .. i
was under the impression that bequeth
was used only
for local and not remote .. thats
why we chose beq
over tcp for db's that resided in
same box for
performance reasons .. or so i thought
until now ;)
thoughts
..?
Thx
Deepak
--- "Koivu, Lisa" [EMAIL PROTECTED]>
wrote:
> One is LOCAL=YES and one is LOCAL=NO
>
> One is Local, one isn't.
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
>
>
> > -Original Message-
> > From:
Seema Singh [SMTP:[EMAIL PROTECTED]]
> > Sent:
Tuesday, November 27, 2001 1:05 PM
> > To: Multiple recipients of list
ORACLE-L
> > Subject: Connection
question?
> >
> > Hi
> > WHen I execute ps -ef |grep LOCAL
on Solaris
> server the following output i
> >
> > see in
> >
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> > What is the diffrence between
1 and 2.
> >
> > Thanks
> > Seema
> >
> >
>
_
> > Get your FREE download of MSN
Explorer at
> http://explorer.msn.com/intl.asp
http://explorer.msn.com/intl.asp>
> >
> > --
> > Please see the official ORACLE-L
FAQ:
> http://www.orafaq.com
http://www.orafaq.com>
> > --
> > Author: Seema Singh
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services
-- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California
-- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing
list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note
EXACT spelling of
> 'ListGuru') and in
> > the message BODY, 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).
>
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy
web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
http://geocities.yahoo.com/ps/info1>
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
http://www.orafaq.com>
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California
-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L
(or the name of mailing list you want
to be removed from).
Re: doubts reg : Tablespace
sangeeta, this is explained in great depth in the 1st chapter of the Oracle concepts manual... Deepak --- sangeetha [EMAIL PROTECTED] wrote: hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: LISTENER CONFIGURATION?
Seema, for this you basically define them in the listener.ora file and start each individually .. here is an e.g. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyy.zz.ea.com)(PORT = 1521)) ) LISTENER_REAL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.ea.com)(PORT = 1522)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = /opt/oracle/product/816) (SID_NAME = gamesdev) ) ) SID_LIST_LISTENER_REAL = (SID_LIST = (SID_DESC = (ORACLE_HOME = /opt/oracle/product/816) (SID_NAME = realdb) ) ) hth Deepak --- Seema Singh [EMAIL PROTECTED] wrote: Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Re: Multiple instances - Sun Solaris
Lisa, 1. Find the amt of shared mem you are using: ipcs -mb 2. see your os limit. for e.g. : sysdef |grep -i shm also ensure that ur /etc/system parameters match with the output from 2. If not, you need to bounce the unix box for those values to tale effect. Check specifically for kernal parameters shmmax and semmns and ensure that these are set correctly. hth Deepak --- YTTRI Lisa [EMAIL PROTECTED] wrote: Hi - We are running a solaris server (2.6) for our develoment environment. We currently have 5 instances on the server. When we create another instance and try to start it, we get a ORA-27101: shared memory realm does not exist. The text reads 'Unable to locate shared meory realm'. We have set the following kernal parameters to what we believe to be appropriate. SHMMAX=1207959552 SHMMIN=1 SHMSEG=10 SEMMNI=100 SEMMSL=350 SEMMNS =1000 SEMOPM =100 SEMVMX=32767 Does anyone know of any other kernal parameter settings that may be causing this error? THanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
RE: Script to Disable Constraint, Change Value, then Enable Const
Rick, thanks for your input. When I test the deferred constraint in SQL*Plus I get an error. What am I doing wrong? I did not find much information in the docs about deferred constraints. SQL set constraints all deferred 2 update table1 set host_name = 'tigerz' where host_name = 'tiger' 3* update table2 set host_name = 'tigerz' where host_name = 'tiger'; SQL update host set host_name = 'tigerz' where host_name = 'tiger' * ERROR at line 2: ORA-00933: SQL command not properly ended TIA, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I have had the same type of requirement and decided to use deferrable constraints. Works great! Rick -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Script to Disable Constraint, Change Value, then Enable Const Not good approach. Instead, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database
RE: Connection question?
On my systems, SUN, the Oracle JDBC connections
show up as BEQ local=no OS sessions.
Todd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Anjan
Thakuria
Sent: Wednesday, November 28, 2001
12:02 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Connection question?
But were these not both BEQ one in Caps and the other
in lower case (BEQ and beq) ..
Anjan
Koivu, Lisa wrote:
Hi Harry,
I admit
ignorance. Networking was never my strong point. IN fact sometimes
I wonder if I still have one.
Thanks for your
response.
Lisa
-Original Message-
From: Lowes, Harry (NESL-IT)
[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 10:31 AM
To: Multiple recipients
of list ORACLE-L
Subject:
RE:
Connection question?
Afternoon Lisa,
I thought that BEQ and (for example) IPC protocols
both used the listener to
spawn
a server-side process. The difference is in the protocol used in the
communication
between the remote and local processes. IPC uses Unix Domain
Sockets
to communicate between the client-side and server-side processes,
where
BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to
be local. This is the view expounded in Note: 1014940.6. If I've got
it
wrong, it'd be nice to know. Any comments, Gurus?
Thanks,
Harry Lowes
Database
Administrator,
npower
Northern Limited
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
-Original Message-
Sent:
28 November 2001 14:00
To:
Multiple recipients of list ORACLE-L
Hi Deepak
Here's what the doco says
The Bequeath protocol glossary.htm enables
clients that exist on the same
machine
as the server to retrieve information from the database without
using
the listener. The Bequeath protocol internally spawns a dedicated
server
process for each client applications. In a sense, it does the same
operation
that a remote network listener does for your connection, yet
locally.
Bequeath is used for local connections where an
Oracle client application,
such
as SQL*Plus, communicates with an Oracle server running on the same
machine
Tell me if I'm wrong but here's my take on it:
When I connect from my pc,
there's
a process on my PC and there's a corresponding process on the
database,
say on a Unix server. Though the connection was initiated
remotely,
the process itself on the db server is still a local process that
exists
to communicate with the database.
Am I wrong? If so let me know.
-Original
Message-
Sent:
Tuesday, November 27, 2001 5:25 PM
To:
Multiple recipients of list ORACLE-L
hey lisa
Thats what i
was temted to reply as well {lol} .. but
if you
look closely .. both her conn are bequeth .. i
was
under the impression that bequeth was used only
for
local and not remote .. thats why we chose beq
over
tcp for db's that resided in same box for
performance
reasons .. or so i thought until now ;)
thoughts ..?
Thx
Deepak
---
Koivu, Lisa [EMAIL PROTECTED] wrote:
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh
[SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05
PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?
Hi
WHen I execute ps -ef |grep LOCAL on Solaris
server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California -- Public
Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, 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).
__
Do You
Yahoo!?
Yahoo!
GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
http://geocities.yahoo.com/ps/info1
--
Please
see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com
--
Author:
Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City
Network Services -- (858) 538-5051 FAX:
Off topic Perlesque question
Title: Off topic Perlesque question I know this is off topic but if I can get grab you perl guru's ear for second I'd greatly appreciate it. First I'd like to ask for a better place to post these types of questions. A perl list would be ideal but my boss has explicitly said I can join no more lists - my mail box is getting too big :(. os (I know here's the fundamental problem) : Win2K perl: ActiveState 5.6.1.630 Microsoft C++ Visual Studio 6.0 Ok now to the problem. I am having trouble using cpan to install certain modules/Bundles. I have been able to use ppm to install most of the modules I need but there are still 7-10 that I believe need to be done through the cpan interface. The problem I am having with cpan is when it's ready to compile the code it never works because of make problems. I have tried to download nmake instead to see if that would work but to no avail. I am making the correct changes in the config.pm file where it says make='blah blah' but the command is always bombing out and thus if no make test it will not continue the real make. Has anyone else had this problem or know how to fix it? What else can I do? I believe that the problem is in the syntax that cpan is using to compile things is not compatible with the windows version of make. The readme I used suggested to download nmake and use that but again the syntax seems different. In the cpan error I see it doing: make -f blah blah but the windows make help command shows all arguments should be like '/A' and I havent seen an argument for force. Does anyone know of a make out there for windows that behaves as unix in terms of syntax? My ultimate goal is to get slashcode to run on this machine for a web site but have to do it on a windows machine. I am terribly lost and don't know what to do next or where to look. Any advice would help thanks. Sorry for being so lengthy and off topic I don't know where I can post this and still be able to get a reply. Wish I could join an additional list. Is there any file I can edit so that every time cpan calls for 'make -f' I can substitute it with a syntax my nmake command will accept? Thank you very much. Ivan
RE: Siebel.
RANT MODE BAH!! These bloody application providers leaving the integrity to their bloody applications instead of leaving it in it's rightful place in the database!!! Makes my life 10 times harder!!! Got no consideration at all have they? /RANT MODE :P Thanks! Mark -Original Message- [EMAIL PROTECTED] Sent: 28 November 2001 17:46 To: Multiple recipients of list ORACLE-L We use Siebel and no it does NOT have RI. Mark Leith [EMAIL PROTECTED]@fatcity.com on 11/28/2001 10:56:07 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi Gang, Does anybody use Siebel - I believe it's a CRM package? I'm trying to find out of the Siebel application enforces RI within the database or the application? Anybody know? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 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).
Need Help Please - With Procedures
Hello all,
I have attached an sql file containing a set of sql's (6) of them, which gives me
information regarding table fragmentation. What I need to do is instead of writing
seperate sql's, I need to write a procedure, where in I pass the owner and table name
and then the result comes out, as you will see in the last sql.
What I need is, if some one could please help in writing a procedure? How to put
cursors and use all the information in different cursor variables etc.
Please help.
Thanks.
Rgds,
Raja
Accept owner prompt 'Enter Owner Name '
Accept tnm prompt 'Enter Table Name '
set echo off verify off heading off
set termout off
col val4 new_val hwm_blocks noprint
col val5 new_val above_hwm noprint
col val6 new_val row_chains noprint
col val7 new_val row_size noprint
col val7a new_val pct_used noprint
col val7b new_val pct_free noprint
col val8 new_val num_rows noprint
col val9 new_val row_chains_pct noprint
select num_rowsval8,
blocks val4,
empty_blocksval5,
chain_cnt val6,
avg_row_len val7,
pct_usedval7a,
pct_freeval7b,
100*chain_cnt/num_rows val9
fromdba_tables
where table_name = upper('tnm')
and owner = upper('owner');
col val9 new_val block_size noprint
select value val9
from v$parameter
where name = 'db_block_size';
col val10a new_val blocks_alloc noprint
col val10b new_val bytes_alloc noprint
col val10e new_val hwm_bytes noprint
col val10f new_val bytes_used noprint
select hwm_blocks+above_hwm val10a,
(hwm_blocks+above_hwm)*block_size/1024/1024 val10b,
(hwm_blocks*block_size)/1024/1024 val10e,
(num_rows*row_size)/1024/1024 val10f
from dual;
col val11a new_val blocks_pct_used noprint
col val11b new_val bytes_pct_used noprint
select 100*hwm_blocks/blocks_alloc val11a,
100*num_rows*row_size/hwm_bytes/1024/1024 val11b
from dual;
col val12 new_val sf noprint
select count(*) val12
fromdba_extents
where segment_name= upper('tnm')
and owner = upper('owner');
set termout on
set echo off feedback off verify off
col bogus format 999,999,999 fold_after
select 'Owner : '||'owner' bogus,
'Table name : '||'tnm' bogus,
'pct_free : '||pct_free bogus,
'pct_used : '||pct_used bogus,
'Number of extents : '||sf||' -- Segment Fragmentation' bogus,
'Rows : '||num_rows bogus,
'Row size : '||row_size bogus,
'Rows frag:migration: '||row_chains bogus,
'Row % frag:migr. : '||row_chains_pct||'% -- Row Fragmentation' bogus,
'DB block size : '||block_size bogus,
'Blocks alloc : '||blocks_alloc bogus,
'Block HWM : '||hwm_blocks bogus,
'% alloc used by HWM: '||blocks_pct_used||'%' bogus,
'MB alloc : '||bytes_alloc||'MB' bogus,
'MB HWM : '||hwm_bytes||'MB' bogus,
'MB used: '||bytes_used||'MB' bogus,
'% HWM bytes used : '||bytes_pct_used||'% -- Block Fragmentation' bogus
from dual;
prompt *** The table owner..tnm must have been recently analyzed for accuracy
prompt *** You may need to ANALYZE TABLE owner..tnm DELETE STATISTICS
set echo on verify on heading on feedback on
Duplicating a Database and Changig SID
Hi Guys, I am newbie oracle DBA and want to duplicate my development database to Test database and want to change ORACLE_SID, Could anyone tell exact steps that I have to follow. My database is on SUN 5.6 and oracle 8.1.6. Thanks,
