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

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*

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:

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

Antwort:

Hi use in mount state of database: alter database datafile '/data/db/database/core.dbf' offline drop; Regards Ivo Libal Mouka Otakar

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

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,

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

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,

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

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

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

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

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 filename on all the files. - Eg.: gunzip Linux9i_Disk1.cpio.gz 2. Extract the cpio archives with the command cpio -idmv filename - Eg.:

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

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

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

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:

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

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

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

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

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

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

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

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

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 ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane,

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