row creation or update date??
Title: row creation or update date?? Hi This may be an easy question or mentioned before, apologize if so, But is there some way of finding a row in a table's creation/update date, without there being a date column specific for that purpose. Something like rowid? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: ftp tools
Leech FTP http://stud.fh-heilbronn.de/~jdebis/leechftp/downloads.html Freeware not ad-ware. Does multi-ftps similtaneously Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 "Ball, Terry" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 22/11/2001 07:10 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject: ftp tools Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
RE: Upgrade 8.0.5 to 8.1.6
Sheesh, glad you pointed this out. -Original Message- Baker Sent: Wednesday, November 21, 2001 9:50 PM To: Multiple recipients of list ORACLE-L Ed: If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a potential difficulty you need to know about. If you're not aware of the dictionary corruption problem, be sure you read the metalink alert (96117.1). This has something to do with block checking enabled in 8.1.6 Essentially, you need to analyze all your system tables to insure no corruption has been introduced. If you have any problem finding the info on metalink, take a look at the Tim Gorman's web site (www.evdbt.com). He has some info about it under "downloads". Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
IOT and ora-600 [ktbgcur_2] on NT 81714
Hi, We are testing the use of IOTs getting ready to implement 1 in production. During some of the testing we have encountered an ora-600 [ktbgcur_2] in the alert log. This has been logged with Oracle support to get an explanation of what this means but in the meantime I was wondering if anyone else has come across this? The all important version information: Oracle 8.1.7.1.4 - Windows NT4, Quad processor server with parallel degree of default on all tables and indexes. >From the alert log: Sun Nov 18 14:36:54 2001 Errors in file d:\oracle\admin\abcd\udump\ORA00657.TRC: ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] >From the user dump file (ora00657.trc mentioned above) *** 2001-11-18 14:36:54.843 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] Current SQL statement for this session: SELECT ANLY_ANALYSIS,ELMN_ELEMENT,ELEMENT_PERCENTAGE FROM ANALYSIS_ELEMENTS WHERE ROWID=:1 FOR UPDATE OF ANLY_ANALYSIS NOWAIT - Call Stack Trace - Any feedback would be appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sqlloader to VSAM
Hei..friend...need some help over here. Will mainframe system able to read our sqlloader text file directly ? as VSAM format? if not how can I convert it to VSAM format ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is CKPT process is Mandatory in 8i
Hi, It is mandatory starting from Oracle 8. In Oracle 7 it was optional. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Thursday, November 22, 2001 6:55 AM To: Multiple recipients of list ORACLE-L Hi List, Today we had a big argument at our work place whether CKPT is Mandatory/Optional process in 8i. My contention is that it is an optional process. I am sure it was optional in 7.3 and later became mandatory in 8. Gurus, can you please clarify whether CKPT is a Mandatory or Optional process in 8i. TIA, Muths _ 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: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: OT: X Win client
Java implementation of xserver under GPL. http://www.jcraft.com/weirdx/ I tried it 6-8 months ago and it was running gnome wm in window on my NT4 wrk. JP On Thu 22. November 2001 18:35, you wrote: > One of the conditions was that the Xserver be free. > > xwin32 is cheap, but not free. > > Jared > > On Wednesday 21 November 2001 19:45, C.S.Venkata Subramanian wrote: > > Try xwin32 from starnet > > -- > > > > On Wed, 21 Nov 2001 10:15:25 > > > > Jared Still wrote: > > >Yes, Xfree86. > > > > > >Just do a search on google. I use it to run Oracle > > >installs, so it works well enough. > > > > > >Jared > > > > > >On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote: > > >> Hi all! > > >> > > >> Is there any free (important: free) X client software for NT? > > >> > > >> Regards, > > >> Vladimir Barac > > > > > > > > >Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > > >Content-Transfer-Encoding: quoted-printable > > >Content-Description: > > > > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Jared Still > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California-- Public Internet access / Mailing Lists > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB ORACLE-L > > >(or the name of mailing list you want to be removed from). You may > > >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i Problem
make sure that the files were unzipped correctly - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 22, 2001 16:50 > Hi > > I have some problems with Oracle 9i for Linux, I downloaded the files from > OTN then I did all the steps that otn said: > > 1. Run "gunzip " on all the files. > - Eg.: gunzip Linux9i_Disk1.cpio.gz > > 2. Extract the cpio archives with the command "cpio -idmv < " > - Eg.: cpio -idmv > but the second step did not work... I didn't see any files!! > What's wrong?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT: X Win client
One of the conditions was that the Xserver be free. xwin32 is cheap, but not free. Jared On Wednesday 21 November 2001 19:45, C.S.Venkata Subramanian wrote: > Try xwin32 from starnet > -- > > On Wed, 21 Nov 2001 10:15:25 > > Jared Still wrote: > >Yes, Xfree86. > > > >Just do a search on google. I use it to run Oracle > >installs, so it works well enough. > > > >Jared > > > >On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote: > >> Hi all! > >> > >> Is there any free (important: free) X client software for NT? > >> > >> Regards, > >> Vladimir Barac > > > > > >Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > >Content-Transfer-Encoding: quoted-printable > >Content-Description: > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Jared Still > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9iAS
This is of course a little less trouble if the developers are a little less ( *ahem* ), sloppy when developing. Lack of case sensitivity is not a good excuse for bad practice. Jared On Thursday 22 November 2001 06:30, Charlie Mengler wrote: > It is a challenge to make Forms60 & Reports60 work on *nix > due to the fact of file name case sensitivity; since these tools > were built on Windows which is a case insensitive OS. > > Cyril Thankappan wrote: > > Hi listers > > > > Can someone (all of you of course!) > > give your 'honest and frank' opinion > > on what you think of the 9iAS > > > > Thanks > > > > Cyril > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is CKPT process is Mandatory in 8i
Mandatory starting with Oracle 8 Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 22 November 2001 14:55 To: Multiple recipients of list ORACLE-L Hi List, Today we had a big argument at our work place whether CKPT is Mandatory/Optional process in 8i. My contention is that it is an optional process. I am sure it was optional in 7.3 and later became mandatory in 8. Gurus, can you please clarify whether CKPT is a Mandatory or Optional process in 8i. TIA, Muths _ 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: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: close_cached_open_cursors "error"
It is an underscored one. Issue this query to look its value: select ksppinm,ksppstvl from x$ksppcv b,x$ksppi a where a.indx=b.indx and ksppinm like '%close_cached%'; Regards. --- [EMAIL PROTECTED] wrote: > > Hi Eva , > Closed_cache_open_cursors is a parameter in Oracle > 7.3.4.x .This is > obsolete in oracle 8.x > If set in u r init.ora remove it. > OR > Some product is setting this at Alter > system /Alter session > > HTH > > shreepad. > This parameter controls whether cursors opened and > cached in memory > by PL/SQL are automatically closed at each COMMIT. A > value of > FALSE signifies that cursors opened by PL/SQL are > held open so that > subsequent executions need not open a new cursor. If > PL/SQL cursors > are reused frequently, setting the parameter to > FALSE can cause > subsequent executions to be faster. > A value of TRUE causes open cursors to be closed at > each COMMIT or > ROLLBACK. The cursor can then be reopened as needed. > If cursors are > rarely reused, setting the parameter to TRUE frees > memory used by the > cursor when the cursor is no longer in use. > > > > > Denham Eva > > <[EMAIL PROTECTED] To: > Multiple recipients of list ORACLE-L > za> > <[EMAIL PROTECTED]> > cc: > > 21/11/01 22:26 Subject: > close_cached_open_cursors "error" > Please respond > > to ORACLE-L > > > > > > > > > Hello Guru's > > I hope someone can shed light on this problem, more > a nuisance really. > The below Alter Session statement has been appearing > in the *alrt.log file. > > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > > The system is a Compaq 8500R system, Win2K and > Oracle 817. > Does anyone have an idea of what this is as everyone > I have approached here > at my work claims not to be using it, I suspect a > third party product. > > Absolutely any info will be appreciated. > > TIA > Denham > > _ > > This e-mail message has been scanned for Viruses and > Content and cleared by > MailMarshal - For more information please visit > www.marshalsoftware.com < > http://www.marshalsoftware.com> > _ > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OORDBMS?
I use them for transient collections , for example, the "table" and "cast" operators to pass 'chunks' of rows about in PL/SQL. Thus this is really just creating various types in the dictionary and referencing these in PL/SQL routines. I'm not really a fan of using object-segments (for lack of a better terms), ie physical tables of objects et al, since if you dig under the covers, Oracle is just implementing the whole lot as relational tables anyway - in which case, I'd rather have the control. hth connor --- Cyril Thankappan <[EMAIL PROTECTED]> wrote: > > > Hi listers > > Can someone please tell me > 'under what circumstances' do people > 'actually' use the OBJECT option of the 8+ RDBMS? > > Thanks > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is CKPT process is Mandatory in 8i
Hi List, Today we had a big argument at our work place whether CKPT is Mandatory/Optional process in 8i. My contention is that it is an optional process. I am sure it was optional in 7.3 and later became mandatory in 8. Gurus, can you please clarify whether CKPT is a Mandatory or Optional process in 8i. TIA, Muths _ 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: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i Problem
Hi I have some problems with Oracle 9i for Linux, I downloaded the files from OTN then I did all the steps that otn said: 1. Run "gunzip " on all the files. - Eg.: gunzip Linux9i_Disk1.cpio.gz 2. Extract the cpio archives with the command "cpio -idmv < " - Eg.: cpio -idmv http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9iAS
It is a challenge to make Forms60 & Reports60 work on *nix due to the fact of file name case sensitivity; since these tools were built on Windows which is a case insensitive OS. Cyril Thankappan wrote: > Hi listers > > Can someone (all of you of course!) > give your 'honest and frank' opinion > on what you think of the 9iAS > > Thanks > > Cyril > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Two questions about PRO*C
ehsan sinavalda wrote: > > Hi All > > 1- I have a (char *) that contains a SQL statement, > Can I apply it to database from a PROC program. > Yes, it's called dynamic SQL. EXECUTE IMMEDIATE is fine if it's DDL or hard-coded INSERT/UPDATE/DELETE. SELECTs are more or less complicated, depending on whether you already know the number and types of the items in the select list. The less you know about the statement, the more complicated it becomes. Check the demo programs. > 2- How can I move a cursor to first record? Although OCI functions are beginning to have parameters pointing into the direction of scrolling back cursors (but so far only one direction is allowed, forwards), this is inherently unnatural to Oracle. Close the cursor and reopen it. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- 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).
OORDBMS?
Hi listers Can someone please tell me 'under what circumstances' do people 'actually' use the OBJECT option of the 8+ RDBMS? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9iAS
Hi listers Can someone (all of you of course!) give your 'honest and frank' opinion on what you think of the 9iAS Thanks Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two questions about PRO*C
Hi All 1- I have a (char *) that contains a SQL statement, Can I apply it to database from a PROC program. 2- How can I move a cursor to first record? Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Odd Listener.ora Stanza
Hi , The settings in the listener.ora point to "EJB specifies Java Remote Method Invocation (RMI) as the transport protocol. Oracle8i JServer implements RMI over IIOP. Because the CORBA Internet Inter-ORB Protocol (IIOP) is the transport protocol for CORBA and for a future version of RMI, Oracle8i effectively enables direct object-oriented access to an array of open systems. " So for Oracle 8i Jserver connections (PRESENTATION = GIOP) is specified. HTH shreepad Srini.Chavali@C ummins.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 21/11/01 21:45cc: Please respondSubject: Re: Odd Listener.ora Stanza to ORACLE-L Ross, It's CORBA stuff. See note 69043.1 on Metalink. HTH Srini Chavali Oracle DBA Cummins Inc "Mohan, Ross" <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001 10:15:27 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Anyone seen this fecality in their listener.ora? It's a new one on me, but then again, what with all the "newfangled" features in this here product, I am probably just losing track.. (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem Running DDL SQL Script
Hi Ken, The syntax seems to be ok . It worked at my environment. So u may have to look at privileges or status of tablespaces. Why are u creating tables as SYSTEM ? .. Just a query. shreepad Ken Janusz <[EMAIL PROTECTED]> cc: 21/11/01 22:35 Subject: Problem Running DDL SQL Script Please respond to ORACLE-L I have this script that will generate a DB with a number of create table and create index statements. When I try to run it in SQL*Plus I get this error: ORA-00959 tablespace SOS2_TBLSPC does not exist. ORA-00942 table or view doesn't exist Here is a sample of one of the create statements: DROP TABLE ACCESS_RIGHT CASCADE CONSTRAINTS ; CREATE TABLE ACCESS_RIGHT ( ACCESS_RIGHT_ID NUMBERNOT NULL, GROUP_ID NUMBERNOT NULL, MODULE_IDNUMBERNOT NULL, CONSTRAINT PK_AR_ALL PRIMARY KEY ( ACCESS_RIGHT_ID, GROUP_ID, MODULE_ID ) USING INDEX TABLESPACE SOS2_TBLSPC PCTFREE 10 STORAGE ( INITIAL 120K NEXT 104K PCTINCREASE 0 )) TABLESPACE SOS2_TBLSPC NOLOGGING PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 30720 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 505 FREELISTS 1 FREELIST GROUPS 1 ) NOCACHE; When I check the DB this tablespace exists and is online. I'm logged in as system/manager. The environment is W2000/8.1.7. Any idea what the problem is? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
aps_data_files
Hi lists, In what way aps_data_files differ from dba_data_file? what this aps_data_files view store in data dictionary? can anybody throw some light? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Can't do the data, but the design yes. Oracle provides a tools called Oracle Migration qworkbench that works pretty well. Make sure that you change the table owner names etc to the correct owner. Good luck. Clint -Original Message-From: S.Jyotinarayan [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 22, 2001 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: Import MS SQL Server 2000 DB into Oracle EE 8.1.7 Hi all, How do I import a MS SQL Server 2000 database (design and data) into Oracle EE 8.1.7 (typical installation) ? Thanx in advance
Antwort:
Hi use in mount state of database: alter database datafile '/data/db/database/core.dbf' offline drop; Regards Ivo Libal Moučka Otakar .cz> Kopie: Gesendet von:Thema: root@fatcity. com 11/21/2001 02:40 PM Bitte antworten an ORACLE-L Hello I need a help with one problem. In the Oracle version 8.1.7 I´ve deleted a "tablespace" in the Linux, but before this I did´t use a function " Drop". After reboot a database, there was a error: ERROR at line 1: ORA-01116: error in opening database file 7 ORA-01110: data file 7: '/data/db/database/core.dbf' ORA-27041: unable to open file Linux Error: 2: No such file or directory Additional information: 3 Is there a some re-step to drop "tablespace" and then regulary delete this object and restart the database ? Thanx a lot for your answer. Ota Moucka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Hi all, How do I import a MS SQL Server 2000 database (design and data) into Oracle EE 8.1.7 (typical installation) ? Thanx in advance
Re: Fwd: A problem
Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls SQLPLUSW to run the above procedure. The outcome is a batch command file called exp_OSC.cmd wich is invoked by the firts batch file to perform the real export. The "secret" is to use the SQL to create the second file since DOS hasn't the ability to handle strings. The example files are within an attached zip file. The file exp_Ora.ftp is a parameter file for to FTP the DMP files to other machine. If you find some strange words in the files, they are Portuguese. Hope it helps. Dias Costa P.S.: My apologies for I have sent the files unziped. Jared Still wrote: > > -- Forwarded Message -- > Date: Wed, 21 Nov 2001 15:34:27 +0100 > > I have created a job to export a user shema > How can I tell Oracle each time it make the export to use lets say > .dmp > I mean for example if today is 21.11.2001 > the exported file whoud have name21112001.dmp or something like this... > > --- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL question
Thankyou everyone for the quick and very useful responses... -Original Message- Sent: 21 November 2001 16:04 To: Multiple recipients of list ORACLE-L Hi, Can you tell me if its possible to write some sql to change some data. Basically I need to run a scritp to change data of column: id from 12345678 to the last four digits. Is this possible to do in sql/plsql?? Any advice/hints would be greatly appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrading from 8.0.5 to 8.0.6
Hi, I am about to upgrade our databases from 8.0.5 to 8.0.6 (on HP-UX). For reasons beyond my control, I am not allowed to change the current ORACLE_HOME (which is /opt/oracle/product/8.0.5). Can I deinstall my 8.0.5 binaries and install the 8.0.6 binaries (same oracle_home), the run the u* script and do the other steps for an upgrade? Or do I have to use that db assistant and do an Upgrade Database objects. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: close_cached_open_cursors "error"
Hi Eva , Closed_cache_open_cursors is a parameter in Oracle 7.3.4.x .This is obsolete in oracle 8.x If set in u r init.ora remove it. OR Some product is setting this at Alter system /Alter session HTH shreepad. This parameter controls whether cursors opened and cached in memory by PL/SQL are automatically closed at each COMMIT. A value of FALSE signifies that cursors opened by PL/SQL are held open so that subsequent executions need not open a new cursor. If PL/SQL cursors are reused frequently, setting the parameter to FALSE can cause subsequent executions to be faster. A value of TRUE causes open cursors to be closed at each COMMIT or ROLLBACK. The cursor can then be reopened as needed. If cursors are rarely reused, setting the parameter to TRUE frees memory used by the cursor when the cursor is no longer in use. Denham Eva <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L za> <[EMAIL PROTECTED]> cc: 21/11/01 22:26 Subject: close_cached_open_cursors "error" Please respond to ORACLE-L Hello Guru's I hope someone can shed light on this problem, more a nuisance really. The below Alter Session statement has been appearing in the *alrt.log file. ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter The system is a Compaq 8500R system, Win2K and Oracle 817. Does anyone have an idea of what this is as everyone I have approached here at my work claims not to be using it, I suspect a third party product. Absolutely any info will be appreciated. TIA Denham _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com < http://www.marshalsoftware.com> _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
