Re: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
I think that this require a deeper investigation. Last night I tried to use alter system sql_trace=true and it did not work either. I had to put sql_trace=true in init.ora and to bounce the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 8:18 PM All Im trying to run the following statement EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE) And get the following error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Looking under SYS schema I have package and package body for DBMS_SYSTEM and the body includes SET_SQL_TRACE_IN_SESSION I had to turn on tracing on the database level... What could be the matter with this?? Many Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Yechiel Adar 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: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
prefix it with sys. ie: EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE); Yechiel Adar <[EMAIL PROTECTED]>wrote: I think that this require a deeper investigation.Last night I tried to use alter system sql_trace=true and it did not workeither.I had to put sql_trace=true in init.ora and to bounce the database.Yechiel AdarMehish- Original Message -To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent: Thursday, October 03, 2002 8:18 PMAll Im trying to run the following statementEXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)And get the following errorERROR at line 1:ORA-06550: line 1, column 7:PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must bedeclaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredLooking under SYS schema I have package and package body for DBMS_SYSTEMand the body includesSET_SQL_TRACE_IN_SESSIONI had to turn on tracin! ! g on the database level...What could be the matter with this??Many Thanks in advancebob--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Bob MetelskyINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Yechiel AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.c! ! omSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
Cary Millsap's course and a new article
I attended Cary's and Jeff's Hotsos Clinic last week. It was really good. I wrote a short review, which probably doesn't do the course justice, at the following URL: http://www.oreillynet.com/pub/wlg/2111 I also wrote a short article last week about an aspect of Oracle's newly-supported SQL92 join syntax that really surprised me: http://www.oreillynet.com/pub/a/network/2002/10/01/whatsinacondition.html Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * mailto:[EMAIL PROTECTED] * 906.387.1698 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Shell scripting
hi well i think i did this once, you can read the output of the SQL query into shell variables by first redirecting the output of the SQL query to an OS file and then reading the file and loading the data in the file into shell variables. /* here is sample code to redirect the output of sql query to OS file */ #!/bin/sh CMD_FILE=sql_input.sql LOC_FILE=output.log SQLCMD="connect internal ; select * from sys.dba_users ;" echo "$SQLCMD" > ${CMD_FILE} svrmgrl < ${CMD_FILE} > ${LOC_FILE} /* redirecting the out of svrmgrl to OS file */ regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' "Cyril Thankappan" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Shell scripting Sent by: [EMAIL PROTECTED] 10/04/2002 09:18 PM Please respond to ORACLE-L Hi I wanted to select a column from a v$ table struggled with it and finally came with a workaround as follows archived_log='$archived_log' begin_seq=`sqlplus -s /nolog
RE: ora-305500
Thank you, Lynda, it worked. Aleem -Original Message- Sent: Saturday, October 05, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Subject:RE: ora-305500 It is the line that contains (--) in the beginning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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).
remove & move a user
Hi, what's the best method to 1) remove a user absolutely. I want to remove the user's tables, indexes, ... etc. 2) move a user absolutely to another tablespace. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS 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).