RE: SQL Question
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values
('||(IDU + 1 )||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from
app_users
where pen_id in (44541,41402,41813) ;
IDU + 1 must be replaced by (IDU + 1).
HTH.
Nirmal.,
-Original Message-
Sent: Tuesday, January 28, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
Hi,
My brain is slow today Can someone help me ?
I can do :
select idu+1 from user_group_members where fk_user
in(44541,41402,41813) ;
IDU+1
--
41411
41821
44546
But I can't do :
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values
('||IDU + 1 ||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users
where pen_id in (44541,41402,41813) ;
I've got on IDU+1 :
ERROR at line 1:
ORA-01722: invalid number
Best Regards
Henrik
--
---
There's fun in being serious.
-- Wynton Marsalis
Henrik EkenbergAnoto AB
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henrik Ekenber
INET: [EMAIL PROTECTED] [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Where are the scripts located to create the SCOTT test object
%Oralce_home%\sqlplus\demo\demobld.sql HTH nirmal. -Original Message- Sent: Wednesday, January 22, 2003 5:29 AM To: Multiple recipients of list ORACLE-L Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:25 PM To: Multiple recipients of list ORACLE-L Subject: Where are the scripts located to create the SCOTT test objects? I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Minimum required init.ora parameters
No, I tried to startup the DB without compatible parameter. It throws message as the same parameter is required. Nirmal. -Original Message- Sent: Monday, January 13, 2003 5:55 PM To: Multiple recipients of list ORACLE-L compatibility or compatible is not a mandatory init.ora parameter. I would think that only the first three are required. Hemant At 06:08 AM 13-01-03 -0800, you wrote: Nirmal - I believe there are four: db_name control_file db_block_size compatibility This is from John Hibbard, a great Oracle Education instructor. But why not try for yourself? Save off your init.ora, then create a new init.ora with just the above parameters. If Oracle comes up, then remove parameters. If there is another parameter, Oracle will tell you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 4:59 AM To: Multiple recipients of list ORACLE-L List, I'm interested to know the minimum required parameters to startup the database. Pls anybody list out that? Nirmal., -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Minimum required init.ora parameters
List, I'm interested to know the minimum required parameters to startup the database. Pls anybody list out that? Nirmal.,
V$SYSTEM_PARAMETER vs V$PARAMETER
Title: AW: How to create two db-links within one schema when global_names=tr Hi, Where these two, V$SYSTEM_PARAMETER, V$PARAMETER dynamic view are differs? Both of them looks the samein structure and data as well. Anybody have any idea. Nirmal. -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: AW: How to create two db-links within one schema when global_name Hi Jonathan, thanks for your reply. The deal is that you can't use DB1@HR and DB1@SHIP if you are using global_names=true; the link name has to be the same than the global database name. But what do I do, if I need the same user to have two db-links to different schemas on the remote database? Any idea? Thanks, Helmut -Ursprüngliche Nachricht- Von: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 8. Januar 2003 12:14 An: Multiple recipients of list ORACLE-L Betreff: Re: How to create two db-links within one schema when global_names=tr Look up the details of 'connection qualifiers'. create public database link DB1@HR connect to hr identified by pwd_hr using 'DB1'; create public database link DB1@SHIP connect to shipping identified by pwd_shipping using 'DB1'; Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 08 January 2003 10:57 global_names=tr Hi! Is there a way to create two db-links within one schema when global_names=true? e.g. create public database link DB1 connect to hr identified by pwd_hr using 'DB1'; create public database link DB1 (???) connect to shipping identified by pwd_shipping using 'DB1'; This is 8.1.7 on Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: SQL puzzle - using where (a, b, c) in select (a, b, c from...
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null SQL edWrote file afiedt.buf 1 select * from widgets_copy 2* order by 1,2,3SQL / ID COST SELL-- -- -- 1 10 20 1 10 20 1 10 30 1 10 30 1 10 1 10 1 1 8 rows selected. SQL delete widgets_copy where rowid not in (select min(rowid) 2 from widgets_copy group by id, cost,sell); 4 rows deleted. SQL select * from widgets_copy 2 order by 1,2,3 3 / ID COST SELL-- -- -- 1 10 20 1 10 30 1 10 1 SQL HTH, Rgds, Nirmal. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 19, 2002 6:04 AMTo: Multiple recipients of list ORACLE-LSubject: SQL puzzle - using where (a, b, c) in select (a, b, c from...) an Maybe there is a simple solution, but I'm too tired to think of one now. I have two tables, widgets and widgets_copy. Each table has columns that can contain null values. SQL select id, cost, sell from widgets order by 1, 2, 3 ; ID COST SELL - - - 1 10 20 1 10 1 SQL select 'ROW' || to_char (rownum) as row_num, 2 id, cost, sell 3 from widgets_copy 4 order by 2, 3, 4 ; ROW_NUM ID COST SELL -- - - - ROW3 1 10 20 ROW6 1 10 20 ROW7 1 10 30 ROW8 1 10 30 ROW2 1 10 ROW5 1 10 ROW1 1 ROW4 1 SQL I want to delete from widgets_copy all duplicates of rows that are present in widgets. Meaning I want to - delete either ROW3 or ROW6 from widgets_copy, since (1, 10, 20) is also in widgets; - delete either ROW2 or ROW5 from widgets_copy, since (1, 10, null) is also in widgets; - and delete either ROW1 or ROW4 from widgets_copy, since (1, null, null) is also in widgets. The statement below will only delete ROW3 or ROW6 from widgets_copy. The "where (id, cost, sell) in (select id, cost, sell ..." only works when the columns do not contain nulls. -- only works when none of the columns are null delete from widgets_copy where rowid in ( select min (rowid) from widgets_copy x where (x.id, x.cost, x.sell) in (select y.id, y.cost, y.sell from widgets y) group by x.id, x.cost, x.sell ) ; How can I write my statement? a) I don't want to use nvl because this is supposed to be a general purpose solution, and I don't know what the possible values can be in the table. b) I could do several deletes, considering cases (a, b, c) not null, only a is null, only b is null, etc... but that would be hard to generalize to a case of a table with 4, 5 or more columns. P.S. SQL to build the sample test case: create table widgets (id number, cost number, sell number) ; insert into widgets (id, cost, sell) values (1, null, null) ; insert into widgets (id, cost, sell) values (1, 10, null) ; insert into widgets (id, cost, sell) values (1, 10, 20) ; create table widgets_copy as select * from widgets ; insert into widgets_copy select * from widgets_copy ; insert into widgets_copy (id, cost, sell) values (1, 10, 30) ; insert into widgets_copy (id, cost, sell) values (1, 10, 30) ; commit ;
RE: ORACLE QUERY
select
record_identifier from records where rownum(
select 40-count(*)
from
(select1 from
customer_view
union all
select2 from unit_view)
);
Just a thought,
HTH.
Nirmal.
-Original Message-From: Savita
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 11:13
AMTo: Multiple recipients of list ORACLE-LSubject:
ORACLE QUERYHi All,
I want to know about one query.
I have two views and I want to get the sum of count of two view ex I
have a query like
select record_identifier from records where
rownum(40-(select count(*) from customer_view+select count(*)
from unit_view));
But this is not working in oracle.
Is there any other way to do this without writing a function --
Best Regards - Savita
Hewlett Packard
(India) +91 80 2051288 (Phone) 847 1288 (HP Telnet)
SQL loader
Hi list, LOAD DATA INFILE 'c:\temp\file2.csv' APPEND INTO TABLE dc_temp1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ( name, old_po_box, dn, gsm, nregc, cr_no, new_po_box , remark, ncli) The above is my control file for loading data. i need to refer the two columns of data from the datafile 'c:\temp\file2.csv' should go into one column(remark) of my table. Oracle7.3.1. Any ideas pls. Thanks. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: User Log-Machine Name
Hei...
Inside trigger block, using userenv('terminal') you can identify the machine
name.
One oracle user can have multiple active sessions.
(Here in my team, 5 people working on the same oracle username with
different machines.
The privileges are set for them at application level.)
HTH.
Nirmal.,
-Original Message-
[mailto:PK_Deepa/VGIL;vguard.satyam.net.in]
Sent: Tuesday, November 05, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Hello
A user log is maintained for a table.I want to log all updations made to
this table.
I have written a database trigger (After Update) to log the changes to
another table.My requirement is to find the machine name from which the
updation has occurred and log the machine name also .
How to get the currently working session ID so that machine name can be
retrieved fromV$session view or any other method to retrive the machine
name uniquely.
Is it that one Oracle user can have multiple active sessions on different
machines? Eg.
User Name Status Module Session Machine
XXACTIVESQL*Plus 10 AA
XXACTIVESQL*Plus 19 BB
Regards,
Deepa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: to_char(sysdate) problem on 8.1.7.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL select to_char(sysdate,'dd.mm.') from dual; TO_CHAR(SY -- 15.10.2002 --- It's doing fine... on Win2k. Nirmal. -Original Message- Sent: Tuesday, October 15, 2002 12:03 PM To: Multiple recipients of list ORACLE-L hi! 8.1.7. on WIN: due to a bug - it seems - the following query returns an error: SQL SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual; SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [538241312], [], [], [], [], [], [] while it works fine on 8.0.5. and 8.1.6.! does anyone know a way to change the query, so it will work on all version and there is no need for a patch? tia regards daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ORA-03113 with dbms_output and sysdate
Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SYSDBA privilege with ORAPWD utility
Hei... Is your sys password is correctly mentioned while logon?. I tested your case, it's doing proper, while i misspelled sys pwd, it thrown the error as u mentioned... HTH, Nirmal -Original Message- Sent: Wednesday, September 11, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan 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: Nirmal Kumar Muthu Kumaran 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: Calling report
Hi
syed...
srw.run_report ('d:\test.rdf destype=file
desname=try.out desformat=dflt batch=yes');
The
above will work fine. You should not mention 'report' keyword in the command
line. This is the
mistake in reports help.
Nirmal.
Prior
Deveoper, Current OCP DBA.
-Original Message-From: sultan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 6:03
PMTo: Multiple recipients of list ORACLE-LSubject:
Calling report
Hi
friends
I am using following command to call report
from report
srw.run_report ('report=d:\test.rdf destype=file desname=try.out
desformat=dflt batch=yes');
I have tested this using After Report /Before Report/Action
Trigger.
But this is not calling the
report.
Any solution will be appreciated.
Syed
Install Oracle 8i on Windows XP?
Hi gurus... I friend newly bought a laptop with windows XP. He wants to install oracle 8i on it. Is it possible to install oracle 8i in XP?. Is there any patch i need apply. Thanks. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Install Oracle 8i on Windows XP?
Can you pls any one guide me, how to succeed on this. Rgds, Nirmal. -Original Message- Sent: Saturday, July 27, 2002 6:24 PM To: Multiple recipients of list ORACLE-L It is possible although it is not supported. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 8:03 AM Hi gurus... I friend newly bought a laptop with windows XP. He wants to install oracle 8i on it. Is it possible to install oracle 8i in XP?. Is there any patch i need apply. Thanks. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Jay 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: Nirmal Kumar Muthu Kumaran 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: Export syntax
C:\EXP SCOTT/TIGER TABLES=EMP QUERY='WHERE JOB IN (''MANAGER'')'
THIS WORKS FINE...
hth.
nIRMAL
(oCP?).
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
the following syntax gives invalid col name :
exp test/test file=expt.dmp tables=x1
query=\where x1_cd in \(\'207\'\)\
EXP-8: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-0: Export terminated unsuccessfully
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
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: Moving tables from one schema to another
Let me know why you put restriction on export/import? -Original Message- Sent: Monday, July 22, 2002 8:59 PM To: Multiple recipients of list ORACLE-L Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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: Nirmal Kumar Muthu Kumaran 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: Rant
Gurus, ocp will let you enter into an interview - proved. However the candidates failed to prove it. Results spoiling the image on OCP. Nirmal. -Original Message- Sent: Monday, July 22, 2002 6:24 PM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you shutdown a database? Answer: Turn off the power to the computer. Question: How do you change the block size of a database. Answer: Change it in init.ora, restart database. Question: How do you add a datafile to a tablespace? Answer: You can't. Question: What are archived redo logs? Answer: There is no such thing. BTW: these folks had an OCP certificate. Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. We hired the guy, he's still here 2 years later and just recently got his OCP. Dick Goulet Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 6:58 AM Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask potential candidates are soley based on what is on the resume. So I figure if someone has, say, hot backups or SQL tuning on their resumes, I'd expect them to be able to hold a fairly intelligent conversation about these topics. No such luck! What really frustrated me, and what I really want to get out of my system, is that nobody that I talked to, had a real good concept of hot backups. Forget about recovery. I asked each and every candidate who claimed to have done hot backups, just give me a high level overview of how you do a hot backup. Don't care about syntax, just give me the mechanics. The answers I got were completely off base, baffling and frustrating. Some of these folks claimed to have 5 years experience!!! 'Well, we use scripts to do these, so I'm not sure how these are done...' (But it says on your resume you've done this???) 'Oh, I take the tablespace offline, and copy the datafile to tape...' (Unless I'm mistaken, that's not how a hot backup is done, right?) 'Well, I use the export utility, and as the backup starts, it is written to the dump file.' (Huh? What?) 'During this time, everything is written to the redo logs and not to the tablespace...' (You've been reading one of those books, haven't you?) I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you don't know. Well how about a simple recovery scenario. I asked every candidate how they would do an online recover of a datafile while the database was still in use. No ideas. Not even close. I dunno, perhaps I'm spoilt by being a member of this list? Perhaps I expect every candidate to be as knowledgeable as you guys? Perhaps I'm asking too much? Rant over. Thanks for listening. mkb __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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: Nirmal Kumar Muthu Kumaran INET
RE: Need to have 2 Columns of Size 3000 in 1 Table to Store Chara
create table t1 (a varchar2(4000)); hope that this will work oracle 8 and above. rgds, nirmal -Original Message- Sent: Monday, July 22, 2002 6:48 PM To: Multiple recipients of list ORACLE-L Data Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long) * ERROR at line 1: ORA-01754: a table may contain only one column of type LONG Qs Also please tell any Limitations , Disadvantages when using any Substitute Advised Datatype ? Thanks P.S. Any Disadvantages with using CLOB ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: Nirmal Kumar Muthu Kumaran 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: Covert tnsnames.ora to OID
Title: RE: Covert tnsnames.ora to OID OID?.. -Original Message- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] Sent: Mon, May 27, 2002 06:58 PM To: Multiple recipients of list ORACLE-L Subject: Covert tnsnames.ora to OID Hello All How can I covert all the names from tnsnames.ora to OID? I do not feel like entering all this data again, by hand, one by one. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: snapshot too old error - strange
Title: RE: snapshot too old error - strange Increase rollback segment size for this transaction and make sure that the transaction will use the huge rollback segment hth nirmal -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Mon, May 27, 2002 15:53 To: Multiple recipients of list ORACLE-L Subject: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
Help me on ORacle Character Set
Title: Help me on ORacle Character Set Hi...all I have installed oracle9i in my desktop winNT with arabic language support. While creating database i chosen US7ASCII. Even then all error messages are showing in arabic, and i couldnot able to read it. Can anyone suggest me a needful to solve this problem. Thanks in adv. Nirmal. - SQL ; 1* select * from nls_database_parameters where parameter like '%CHAR%' SQL / PARAMETER VALUE -- NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET US7ASCII NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 Êã ÇÎÊíÇÑ 4 ÕÝ SQL SQL*Plus: Release 9.0.1.0.1 - Production on ÇáÓÈÊ 05 25 16:15:12 2 (c) Copyright 2001 Oracle Corporation. All rights reserved. ÃÏÎá ßáãÉ ÇáÓÑ: ãÊÕá È: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production SQL dir SP2-0042: ÃãÑ dir ÛíÑ ãÚÑæÝ- Êã ÊÌÇåá ÈÇÞí ÇáÓØÑ SQL -
RE: Errors on Alert file
Title: RE: Errors on Alert file ORA-00602 ORA-00602internal programming exception Cause:An internal programming exception has occurred. Action:Report this error as a program bug to Worldwide Customer Support. nirmal. -Original Message- From: GL2Z/ INF DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]] Sent: 09 ÑÈíÚ ÇáÇæá, 1423 02:33 PM To: Multiple recipients of list ORACLE-L Subject: Errors on Alert file Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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: MTS and Dedicated Server
Title: RE: MTS and Dedicated Server Hi... 1) Just comment or remove the init.ora parameters related with mts. 2) Configure the database as MTS. By default all connections uses dispatchers. If you want to made a dedicated connection, configure ur tnsnames.ora accordingly. Means add the attribue SHARED_SERVER = YES in the CONNECTION_DATA tns parameter. HTH. Nirmal. -Original Message- From: Eriovaldo Andrietta [SMTP:[EMAIL PROTECTED]] Sent: 08 ÑÈíÚ ÇáÇæá, 1423 04:18 PM To: Multiple recipients of list ORACLE-L Subject: MTS and Dedicated Server Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
jre error while installing ora817
Title: jre error while installing ora817 Guru's I faced the following problem while installing oracle 8.1.7 on winNT pack4. Not all the dependencies for the component Oracle Enterprise Manager Common Files 2.2.0.0.0 are found. Missing Component oracle.swd.jre 1.1.8.10.0 Before i was installed oracle 8.1.7 and oracle 9i on the same pc without facing this problem. Lated i removed oracle 817, by deleting folders and cleared entries in regedit. Can any one have idea about this problem. Thanks. Nirmal.
RE: Table Insert Lock!!
Title: RE: Table Insert Lock!! Hi subra( my ex-pm name), Hope that ur not pricise in ur ?. If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by table level trigger of INSERTING. Sorry if i was u/s wrongly. Nirmal. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 15 ãÍÑã, 1423 03:43 PM To: Multiple recipients of list ORACLE-L Subject: Table Insert Lock!! Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on sun Solaris 5.7 Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- 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: system packages status is invalid Oracle 8.1.7 on red hat 7.2
Title: RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2 May be running the script file resolve the problem, but i could not find that why the packages became invalid after the application creation. any idea anyone ahve? Nirmal. -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: To: Multiple recipients of list ORACLE-L Subject: RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2 Run rdbms/admin/utlrp.sql or utlrep.sql. Then query again for invalid packages. If there are still many, then not enough room to hold them all in your shared pool. Packages are invalid when the db starts up, because no one has accessed them yet. Utlrp.sql forces Oracle to do the work up front. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2 And you can't compile them? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Praveen Sahni [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject: system packages status is invalid Oracle 8.1.7 on red hat 7.2 Hi All, I have installed Oracle 8.1.7 on red hat linux 7.2. Every thing has gone fine. I even gone and installed the application on that. My problem is I saw now that there are some system packages listed below having status as 'INVALID'. Can anyone please let me know why and if we have any solution now. Is there any script I missed that's need to run and can I run it now after creating the application. Thanks in Advance Praveen PACKAGE DBMS_AQADM PACKAGE DBMS_AQADM_SYS PACKAGE DBMS_AQIN PACKAGE DBMS_AQIN PACKAGE DBMS_AQ_EXP_HISTORY_TABLES PACKAGE DBMS_AQ_EXP_INDEX_TABLES PACKAGE DBMS_AQ_EXP_QUEUES PACKAGE DBMS_AQ_EXP_QUEUE_TABLES PACKAGE DBMS_AQ_EXP_SUBSCRIBER_TABLES PACKAGE DBMS_AQ_EXP_TIMEMGR_TABLES PACKAGE DBMS_AQ_IMPORT_INTERNAL PACKAGE DBMS_AQ_IMP_INTERNAL PACKAGE DBMS_AQ_SYS_EXP_INTERNAL PACKAGE DBMS_AQ_SYS_IMP_INTERNAL PACKAGE DBMS_DDL PACKAGE DBMS_HS PACKAGE DBMS_HS_ALT PACKAGE DBMS_HS_UTL PACKAGE DBMS_IAS_CONFIGURE PACKAGE DBMS_IAS_QUERY PACKAGE DBMS_IAS_SESSION PACKAGE DBMS_IREFRESH PACKAGE DBMS_ISNAPSHOT PACKAGE DBMS_PRVTAQIM PACKAGE DBMS_PRVTAQIP PACKAGE DBMS_RULE_ADM PACKAGE DBMS_SNAPSHOT PACKAGE DBMS_SNAPSHOT_UTL PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_STATS PACKAGE DBMS_SUMADV PACKAGE DBMS_SUMMARY PACKAGE DBMS_SUMREF_CHILD PACKAGE DBMS_SUMREF_PARENT PACKAGE DBMS_UTILITY PACKAGE HTP PACKAGE OWA PACKAGE OWA_COOKIE PACKAGE OWA_CUSTOM PACKAGE OWA_TEXT PACKAGE OWA_UTIL PACKAGE PRVT_EGUTL PACKAGE PRVT_EPGC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni 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: Koivu, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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
init.ora (un documented) parameters
Hei all, Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that only 203 parameters only documents, remaining are undocumented. This i read on a white paper. Where should i get information about these parameters? Just i want to know. Here is my Q. the init.ora parameter sql_trace=true, creates trace files in the server folder specified in USER_DUMP_DEST parameter. As a user, am running a SQL statement at client side, So how can i get the trace information for my sql statement. On the same white paper i read, the parameter _trace_files_public=true will do my request. Any Help highly appriciated. Rgds, Nirmal. application/ms-tnef
RE: Import Characterset problem
Hi gholam, Thanks for ur help, by the way let me know how to change the character set of DB using props$? Just you want me to update this props$ for nls_characterset with the new value?... is it recommanded one?... The exp dump file is of character set AR8MSWIN1256, now the target db is with characterset US7ASCII. Thanks. Nirmal. -Original Message- From: Ahmed Gholam Hussain [SMTP:[EMAIL PROTECTED]] Sent: 23 ÔæÇá, 1422 10:15 AM To: Multiple recipients of list ORACLE-L Subject: RE: Import Characterset problem Hi Nirmal , While importing u have to consider that the source and target databases character sets should be matching U can change the character set of your target database using props$ data dictionary view HTH Gholam -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Subject:Import Characterset problem Helo gurus, I exported on schema from the old datatabase and then i created new database in my PC. Now i want to import it, but it's saying that characterset is not match error. How can i rectify it Thanks. Nirmal. File: ATT18366.ATT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain 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). application/ms-tnef
Data Archiving
Title: Data Archiving Hi all, New year Greetings. We need to archive some history tables from the production database to new server. Totally around 50 history tables we need to move and each table having around 10 million of records. Some of history tables having records, which are required for another a year the production database, approximatedly i can say around 2 million of records in each table like this. So what is the best way to move these tables?. I suggested them to export/import tables and delete invalid records. But another team are planned to do it by a simple pl/sql script by making cursor, check validity of record, if yes insert into new server and then delete from production, repeat. I want to know the best way to do this job without any major implications. Both servers are oracle7.3.1. running on VAX/VMS. Thanks. Nirmal.
RE: Trigger
Title: RE: Trigger Hi if (col1,col2,col3) are forming primary key means, then how come you insert value for any one of primary key columns, if so it would not give error for NOTNULL nIRMAL, -Original Message- From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]] Sent: 06 ÔæÇá, 1422 04:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Trigger Hamid, Change your trigger as follows: Create or replace trigger cre_PK before insert declare loc_seq number; begin select seqname.nextval into loc_seq from dual; insert into tableA(col1) values(loc_seq) end / Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, December 20, 2001 12:55 PM To: Multiple recipients of list ORACLE-L List, I need some help for creating a trigger, here is my question? I have a table TABLEA(col1,col2,col3) col1 is Primary Key for this table and an application insert records into this table, but I want to write a trigger on this table to generate primary key with using nexval of a sequence I have tried but doesn't work , if any of you have some sample or some links I really appreciate, This is my trigger: Create or replace trigger cre_PK before insert insert into tableA(col1) values(seqname.nextval) end Thanks in Advance Hamid Alavi Office 818 737-0526 Cell 818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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).
RE: RE: Change PCTINCREAE for SYSTEM Tablespace
Title: RE: RE: Change PCTINCREAE for SYSTEM Tablespace Hi Tom, Can you review my views in changing pctincrease value: If i'm creating database manualy without dbassistant, The steps are, 1) CONNECT INTERNAL 2) CREATE DATABASE ( LOGFILES, A SINGLE DATAFILE FOR SYSTEM TABLESPACE AND other infos) 3) CREATING SYSTEM TABLESPACE 4) OTHER STEPS. GOING ON... Now why not i can change the PCTINCREASE at the step3?... In what way it'd affect the DB? And why we need to change sql.bsq instead? Hope that i didn't say anything incorrect. Let me know ur valuable reply... Nirmal., -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 03 ÔæÇá, 1422 04:50 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Change PCTINCREAE for SYSTEM Tablespace Tom, I agree and disagree with you, respectfully. Oracle does allow some changes to be made to sql.bsq and they always leave the option open to make changes after database creation and I don't see this request as all that odd. But for the most part if you do as recommended and leave the system tablespace to sys only you should not have a problem. That is until migration time!! Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 12/18/2001 5:30 AM Kimberly, I would agree with you if an experienced DBA makes the decision to change the storage parameters, and they absolutely know what the benfits would be. Generally speaking though, I think changing anything in the SYSTEM tablespace is bad practice. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 17, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Actually, I would not ignore the storage parameters of the SYSTEM tablespace. There are legit reasons to change the pctincrease to 0. If you leave it at 50 then SMON (or PMON can't remember at the moment) will try to coalesce the tablespace every time it wakes up. Its work it has to do that it really does not need to do. Better off scheduling to happen at your time schedule. -Original Message- Thomas F Sent: Monday, December 17, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Ken, Do yourself a favor. Ignore the SYSTEM tablespace storage params. The ONLY thing you should concern yourself in regard with the SYSTEM tablespace is if the file needs to extend itself because it is too full. All other storage parameters are created by Oracle at database create time and should not be changed. For other tablespaces, you can change this parameter anytime after the tablespace has been created. It will not, however, change existing extents, but will be used when new extents are allocated. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 17, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace without recreating the DB? For some reason the person who created the DB I am working on set PCTINCREASE to 50 (or didn't did not include this parameter). I am using this DB for a data conversion so there is no software connected to it and in turn no users on it. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. -- 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: 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: Kimberly Smith 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: which view for hidden objects
Title: RE: which view for hidden objects what u mean by hidden tables?... views? or synonyms? -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: 28 ÑãÖÇä, 1422 12:11 AM To: Multiple recipients of list ORACLE-L Subject: which view for hidden objects Which view is used to see hidden tables? 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).
Tuning FAQ's
Title: Tuning FAQ's Hi gurus, I wish to know very familiar questions or usual questions related with Oracle Tuning and backup and recovery. Hope that everyone will input their ?'s. Rgds, nirmal.,
RE: Message at the start of svrmgrl
Title: RE: Message at the start of svrmgrl What are the new things on oracle 8.1.7.2.1 patch. is't available on oracle downloads...? I'm much interested to know why should apply this patch is it for to rectify some bugs or something else... Rgds, Nirmal -Original Message- From: Hand, Michael T [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Message at the start of svrmgrl Anand, I installed the same(? 8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only executable responding like this. If so, try relinking. Mike Hand Polaroid Corp. -Original Message- I have just done installation of 8.1.7.0 on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. When I start svrmgrl I see a line inst emulated pid=175364 --$ svrmgrl inst emulated pid=175364 svrmgrl va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
RE: simple sql problem
Title: RE: simple sql problem
Hi...
You cann't run sql statement in command line directly However you can in case of script file.
Make the query as a script file. Then run it on SQLPLUS.
-- c:\test.sql
-
select * from emp
/
exit
/
--
c:\ sqlplus -s scott/tiger@oranir @c:\test
This will work.
HTH.
Rgds,
Nirmal,
-Original Message-
From: Viraj Luthra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option ::= { -s | -? }
-s for silent mode and -? to obtain version number
What is wrong above? I need to run the query from command line. How do I modify this :-
sqlplus -s scott/tiger select * from emp;
Rgds,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
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: how to pass argument to a dos batch program from sqlplus
Title: RE: how to pass argument to a dos batch program from sqlplus Have you been tried for it? It'll work fine. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 5:25 AM To: Multiple recipients of list ORACLE-L Subject: how to pass argument to a dos batch program from sqlplus Hello List, I need to pass several arguments to a dos batch program which is being called from sqlpus through HOST command. Example: host mybatch.bat myargument myargument Would such idea work? Thank you. -- 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: GRANT REFERENCES
Title: RE: GRANT REFERENCES Oracle itself saying that, you cann't create foreign key for a remote database table. To achive this, use database triggers. Let me know if am wrong? Nirmal. -Original Message- From: Ekan Emokpae [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Subject: GRANT REFERENCES Hi All, I am trying to GRANT REFERENCES on a table that resides on a different database, on a different server. Is this possible and how do I go about doing it. TIA E.
RE: Determinants of control file
Title: RE: Determinants of control file No. i already checked the view v$control_record_section, This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc Nirmal. -Original Message- From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
Determinants of control file
Title: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
Enable the partitioning option in database?.
Title: Enable the partitioning option in database?. -Original Message- From: Nirmal Kumar Muthu Kumaran Sent: Wednesday, November 28, 2001 4:56 PM To: '[EMAIL PROTECTED]' 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: enable the partitioning option in database?.
Title: RE: enable the partitioning option in database?. i didn't find the directory ORACLE_HOME\rdbms\lib itself... there is one directory jlib, but in that there is no 'make' file my system is ora817 on win nt. any help pls. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:33 PM To: Multiple recipients of list ORACLE-L Subject: 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).
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: 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: 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 /
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: HELP : doubts regarding --- Tablespace ,Roll Segment , dif
Title: RE: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent Hi sangeetha, Well, hope that u want to know all in big things in one struch ;-). Ok, here are my answers to you. 1) If the tablespace constains objects, you should not drop it normally, however you can do it by using the clause include contents in the drop tablespace command. This case, the tablespace itself removed, but still the user will exists with the same tablespace. But you cannt create any objects under that user, since tablespace is not available. 2) No. It's not necessary to create rollback segment( there is no such segment named Roll), every time you create any tablespace. Usually, there should a one tablespace space for rollback segments, so whenever required you can create it. 3) Myself known examples are, a) External tables: you can query on a flat datafile from Oracle, if u created external tables. b) Merge statment:, Suppose you want to insert into emp table using other table if the rows are not exists in emp or else you want to update it. In such a case, the merge statement is useful for u. More than this many new features are there so just gothrough the docs for it. 4) Oracle 7.3 was RDBMS, Oracle 8 was ORDBMS, Oracle8i is Internet based,(JAVA enables DB server), This is very short difference between oracle versions, as remaing gothrough oracle docs. HTH. Rgds, Nirmal. -Original Message- From: sangeetha [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Subject: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent hi list, i enrolled in this list jus today and it was really nice to see the questions and the responses that were posted.here i've got few doubts.if possible plz do clear them as soon as possible, as comming nov 30th is my project presentation. 1)If a tablespace is deleted will the users and tables created in that tablespace get deleted?,if not in which tablespace will the users and tables get stored. 2)what is the function of Roll Segment?...is it necessary to create it every time we create tablespace? 3)plz do give me the exact difference between oracle8i and oracle9i,ie., what are the advancements in Oracle9i not present in oracle 8i. d) diff between oracle8i and its previous versions. plz do clear all or any of the above doubts. awaiting for all u're replies eagerly. regards 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: Find DBA users
Title: RE: Find DBA users [EMAIL PROTECTED] select grantee from dba_role_privs where granted_role='DBA'; GRANTEE -- SCOTT SYS SYSTEM [EMAIL PROTECTED] grant dba to nirmal; Grant succeeded. [EMAIL PROTECTED] select grantee from dba_role_privs where granted_role='DBA'; GRANTEE -- NIRMAL SCOTT SYS SYSTEM [EMAIL PROTECTED] HTH, Nirmal. -Original Message- From: Daiminger, Helmut [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Find DBA users Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D
Title: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D Hi Tom, A week before i was tried to install oracle 9i on WinNT4(20GB Hard Disk, 128MB RAM). The software has been downloaded from Net. In my pc, i already have oracle731. I had tried to install oracle9i in another home. I had been installed oracle server sucessfully, but while creating the DB it failed by throwing our error message OUT of memory, there is no log, nothing. I cann't able to identify why is was happening. Even i tried to increase the virtual memory too (I want to know is it helpful if we were in out of memory state?). Then what i did is, uninstalled Oracle731, and cleared all relavant registry entries, restart the PC, started to install ORa9i. This time, it has done nicely, no problem nothing. But i was confused why installer refering other versions of oracle to install ora9i, anyway we are using different home, is't it?... Ok, ur attachment is in binary format, so it's NOT useful for us. I didn't find any similar type of doc file in ora9i installer CD. Can you post it in text format, if you don't mind. Another thing is, I would go into the registry and remove all traces of Oracle. -- How can do this, do you mean that, just search for oracle9i or something similar like this and remove from the registery? Thanks in advance Rgds, Nirmal. -Original Message- From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 10:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D Dan, It sounds like the 817 install left some trash around. If I were you, [Nirmal Kumar Muthu Kumaran] I would go into the registry and remove all traces of Oracle. Then, reboot the win2k box and try your install again. Attached is the Create a clean machine document that I obtained a few years back from an Oracle install disk. I have used it many times, and it *always* solves install problems on NT for me. The trick is to remove all traces, and reboot to make sure that all dll's have been purged from the system. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 26, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Database Configuration Assistant For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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). File: Creating a Clean Machine.doc
RE: create trigger and create any trigger
Title: RE: create trigger and create any trigger hI You must have create any trigger privilege to create trigger on any table which in other schema. The alter any table will allow you to change the structure of table, but not to create trigger on it. -Original Message- From: Wiegand, Kurt [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Subject: create trigger and create any trigger Is the CREATE ANY TRIGGER privilege required in order for a user to create a trigger on another user's table? Oracle8: The Complete Reference leads me to believe that all the user needs is the ALTER privilege for the table and the CREATE TRIGGER privilege. It seems to say that CREATE ANY TRIGGER is only required if the trigger is to be created in another schema. However, as USER1, I can't get the following to work without it: CREATE TRIGGER ABC AFTER INSERT ON USER2.DATA_READY FOR EACH ROW BEGIN return; END; SQL @t3.sql AFTER INSERT ON USER2.DATA_READY FOR EACH ROW * ERROR at line 2: ORA-00942: table or view does not exist Am I looking at this correctly? (I'm running 8.0.5.2.1 and all privileges on USER2.DATA_READY have been granted directly to USER1) Thanks. Kurt Wiegand IBM Global Services Cable Wireless Communications [EMAIL PROTECTED] 703 760-3619 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt 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).
Grant a cluster?
Title: Grant a cluster? Hi.. guru's... Sorry if it's a basic question Can i grant a grant a cluster to any user? Oracle document says, the object may be a table/view/sequence/synonym/procedure/package/funtion/...etc., except cluster. It means, we cann't grant a clusters? I don't think so it's not possible, since the all_clusters object having owner column, [EMAIL PROTECTED] select owner, cluster_name from all_clusters; OWNER CLUSTER_NAME -- -- SYS C_OBJ# SYS C_USER# SYS C_FILE#_BLOCK# SYS C_TS# SYS C_COBJ# SYS C_MLOG# SYS C_RG# SYS C_OBJ#_INTCOL# SYS C_TOID_VERSION# SCOTT MY_CLUSTER 10 rows selected. This give meaning that the cluster objects c_... are granted to scott rt? Please clear me... Thanks. Nirmal.
RE: close_cached_open_cursors error
Title: RE: close_cached_open_cursors error Hi... how i can come to know about all x$ tables... is there dictionary is there for it? Please let me know. Rgds, Nirmal. -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 6:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: close_cached_open_cursors error It is an underscored one. Issue this query to look its value: select ksppinm,ksppstvl from x$ksppcv b,x$ksppi a where a.indx=b.indx and ksppinm like '%close_cached%'; Regards. --- [EMAIL PROTECTED] wrote: Hi Eva , Closed_cache_open_cursors is a parameter in Oracle 7.3.4.x .This is obsolete in oracle 8.x If set in u r init.ora remove it. OR Some product is setting this at Alter system /Alter session HTH shreepad. This parameter controls whether cursors opened and cached in memory by PL/SQL are automatically closed at each COMMIT. A value of FALSE signifies that cursors opened by PL/SQL are held open so that subsequent executions need not open a new cursor. If PL/SQL cursors are reused frequently, setting the parameter to FALSE can cause subsequent executions to be faster. A value of TRUE causes open cursors to be closed at each COMMIT or ROLLBACK. The cursor can then be reopened as needed. If cursors are rarely reused, setting the parameter to TRUE frees memory used by the cursor when the cursor is no longer in use. Denham Eva [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L za [EMAIL PROTECTED] cc: 21/11/01 22:26 Subject: close_cached_open_cursors error Please respond to ORACLE-L Hello Guru's I hope someone can shed light on this problem, more a nuisance really. The below Alter Session statement has been appearing in the *alrt.log file. ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter The system is a Compaq 8500R system, Win2K and Oracle 817. Does anyone have an idea of what this is as everyone I have approached here at my work claims not to be using it, I suspect a third party product. Absolutely any info will be appreciated. TIA Denham _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com http://www.marshalsoftware.com _ -- 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ 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: Christian Trassens 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: SQL question
Title: RE: SQL question
update table_name set id = substr(id,-4);
eg:
[EMAIL PROTECTED] select substr('48900322',-4) from dual;
SUBS
0322
1 row selected.
Nirmal.
-Original Message-
From: Malik, Fawzia [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 7:04 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL question
Hi,
Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??
Any advice/hints would be greatly appreciated
Rgds
Fawzia
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Malik, Fawzia
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).
parallize printing reports to different printers
Title: parallize printing reports to different printers Hi all, A report producing multiple 1000 (say 5000) pages producing and we want to print it. However we don't want the user to be idle until it completes. So we plan to reduce the printing time by distributing (say 1000 each) report pages with different printers (say 5 printers). Question is, there is anyway i can assign the printer name in the report while printing it, like system parameters ., etc., Pleasae let me get ur ideas aeap. Thanks. Nirmal,
selftest q's doubt
Title: selftest q's doubt Helo guru's I had small doubts, may be it's trival too. Please remind me, How the following statements are true: a) Imiplicit cursors process only one row at a time Eg. Suppose a delete statement wipe off 10 rows from a table. This case How many rows are processes?, Is't 10 rows or 1 row? b) When using an ORDER BY clause to sort the rows returned by a query, the sort limit is the number of columns that exist in the tables(s) listed in the FROM clause. Eg. Assume that a table t having 2 columns c1, c2. In this case i can do the following query: sql select c1, c2, c1||'a', 'abc' from t order by 1,2,3,4; Here the table having only 2 columns, however i can able to sort in a query upto the number of columns exists in the select list. If so, how come quoted statement becomes true?. Is i'm missing something?. PS:. These hints got from the selftest. Rgds, Nirmal.
RE: List of synonyms
Title: RE: List of synonyms [EMAIL PROTECTED] COLUMN OBJECT_NAME FORMAT A30 [EMAIL PROTECTED] SELECT owner, object_name, object_type FROM dba_objects WHERE object_type='SYNONYM'; OWNER OBJECT_NAME OBJECT_TYPE -- -- -- SYS DEF$_AQCALL SYNONYM SYS DEF$_CALLDEST SYNONYM SYS DEF$_DEFAULTDEST SYNONYM SYS DEF$_ERROR SYNONYM SYS DEF$_LOB SYNONYM SYS DEF$_SCHEDULE SYNONYM PUBLIC ALL_ALL_TABLES SYNONYM PUBLIC ALL_ARGUMENTS SYNONYM Rgds, Nirmal. -Original Message- From: Ramon Estevez [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Subject: List of synonyms Hi, Does exist any view to check the list of synonyms in the DB. Version 8.1.7 Regards, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Dominican Republic 809-565-3121
RE: utl_file example
Title: RE: utl_file example
Hi,
Verify UTL_FILE_DIR init.ora parameter is defined properly.
In FOPEN function specify, filepath and filename as separate.
[EMAIL PROTECTED] ;
1 DECLARE
2 fid UTL_FILE.FILE_TYPE;
3 BEGIN
4 fid := UTL_FILE.FOPEN('c:\','test.log','w');
5 UTL_FILE.PUT_LINE(fid, 'Test file for usage of UTL_FILE package');
6 UTL_FILE.FCLOSE(fid);
7* END;
[EMAIL PROTECTED] /
PL/SQL procedure successfully completed.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
HTH.
Rgds,
Nirmal,
-Original Message-
From: Szecsy Tamas [SMTP:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: utl_file example
Hi,
Sorry for the previous post with a wrong subject in it.
Could somebody help me out with a very short utl_file example for Windows
NT? I would like write error data into a simple text file, but I get
exceptions.
TIA,
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
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: How can I tell if a procedure/package is running?
Title: RE: How can I tell if a procedure/package is running? Hi adams What should i get details of X$ tables. How much these tables are important as a DBA.. Rgds, Nirmal, -Original Message- From: Steve Adams [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: How can I tell if a procedure/package is running? Hi Rahul, 0 means not pinned; 3 means pinned in exclusive mode. I don't know what 1 means. I'm not accustomed to seeing it. Do you have any examples? @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- Sent: Tuesday, 30 October 2001 16:00 To: Multiple recipients of list ORACLE-L out of curiosity... what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD) -- From: Steve Adams[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: How can I tell if a procedure/package is running? Hi Doug, You can look at the mode in which the stored procedure or package is pinned in the library cache. This information is in X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by one or more sessions. If necessary, you can join to X$KGLPN to find the sessions holding the pins. See executing_packages.sql at http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- How can I tell if a stored procedure or package is in the middle of execution? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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: Moving the ALert and Dump Locations
Title: RE: Moving the ALert and Dump Locations yES, BY USING INIT.ORA PARAMETER BACKGROUND_DUMP_DEST nIRMAL. -Original Message- From: Denham Eva [SMTP:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 12:15 PM To: Multiple recipients of list ORACLE-L Subject: Moving the ALert and Dump Locations Hi, Is it possible to move the Alert log and Dump Locations to another location? ie - Oracle 8.1.7 on Win2K c:\Oracle\admin\DBNAME TO e:\Oracle\admin\DBNAME... Just wondering, anyone got any ideas? TIA Denham
RE: Rebuilding Indexes Question
Title: RE: Rebuilding Indexes Question
I think, rebuilding indexes may use the existing index to build, so that the performancce will improve comparitively doind drop and create indexes...
Nirmal.,
-Original Message-
From: Alex Hillman [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, October 28, 2001 3:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rebuilding Indexes Question
I remember reading somewhere that alter index ... rebuild analyzes index with estimate default. In case this is not desirable one need to reanalyze an index after rebuilding.
Alex Hillman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques Kilchoer
Sent: Monday, October 22, 2001 7:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rebuilding Indexes Question
-Original Message-
From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]]
What are the advantages/disadvantages to doing a alter index rebuild
(Oracle 8.0.X) versus dropping and recreating the index.
My personal opinion - if your database is not subject to any of the bugs reported against alter index ... rebuild commands,
{some bug examples:
[BUG:1475310] ALTER INDEX .. REBUILD ONLINE/ MOVE IOT ONLINE can corrupt the index. See [NOTE:125149.1]
[BUG:1427002] ALTER INDEX i REBUILD PARAMETERS('SYNC') may raise ORA-29863 / DRG-10595 / ORA-28579 (interMedia Text)
[BUG:1573283] OERI:6033 from ALTER INDEX .. REBUILD ONLINE PARAMETERS ('OPTIMIZE FULL')
etc...
}
alter index ... rebuild is easier to use, since you don't have to specify the full syntax that was used to build the index. I don't know of any reasons to prefer the drop index / create index method.
Any corrections/suggestions welcome.
Oracle9i-Download
Title: Oracle9i-Download Hi guru's anybody had an exp of downloading oracle 9i for nt/2000 from oracle site? I downloaded 3 winzip files. But i'm not able open the 2nd zip file, i got winzip error Cannot openfile: it does not appear tobe a valid archive however 1st and 3rd are perfect. I downloaded 2nd file(558m) itself, 3 times... i had the same problem What shall i do, to successfully download it. I have very eagar to practice, 9i features. Rgds, Nirmal.
RE: sequence pool
Title: RE: sequence pool Can you provide a small brief about the scenario, where exactly you want the bulk of sequences. Just want to know, until now i didn't face this scenario in my dev. Thanks, Nirmal, -Original Message- From: Doug C [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: sequence pool We had a situation like this - we wanted to get a large batch of sequences at once with one trip to the database. We used a stored procedure that took an argument how many do you want - and it used an execute immedate select nextval into an array and passed the array back. On Wed, 24 Oct 2001 08:00:24 -0800, you wrote: Hi, is there a smart way to generate IDs in chunks? getting an ID with nextval is perfectly ok most of the time, but sometimes the application would need to generate a pool of IDs and keep them for later use as I can't manipulate the currval of the sequence, I wander what the best solution would be thanx, 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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: Why does ittake long time?
Title: RE: Why does ittake long time? Have you checked, whether the query will be using the indexes, if u have any... Nirmal, -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject: Why does ittake long time? Hallo, Why does this query take so longtime to run...At least 20 minutes it is just a simple count... (Embedded image moved to file: pic24685.pcx) Thanks in advance Roland Sköldblom File: Paintbrush
RE: Oracle 9i CD
Title: RE: Oracle 9i CD http://download-east.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm Here is all, Oracle9i Database List of Books (Release 9.0.1; includes Windows books) Rgds, Nirmal. -Original Message- From: Sinard Xing [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i CD Hi, Where can I get Oracle 9i Document CD or Download URL (I prefer HTML format, but if pdf em... ok just have to print) I can't find Oracle 9i Concept in Technet, nobody raise this question before in Metalink. 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: Move table to another tablespace
Title: RE: Move table to another tablespace in your 3rd option, you must create all constraints(except notnull) for the new table, if any. + ur checklists. Nirmal. -Original Message- From: Hallas John [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Move table to another tablespace Various options available ) If using 8.1.7 then ALTER TABLE X MOVE TABLESPACE NEW should do it. Remember to rebuild any indexes afterwards 2)Export table rows =y grants=y indexes=y etc then drop the table. Create table in new tablespace (get syntax from imp file=x.dmp full=y indexfile=newtab.ind). Then run an import with the ignore existing objects set to Y. 3)create temp table in new tablespace by using create table new as select * from old;. Drop old table (or rename it) then rename the new table to the same name as the original one. Will need to check grants synonynms and recreate indexes. John -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Sent: 25 October 01 12:00 To: Multiple recipients of list ORACLE-L Subject: Move table to another tablespace Hallo, Can you please tell how to move one table from one tablespace to another? I have data inthistable. Thanks in advance Roland Sköldblom -- 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Move table to another tablespace
Title: RE: Move table to another tablespace hi... can you give the exact steps for ur 2nd option. 1)exp scott/tiger tables=emp, 2)alter user scott default tablespace tools,(before it's users) 3)imp scott/tiger fromuser=scott touser=scott But still oracle imports to users tablespace itself. i made users tablespace off, before import, that case, i kicked away by an error, as tablepsace is in offline. Expecting your answer. Rgds, Nirmal., -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Move table to another tablespace above 8.something alter table table_name move tablespace tablespace_name; Or always you can 1. export table 2. recreate in another tablespace 3. import data in table created in step 2. Gints Plivna IT Sistºmas, Meróe¶a 13, LV1050 Rïga http://www.itsystems.lv/gints/ Roland.Skoldbl [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Move table to another tablespace om 2001.10.25 13:00 Please respond to ORACLE-L Hallo, Can you please tell how to move one table from one tablespace to another? I have data inthistable. Thanks in advance Roland Sköldblom -- 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: 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: Droping System User
Title: RE: Droping System User hi I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before. Now i shutdown my database and startup again, here the problem arises. Oracle mount the database but while opening the database, the instance has been terminated by PMON. Sat Oct 20 10:57:45 2001 PMON: terminating instance due to error 470 Instance terminated by PMON, pid = 316 Oracle posted the following error continuosly in the alert log: SMON: following errors trapped and ignored: ORA-00376: file 1 cannot be read at this time ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' Am crusious, come to know what type of problem you have faced? Regards, Nirmal -Original Message- From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Droping System User -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Dropping the SYSTEM user is not really all that traumatic. In most cases it's just a DBA account that may own some pieces you'd rather not lose, but dropping SYSTEM will not be noticed by the users of the database. That's the impression I get. When I looked at the objects owned by SYSTEM in my test database before the drop, none of them seemed vital. On the other hand, dropping sys would probably be bad, but I wasn't able to do that (insufficient privileges.) Trying to drop sys tables like sys.user$ caused an ORA-00701. So since I'm on a quest to wound this database, I tried this: SQL delete from sys.user$ where name = 'SYS' ; 1 ligne supprimée. SQL commit ; Validation effectuée. So far no ill effects!
sys.obj$, type# desc
Title: sys.obj$, type# desc hI gurus' [EMAIL PROTECTED]; 1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and rownum 4 [EMAIL PROTECTED] / OBJ# NAME TYPE# - -- - 1149 DBA_ROLES 4 1150 DBA_ROLES 5 1151 DBA_PROFILES 4 [EMAIL PROTECTED] Hope that type# 4, refers 'SYNONYMS'. what is the object whic are refered by type# 5?.(Is't view?) Where i can check to know the desc for all the type#?. Regards, Nirmal.
RE: MAIL on insertion/updation of a record.
Title: RE: MAIL on insertion/updation of a record. I'm redirecting you to http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D This link explains how to send email through developer2000 forms. Hope that using utl_smtp package, you can send mails through pl/sql triggers. Rgds, Nirmal. -Original Message- From: SUNILSHIVAPPA [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 1:10 PM To: Multiple recipients of list ORACLE-L Subject: MAIL on insertion/updation of a record. hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case. regards sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA 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).
Export - Import from Oracle v8 to v731
Title: Export - Import from Oracle v8 to v731 Hi gurus, i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax). I successfully completed the export process: c:\exp80 parfile=c:\exp_par.dat exp_par.dat --- userid=msalah/msalah@qtel file=c:\test.dmp tables=(ctv_tv_dockets) grants=y indexex=y then am importing this dump file into oracle v731 which is running on vms-vax. imp_par.dat - userid=ops$cssdba/cssdba#act@csscli file=c:\test.dmp tables=(*) fromuser=msalah touser=ops$cssdba c:\imp71 parfile=c:\imp_par.dat here it's giving problem: IMP-3: ORACLE error 12151 encountered ORA-12154: TNS: could not resolve service name IMP-0: Import terminated unsucessfully Note that in interactive mode also i tried to import, but it's also not working. I'm expecting the problem is around - userid=ops$cssdba/cssdba#act@csscli here the password contains # symbol which refers comment usually. Before once i handled it successfully, but i forgot that way. anyone have any idea... rgds, Nirmal.
RE: privileges on packages
Title: RE: privileges on packages USER_TAB_PRIVS. Here is an example: [EMAIL PROTECTED] create or replace package my_pack is 2 type abc_t is table of number index by binary_integer; 3 p_abc abc_t; 4 p_un varchar2(20); 5 end my_pack; 6 / Package created. [EMAIL PROTECTED] show user; USER is NIRMAL [EMAIL PROTECTED] grant execute on my_pack to scott; Grant succeeded. [EMAIL PROTECTED] connect scott/tiger Connected. [EMAIL PROTECTED] select * from user_tab_privs 2 where owner='NIRMAL' and table_name='MY_PACK'; GRANTEE OWNER TABLE_NAME -- -- -- GRANTOR PRIVILEGE GRA -- --- SCOTT NIRMAL MY_PACK NIRMAL EXECUTE NO Rgds, Nirmal. -Original Message- From: SUNILSHIVAPPA [SMTP:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Subject: privileges on packages hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards, sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA 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).
Query
Hi gurus, My table data looks like as follows: [EMAIL PROTECTED] select * from t; ID P1 PVAL1 P2 PVAL2 P3 PVAL3 - - - 101 A VALUE A B VALUE B C VALUE C 102 X VALUE X Y VALUE Y Z VALUE Z 103 P VALUE P Q VALUE Q R VALUE R [EMAIL PROTECTED] Tab Description: [EMAIL PROTECTED] desc t; NameNull?Type --- ID NUMBER PCD1 CHAR(1) PVAL1VARCHAR2(20) PCD2 CHAR(1) PVAL2VARCHAR2(20) PCD3 CHAR(1) PVAL3VARCHAR2(20) I need output as like: ID Pcd PVAL 101 A VALUE A 101 B VALUE B 101 C VALUE C 102 X VALUE X 102 Z VALUE Z 102 Y VALUE Y 103 P VALUE P 103 R VALUE R 103 Q VALUE Q Anyone have any idea pls. Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Alert log from Remote client
Hi sean, My db is oracle816 on WinNT4. Acutally, i want to know how to access alert/trace files from the remote oracle server. Is the DBA should share access to the directory(background_dump_dest) for the remote adminstrator? In other way, i simply want to view the alert logs and trace files for the various databases, as you said. How can i? Nirmal -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Alert log from Remote client Nirmal, Perhaps the replies re AlertView have answered your question. AFAICR it requires FTP service to be running. You did not specify your Operating System. Do you simply want to view the Alert logs and Trace files for the various databases or be alerted if an error appears in Alert Log or a new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 12:19:57 +0300 Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Performance problem with connect string (2nd attempt)
unable to open the zip files. -Original Message- From: Dharani Ravi [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Performance problem with connect string (2nd attempt) Hi, Last week I had posted the same the question. As there are no replies, I am trying my luck once again. Pl help. Oracle Version 8.1.6 OS Solaris 8 Whenever we telnet and execute a job without connect string, the job runs within 15 minutes. However if the same job is executed with connect string (@dbname), then the same job takes 2 hours. I am enclosing a zip file which contains listener.ora and tnsnames.ora. How to solve this problem ? Thanks in advance. Dharan __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com File: Listener.zip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
Alert log from Remote client
Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
How to Identify the BG processes?
List, In multiple database instances, how can i find the background processes of appropriate instances?.. reGARDS, nIRMAL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: changing the internal password
Use the utility ORADIM C:\ORADIM -EDIT -SID SID_NAME -INTPWD NEW_PWD rEGARDS, nIRMAL. -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: changing the internal password You can use the orapwd utility to recreate the password file. Rick -Original Message- Sent: Tuesday, September 25, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: changing the internal password
Hi, - oracle_home\network\admin\sqlnet.ora # SQLNET.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN = qtel.com.qa SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf -- In this what type of modification i should do?... I had another doubt: Most of the times, oracle connects with internal without any password, may i know in which scanario, oracle will ask password for internal? Yearly of this year, from this list only i learned that we can change the internal password by 'ORADIM' utility. Now now i changed the internal password by using this utility. After that i tested with default password 'oracle' (???). it's going ... i surpriced... even more, if i put any characters instead of password, it's succeeded Can anyone please clear these issues. Thanks in adv. Regards, Nirmal. -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: changing the internal password You probably are running sqlplus on NT. Therefore, try with sqlnet.authentication_services=(nts) in the sqlnet.ora and look in the groups of users of NT for the group ora_SID_NT. The Oracle NT user has to be member of this one. If you are running Oracle on Unix, you have to look in sqlnet.ora again. You probably have a line with sqlnet.authentication_services with a value different that none and you don't have Advance Security installed or you are not using it. Regards. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Nirmal Kumar Muthu Kumaran 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: test
Please don't test here. -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject: test test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: Nirmal Kumar Muthu Kumaran 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: SQLLOADER question.
Hi, You can use the same with little modification. Since if there is more no. of columns, then terminated by is more headache. Load data infile * Append Into table tab1 fields terminated by ',' trailing nullcols ( col1 , col2 , col3 , col4 :col3*.07, col5) begindata 123,20010920,20,30,35 123,20010920,20,30,35 123,20010920,20,30,35 Regards, Nirmal. -Original Message- From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 11:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQLLOADER question. Ron, try this: Load data infile * Append Into table tab1 trailing nullcols ( col1 terminated by , , col2 terminated by ,, col3 terminated by , , col4 terminated by , :col3*.07, col5 terminated by , ) begindata 123,20010920,20,30,35 123,20010920,20,30,35 123,20010920,20,30,35 I just ran it - works fine! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 21, 2001 3:21 PM To: Multiple recipients of list ORACLE-L List, Oracle 7.3.4 Using SqlLoader I load a table with 5 columns of data. I would like to be able to have column 4 be the value of (col3 * .07). I have RTFM and other books but it seems that you are not allowed to perform calculations during the load except the date functions. Am I correct in my understanding? Control file info: Load data Append Into table tab1 trailing nullcols ( col1 terminated by , , col2 terminated by , TO_DATE(:col2,'MMDD'), col3 terminated by , , col4 terminated by , , col5 terminated by , ) The source data has values in each location: 123,20010920,20,30,35 Any Ideas? Thanks, Ron ROR mª¿ªm -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Nirmal Kumar Muthu Kumaran 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).
How to find the current instance name?
List, How to find the current instance name for the session?. From svrmgrl, i can using SELECT name FROM v$database. What is the equivalant from the ordinary user? Regards Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Error in creating tablespace
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: Nirmal Kumar Muthu Kumaran 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: Bulk collect error
Can you provide simplified resource details -Original Message- From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Bulk collect error can you provide simlified resource details. Hi, The following statment works perfectly: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) From Fofejezet F ; However when I put this very same statement into a Pl/Sql procedure with Bulk Collect, I get PLS-00103 error: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; Can somebody help me? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Nirmal Kumar Muthu Kumaran 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: How to find the current instance name?
No. By default SID and GLOBAL_NAME is same, but *NOT* necessarily. But in my case these two are different. Any ideas. Nirmal -Original Message- From: Ramasubramanian, Shankar (Cognizant) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to find the current instance name? select * from global_name; -Original Message- Sent: Thursday, September 20, 2001 4:25 PM To: Multiple recipients of list ORACLE-L List, How to find the current instance name for the session?. From svrmgrl, i can using SELECT name FROM v$database. What is the equivalant from the ordinary user? Regards Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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). File: InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: How to find the current instance name?
i cann't access V$ views as an ordinary user, rt? -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to find the current instance name? You probably want to do the following. v$database.name is the database name not the instance name. Although most name the same but not required. SELECT instance FROM v$thread; Rick -Original Message- Sent: Thursday, September 20, 2001 6:55 AM To: Multiple recipients of list ORACLE-L List, How to find the current instance name for the session?. From svrmgrl, i can using SELECT name FROM v$database. What is the equivalant from the ordinary user? Regards Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Two Instances at one oracle Server
No.. Not necessary for more listeners. One listener is enough to listen many servers. Nirmal. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Subject: Re: Two Instances at one oracle Server I'm sure that someone will correct me if I'm wrong but: The database is the physical datafiles laid out on the storage devices - hard disks; The instance is the logical constructions (SGA) that exist, hopefully, in RAM; The services are the NT operating system equivalent of UNIX processes which run the Oracle engine against the instance to access the database. In theory, an instance could be used to access multiple databases; however, in practice, DBAs set up one instance that will be used to access one database (and no other database). Also, databases could, in theory, be accessed from multiple instances; however, in practice, DBAs set up a database to be accessed from only one instance (and no other instance). Microsoft NT sets up the service so that it executes against one, given instance. However, NT will allow multiple services. So, you can have two databases, two instances, and two services on the same NT server. You'll also need two listeners and two services to run those listeners. You'll probably need to read the manuals for the exact details. Nirmal Kumar Muthu KumaranTo: Multiple recipients of list ORACLE-L NIRMALK@qtel[EMAIL PROTECTED] .com.qa cc: Sent by: Subject: Two Instances at one oracle Server root@fatcity. com 09/19/2001 03:55 AM Please respond to ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Nirmal Kumar Muthu Kumaran 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: inspdver... equivalent in 8i and above...
what is it INSPDVER??? -Original Message- From: Anjan Thakuria [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Subject: inspdver... equivalent in 8i and above... Listers, I am hoping someone knows the equivalent of inspdver in 8i and above. Can you please let me know. thanks Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
Two Instances at one oracle Server
Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Renaming GLOBAL_NAME
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: Mario Alberto Ramos Arellano 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: Nirmal Kumar Muthu Kumaran 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: DB Names in multiple oracle installs
You CANN'T(if not anyone correct me). Even if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:05 AM To: Multiple recipients of list ORACLE-L Subject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Two Instances at one oracle Server
How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: Sinardy 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: Nirmal Kumar Muthu Kumaran 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: Error in creating tablespace
Hi ... Might be your disk drive currpted, so that oracle unable to create the datafile on that drive, Try do create with some other drive. If not contact oracle support. Nirmal. -Original Message- From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Subject: Error in creating tablespace Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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: Nirmal Kumar Muthu Kumaran 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: ORA-00600
Hi sirisha, ORA-00600 ORA-00600internal message code, arguments: [num], [?], [?], [?], [?], [?] Cause:This is a catch-all internal message for ORACLE program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include: ·time-outs ·file corruption ·failed data checks in memory ·hardware, memory, or I/O messages ·incorrectly restored files The first argument is the internal message number; other arguments are various numbers, names, and character strings. (See section Reporting a Problem to Worldwide Customer Support on page 1-12 for more information.) The numbers may change meanings between different versions of the ORACLE Server. Action:Report this error to Worldwide Customer Support after gathering the following information: ·events that led up to the error ·the operations that were attempted that led to the error ·the conditions of the operating system and database at the time of the error ·any unusual circumstances that occurred prior to receiving the ORA-00600 message. ·contents of any trace files generated by the error ·the relevant portions of the Alert file NOTE: The cause of this error may manifest itself as different errors at different times. Be aware of the history of errors that occurred prior to this internal error. *** Hope that this would help you, REgards, lamriN. Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha 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: Nirmal Kumar Muthu Kumaran 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: Select question
Hi,
You cann't use the distinct operater for multiple columns of a select list
as well as in the middle.
U can do like this:
SQL SELECT DISTINCT ('Testing '||To_Char(my_date,'mon')) FROM mytable;
Nirmal,
-Original Message-
From: Sinardy [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Select question
Hi all,
Why I can't do this ?
Select 'Testing ' || distinct(to_char(mydate, 'MON')) from mytable;
*
ERROR at line 1
ora-00936: missing expression
it is work if I do
Select distinct(to_char(mydate, 'mon')) || ' testing' from mytable;
WHY ??
Best Regards
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
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: Nirmal Kumar Muthu Kumaran
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: Ftp from Oracle
You can thorugh HOST command, obivously *NOT* from the serverside, in front end you can. Nirmal -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Ftp from Oracle Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: Nirmal Kumar Muthu Kumaran 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: Sql query
The query becomes perfect, if you replace ROW_NUMBER() BY DENSE_RANK(). --nIRMAL. -Original Message- From: Swapna_Chinnagangannagari [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sql query Hello Larry, Thanks alot for u'r immediate response but i'm a not old bee in sql queries can u please elaborate on the line ROW_NUMBER () OVER (PARTITION BY Pname ORDER BY Score Regards Swapna -Original Message- From: Larry Elkins [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Subject:RE: Sql query The following works with 8.1.6 and above: 1 SELECT T3.Pname, 2 T3.Team, 3 Sum(Decode(T3.Top3,1,T3.Score)) Score1, 4 Sum(Decode(T3.Top3,2,T3.Score)) Score2, 5 Sum(Decode(T3.Top3,3,T3.Score)) Score3 6 FROM (SELECT Pname, 7 Team, 8 Score, 9 ROW_NUMBER () OVER (PARTITION BY Pname ORDER BY Score DESC) Top3 10FROM Player 11WHERE Team = 'IND') T3 12 WHERE T3.Top3 = 3 13 GROUP BY T3.PName, 14 T3.Team 15* ORDER BY nvl(Score1,0)+nvl(Score2,0)+nvl(Score3,0) DESC SQL / PNAMETEAM SCORE1 SCORE2 SCORE3 -- -- -- -- TendulkarIND 138 83 67 Dravid IND53 32 Yuvaraj IND42 27 12 SewagIND47 I wasn't sure of the order was important, but, your output (maybe by chance) was in descending order of the sum of the top 3 grades, thus the order by clause you see above. Ditch it if it should be something else. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- Swapna_Chinnagangannagari Sent: Sunday, September 09, 2001 9:45 PM To: Multiple recipients of list ORACLE-L Hello Friends I am struck up with typical problem. I got this problem while querying data from Oracle Tables. I can't explain the problem as it is with my project business jargons so I am formulated the problem in following way. Let us assume that table and data of it as given below: TABLE : PLAYER PLAYER NAME TEAMSCORE Tendulkar IND 83 Tendulkar IND 42 Tendulkar IND 138 Tendulkar IND 67 Tendulkar BOMBAY 159 Dravid IND 32 Dravid IND 53 Dravid SZONE 72 Yuvaraj NZONE 91 Yuvaraj IND 27 Yuvaraj IND 42 Yuvaraj IND 12 LaraWI 83 Sewag IND 47 Sewag NZONE 17 I want the report based on the above table data as follows: I want player name and his best 3 scores played for the team IND. Report has to be look like as given below. To get the following report output I need One-shot-SQL query? (I don't want any PL/SQL as solution) PLAYER TEAMSCORE1 SCORE2 SCORE3 Tendulkar IND 138 83 67 Dravid IND 53 32 Yuvaraj IND 42 27 12 Sewag IND 47 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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: Nirmal Kumar Muthu Kumaran 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: query for top customer
Hi thomas, You use correlated sub-query for that, it's quite simple than ur stuff: select * from emp a where n = (select count(distinct sal) from emp b where a.sal = b.sal) order by sal desc; --- [EMAIL PROTECTED] ed Wrote file afiedt.buf 1 select * from emp a where n = (select count(distinct sal) from emp b where a.sal = b.sal) 2* order by sal desc [EMAIL PROTECTED] / Enter value for n: 3 old 1: select * from emp a where n = (select count(distinct sal) from emp b where a.sal = b.sal) new 1: select * from emp a where 3 = (select count(distinct sal) from emp b where a.sal = b.sal) EMPNO ENAME JOB MGR HIREDATESAL COMM DEPTNO - -- - - - - - - 7839 KING PRESIDENT 17-NOV-81 5000 10 7788 SCOTT ANALYST7566 09-DEC-82 3000 20 7902 FORD ANALYST7566 03-DEC-81 3000 20 7566 JONES MANAGER7839 02-APR-81 2975 20 4 rows selected. --- The same thing you can impose in ur case also. REgards, Nirmal Kumar. -Original Message- From: Thomas, Kevin [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: query for top customer Try this... DECLARE CURSOR c_sales IS SELECT * FROM sales ORDER BY sales desc; r_sales c_sales%rowtype; l_count NUMBER := 0; BEGIN OPEN c_sales; DBMS_OUTPUT.PUT_LINE( 'Customer' || ' ' || 'Sales' ); WHILE l_count 3 LOOP FETCH c_sales INTO r_sales; DBMS_OUTPUT.PUT_LINE( r_sales.customer || ' ' || r_sales.sales ); l_count := l_count + 1; END LOOP; CLOSE c_sales; END; / I did it as a pl/sql block because you can't be fancy (well not in 7.3.4) and use ROWNUM with an ORDER BY. I was going to suggest just doing: SELECT * FROM sales WHERE rownum 4 ORDER BY sales DESC; But alas, this doesn't work...try the above, it's nasty but quick... HTH, Kev. __ 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: 10 September 2001 14:30 To: Multiple recipients of list ORACLE-L how to write a query to find top 3 customer based on their sales . eg. TABLE A customer sales A100 100 A101 200 A102 105 A103109 A104108 RESULTS should be.. A101 200 A103109 A104108 Thanks in advance Brajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA 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 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: Nirmal Kumar Muthu Kumaran 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).
SQL*LOADER ERROR
Hi gurus, Greetings. c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl ORA-12203: TNS:unable to connect destination SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1] But am able to connect with SQL*Plus with the same username/password. Why it's showing this error, then?. Am using oracle 8.0.4, on Win NT. Rgds, Nirmal. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
how to close report BG engine programatically
How can i close the report engine window, which is automatically opened while calling a report from forms, programatically. any one any help greately appriciated. rgds, nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
sqlldr80- error
Hi gurus, Greetings. c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl ORA-12203: TNS:unable to connect destination SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1] But am able to connect with SQL*Plus with the same username/password. Why it's showing this error, then?. Am using oracle 8.0.4, on Win NT. Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).
