RE: view other people's TAR
Hell, I sure hope you can't view other companies tars. I put customer specific stuff in some of my tars and that would just be obscured if Oracle opened up other folks tars to everyone. That being said, Kirti is right, you cannot see other folks tars on Metalink. -Original Message- Kirti Sent: Saturday, March 09, 2002 4:13 PM To: Multiple recipients of list ORACLE-L TAR info contains the CSI number, and thus viewing other people's TAR won't be possible. - Kirti -Original Message- Sent: Saturday, March 09, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: view other people's TAR
Thanks Kirti. That's what I thought, but from time to time people would post TAR numbers as if others can view them. So I was wondering about that. Thanks for verifying my doubts. Rich -Original Message- Sent: Saturday, March 09, 2002 7:13 PM To: Multiple recipients of list ORACLE-L TAR info contains the CSI number, and thus viewing other people's TAR won't be possible. - Kirti -Original Message- Sent: Saturday, March 09, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: view other people's TAR
Rich, I am not sure how you can view my tar, but if you respond to me directly at [EMAIL PROTECTED], I will send you a copy of the tar. HTH, -Ron- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > Sent: Saturday, March 09, 2002 4:53 PM > To: Multiple recipients of list ORACLE-L > Subject: view other people's TAR > > > Hi All, > > How do I look up other people's TAR such as the one posted by Ron Yount > 1921166.995? > I tried to search for it which yielded no results. I then tried to view a > single TAR by number > under the TAR menu but got the following message: > > You have insufficient privileges to enter this section of MetaLink. > If you feel like this privilege should have been granted to you, > please send a feedback request to our administration team. > > Thanks for your help. > > Rich > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, 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: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: view other people's TAR
TAR info contains the CSI number, and thus viewing other people's TAR won't be possible. - Kirti -Original Message- Sent: Saturday, March 09, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
view other people's TAR
Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed ts
Thanks. I was not aware of that. I did not work with 8.1.5. These procedures are available in 8.1.6 and up. - Kirti -Original Message- Sent: Saturday, March 09, 2002 1:43 PM To: Multiple recipients of list ORACLE-L It's version dependent. Convert to local appeared in 8.1.6 or 8.1.7, but was not in 8.1.5. It is probably not a good idea. The tablespace becomes "bitmapped managed", but the extent size is the greatest common divisor of the currently existing extents (including free extents) which in the worse case means one block; and the extent policy if still "user" - which means it follows your initial, next, pctincrease etc. If you can manage it, you are better off trying to create a new tablespace, and transfer the contents form a DMT to an LMT using MOVE and REBUILD. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 09 March 2002 19:37 |There are procedures in DBMS_SPACE_ADMIN to do either. |And those are: |LMT->DMT dbms_space_admin.tablespace_migrate_from_local |DMT->LMT dbms_space_admin.tablespace_migrate_to_local | |- Kirti | |-Original Message- |Sent: Saturday, March 09, 2002 6:13 AM |To: Multiple recipients of list ORACLE-L | | |This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to |Locally managed ts. |It allows reverse. | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally managed ts
It's version dependent. Convert to local appeared in 8.1.6 or 8.1.7, but was not in 8.1.5. It is probably not a good idea. The tablespace becomes "bitmapped managed", but the extent size is the greatest common divisor of the currently existing extents (including free extents) which in the worse case means one block; and the extent policy if still "user" - which means it follows your initial, next, pctincrease etc. If you can manage it, you are better off trying to create a new tablespace, and transfer the contents form a DMT to an LMT using MOVE and REBUILD. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 09 March 2002 19:37 |There are procedures in DBMS_SPACE_ADMIN to do either. |And those are: |LMT->DMT dbms_space_admin.tablespace_migrate_from_local |DMT->LMT dbms_space_admin.tablespace_migrate_to_local | |- Kirti | |-Original Message- |Sent: Saturday, March 09, 2002 6:13 AM |To: Multiple recipients of list ORACLE-L | | |This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to |Locally managed ts. |It allows reverse. | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Locally managed ts
There are procedures in DBMS_SPACE_ADMIN to do either. And those are: LMT->DMT dbms_space_admin.tablespace_migrate_from_local DMT->LMT dbms_space_admin.tablespace_migrate_to_local - Kirti -Original Message- Sent: Saturday, March 09, 2002 6:13 AM To: Multiple recipients of list ORACLE-L This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to Locally managed ts. It allows reverse. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 3:13 PM > Ayyapps, > > Use the DBMS_SPACE_ADMIN supplied PL/SQL package. > > Jack > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -Original Message- > [EMAIL PROTECTED] > Sent: Friday, March 08, 2002 4:03 AM > To: Multiple recipients of list ORACLE-L > > > > Hi all > Can we able to change the dictionary managed tablespace to locally managed > tablespace. if so how? > Ayyapps > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where is tkprof?
Last night I applied the 9.0.1.2 patchset (for Win NT 4.0). Tkprof.exe appeared after I was done :) - Kirti -Original Message- Sent: Thursday, March 07, 2002 7:18 AM To: Multiple recipients of list ORACLE-L patch set number? --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > Jonathan, > > Some intelligent person at M&D forgot to add the tkprof (Trace Kernel > PROFile) > with the NT versions. OWS has a patch for that. > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > > > > -Original Message- > Gennick > Sent: Wednesday, March 06, 2002 3:54 PM > To: Multiple recipients of list ORACLE-L > > > I'm running 9.0.1.1.1 on Win NT, and I don't have a tkprof > executable. Am I losing my mind? Did Oracle do away with > tkprof on NT? I realize the answer to both those questions > may be yes, but I'm most interested in why I don't > have tkprof. > > Best regards, > > Jonathan Gennick --- Brighten the corner where you are > mailto:[EMAIL PROTECTED] * 906.387.1698 > http://Gennick.com * http://MichiganWaterfalls.com * > http://ValleySpur.com > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cursor not closing
At the time that the problem occurred, we were using thin drivers. In the near future, we will be switching to OCI (thick) drivers for the benefits of TAF in OPS... but I digress.. The parameter, is a init parameter and it is effective at the instance level, regardless of how the client connects. HTH, -Ron- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > Sent: Saturday, March 09, 2002 11:23 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: cursor not closing > > > Are u using the JDBC OCI driver or the Thin driver? And which version? > I know the "feature" you described exists for JDBC OCI driver but not for > JDBC Thin driver. > > -Original Message- > Sent: Friday, March 08, 2002 10:23 PM > To: Multiple recipients of list ORACLE-L > > > In the for what it is worth department, I had similiar issues. After the > developers knocked themselves out looking for code that was not > closing the > cursor, I opened a tar: > > In a nutshell: yet another "feature" that cursors "even though > closed by the > session that opened them" remain available this is touted as a feature > since there may be a session later that could benefit from a previous > cursor... this behavior will continue until max_cursors is > reached and then > you are done...:-( > > You can remedy this situation with the > _CLOSE_CACHED_OPEN_CURSORS=true init > parameter. > > If you are interested in more detail... my tar number is: 1921166.995 > > HTH, > > -Ron- > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > > Sent: Friday, March 08, 2002 6:23 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: cursor not closing > > > > > > Identify all the codes where ResultSet, Statement are used and make sure > > they are closed after it's done. > > > > -Original Message- > > Sent: Friday, March 08, 2002 4:48 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > We have a Application that user JDBC thin client connecting to Oracle > > database. > > It seems like java code is opening the cursor , running some sql but not > > closing > > the cusrsor. > > Now the number of open_cursor reached 3568 . > > Is there any way we can close cursor from sqlplus. > > > > Thanks > > --Harvinder > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Harvinder Singh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ji, 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: Ron Yount > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ji, 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 n
RE: cursor not closing
Are u using the JDBC OCI driver or the Thin driver? And which version? I know the "feature" you described exists for JDBC OCI driver but not for JDBC Thin driver. -Original Message- Sent: Friday, March 08, 2002 10:23 PM To: Multiple recipients of list ORACLE-L In the for what it is worth department, I had similiar issues. After the developers knocked themselves out looking for code that was not closing the cursor, I opened a tar: In a nutshell: yet another "feature" that cursors "even though closed by the session that opened them" remain available this is touted as a feature since there may be a session later that could benefit from a previous cursor... this behavior will continue until max_cursors is reached and then you are done...:-( You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true init parameter. If you are interested in more detail... my tar number is: 1921166.995 HTH, -Ron- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > Sent: Friday, March 08, 2002 6:23 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: cursor not closing > > > Identify all the codes where ResultSet, Statement are used and make sure > they are closed after it's done. > > -Original Message- > Sent: Friday, March 08, 2002 4:48 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > We have a Application that user JDBC thin client connecting to Oracle > database. > It seems like java code is opening the cursor , running some sql but not > closing > the cusrsor. > Now the number of open_cursor reached 3568 . > Is there any way we can close cursor from sqlplus. > > Thanks > --Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, 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: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally managed ts
This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to Locally managed ts. It allows reverse. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 3:13 PM > Ayyapps, > > Use the DBMS_SPACE_ADMIN supplied PL/SQL package. > > Jack > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -Original Message- > [EMAIL PROTECTED] > Sent: Friday, March 08, 2002 4:03 AM > To: Multiple recipients of list ORACLE-L > > > > Hi all > Can we able to change the dictionary managed tablespace to locally managed > tablespace. if so how? > Ayyapps > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack C. Applewhite > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Offtopic: www.lonyx.com ????
Sandeep Kurliye wrote: > > Hi, > > Anyone has idea - what happened to website www.lonyx.com > > I think it is Kevin Lonyx website. > > I found this website very interesting in past... but when I am trying to > access today, I am unable to get in. > > Thanks in Advance. > -- There's a bit of explanation here http://www.kevinloney.com/whatnews.htm one month old, but ... -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Offtopic: www.lonyx.com ????
Looks like it is down. Check Kevin Loney's site at http://www.kevinloney.com/ Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kurliye Sent: Saturday, March 09, 2002 2:23 AM To: Multiple recipients of list ORACLE-L Hi, Anyone has idea - what happened to website www.lonyx.com I think it is Kevin Lonyx website. I found this website very interesting in past... but when I am trying to access today, I am unable to get in. Thanks in Advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Offtopic: www.lonyx.com ????
Hi, Anyone has idea - what happened to website www.lonyx.com I think it is Kevin Lonyx website. I found this website very interesting in past... but when I am trying to access today, I am unable to get in. Thanks in Advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Do you use RMAN? DB clone problem
Hi Lists I have encountered error(ORA-00600: internal error code, arguments arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while running package called 'JC_PR_SPLIT_PROCESS' Error message is listed below . I am using SQL Navigotor to process this package. Any idea or clue for this error. Please give me a soultion for this. * SCRIPT START : Session:prodho8i.world-MECJCPDAT:1 9-Mar-02 11:13:49 am SCRIPT File: UnNamed1 Starting from line number : 1 Processing ... BEGIN * ORA-00600: internal error code, arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 688 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 306 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 913 ORA-06512: at line 2 * SCRIPT END : 9-Mar-02 11:16:40 am How do I solve this error Any help is really appreciated. Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
