Funny Error... Any Ideas what the hell is happening here? Trace F
Hi All Funny Error... Any Ideas what the hell is happening here... Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 & 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com *** The information in this e-mail is confidential and is legally privileged. It is intended solely for the addressee. If this email is not intended for you, you cannot copy, distribute, or disclose the included information to any-one If you are not the intended recipient please delete the mail. Whilst all reasonable steps have been taken to ensure the accuracy and integrity of all data transmitted electronically, no liability is accepted if the data, for whatever reason, is corrupt or does not reach it's intended destination. All business is undertaken, subject to our standard trading conditions which are available on request. *** comdev_ora_29325.zip
RE: Re-claiming the space from Table after deleteion
TRUNCATE the table by using: TRUNCATE TABLE ; Just remember that this command falls under ddl, ie. - An implicit commit is fired (no rolling back) Everything is deleted, and the high water mark reset Cheers JL -Original Message- Sent: Friday, March 09, 2001 2:17 PM To: Multiple recipients of list ORACLE-L If we delete data from a table, tables highwater mark doesnot come down. That's why u cannot reclaim the freespace after deletion from a table. This FYI&A -- On Fri, 09 Mar 2001 01:56:07 rafi wrote: >Dear All, > > Platform: Solaris 2.6, Oracle: 7.3.4.0 > >We have a few tables which are growing very fast due to large no of >insertions. But the data gets obselete after a month and we use a >procedure to delete the obselete data from the tables. > > The problem is that the table does not free the space even after the deletion of 40% of the data. > >How can we re-claim the unused space which got created due to deletion? > >How do we ensure that future inserts are done in this unused space? > > > [We can not try exp/imp or truncate option > due to the huge size & high activity and > online use of the tables]. > >Kind Regards and thanks to all there, > > >Rafi Ahmad > > > >-- >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). > Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 in this e-mail is confidential and is legally privileged. It is intended solely for the addressee. If this email is not intended for you, you cannot copy, distribute, or disclose the included information to any-one If you are not the intended recipient please delete the mail. Whilst all reasonable steps have been taken to ensure the accuracy and integrity of all data transmitted electronically, no liability is accepted if the data, for whatever reason, is corrupt or does not reach it's intended destination. All business is undertaken, subject to our standard trading conditions which are available on request. *** -- 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).
RE: LONG to char
Hi
I'm attemting to write an insert script for a table:
Spool out.log
SELECT 'INSERT INTO TAB2 VALUES(''' || LONG_TYPE_COLUMN || ''',''' ||
VARCHAR2_TYPE_COLUMN||''');'
FROM TAB1;
spool off
(It moans about Inconsistant Datatypes - which I can understand)
Any ideas on how to get around this?
Regards
JL
-Original Message-
Sent: Tuesday, February 20, 2001 5:23 PM
To: [EMAIL PROTECTED]
Johan,
What do you exactly want to do? If you could explain it in more detail, I
might
be able to help, at least I'll try.
--- "Johan Locke@i-Commerce Services" <[EMAIL PROTECTED]> wrote:
> Anybody have any Idee how to conevrt a LONG datatype to char/varchar
>
> Regards
> JL
> --
> 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).
=
Gunawan Yuwono
Oracle DBA
Kansas City, USA
__
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: 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).
LONG to char
Anybody have any Idee how to conevrt a LONG datatype to char/varchar Regards JL -- 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).
RE: Which is faster?
I don't think there is any question. A smart select statement always tends to be a better solution. The one instance where I'd definitly prefer a procedure over a select is when the select contains Oracle's tree-walk method (i.e. connect by prior... start with) Regards JL -Original Message- Sent: Tuesday, February 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi Gurus ! I'm going to some tables with huge amount of records. There are references between these tables. The question is: Does it worth creating a procedure with several small selects or is it faster to use one select with joins? For example: CUSTOMER(CUST_ID); CONTRACT(CONTR_ID,CUST_ID); CONTRACT_ITEM(CONTR_I_ID,CONTR_ID,PHONE_NUM_ID); PHONE_NUMBER(PHONE_NUM_ID,PHONE_NUM); I have the PHONE_NUM and I need the CUST_ID. Which Faster? SELECT CUST_ID from PHONE_NUM,CONTRACT_ITEM,CONTRACT,CUSTOMER where [JOINS] and PHONE_NUM=searchedone or In procedure or function select phone_num_id into Variable from phone where phone_num=searchedone; select contract_id into Variable2 from contract_item where phone_num_id=Variable; select cust_id into Variable from contract where contr_id=Variable2; Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Truncate in a procedure?
'ello As far as I can remember, "Truncate" is part of DDL, not part of DML Ie. for it to work, you'd require the DBMS_SQL package (Dynamic SQL) or DBMS_DDL package. All DDL causes an implicit commit Cheers JL -Original Message- Sent: Monday, February 19, 2001 5:50 AM To: Multiple recipients of list ORACLE-L Hi, I wanted to let u know that when u issue a truncate command, it will issue a implicit commit internally. This may be something which u would not like to have in a transaction. Just a FYI.. Regards Rajagopal Venkataramany --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have a developer that is trying to truncate a > table from within a > procedure. If he does a delete it works ok. If he > tries to issue the > truncate command he gets errors. He is running the > procedure as the schema > owner. Is there a problem with issuing a truncate > command from within a > procedure? > > Ron Smith > Database Administration > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ 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: Rajagopal Venkataramany INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: When you should use NOLOGGING while creating indexes
Advantages: - Less performance overhead in creating the indexes Disadvantages: - Unrecoverable. Ie. If the Database is not shutdown normally after the creation of the indexes (SHUTDOWN ABORT or crash), you'll have to recreate those indexes. Also look at: - Creating an index in using parallel servers (multiple instances) (I think this can be done - MAYBE SOMEBODY CAN COMMENT) - Analyzing your tables and indexes regularly ie. "ANALYSE INDEX [COMPUTE|ESTIMATE] STATISTICS " Regards JL -Original Message- Sent: Monday, February 19, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi all, when I should use NOLOGGING while creating indexes: what are the advantages and what the dis-advantages... br and thanks, 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: 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).
RE: Renaming a Column
Hi All I think I did send one out earlier. Don't bite. You can't rename a column. The combatibility parameter issue I was thinking of has to do with when you want to drop a column in 8i. That I know, has to be greater or equal to 8.1.0 when you want to drop a column Sorry again Regards JL -Original Message- Sent: Wednesday, February 14, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Ok i'll bite, i try to keep up with the new features and i'm looking at 8i(8.1.7) docs right now and i dont see it, would you like to elaborate? you can rename a table, rename a partition but NOT rename a column, this has been on the wish-list for many years just like drop column was. Feel free to flame me if i'm wrong(it does happen but rarely) :) joe "Johan Locke@i-Commerce Services" wrote: > > Wait wait wait... > > Yes you can rename a column in 8i, it just depends to what value your > compatibility parameter is set > > Regards > JL > > -Original Message- > Sent: Wednesday, February 14, 2001 8:05 AM > To: Multiple recipients of list ORACLE-L > > In Oracle > It's not possible to rename a column.You can instead > use alias for that column name in your queries. > Or you have to create a new table from existing one > Drop existing table.And recreate a table by > selecting from new table. > > Regards > Bipin > --- Heikki Jantunen <[EMAIL PROTECTED]> wrote: > > 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). > > > Do You Yahoo!? > Get your free @yahoo.co.in address at http://mail.yahoo.co.in > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?bipin=20sahani?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Renaming a Column
Sorry sorry ID-10-T error Cheers JL -Original Message- Sent: Wednesday, February 14, 2001 9:19 AM To: '[EMAIL PROTECTED]' Wait wait wait... Yes you can rename a column in 8i, it just depends to what value your compatibility parameter is set Regards JL -Original Message- Sent: Wednesday, February 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L In Oracle It's not possible to rename a column.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen <[EMAIL PROTECTED]> wrote: > 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). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: can not create database by dbassist
I had a similar problem before Make sure in your /etc/system file you set the following correctly (use appropriate values where necesary) set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 Regards JL -Original Message- Sent: Wednesday, February 14, 2001 9:27 AM To: Multiple recipients of list ORACLE-L solaris 2.7 + oracle 8.1.6 ( 64-bit) After I installed the oracle software, I tried to create a database by dbassist. But dbassist exited at finial step with 'segmentation violation' error and thread dump; Oracle support told me that it has relations with os enviroment and it does happen sometime. I now had to create the database manually . Any suggestions? Thanks in advance Ken Errors: SIGSEGV 11* segmentation violation si_signo [11]: SIGSEGV 11* segmentation violation si_errno [0]: Error 0 si_code [1]: SEGV_MAPERR [addr: 0x0] stackbase=FE051D5C, stackpointer=FE04EE34 Full thread dump: "Image Fetcher 0" (TID:0xfd2e6770, sys_thread_t:0xd03ba8, state:CW, thread_t: t@39, sp:0xfce80d20 threadID:0xfce81dc8, stack_base:0xfce81d5c, stack_size:0x2) prio=8 sun.awt.image.ImageFetcher.nextImage(Compiled Code) sun.awt.image.ImageFetcher.fetchloop(Compiled Code) sun.awt.image.ImageFetcher.run(Compiled Code) "Image Animator 0" (TID:0xfd2e6f70, sys_thread_t:0xc89868, state:CW, thread_t: t@38, sp:0xfceb0a48 threadID:0xfceb1dc8, stack_base:0xfceb1d5c, stack_size:0x2) prio=3 sun.awt.image.GifFrame.dispose(Compiled Code) sun.awt.image.GifImageDecoder.readImage(Compiled Code) sun.awt.image.GifImageDecoder.produceImage(Compiled Code) sun.awt.image.InputStreamImageSource.doFetch(Compiled Code) sun.awt.image.ImageFetcher.fetchloop(Compiled Code) sun.awt.image.ImageFetcher.run(Compiled Code) "Thread-4" (TID:0xfd2deb78, sys_thread_t:0xcada28, state:R, thread_t: t@37, sp:0xfe050cb8 threadID:0xfe051dc8, stack_base:0xfe051d5c, stack_size:0x2) prio=5 *current thread* java.lang.UNIXProcess.(Compiled Code) java.lang.Runtime.exec(Compiled Code) DBCreator.ExecProg(Compiled Code) CreateOracle_base.CreatePasswordFile(Compiled Code) CreateOracle.CreateDatabase(Compiled Code) CreateOracle.run(Compiled Code) java.lang.Thread.run(Compiled Code) "AutoScroller" (TID:0xfd2e7f98, sys_thread_t:0xb90570, state:CW, thread_t: t@23, sp:0xfcf10de0 threadID:0xfcf11dc8, stack_base:0xfcf11d5c, stack_size:0x2) prio=5 java.lang.Object.wait(Compiled Code) oracle.ewt.timer.Timer._waitTilScheduled(Compiled Code) oracle.ewt.timer.Timer.run(Compiled Code) java.lang.Thread.run(Compiled Code) "CursorIdler" (TID:0xfd28ed30, sys_thread_t:0xb95b40, state:CW, thread_t: t@22, sp:0xfcff0de0 threadID:0xfcff1dc8, stack_base:0xfcff1d5c, stack_size:0x2) prio=5 java.lang.Object.wait(Compiled Code) oracle.ewt.timer.Timer._waitTilScheduled(Compiled Code) oracle.ewt.timer.Timer.run(Compiled Code) java.lang.Thread.run(Compiled Code) "TaskScheduler timer" (TID:0xfd28, sys_thread_t:0xa747f8, state:CW, thread_t: t@21, sp:0xfcf40de0 threadID:0xfcf41dc8, stack_base:0xfcf41d5c, stack_size:0x2) prio=5 java.lang.Object.wait(Compiled Code) oracle.ewt.timer.Timer._waitTilScheduled(Compiled Code) oracle.ewt.timer.Timer.run(Compiled Code) java.lang.Thread.run(Compiled Code) "Screen Updater" (TID:0xfd2b1810, sys_thread_t:0xa8b120, state:CW, thread_t: t@20, sp:0xfcf90d88 threadID:0xfcf91dc8, stack_base:0xfcf91d5c, stack_size:0x2) prio=4 java.lang.Object.wait(Compiled Code) sun.awt.ScreenUpdater.nextEntry(Compiled Code) sun.awt.ScreenUpdater.run(Compiled Code) "AWT-Finalizer" (TID:0xfd2b2d98, sys_thread_t:0xde470, state:CW, thread_t: t@19, sp:0xfcfc0ed8 threadID:0xfcfc1dc8, stack_base:0xfcfc1d5c, stack_size:0x2) prio=9 java.lang.Object.wait(Compiled Code) sun.awt.AWTFinalizer.run(Compiled Code) "process reaper" (TID:0xfd2798d8, sys_thread_t:0x2d6b08, state:CW, thread_t: t@8, sp:0xfe080ee8 threadID:0xfe081dc8, stack_base:0xfe081d5c, stack_size:0x2) prio=5 java.lang.Thread.run(Compiled Code) "AWT-Motif" (TID:0xfd271e20, sys_thread_t:0x1cd290, state:R, thread_t: t@7, sp:0xfe3d1098 threadID:0xfe3d1dc8, stack_base:0xfe3d1d5c, stack_size:0x2) prio=5 java.lang.Thread.run(Compiled Code) "AWT-EventQueue-0" (TID:0xfd271e30, sys_thread_t:0x1bb288, state:CW, thread_t: t@6, sp:0xfec40df8 threadID:0xfec41dc8, stack_base:0xfec41d5c, stack_size:0x2) prio=5 java.lang.Object.wait(Compiled Code) java.awt.EventQueue.getNextEvent(Compiled Code) java.awt.EventDis
RE: Renaming a Column
Wait wait wait... Yes you can rename a column in 8i, it just depends to what value your compatibility parameter is set Regards JL -Original Message- Sent: Wednesday, February 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L In Oracle It's not possible to rename a column.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen <[EMAIL PROTECTED]> wrote: > 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). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Off Topic: Row Locking - Row Id
Hi Riyaj Thanx for the reply. As it's a web system we'll probably be selecting 20 records at a time (ie. the user sees 20 products of which he can book more than one at a time). So I'd probably not try to select and test each individual record, purely for performance considerations. select * from t1 skip locked I need to unfortunately know which records have been locked - > I need to display them as well to the user, because he may want to wait to book them, if the other user doesn't buy them ... this happens frequently. Also, "skip locked" only works when you want to select something for update, ie. select * from t1 FOR UPDATE skip locked. When the user is only browsing, I don't want to lock anything. Thanx for the responses. Cheers JL -Original Message- Sent: Tuesday, February 13, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Hi Johan Will this work ? Person A books the product he wants with 'select * from t1 for update'. At this point, he has lock on the row. Person B comes in, looks at the product and does a 'select * from t1 for update nowait' If the row is locked for update then person B will get ORA-0054. If Person B gets an ORA-0054 then, you know that the person A has booked the product but not bought yet. The locks hold by the person A will be cleaned by the pmon if the process dies away. But the above will only work if each of the web user gets its own database connections. I don't know about your environment, but in most environment, the connection to the database is shared among the web sessions. If that is the case, then you may have to use the flags to track the state changes. If you want to show only rows that are locked then you could use this undocumented feature: 'select * from t1 skip locked'. This will skip all the rows that have been locked. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "These are my opinions and does not bind my employer. Use at your risk" "Johan Locke@i-CommeTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> rce Services"cc: rce Services"cc: Sent by: cc: root@fatcity.Subject: Deadlock Interpretation Assistance Requested com 02/10/01 07:00 PM Please respond to ORACLE-L Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY Deadlock graph: -Blocker(s) -Waiter(s) -- --- Resource Name process session holds waits process session holds waits TX-00180008-42d6 837 635 X784 481 S TX-00160010-4412 784 481 X837 635 X Rows waited on: Session 481: no row Session 635: obj - rowid = 0722 - 0289.0033.0102 I've never really encountered all that many deadlocks before. The ones I *have* seen in the past were the "classic" TX locks where user A has a row locked that user B needs and vice versa and the mode requested was X. On Friday, the DBA's sent me a trace file from a deadlock (with the info above from that trace file) and asked me to investigate. The deadlocks they had seen in the past were due to application coding issues, hence their tossing this to the development side of the house. After a lot of research on Metalink, the Steve Adams site (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the S mode wait for session 481 (and no row) makes me think this isn't the typical application induced deadlock due to the way and order in which locks are acquired. There are 3 foreign keys on the table, and, each of them are indexed. There is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know all that much about how heavily DML is issued against the table. But, after reading material on when the wait is in S mode, I wonder if this might be an ITL issue. From what I've read the past 2 days, there could be other reasons for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL slots, and bitmap index were the most common reasons mentioned. Because the statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?) the check for uniqueness wait during inserts, and, with no bitmap index on the table, that leaves the ITL slots as the main candidate. What I need to do is determine if this is indeed an application coding issue, or, if I need to kick this back to the DBA's and let them research it. And I don't mean that in a finger pointing way. The DBA's and developers there work well together.
RE: Off Topic: Row Locking - Row Id
Hi Jared Thanx for the reply. I'll do some stress testing, and keep you up to date. (I'm not too optimistic though) Cheers JL -Original Message- Sent: Tuesday, February 13, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Depending on your application design, you may find a locking scheme useful. Below is an example that uses rowid to take out a lock. Note that this is not a lock on an object, but simply a lock identified by a rowid. As the demo is setup, the locks are automatically released on rollback or commit, which would include exiting a session. Not for use on OPS w/MTS. See dbmslock.sql for details. Jared -- -- run this part from session A: drop table lock_test; create table lock_test ( name varchar2(10) not null ); insert into lock_test values ( 'nebula'); insert into lock_test values ( 'quasar'); insert into lock_test values ( 'pulsar'); insert into lock_test values ( 'red dwarf'); insert into lock_test values ( 'Lister'); insert into lock_test values ( 'Rimmer'); insert into lock_test values ( 'Cat'); commit; -- Then run this section from session A and session B declare cursor c_hoser ( hoser_name_in lock_test.name%type ) is select rowid from lock_test where name = hoser_name_in; lock_handle pls_integer; v_hoser_rowid rowid; v_lock_handle pls_integer; v_lock_result pls_integer; v_name_to_book lock_test.name%type; begin v_name_to_book := 'Lister'; open c_hoser(v_name_to_book); fetch c_hoser into v_hoser_rowid; close c_hoser; v_lock_handle := dbms_utility.get_hash_value(v_hoser_rowid,100,power(2,20)); v_lock_result := dbms_lock.request( id => v_lock_handle , timeout => 1 , release_on_commit => true ); if v_lock_result = 0 then dbms_output.put_line( 'You have booked ' || v_name_to_book ); elsif v_lock_result = 1 then dbms_output.put_line( v_name_to_book || ' is currently booked'); else dbms_output.put_line( 'Error attempting to lock ' || v_name_to_book || ' return val: ' || to_char(v_lock_result)); end if; end; / -- On Mon, 12 Feb 2001, Johan Locke@i-Commerce Services wrote: > Thanks Riyaj > > Unfortunately it doesn't solve my problem. It only helps if the transaction > is BLOCKING another transaction. > > This is my requirement, maybe somebody has a good solution. > > A product selection engine. There are a limited number of products, each > unique. > > Person A comes in over the web (this important). Looks at the products and > "books" the product he wants. At this stage I just want to issue a "SELECT > FOR UPDATE" - without commiting. Person A goes through the payment > selection, and if succesfull, the product is marked as "bought" and the > transaction commited. > > If during the process of payment authorisation for Person A, person B looks > through the products, Person B must see the product person A is buying as > "Booked - not yet bought". > > Why don't I just set a flag in the row, commit it, do the payment and commit > that? > > -- > If for some reason person A's web session terminates voluntarily or > involuntarily, I'd have to run a process in the background which cleans up > the flags. As this is a very processing intensive table, it slows down the > processing tremendously. Conversly, if I could use the user's web session > termination, which will terminate the database session, to make oracle > release the lock on that row it makes my life a lot easier. > > About 90% of the people will access the site within a period of about an 1-2 > hours (within which you're aiming to sell 54000 of the 6 products) > -- 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
RE: Off Topic: Row Locking - Row Id
Thanks Riyaj Unfortunately it doesn't solve my problem. It only helps if the transaction is BLOCKING another transaction. This is my requirement, maybe somebody has a good solution. A product selection engine. There are a limited number of products, each unique. Person A comes in over the web (this important). Looks at the products and "books" the product he wants. At this stage I just want to issue a "SELECT FOR UPDATE" - without commiting. Person A goes through the payment selection, and if succesfull, the product is marked as "bought" and the transaction commited. If during the process of payment authorisation for Person A, person B looks through the products, Person B must see the product person A is buying as "Booked - not yet bought". Why don't I just set a flag in the row, commit it, do the payment and commit that? -- If for some reason person A's web session terminates voluntarily or involuntarily, I'd have to run a process in the background which cleans up the flags. As this is a very processing intensive table, it slows down the processing tremendously. Conversly, if I could use the user's web session termination, which will terminate the database session, to make oracle release the lock on that row it makes my life a lot easier. About 90% of the people will access the site within a period of about an 1-2 hours (within which you're aiming to sell 54000 of the 6 products) Why did I want the rowid's? --- I wanted to run a query something like: SELECT PRODUCT, decode(oracle_internal_lock,yes,'Booked','Available') FROMPRODUCTS where status != 'Bought' To get an output like: PRODUCT AVAILABLE --- - PROD A Booked PROD B Available PROD C Available A background process killing flags that have timed out is not a viable solution. Additional Info: OPS 8.1.6 on a Sun Cluster Dynamo Appserver (4.5.0), JDK 1.2.1 Netscape Web Server Ideas??? Regards JL -Original Message- Sent: Monday, February 12, 2001 5:21 PM To: Multiple recipients of list ORACLE-L Hi You could get the following columns from the v$session table and then use dbms_rowid.rowid_create to construct the rowid: ROW_WAIT_OBJ#NUMBER ROW_WAIT_FILE# NUMBER ROW_WAIT_BLOCK# NUMBER ROW_WAIT_ROW#NUMBER Session that is waiting will have this information in its v$session view and the session holding will have -1 in the row_wait_obj#. ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# ------ - 926325 13 1 -1 00 0 Hope this helps!! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "This is my opinion and does not bind my employer. Use at your own risk" "Johan Locke@i-CommeTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> rce Services"cc: Sent by: cc: root@fatcity.Subject: Deadlock Interpretation Assistance Requested com 02/10/01 07:00 PM Please respond to ORACLE-L Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY Deadlock graph: -Blocker(s) -Waiter(s) -- --- Resource Name process session holds waits process session holds waits TX-00180008-42d6 837 635 X784 481 S TX-00160010-4412 784 481 X837 635 X Rows waited on: Session 481: no row Session 635: obj - rowid = 0722 - 0289.0033.0102 I've never really encountered all that many deadlocks before. The ones I *have* seen in the past were the "classic" TX locks where user A has a row locked that user B needs and vice versa and the mode requested was X. On Friday, the DBA's sent me a trace file from a deadlock (with the info above from that trace file) and asked me to investigate. The deadlocks they had seen in the past were due to application coding issues, hence their tossing this to the development side of the house. After a lot of research on Metalink, the Steve Adams site (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the S mode wait for session 481 (and no row) makes me think this isn't the typical application induced deadlock due to the way and order in which locks are acq
RE: Off Topic: Row Locking - Row Id
Hi Not realy what I was looking for. Thanks anyways Regards JL -Original Message- Sent: Monday, February 12, 2001 10:41 AM To: Multiple recipients of list ORACLE-L hi, you can simply include the hidden(or embedded) column in your querry as u write other columns. this is the column which is locked in every table. and can give u the desired value for each row.. try select col1, col2,., rowid from tablename; saurabh - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 10:35 AM > Hi > > Anybody have any idea where I can find the rowid of a row that is being > locked within a table? > > Kind Regards > JL > > -Original Message- > Sent: Monday, February 12, 2001 5:40 AM > To: Multiple recipients of list ORACLE-L > > > > Hi > In my opinion, this is an ITL issue. When a process need an ITL and > have to wait for it , then it pseudo randomly selects a locked row (from > that block) and enqueues itself in to the waiters queue. But the > row_waited information in v$session will be null. In rare cases, it is > possible for the deadlock to occur if the ITL waiter holds the row that is > needed by the other process. > I would ask, what is the frequency of this deadlock ? Is this the first > occurrence ? If it is the first occurrence, then I would wait for the next > occurrence and then spend time and resource. >Hope this helps!! > Thanks > Riyaj "Re-yas" Shamsudeen > Certified Oracle DBA > "These are my opinions and does not bind my employer. Use at your risk" > > > > > > elkinsl@flash > > .net To: Multiple recipients of list > ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > > root@fatcity.Subject: Deadlock > Interpretation Assistance Requested > com > > > > > > 02/10/01 > > 07:00 PM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Listers, > > HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: > > SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND > YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY > > Deadlock graph: >-Blocker(s) -Waiter(s) > -- > --- > Resource Name process session holds waits process session holds > waits > TX-00180008-42d6 837 635 X784 481 > S > TX-00160010-4412 784 481 X837 635 > X > Rows waited on: > Session 481: no row > Session 635: obj - rowid = 0722 - 0289.0033.0102 > > I've never really encountered all that many deadlocks before. The ones I > *have* seen in the past were the "classic" TX locks where user A has a row > locked that user B needs and vice versa and the mode requested was X. On > Friday, the DBA's sent me a trace file from a deadlock (with the info above > from that trace file) and asked me to investigate. The deadlocks they had > seen in the past were due to application coding issues, hence their tossing > this to the development side of the house. > > After a lot of research on Metalink, the Steve Adams site > (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the > S > mode wait for session 481 (and no row) makes me think this isn't the > typical > application induced deadlock due to the way and order in which locks are > acquired. > > There are 3 foreign keys on the table, and, each of them are indexed. There > is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know > all that much about how heavily DML is issued against the table. But, after > reading material on when the wait is in S mode, I wonder if this might be > an > ITL issue. From what I've read the past 2 days, there could be other > reasons > for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL > slots, and bitmap index were the most common reasons mentioned. Because the > statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?) > the > check for uniqueness wait during inserts, and, with no bitmap index on the > table, that leaves the ITL slots as the main candidate. > > What I need to do is determine if this is indeed an application coding > issue, or, if I need to kick this back to the DBA's and let them research > it. And I don't mean that in a finger pointing way. The DBA's and > developers > there work well together. From what I've read and learned so far, this > deadlock doesn't seem to be an application coding issue. I am thinking > about > saying that and asking them (if they haven't already) to open a TAR and > provide the trace file to Oracle Support. > > If anyone has any comments or suggestions, I would appreciate hearing them > (because if this could still be due to an application coding issue, more > re
Off Topic: Row Locking - Row Id
Hi Anybody have any idea where I can find the rowid of a row that is being locked within a table? Kind Regards JL -Original Message- Sent: Monday, February 12, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi In my opinion, this is an ITL issue. When a process need an ITL and have to wait for it , then it pseudo randomly selects a locked row (from that block) and enqueues itself in to the waiters queue. But the row_waited information in v$session will be null. In rare cases, it is possible for the deadlock to occur if the ITL waiter holds the row that is needed by the other process. I would ask, what is the frequency of this deadlock ? Is this the first occurrence ? If it is the first occurrence, then I would wait for the next occurrence and then spend time and resource. Hope this helps!! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "These are my opinions and does not bind my employer. Use at your risk" elkinsl@flash .net To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: Deadlock Interpretation Assistance Requested com 02/10/01 07:00 PM Please respond to ORACLE-L Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY Deadlock graph: -Blocker(s) -Waiter(s) -- --- Resource Name process session holds waits process session holds waits TX-00180008-42d6 837 635 X784 481 S TX-00160010-4412 784 481 X837 635 X Rows waited on: Session 481: no row Session 635: obj - rowid = 0722 - 0289.0033.0102 I've never really encountered all that many deadlocks before. The ones I *have* seen in the past were the "classic" TX locks where user A has a row locked that user B needs and vice versa and the mode requested was X. On Friday, the DBA's sent me a trace file from a deadlock (with the info above from that trace file) and asked me to investigate. The deadlocks they had seen in the past were due to application coding issues, hence their tossing this to the development side of the house. After a lot of research on Metalink, the Steve Adams site (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the S mode wait for session 481 (and no row) makes me think this isn't the typical application induced deadlock due to the way and order in which locks are acquired. There are 3 foreign keys on the table, and, each of them are indexed. There is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know all that much about how heavily DML is issued against the table. But, after reading material on when the wait is in S mode, I wonder if this might be an ITL issue. From what I've read the past 2 days, there could be other reasons for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL slots, and bitmap index were the most common reasons mentioned. Because the statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?) the check for uniqueness wait during inserts, and, with no bitmap index on the table, that leaves the ITL slots as the main candidate. What I need to do is determine if this is indeed an application coding issue, or, if I need to kick this back to the DBA's and let them research it. And I don't mean that in a finger pointing way. The DBA's and developers there work well together. From what I've read and learned so far, this deadlock doesn't seem to be an application coding issue. I am thinking about saying that and asking them (if they haven't already) to open a TAR and provide the trace file to Oracle Support. If anyone has any comments or suggestions, I would appreciate hearing them (because if this could still be due to an application coding issue, more research needs to be done on the development and/or my side of the house). Regards, Larry G. Elkins [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
RE: Submitting a URL to Search engines
Dear Mr. Flynn There are numerous tools available for doing this. I know a company called LockTrinity (www.Locktrinity.com) who would do it for free. Please forward me the URL and I'll pass it on to them. Bliksem. Soek jy nog jou CD? Cheers JL -Original Message- Sent: Friday, February 09, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Hi, I have been roped into creating a web page for my daughter's school! So I am learning lots about HTML at a huge rate. The actual creation of the site will be fun (I hope). But I will need to make all the search engines aware of the URL of the new site. - How do I do this? I have seen ISPs offering to 'submit your URL to 100/200 search engines', but they normally want a fee for it - How can I do this myself? - Must I do it manually, or can I create some sort of procedure/script to do it? - Where do I get a list of all these search engines - I can only think of the top 5 or 6 like Yahoo and Google! Any assistance / stories / experiences would be much appreciated. Regards Oweson Flynn -- Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 Email: [EMAIL PROTECTED] This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle startup script for Solaris
Thank you! Kind Regards Johan -Original Message- Sent: Monday, February 05, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Look in $ORACLE_HOME/bin. dbstart and dbshut will get you there. > Lee Robertson > Acxiom > Tel: 0191 525 7344 > Fax: 0191 525 7007 > Email: [EMAIL PROTECTED] > -Original Message- Sent: 05 February 2001 11:20 To: Multiple recipients of list ORACLE-L Has anybody have a automatic startup script for oracle on Solaris? I.e., when the box is bounced, the database & listeners can start up automatically Kind Regards Johan Locke -- 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). 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: 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).
Oracle startup script for Solaris
Has anybody have a automatic startup script for oracle on Solaris? I.e., when the box is bounced, the database & listeners can start up automatically Kind Regards Johan Locke -- 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).
Sql*Loader
Hi
I've got the following entries in a sql*Loader import file
-
2000-02-25JOHN 0608
2000-02-28PETE 0718
-
123456789012345678901
Char 1 to 9 and 18 to 21 make up the date and time, ie '2000-02-25 06:08'
('-MM-DD HH24:MI')
I need to import this information into a table with two columns, "USERNAME"
(1st) & "BIRTHDATE" (2nd), but I'm struggeling using Sql*Loader to
concatenate the two fieds.
create table USER_BIRTHDATES
(USERNAME varchar2(20),
BDATE date);
Any ideas.
--
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).
