Re: ORA - 12560: TNS: protocol adapter error
Title: How to read trace file check to see whether listener settings are done on the system. check for tnsnames.ora and listener.ora files on home\network\admin folder cheers. saurabh - Original Message - From: S.Jyotinarayan To: Multiple recipients of list ORACLE-L Sent: Monday, November 12, 2001 3:00 PM Subject: ORA - 12560: TNS: protocol adapter error Hi, I have installed your Oracle 8i EE trial software. When i am trying to connect through SQLPLUS with username: SCOTT andpassword: TIGER i am getting the following error :- "ORA - 12560: TNS: protocol adapter error".Could you tell why i am getting this error? What other information should i provide you?Thanx in advanceJyotinarayan
Re: Oracle 9i Problem
may be the Zip file is downloaded properly (left some component) or may not be unzipping correctly. try out after restarting the Unzip operation. or else download again. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 8:20 PM Hi I have some problems with Oracle 9i for Linux, I downloaded the files from OTN then I did all the steps that otn said: 1. Run gunzip filename on all the files. - Eg.: gunzip Linux9i_Disk1.cpio.gz 2. Extract the cpio archives with the command cpio -idmv filename - Eg.: cpio -idmv Linux9i_Disk1.cpio but the second step did not work... I didn't see any files!! What's wrong?... Thanks Alex Tomita -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) 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: Saurabh 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).
Problem - V$BUFFER_POOL_STATISTICS
Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED]Contact : saurabh00pc @ MSN / Yahoo
Re: orapwd utility
ORAPWD utility is used to create password file for verification of dba users through password file. when u create pasword file through it, dba users INTERNAL an SYS are automatically added and verified through this file. similarly when u grant SYSDBA to any user, it is also added to this file. but this needs remote_login_passwordfile parameter to be set as EXCLUSIVE. hope this helps.. Saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 05, 2001 3:15 PM Hi lists, Can anynbody tell me this orapwd utility. is there any relation tothis password utility and grant a user SYSDBA/SYSOPER? if i need to grant to user SYSDBA , do i need to create password file. regards sriniva -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: Hot Backup Issue
hi, i feel u need to give the name of online redo log file after u had applied all the archived log files, if it's asking for more files. this should solve ur problem. pls let me know if it not. i'll try finding other issues also. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 01, 2001 5:50 PM Hi All, I am trying for hot backup restore/recovery. Oracle 8.1.7.0.0 on WIN 2K Server. I am performing the operations in following order: 1. Put all the tablespaces in backup mode. 2. Copy all the datafiles to backup location. 3. Do end backup for all the tablespaces. Also switch logfile after every end backup ( some more switch logfile at the end). 4. Shutdown the database ( after all its test instance). When I try to completely recover the database using backed up datafile the recovery goes upto last archived logfile and even after applying last archived logfile it asks for the next archived logfile. This is a very awkward situation, how can I provide next archived logfile if there is no activity and I had shutdown the database immediately after last switch logfile. If I try to open the database, then I get following error: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' Upon checking the metalink, some guys suggest, using _allow_resetlogs_corruption = true. But I am afraid of using this, because I have to implement this into production environment too (where same problem is happening). After lots of testing I have found that incomplete recovery (cancel based) goes fine with the same backup and I can open the database without any error. But keeping the needs of production database in mind, it would be very difficult to do an incomplete recovery every time. Why can't I perform complete recovery? Am I missing something? I hope someone on this list would have experienced the problem and would have got the solution as well. Please share your experience... Thanks in Advnace, Rajesh -- 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: Saurabh 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).
Re: Shutdown and archivelog mode
do a shutdown normal ALWAYS after issuing a shutdown abort. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 3:16 PM Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that, same) Due to this when I try to put it archivelog mode after shutdown abort I get a message saying that the database can't be put into archivelog mode because recovery is needed. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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: Saurabh 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).
constraints in create table..
hi all, do anybody explain me what is happening when i'm creating a table with the following constraints.. CREATE TABLE TAB1( ENUM NUMBER PRIMARY KEY CHECK(ENUM IS NULL), ENAME VARCHAR2(10) ); why i'm being able to create table with such contradicting constraints. both can't be true at the same time. i can't have null in aprimary key. what's the significance of this DDL. thanks in advance.. Saurabh Sharma
different stats in sga..
Hi all, i've changed the log_buffer parameter in my init file to a little higher value( say from 32768 to 40960) and bounced my DB but sga shows the redo buffer to 73728 (no change in pre value) while looking into v$sgastat, it says log_buffers = 65536 (still no change in pre value) why is this so, i'm getting diff values.. can anyone explain. thanks Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: IMP 8.1.6 to 8.1.7 DB
wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you
mts parameters
hi all, do the setting up of following mts parameters means, i'm using mts architecture. mts_dispatchers string (ADDRESS=(PARTIAL=YES)(PROTOCOmts_listener_address stringmts_max_dispatchers integer 5mts_max_servers integer 20mts_multiple_listeners boolean FALSEmts_servers integer 1mts_service string APEX by mts configuration, the doc says.. The multi-threaded server architecture eliminates the need for a dedicated server process for each connection. A small number of shared server processes can perform the same amount of processing as many dedicated server processes. but all the connections made to server are dedicated. what does this means. what is then i'm using.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html BEGIN:VCARD VERSION:2.1 N:Sharma;Saurabh FN:Saurabh Sharma EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010808T095228Z END:VCARD
Re: cleaning up oracle homes on NT
u can also remove specific or all oracle home from ur system. go to registry editor.. local machine/software/oracle and remove what u want.. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 5:11 PM Andrea asked about removing NT services. What about Oracle homes? The Oracle Universal Installer appears to be doing a poor job of cleaning those up when we de-install Oracle software. 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] mailto:[EMAIL PROTECTED] -- 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 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: Saurabh 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).
using ora dbf as datafile extensions..
hi all, is there any problems using different filetypes for various datafiles in the same database. i mean using some files as .dbf extension while some as .ora i'm using system, rbs, temp, oemrep as .dbf, while the one i creted later are using .ora extension. does it cause any problem in conversion or upgradation. any views. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html BEGIN:VCARD VERSION:2.1 N:Sharma;Saurabh FN:Saurabh Sharma EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010731T071402Z END:VCARD
Re: Urgent..DB creation problem..
there are two parameters infact that need to be removed(commented) from init file. mts_dispatcher mts_server thanks for all replies. problem goes away. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 30, 2001 12:20 AM Look at the parameter mts_dispatcher in the init.ora. Probably you'll see this: mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) I suggest you to choose on the Database Assistant the option of generating the scripts. And before running these, renmark the parameter. Regards. --- Saurabh Sharma [EMAIL PROTECTED] wrote: Hi all, i'm having a problem in creating new database through database config assistant. after giving all information (both in typical and custom mode) it starts creating DB, but soon shows the msg invalid specification for mts_dispatcher in initSID.ora file.. while there is no DB on the server, how is it reading the init.ora file. i've not specified any new mts_dispatcher parameter value. why it is showing me the error msg. how to counter this. other errors are oracle not available. error code ORA-00101 invalid specification for system parameter MTS_DISPATCHERS Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: Saurabh 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).
Re: Urgent..DB creation problem..
thanks a lot Jon, that was really a big help. thanks again. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Jon Walthour To: Multiple recipients of list ORACLE-L Sent: Saturday, July 28, 2001 5:55 PM Subject: Re: Urgent..DB creation problem.. There's not a database on the server yet, that's true. Oracle is just trying to start the instance with the initSID.ora file it has. Are you using MTS? If not, the way to fix the problem is to remove the MTS_DISPATCHERS parameter from your initSID.ora file. To make this work, when the db assistant gets done with all the setup and offers to either create the db or save off the scripts for running later, save the scripts then edit the initSID.ora to make sure the MTS_DISPATCHERS parameter isn't there. Then run the scripts yourself and you shouldn't have that problem. Jon Walthour - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Saturday, July 28, 2001 2:50 AM Subject: Urgent..DB creation problem.. Hi all, i'm having a problem in creating new database through database config assistant. after giving all information (both in typical and custom mode) it starts creating DB, but soon shows the msg "invalid specification for mts_dispatcher in initSID.ora file.." while there is no DB on the server, how is it reading the init.ora file. i've not specified any new mts_dispatcher parameter value. why it is showing me the error msg. how to counter this. other errors are oracle not available. error code ORA-00101 invalid specification for system parameter MTS_DISPATCHERS Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Help need
Title: Help need Hi deewakar, hope this will help.. SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/ Saurabh Sharma Oracle DBA [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Deewaker G.V. To: Multiple recipients of list ORACLE-L Sent: Friday, July 27, 2001 2:20 PM Subject: Help need HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf
Urgent..DB creation problem..
Hi all, i'm having a problem in creating new database through database config assistant. after giving all information (both in typical and custom mode) it starts creating DB, but soon shows the msg "invalid specification for mts_dispatcher in initSID.ora file.." while there is no DB on the server, how is it reading the init.ora file. i've not specified any new mts_dispatcher parameter value. why it is showing me the error msg. how to counter this. other errors are oracle not available. error code ORA-00101 invalid specification for system parameter MTS_DISPATCHERS Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Help ! ORA-00600 : internal error code
this is an error code that must be reported to Oracle support along with full description of error, procedure performed that caused this error and also details about your database environment settings. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:01 PM Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Saurabh 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).
Re: Solaris.. help.!!
thanks.. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 1:15 PM Start at Oracle Technet there is documents on installing and administering on Solaris. After that maybe ask specific questions on this list about something you don't understand and provide error messages if you have any from installing or using it. It isn't all that hard if you just want to get it up and running. The document is pretty straight forward and mostly self explanatory. If you need to do more like set up correct tablespaces and specific rollback segments to say run Oracle Financials, then perhaps you should look at spending some money on a experienced DBa to consult and or assist. HTH Peter At 04:25 PM 26/07/2001, you wrote: Hi all, please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc.. thanks. Saurabh Sharma mailto:[EMAIL PROTECTED][EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty 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: Saurabh 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).
Solaris.. help.!!
Hi all, please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc.. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
retrieving BLOB column..
hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
OUTPUT WIDTH..
hi all, how do i increase the width of output of a querry concatenated with some strings through '||'. the output is truncated in the end. output is ok in sql prompt with set line option. but whatabput svrmgrl.. any idea.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Re: Jobs
i definitely agree with u. i feel if the information is recieved through the list. at least one should try to communicate individually. as the mails provides the sender's id clearly. it should'nt be to include all for your individual work. and with an attachment.. god save all!!! it's a common effort of the have's for the have not's. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 7:10 PM Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour --- Original Message --- From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 8:30:27 AM Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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: Saurabh 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).
Re: How to deal with special character like in ' '
choose use some other character for define. set define $ or so.. will let u insert string containing Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 24, 2001 3:03 AM Subject: RE: How to deal with special character like in ' ' Thanks Joe. I did not know that command existed. Makes life easier. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How to deal with special character like in ' ' set scan off joe [EMAIL PROTECTED] 07/23/01 01:51PM Hi, I want to insert a string like 'AM University' but has problem with '' I want the database exact AM University. But it always ask me new or old value because of symbol '' how could I deal with that. Thanks. HL Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/
pls help..
hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Locally managed tablespaces
consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Hillman, Alex 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The 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: Jon Walthour 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: Saurabh Sharma
urgent pls...PL/SQL problem..
hi list, i'm conerting my old db structure into a new one with entirely different constraints, references, etc.. the new structure holds many new tables some splitted from old ones with few new columns. and like. now i want to move my old data into this new one. i 'm doing it through pl/sql, writing procedures, etc. now my problem is i've a master table for skills. and a detailed table referencing it. previously the detailed table stores the values with no ref. to the master, now it is storing the code corresponding the master value. i want to compare the old detailed table and old master table's values to fetch the code from the master table. when i try to fetch this through cursor, the values containing null in detailed tableare returning error.. while rest going fine. how do i treat the nulls, the nvl(col,'0') to convert nulls to 0 is also not working. any idea. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
how to get back value stored through get_hash_value function..
hi list, dbms_utility.get_hash_value converts a string into its hash value.. how do we get back the original value while selecting the entire record. TIA Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
strange datafile name..
hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Oracle db missing
i think u need to check whether the oracle agent is started on the node running that database. check it from control panel/services. a service named oracleAgent must be started. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 9:15 AM I just install a preconfigure - Oracle 8i into my win2k machinese becoz of the testing requirement , I have configure another small 'test' db , I can see the tnsname already include the new small baby 'test', but when I goto DB studio ,the OEM did't show me my new db ? why ? I can run sqlplus scot/tiger@test ,why the OEM can't detect it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong 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: Saurabh 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).
Re:
u can always have multiple oracle homes on NT. create new home for installing new version. if u want to install higher version it will ask u for migrating the DB. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 06, 2001 11:45 AM Hello guys, can anyone tell me how can i have two versions of oracle on the same machine. Is it possible. I have to put together 8.1.6 and 8.1.7 on the same machine. I'm using Windows NT. Thanks in advance Tom Pilfer _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ssskrun ssskrun 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: Saurabh 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).
Re: db links...
thanks a lot. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 1:20 PM Hi, Create {public} database link LINK connect to remote_db_username identified by remote_db_username_password using 'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_l ink'; There may be some issues with global name settings that may force you to name the database link exactly the same as the global name of the remote database. jack Saurabh Sharma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ssharma1@fcsl cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) td.com Subject: db links... Sent by: [EMAIL PROTECTED] om 05-07-2001 09:05 Please respond to ORACLE-L hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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: Saurabh 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).
Re: urgent..! how to combining 2 querries...
ya i checked this too.. it's not working. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:00 PM sorry. I checked it and turned out that this is wrong solution Hi! Try this. select a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files a, dba_free_space b where b.tablespace_name=a.tablespace_name group by a.tablespace_name Gyula -- 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: Saurabh 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).
urgent..! how to combining 2 querries...
hi gurus, any body have any idea of how to join these querries. i want to select from two different tables namely dba_data_filescall it A and dba_free_space call it B. but the columns being selected are same i.e. tablespace_name and bytes from both tables. i want to select in a single querry as.. tablespace_name bytes1 bytes2 -- -- -- -- -- -- -- -- -- where bytes1 is sum(bytes) group by tablespace_name in table a. and bytes2 is sum(bytes) group by tablespace_name in table b. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
sysstat table..
hi all, can anybody explain me what does the following statistics means from my sysstat table. redo entries 10476redo size 2851660redo buffer allocation retries 5redo wastage 1044924redo writer latching time 73redo writes 3465redo blocks written 7851redo write time 6583redo log space requests 16redo log space wait time 1438redo log switch interrupts 0redo ordering marks 0 Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: EXECUTING DOS COMMAND IN A STORED PROC?
hi, i think u should make use of ocopy utility instead of simple copy command. this is provided in oracle_home\bin jsu replace copy with ocopy. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 27, 2001 8:37 PM Subject: EXECUTING DOS COMMAND IN A STORED PROC? Hi gurus, I want to create a stored procedure to move some files to a different location. CREATE OR REPLACE PROCEDUREmove_file (file_name varchar2) IS begin host copy C:\file_name.txt D:\file_name.txt; end; / But does not recognize COPY command here. How can I do that?? Thank you
need urgent reply..
hello all, i installed and configured the OEM 2.0.4 successfully. and also do the configuration for Oracle Management server as required. but unable to start the oracle agent service. I've Oracle 8.1.5 on NT 4.0 Server. the error was: Error 0015: could not find the file specified. i came to know through Oracle\ora81\network\agent\doc\readme, that i've agent version 8.1.5, which it says is compatible with my oracle version. how do i start the agent service, any help is highly appreciated. Is agtctl utility provided in oracle\bin used for this purpose, but it is also not running saying unable toaccess the initialisation file. thanks in advance.. Saurabh Sharma Oracle 8i DBA
Re: which initSID?
hey, why don't u querry v$parameter view. the parameter ifile gives u the complete path and name of init.ora file. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 9:35 AM This will not give you solution. As backup of controlfile to trace will not give initSID.ora file path. Actually as per my knowledge there is no table which gives path of initSID.ora file. What you can do is find all init parameter files in your system. Then check SID part of your filename. If you have any doubt then also count SGA of each initSID.ora and your database SGA. This is not 100 percent correct and also seems to be some what tedious but you can try this for your database. Regards, Jaimin. -Original Message- Michael (TEM) Sent: Tuesday, June 26, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Can't you do it indirectly with an 'alter database backup controlfile to trace' command? I seem to recall that there's a path to the initSID.ora file there. 'Course, it could be just the generic path...I never tried changing it to see... HTH, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message- Sent: Monday, June 25, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Seema, There is no way to find that out. Unless, the init.ora uses ifile option and the file pointed to by ifile contains all the parameters. In that case you can query v$parameter view to see what ifile points to. By default Oracle looks for it in the $ORACLE_HOME/dbs directory. HTH, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 2:09 PM To: Multiple recipients of list ORACLE-L Subject: which initSID? Hi gurus How we know which initSID.ora file are in use in running instance if disk is not designed as OFA? Where can I found referenced tables name menas which Data dictionary table? Thanks -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: jaimin 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: Saurabh 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).
Re: Auditing
Title: RE: Auditing why don't u create a separate tablespace for containing the audit information. it depends on ur requirements what level of auditing u want. and also what diff info u want to store. create a separate tablespace and create the aud$ table in it by selecting from sys.aud$. when this is created drop from sys and create a synonym for it in sys. saurabh - Original Message - From: Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L Sent: Friday, June 22, 2001 4:11 PM Subject: RE: Auditing Hi Norrell, I just tested ur case. Can you tell me, how it's possible , when doing auditing, oracle will refer to the sys.aud$ table itself, correct?. If i droped it (even there is a synonym on that name), Oracle giving an error, it's not able to find the sys.aud$ table. Nirmal, -Original Message- From: Norrell, Brian [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 6:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: Auditing aud$ is one of the few system tables that can have an owner other than sys. You can create it under another schema (like system) and give sys a private synonym pointing to system.aud$. Then put the trigger on the alternate aud$ create table system.aud$ as select * from sys.aud$; drop table sys.aud$; create synonym sys.aud$ for system.aud$; create trigger x on system.aud$ as ... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- Sent: Thursday, June 21, 2001 6:00 AM To: Multiple recipients of list ORACLE-L This will not work as you can't create triggers on sys objects. So tell me the way how i should create triggers on aud$. -Original Message- Sharma Sent: Thursday, June 21, 2001 2:56 PM To: Multiple recipients of list ORACLE-L i think u can use triggers such kind of auditing. create aud$ table with one more column, and try updating the column as soon user fires some sql. this is just a thought. could find another opinion. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 11:15 AM Hi all there, I am auditing a database where 400 users are concurrently accessing the database. Now in the table AUD$ we have all the records of the user transactions.But is there any way to store what sort of query he is running so that i can see the actual text of query which was fired 3 days before. Regards, Anand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand 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: Saurabh 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: Anand 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: Norrell, Brian INET: [EMAIL PROTECTED] Fat City Network Services
Re: Auditing
i think u can use triggers such kind of auditing. create aud$ table with one more column, and try updating the column as soon user fires some sql. this is just a thought. could find another opinion. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 11:15 AM Hi all there, I am auditing a database where 400 users are concurrently accessing the database. Now in the table AUD$ we have all the records of the user transactions.But is there any way to store what sort of query he is running so that i can see the actual text of query which was fired 3 days before. Regards, Anand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand 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: Saurabh 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).
Re: Database in archivelog mode
://www.orafaq.com -- Author: Saurabh 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).
Re: Oracle Passwords
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: GRANTS FOR SESSION
there are two session grants available. create session and alter session - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 15, 2001 6:21 PM Hi Friends, I want to assign some privileges to a user for session level. Any help would be highly appreciated. Shahid Latif. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shahid Malik(IT) 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: Saurabh 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).
rowcount and rowsize..
hi all, i've a c program which calculates the estimated no of blocks required to store a table after reading the table name, row size and row count. i feel to gather these stats i need to analyze tables. the row size can be found at user_tables.ang_row_len. but from where can i get the rowcount after analyzing table. any help regarding this. i need these 3 stats in a text file. namely table_name row_size rowcount to make them read by the c program and generate an output file. thanks saurabh
public objects..
hi, do the syntax 'public' in DDL means any new user with connect , resource (default) privileges would entitles himto accesssuch objects without any special privileges. ishould say whether its synonym, view, etc.. or we need to grant specific privileges on the object for any operation. any different idea saurabh
Re: Oracle 8i database ER diagram
hi magesh, you can hire a product called ERWin 3.5 from Platinum corporation. it's very handy tool to generate script/database from ERdiagrams and vice versa. it'll definitely solve ur search. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 2:30 PM Hi We are exploring the possibility of generating ER diagram from the Oracle 8i database. We want to know how it can be done. Thanks Regards Magesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: magesh 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: Saurabh 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).
regarding indexes..
hi all, how can we find whether we need to build more indexes other than primary keys. how can we know about what all indexes are being accessed, and creating on which columns will help improve performance. saurabh
Re: regarding isqlPlus
can a version earlier than 8.1.7 be used as the database server in the 3-tier-architecture. i have 8.1.5 on NT 4.0 service pack 5. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 9:11 PM Got it working at home on Windows 2000 with 8.1.7.0.0. Works just fine, but .sql files are not able to read SQL*Plus commands (i.e. column xxx format a10). As I recall the install was fairly simple. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net Saurabh Sharma wrote: hi all, has anybody using iSqlPlus tool, provided by oracle. what i know is , it's the internat enabled extension of sql * plus, utilising the 3-tier architecture. they say oracle 8.1.7 is required for the implementation. any suggestions. saurabh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Baker 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: Saurabh 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).
Re: isqlPlus
if u r a member of oracle.com web account(u can simply register at the site) u can download a free version of iSQL * Plus from www.oracle.com/download select from tools section and just fill the acceptance form. its in zip format. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 11:10 PM I'm interested in using iSQL but I can't figure out where to install it from? 9iAS, 8i1.7, DEVELOPER 6i ? Could somebody shed some light upon me, there are way to many CDs to go through them all. TIA Tavo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: Oracle's Market share
just visit www.oracle.com the official web site of Oracle Corp. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 8:45 PM Where can one find some information about Oracle's market share in the various O/S markets. Like, UNIX,LINUX,NT etc. Regards Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: help for rollback segments..
hi rachel, i recreated them in rbs tablespace, created all right. i created them as public segments. i tried to give them private. but create private rollback segment rbs1... failed. how i could create them private. after creating them as public, some are still shown as offline. when i tried to include them in init.ora file as.. rollback segments =(1,2,3,) it again failed to start the server.. right now it's working fine, but some are shown as offline. what to do. any idea. thanks saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 08, 2001 8:47 PM the rollback segments are offline because they are 1) not mentioned in the init.ora file (which would cause them to be automatically brought online when you start the database) 2) because you did not bring them online when they were created 3) ones you specifically took offline I would change the tablespace they exist in (except for the ones named SYSTEM, SYSROL, RB0 and RB1) from SYSTEM to RBS. Unfortunately, the only way I know of to do that is to take them offline and drop them, then recreate them and bring them online. Why are they in SYSTEM? Because when they were created no tablespace was specified and they were created in the SYSTEM tablespace. From: Saurabh Sharma [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: help for rollback segments.. Date: Thu, 07 Jun 2001 23:15:23 -0800 HI ALL, i've some confusion regarding rollback segments. could anyone explain this information from my database. select * from dba_rollback_segs revealed following stats.. SEGMENT_NAME OWNER TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS - -- -- -- -- -- -- -- --- SYSTEMSYSSYSTEM 57344 57344 2 505 0 ONLINE SYSROLSYSSYSTEM 106496 106496 2 505 0 OFFLINE RB0 PUBLIC RBS106496 262144 2 121 0 ONLINE RB1 PUBLIC RBS106496 262144 2 121 0 ONLINE RB_TEMP SYSSYSTEM 106496 106496 2 121 0 OFFLINE RB2 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB3 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB4 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB5 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB6 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB7 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB8 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB9 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB10 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB11 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB12 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB13 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINE RB14 PUBLIC SYSTEM 57344 262144 2 121 0 OFFLINE RB15 PUBLIC SYSTEM 57344 262144 2 121 0 OFFLINE RB16 PUBLIC SYSTEM 57344 262144 2 121 0 can anybody explain, why i get some status as offline. will this extent allocation and other parameters ok. i 've oracle 8.1.5 on NT, these stats are from my test database. why are they in system tablespace. i've two rollback tablespace of size 15 and 20 mb resp. should they be in system or in rollback. if yes, how to change their default tablespace. pls help me in deciding that. thanks in advance. saurabh _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author
regarding isqlPlus
hi all, has anybody using iSqlPlus tool, provided by oracle. what i know is , it's the internat enabled extension of sql * plus, utilising the 3-tier architecture. they say oracle 8.1.7 is required for the implementation. any suggestions. saurabh
help for rollback segments..
HI ALL, i've some confusion regarding rollback segments. could anyone explain this information from my database. select * from dba_rollback_segs revealed following stats.. SEGMENT_NAME OWNER TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS- -- -- -- -- -- -- -- ---SYSTEM SYS SYSTEM 57344 57344 2 505 0 ONLINESYSROL SYS SYSTEM 106496 106496 2 505 0 OFFLINERB0 PUBLIC RBS 106496 262144 2 121 0 ONLINERB1 PUBLIC RBS 106496 262144 2 121 0 ONLINERB_TEMP SYS SYSTEM 106496 106496 2 121 0 OFFLINERB2 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB3 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB4 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB5 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB6 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB7 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB8 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB9 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB10 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB11 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB12 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB13 PUBLIC SYSTEM 57344 262144 2 121 0 ONLINERB14 PUBLIC SYSTEM 57344 262144 2 121 0 OFFLINERB15 PUBLIC SYSTEM 57344 262144 2 121 0 OFFLINERB16 PUBLIC SYSTEM 57344 262144 2 121 0 can anybody explain, why i get some status as offline. will this extent allocation and other parameters ok. i 've oracle 8.1.5 on NT, these stats are from my test database. why are they in system tablespace. i've two rollback tablespace of size 15 and 20 mb resp. should they be in system or in rollback. if yes, how to change their default tablespace. pls help me in deciding that. thanks in advance. saurabh
Trouble.. Standby Database. Urgent!!
hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomount ok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for thread 1 is in sequence #505Specify log: {RET=suggested | filename | AUTO | CANCEL}autoORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma
Re: Recording Destructive DDL
hi, can u tell me, how have u done this. i too require it. can u explain it. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 7:16 AM I've written a system event trigger which records information on when a table was dropped or truncated. I would also like to record when someone does an alter table drop column... The problem is determining when the alter statement includes the drop column clause. It looks like I have to use the ora_is_drop_column function, calling it for each column in the table and checking the return code. Is there a way of determing whether drop column was issued without using this function? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: Saurabh 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).
Re: How to send email from pl/sql in 806?
hi Jared, my execution cmd goes like.. EXECUTE SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello') it's giving the following error msgs.. ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYS.UTL_TCP does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.SEND_MAIL, line 10 ORA-06512: at line 2 the package is shown as valid in dba_objects for sys. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 12:05 PM Your procedure is masking the error in the exception block. Comment out the exception block to see the real error. Jared On Wednesday 30 May 2001 22:18, you wrote: it gives other error msg which are defined in the exception body inside the procedure. here it goes.. EXCEPTION when others then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); this msg is returned with ora 06512 any suggestions.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Saurabh 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).
Re: How to send email from pl/sql in 806?
hi, the package involved is utl_tcp, i created it under sys. the procedure is also created without any error under sys. do i still need to grant execute privilege on it, when sys itself is the owner. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 9:56 PM Saurabh; Have you looked at ALL of the packages involved ?? Does the SYS.UTL_TCP exist and does the ID using SEND_MAIL have the correct access to it ?? (I know these are basic questions, but its usually the basic ones that get us first !) Kevin -Original Message- Sent: Thursday, May 31, 2001 3:21 AM To: Multiple recipients of list ORACLE-L hi Jared, my execution cmd goes like.. EXECUTE SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello') it's giving the following error msgs.. ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYS.UTL_TCP does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.SEND_MAIL, line 10 ORA-06512: at line 2 the package is shown as valid in dba_objects for sys. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 12:05 PM Your procedure is masking the error in the exception block. Comment out the exception block to see the real error. Jared On Wednesday 30 May 2001 22:18, you wrote: it gives other error msg which are defined in the exception body inside the procedure. here it goes.. EXCEPTION when others then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); this msg is returned with ora 06512 any suggestions.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Saurabh 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: Kevin Lange 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: Saurabh 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).
Re: Number Vs. Varchar2 Datatype
Title: Number Vs. Varchar2 Datatype this always a better decision to decide the datatypes of such columns keeping in mind the future requirements. u may come to a certain point where u think, number datatype to be better and somewhere to varchar2. u said number datatype which is not always used for calculation. actually a number datatype takes less space on disk(actual storage space) as u define it. and as compared to varchar2 if difference is of concern. it's a matter of requirement of application. - Original Message - From: Arslan Dar To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 30, 2001 2:35 PM Subject: Number Vs. Varchar2 Datatype Hi list, We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) , The main decision to be made right now is to choose the right datatype, Options ofcourse are VARCHAR2 or NUMBER, i know its better to have varchar2 cuz its a bit flexible, but i want some expert opinion, can u tell me any pros and cons of having NUMBER or Varchar2 datatype on a feild which is numeric, which may be PRIMARY KEY and also which is NOT always used in Calculations, which datatype is more efficient Its Oracle 8.1.7 on NT4, TIA, Arslan
Re: 4 join methods?
i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: Table size
hi viraj, here's the method which'll let u know about the tables in a tablespace and thier occupied spaces. u can modify this according to your need by adding whatever more columns and condition u want. select segment_name,tablespace_name, sum(bytes)/1024 KB from dba_segments where segment_type='TABLE' and owner='name' group by segment_name / this will give u tables of a particular user and their sizes. hope it help. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:45 AM Hello all, How do I come to what tables are present in a particular tablespace and then when I found the table, can I come to know what amount of space it consumes? eg. I want to know what tablespace does the table emp (user is scott) belong to and the space it consumes (eg 5M)? Please help. Thanks and Regards, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh 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).
Re: How to send email from pl/sql in 806?
of 'ListGuru') 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: Saurabh 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).
QUERRY DOUBT..
hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables a,user_constraints b,user_cons_columns cwhere a.table_name=b.table_name andb.constraint_name=c.constraint_name/ now i need to make a report which gives out in the same result all the tables' columns which have constraints and which have not, both. leaving the constraint_type and constraint name columns null in the same querry. is it possible, or do we have other alternative to do that. pls suggest. thanks saurabh
Re: Exporting and Importing table statistics
i feel this is at the full database export level. once u export ur database, u can import it as it is into another database and it'll create allthe required definitions for u. the statistics are exported with the tablespace and table definitions. hope i'm sure. if not pls correct. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 3:48 AM Hi all, According to the 8i utilities manual I should be able to export a tables' statistics from one database, then import those statistics into another database. I have tried various combinations of export and import scripts but nothing seems to work. My table has none of the restrictions described in the utilities manual that would prevent the statistics from being exported and then imported. Can this export/import of statistics be done at a single table level or does it have to be a full database export? If not at the table level can it be done at the schema level? Thanks everyone, Gary Bonner [EMAIL PROTECTED] -- 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: Saurabh 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).
Re: How to send email from pl/sql in 806?
hi, i've oracle 8.1.5 on NT. but could'nt find the utltcp.sql , infact it had the procedure utl_http could it help? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 1:56 PM hi sharma The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5 onwards , thats the reason you were getting compilation errors. Ramana -- From: Saurabh Sharma[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, May 25, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to send email from pl/sql in 806? HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared, and so does for utl_tcp.get_line and utl_tcp.write_line how do we fefine them. where is this package utl_tcp pls explore. thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 11:05 AM try this procedure it works just replace the IP address in the line c := utl_tcp.open_connection('192.168.1.1', 25); with the IP address of u'r mail server regards __ Omar Khalid Software Engineer LMKResources A LANDMARK AFFILIATE (Formerly Mathtech Pakistan Pvt. Ltd) 18, F-8/3, Main Margalla Road, Islamabad, Pakistan Voice: 111-101-101*780 Fax: 92-051-2255989 Email: [EMAIL PROTECTED] Web: www.lmkr.com rem --- rem Filename: smtp.sql rem Purpose:Send e-mail messages from PL/SQL rem Notes: From Oracle8i release 8.1.6 one can send e-mail messages rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP rem packages. No pipes or external procedures required. rem Date: 27-Mar-2000 rem Author: Frank Naude ([EMAIL PROTECTED]) rem --- CREATE OR REPLACE PROCEDURE SEND_MAIL ( msg_fromvarchar2 := 'oracle', msg_to varchar2, msg_subject varchar2 := 'E-Mail message from your database', msg_textvarchar2 := '' ) IS c utl_tcp.connection; rc integer; BEGIN c := utl_tcp.open_connection('192.168.1.1', 25); -- open the SMTP port 25 on local machine dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'HELO 192.168.1.1'); dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from); dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to); dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'DATA'); -- Start message body dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'Subject: '||msg_subject); rc := utl_tcp.write_line(c, ''); rc := utl_tcp.write_line(c, msg_text); rc := utl_tcp.write_line(c, '.');-- End of message body dbms_output.put_line(utl_tcp.get_line(c, TRUE)); rc := utl_tcp.write_line(c, 'QUIT'); dbms_output.put_line(utl_tcp.get_line(c, TRUE)); utl_tcp.close_connection(c); -- Close the connection EXCEPTION when others then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); END; / show errors -- Examples: set serveroutput on exec send_mail(msg_to ='Omar Khalid/IT/LotusCert/Pk'); exec send_mail(msg_to ='[EMAIL PROTECTED]'); exec send_mail(msg_to ='[EMAIL PROTECTED]', msg_text='Look Ma I can send mail from plsql'); Oracle DBA acur8dba@yaho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: How to send email from pl/sql in 806? [EMAIL PROTECTED] om 05/23/2001 11:35 AM Please respond to ORACLE-L Hi, I am aware that 817 supports UTL_SMTP for this same functionality. But how can one send email from pl/sql in 806? thanx = Vicky D. Foster, Senior Oracle DBA: email: [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services
Re: QUERRY DOUBT..
THANKS A LOT, Seley the querry works absolutely fine. instead i've created a view. which can be easier to querry. and it also let me able to devise way for finding each individuals' report. thanks again. saurabh sharma - Original Message - From: Seley, Linda To: Multiple recipients of list ORACLE-L Sent: Friday, May 25, 2001 1:51 PM Subject: RE: QUERRY DOUBT.. Try this: select d.owner, d.table_name,b.constraint_name,b.constraint_type,d.column_namefrom all_tables a,all_constraints b,all_cons_columns c, all_tab_columns dwhere d.owner = c.owner (+)and d.table_name = c.table_name (+)and d.column_name = c.column_name (+)and c.table_name = a.table_name (+)and c.table_name = b.table_name (+)and c.constraint_name = b.constraint_name(+)and c.owner = a.owner (+)and c.owner = b.owner (+)order by d.owner, d.table_name, d.column_id; HTH Linda -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 12:46 AMTo: Multiple recipients of list ORACLE-LSubject: QUERRY DOUBT.. hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables a,user_constraints b,user_cons_columns cwhere a.table_name=b.table_name andb.constraint_name=c.constraint_name/ now i need to make a report which gives out in the same result all the tables' columns which have constraints and which have not, both. leaving the constraint_type and constraint name columns null in the same querry. is it possible, or do we have other alternative to do that. pls suggest. thanks saurabh
Re: NT Scheduled Restart
Title: Database Down hi suhen, for some reasons i did'nt recieved the mail with the attachment as exe file. have u sent it. pls confirm. i'm also looking for such utilities. thanks. - Original Message - From: Rajesh Dayal To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 23, 2001 2:15 PM Subject: RE: NT Scheduled Restart That's the best thing I like about this list... You ask for something and you get it, with no delay at all Thanks list and Thanks Suhen... Rajesh -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 11:11 AMTo: Rajesh DayalSubject: RE: NT Scheduled Restart Rajesh, We use a exe called shutdown.exe. It works quite well.I think it is a freeware. I have attached a copy of shutdown.exe. Copy this file to C:/winnt. We pass it arguments shutdown.exe /L /R /T:25 /C /Y HTHSuhen Hi all, I am looking for a utility (preferably freeware), which can perform a scheduled shutdown of NT 4.0 server. This I need because of inconsistent behavior of NT for Oracle Services. I want to do a scheduled restart after every night backup(scheduled). Appreciate your inputs and suggestions. TIA, Rajesh
Re: Why I can not create temporary tablespace?
hi, u can use locally managed tablespace for temp. create temporary tablespace name tempfile.will create temp as locally managed. if u want to create temp as dictionary manged..use create tablespace name datafile. (as normal tablespace) then changed to temporary using.. alter tablespace name temporary. will changed it to temporary but as a dictionary managed. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 21, 2001 11:05 PM David,Can we use Locally managed tablespace for TEMP? Thanks, -Original Message- Sent: Saturday, May 19, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Robert, Check your syntax. CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' SIZE 50M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Regards, David A. Barbour Robert Chen wrote: hi, I connect as sys/change_on_install and execute this: create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M; Error at line 1: ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Please tell me why? I even change the directory to 777(anyone can read and write) still gotta this error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen 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: David A. Barbour 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: Anne Yu 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: Saurabh 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).
How to enable partitioning option now..
HI ALL, while querying the v$option view, i came to know thatPartitioning option is false. due to this i'm unable to create partitioned tables. how to enable such options. can i enable it now. i've oracle 8i version 8.1.5 on NT4.0 thanks in advance. saurabh.
Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P
for downgrading from oracle 8 to 7, u need to take complete export and import the file in oracle 7 by running the catexp7.sql utility. look for more help on this utility. - Original Message - From: Djordje Jankovic To: Multiple recipients of list ORACLE-L Sent: Thursday, May 17, 2001 10:56 PM Subject: RE: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P The safest way is to do a full database export, to create a new 8.0.6 database instance and to import the datain the new database. You have to see for inter-version specifics - you might need to use 8.1.5 import version to import in the 8.0.6 database - you have to check that, but it is for sure doable. If at all possible, I would not delete the original 8.1.5 database before I am fully done with the import and I test that 8.0.6 is working fine. If you do not have enough space for 8.1.5 + export file + 8.0.5 (and you are on unix) you might use the named pipes for export/import (again make sure that the exp/imp versions are OK): · create a named pipe: $ mknod p_expimp p · export from the source database to the pipe: $ exp userid=src_username/password file=p_expimp OtherParameters · at the same time importing from the pipe is started: $ imp userid=trg_username/password file=p_expimp buffer=1024000 OtherParameters Djordje -Original Message-From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 12:16 PMTo: Multiple recipients of list ORACLE-LSubject: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please! Hello: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advance Do You Yahoo!?Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Re: SQL loader query
you can use the skip option of the sql loader. in ur case it should be skip=1(if headings are also separated by commas) can have the full help by typing sqlldr help=y at the command prompt. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:05 PM Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- 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: Saurabh 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).
RE:..not importing previous export!!!!!!!!
hi winnie, it got me errors like..* IMP-00015: following statement failed because the object already exists:* IMP-00017: following statement failed with ORACLE error 1119:"CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE'G:\ORANT\DATABASE\RBS1ORCL.ORA" ..* IMP-3: ORACLE error 1536 encountered* ORA-01536: space quota exceeded for tablespace 'USER_DATA'these are corrected when i increased the quota granted to users. andmodified the path of datafile creation as according to new locations.any more suggestions in this regard are highly welcomed.thanks.saurabh
URGENT..not importing previous export!!!!!!!!
hi all, there is an urgent problem that cropped up while ihad some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching.
Re: monitoring listener.log
Title: monitoring listener.log hey can u elaborate how do u scan each log file, and convert it in email msg. how do u do this.. saurabh sharma dba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
oraCore.log
hi everyone, can anyone help me in understanding the contents iof the above file... i.e. oraCore.log in orahome\rdbms##\trace\ what does this file contains and when it is created, which process controls it. thanks in advance. saurabh sharma
Re: Database Connection Log!!!
hi, but where to find the audited data.. pls tell in detail. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 20, 2001 3:30 AM SQL audit connect; works for me on V8.1.6 [EMAIL PROTECTED] wrote: Hi, we would like to log all the connections made to the database. currently I can only find the users who logged in from the client using net8 tcp/ip. BUT Which log file captures log of logging from unix server NOT using net8 tcp/ip. connecting using ipc. TIA - H -- 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131 The future is here. It is just not evenly distributed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Saurabh 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).
Re: Entity Relationship diagrams
hi, ya there are tools which can do this work for you. one such tool i know is Platinum ERwin, but i don't know whether it's free or not. but what i feel is u can get some trial version of it. try getting some more info about how to get it. but one thing i tell u, it's really a good tool. i've used it, it's handy and easy to use. it has tools for reverse and forward engineering. bye, saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:20 PM Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Saurabh 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).
Re: Default database blocksize
u can check it from listing the db_block_size parameter. when u don't specify or change it while creating a new database it is set to default, which is 2048 bytes i.e. 2k on NT, may differ on OS. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 12:40 PM Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Saurabh 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).
No Listner...!!!!
hi friends, I'm trying tough towards becoming a ful handed oracle 8 DBA. yesterday, i tried built new database on my test server, with successful creating req. set of files. i managed for successful running of both database. but got some problem while connecting toprevious one, it says tns, unable to connect while starting svrmgr30. before that i querried dba_users, it displayed sys a/c as locked. now, i replaced the listner with a new one and made changes acc to my servername. after a bit, the datbase started i connected to my server. but still not able to connect from any other or even my own m/c through sql plus. can anyone pls tell me the possible lokkups where i missed or should look. thanks in advance. saurabh
Re: Insert
well Kevin Kostyszyn, this is true that often we ignore such small issues which sometime impact the performance a lot. ya, it's good if we do inserts and then rebuild the indexes, but generally not done during usual work., since every time u insert records , oracle rebuilds the index itself with every entry (..if i'm not correct pls suggest..) and thus impact ther performance. we certainly have an alternative to this situation, where we have Index organised tables..which do not build index on tables rather it stores the table as index.. but has its own ups and down sides.. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 2:56 AM Hi DBA's, One of my developers just asked me a question, and honestly I don't know what he's talking about. But, it made me think of my own that I do know the answer to or at least I used to:( Anyway, when doing an insert into a table, doesn't it increase performance to delete any indexes, do the insert then rebuild the index. Or do you just have to disable the index? Also, does this work the same for delete? Also...is there anyway to guestemate how long an insert is going to take? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Saurabh 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).
about analyse table..
hello, i'm not very familiar with the analyse table command. and not fully aware of it's advantage or limits to analyse the tables. could anyone pls help me with this cmd, how to see the analysed statistics, etc. any help is highly appreciated. thanks in advance. saurabh sharma
Re: Limit
i feel this could be a better alternative instead of having a composite pk consisting of 6 columns. this way u might be making ur structure more complex.. a better approach should be to use more simpler and streamline stuctures if possible.. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 19, 2001 6:11 PM I don't know the limit of columns making PK. But I can suggest to use surrogate key and populate it from sequence. What You will do with your 6 columns if you need a foreign key to this table? Gints Plivna "Vishak" vishak.holla@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wipro.comcc: Sent by: Subject: Limit [EMAIL PROTECTED] om 01.03.19 14:10 Please respond to ORACLE-L Hello Gurus I just want to know the number of columns that can be combined to make a primary key(composite). I have a table with 16 columns of which I would like to make a combination 6 columns as a PK. The volume of records may be 10,000 or less. This table will be used to generate a report(thro a screen). Any suggestions on how to design the table TIA Regards Vishak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vishak 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: Saurabh 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).
Re: Re:date of last password change
but this table is not reflecting any date timestamp of such change. i 've oracle 8.0.4 on NT. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 19, 2001 7:20 PM AH, another well written third party application!! OH, well, it's the expiry_date in DBA_USERS. Dick Goulet Reply Separator Author: "Jeffrey Beckstrom" [EMAIL PROTECTED] Date: 3/19/2001 5:05 AM anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user does not change then would lock user out. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content="text/html; charset=iso-8859-1" http-equiv=Content-Type META content="MSHTML 5.00.3211.1700" name=GENERATOR/HEAD BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px" DIVanyone know of a way to find the date a user's password was last changed.nbsp; I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins.nbsp; Therefore, I was going to email users when password is N days old.nbsp; If user does not change then would lock user out./DIV DIVnbsp;/DIV DIVJeffrey BeckstromBRDatabase AdministratorBRGreater Cleveland Regional Transit AuthorityBR1240 W. 6th StreetBRCleveland, Ohio 44113BR(216) 781-4204/DIV/BODY/HTML -- 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: Saurabh 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).
Re: Order of table_name resolution
yes i think u r right. at this oracle seems to follow this sequence. but is there any way to know the exact path of sequence.. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 6:30 PM Hi DBAs, Can someone clarify/confirm on how Oracle determines what table to use in select statement? For ex. If I am login as Scott and do the following: SELECT * FROM employee; Of course Oracle will use Scott.employee if it exist. If it does not exist but exist under another schema. Does Oracle look at private synonyms then public synonyms or vice versa. My guess is Oracle checks in this order. Please confirm or correct. 1. Check if table exist in current schema 2. Check private synonyms 3. Check public synonyms 4. 3 strikes your out with an error. Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- 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: Saurabh 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).
Re: Last Fri. of the Month ?
here it is.. SELECT NEXT_DAY(SYSDATE+(LAST_DAY(SYSDATE)-SYSDATE-7),'FRIDAY') FROM DUAL; saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 3:10 AM Given Any Date , How to Deduce the Date for the Last Fri. of the SAME Month ? how about next_day(last_day(date) - 7, 'Friday') where date is the given date? for example to find the last Friday of the month select next_day(last_day(sysdate) - 7, 'Friday') from dual; Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand 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: Saurabh 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).
Re: HOW TO SELECT LATEST INSERTED ROW..
thanks rana sengupta. it worked. but it is actually working fine whileinserting 1 row at a time. i tried to write with row level trigger. but both should be statement level triggers. else giving errors like. table is mutataing, trigger/function can't see it..etc. thanks again. saurabh - Original Message - From: Rana Sengupta To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 21, 2001 5:15 PM Subject: Re: HOW TO SELECT LATEST INSERTED ROW.. Hay, U can proceed in following way.. create a dummy table having one row one column ; Update this value in a row level insert trigger of your concrn table by the current row id ( or any key ). Next use a statement level insert trigger on that concern table and by select that key from dummy table U and perform the required opr. This Row-level Statement level triggers will be usefull only when U inserting 1 row at a time. Regards Rana SenguptaExecutive SystemsUsha Martin Telekom Ltd.11 Dr. U N Bhramchari Road.Calcutta - 700017Cell Phone: + 91 98300 32780Email : [EMAIL PROTECTED]Web: www.commandcell.com - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 21, 2001 3:45 PM Subject: HOW TO SELECT LATEST INSERTED ROW.. HI ALL, how can i select the latest inserted row from a table. i want to select a col value, perform some operation on it and update the same to table via a trigger.. it says table is mutating. i'm inserting rows 1 at a time. any suggestions.. thanks in advance. saurabh
HOW TO SELECT LATEST INSERTED ROW..
HI ALL, how can i select the latest inserted row from a table. i want to select a col value, perform some operation on it and update the same to table via a trigger.. it says table is mutating. i'm inserting rows 1 at a time. any suggestions.. thanks in advance. saurabh
Re: could we please stop the political discussions?
I appreciate ur views..Jacques it's better if v discuss something meaningful..for which this list was created. saurabh - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Saturday, February 17, 2001 8:50 AM Subject: could we please stop the political discussions? I enjoy talking public affairs as much as the next person, but not on this list! The reason I joined the mailing list is to learn about Oracle features, not to receive e-mail after e-mail either praising the benefits of capitalism and decrying socialism or to read manifestoes promulgating liberal policies. I know I can just as easily hit the "delete" key, but when approx. 15% (my rough estimate) of the messages on the list are from people trying to promote their political agenda, I start to get weary of the issue. If anyone is interested in some internet message boards where they can discuss politics, please e-mail me privately and I can point you in the right direction. -- any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: this drove me crazy!!!
ices-- (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: Saurabh 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).
Re: Off Topic: Message for you
this was fabulous..how could u do it. pls explain.. - Original Message - From: magesh To: Multiple recipients of list ORACLE-L Sent: Thursday, February 15, 2001 7:40 AM Subject: Off Topic: Message for you Dear All Execute the statement on a SEQUEL prompt and see the message for you. SELECT TRANSLATE('_9(8.-.=5*;.81^^;.=1@5$)9$5.41;', '1234567890!@#$%^*()-=_+;,.', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) from dual Regards **Magesh
Re: Resouce Allocation
but i did'nt find any bytes column in user_tables analyzed table in compute mode.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 09, 2001 9:05 PM analyze the table in compute mode. Then select bytes from user_tables where table_name = 'MY_TABLE'; -Original Message- Sent: 09 February 2001 14:56 To: Multiple recipients of list ORACLE-L Dear friends I have a little problem I have a table here the description ... create table my_table ( id number primary key. namevarchar2(20), address varchar2(50), notesvarchar2(4000) ); and then ... I inserted one record, and I wanna know ... How to count a resource allocation from one record ? byte ? kb ? I hope one of you can give me a solution to count resource allocation from one record. Thanks regards abimanyu "I'll be back!" Arnold Schwarzenegger -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: Saurabh 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).
Re: top n or top n%
do you mean to find top rows based on some coplumn values.. will this help..it will fetch u the nth row based on some value of particular column. select * from tablename a where position_salary-1= (select count(distinct col1) from tablename where col1a.col1) order by col1; can modify it to suit ur need.. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 3:20 AM Hi listers, I remeber vaguely there is a way to select top n or top % rows of a select statement. But I cannot find it anywhere. Could somebody let me know? Thank you. Leslie __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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: Saurabh 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).
Re: Renaming a Column
CREATE THE TABLE AGAIN WITH AS SELECT CLAUSE.. SELECTING ONLY COLUMN DEFINITION WHILE SUPPLYING THE NEW COLUMN NAME URSELF. apply constraints if any. reinsert the data from old table. drop old table . rename new table as old one. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 10:30 AM Hi all, I need to rename some columns on my table. Any idea how to do that... Thanks in advance, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen 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: Saurabh 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).
Re: Off Topic: Row Locking - Row Id
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: Johan Locke@i-Commerce Services 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: Saurabh 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).
Re: How to insert data in LOBs
thanks it worked fine. but how if i want to insert some file(text,word) or some image file to a blob. and i did'nt understood how to querry such table with LOBs. thanks again for the guidance. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 09, 2001 3:20 PM If you use CLOB, you can insert text in the same way as with varchar2. If you have BLOB, you'll probably need the function utl_raw or dbms_lob. However with BFILE, you should create a directory with the stmt: CREATE DIRECTORY and insert using BFILENAME expression. Then you have the function EMPTY_BLOB() or EMPTY_CLOB to set them without a value. An example SQL desc kk NombreNulo? Tipo - A CLOB B BLOB SQL r 1 insert into kk 2* values ('PUMAS',utl_raw.cast_to_raw(' are the best rugby team')) 1 fila creada. Regards. -Mensaje original- De: Saurabh Sharma [SMTP:[EMAIL PROTECTED]] Enviado el: jueves 8 de febrero de 2001 14:32 Para: Multiple recipients of list ORACLE-L Asunto: How to insert data in LOBs hi all, i want to know how to insert values i.e. text/word or images in a table's LOB column. can we insert them with the regular insert command. please help in this regard. thanks in advance.. saurabh FCS Software Solutions Ltd. Noida.(India) [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian 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: Saurabh 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).