RE: oracle cliënt

you just installed the oracle 8 clint software i suppose ? -Oorspronkelijk bericht- Van: Trivedi, Hitarth [SMTP:[EMAIL PROTECTED]] Verzonden:dinsdag 30 januari 2001 16:00 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle clint We had problems when we

Re: salary advise

Thanks very much Rao for providing all the helpful information. Now I am in a better position to decide about job salary. regards Shuja Rao, Maheswara wrote: Sent: Thursday, January 25, 2001 2:35 PMTo: Multiple recipients of list ORACLE-LShuja,I can give you the salary ranges in Saudi Arabia

SQLplus Help

Hello, I executed the sql script the sqlloader commands to create, load and index the table SYSTEM.HELP. When I launch the command HELP ... in sqlplus environment installed in the Server (HP-UX), it works fine. From an NT client, when I launch the command HELP ..., I have the following message :

Re: OT ? for people who know other databases besides Oracle

Tools like the one you are building often use 3 tiers.. The middle application server is where the code runs that may substitute functionality of procs/ triggers etc.. The down side as paquette said is performance hit.. its either that or hiring extra programmers to make sure your code is

RE: error message

Doug, I had a similar problem - the file that it is looking for was not installed. I am not sure if the 1.0 is part of the file. It was the .so file for me. libclntsh.so libclntsh.so.1.0 In the end I downloaded a new install version and unzipped all the .jar files until I found the culpret

Re: Init.ora .. OPTIMIZER parm: optimizer_index_cost_adj

I've used this in an attempt to make the optimizer prefer a hash join over a nested loops join. The desired results were not achieved. Jared On Tue, 30 Jan 2001 [EMAIL PROTECTED] wrote: Has any one messed with optimizer_index_cost_adj on 8.1.7 ?? The default is 100, but my boss

Re: Index Usage Monitoring

Pine Cone Systems has software to do this. There is also another company that has software to do this, but I can't recall their name at the moment. If you talk to Pine Cone, ask them who their competitors are. Be forewarned, this stuff is very expensive. Jared On Tue, 30 Jan 2001, PRINCE,

Re: Re[2]: OT ? for people who know other databases besides Orac

Dick, I've just check on metalink and found notrace of my sql_ansi init.ora parameter :-( but I'm sure there was one (Oracle 7.1 on Novell 3.11). By the way, I do not know Linda Seley . Stephane --- [EMAIL PROTECTED] a crit: Stephane, I'll add your friend onto the addressee list as

RE: newbie: problem in dynamic SQL

stephane, just curious, really, no subtle lines... should I, a developer, tell my dba that I'm gonna create temporary tables? (I know most of you are dba's, please don't flame me...) deep inside I would say, yes, but, really why? Rigth access? space allocation? performance tunning? curious dba?

People Soft dba info

Hello all, I was wondering if anyone has info or leads in the particulars of managing an Oracle database supporting PeopleSoft. Oracle version 7.3. Thanks Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Lanteigne INET: [EMAIL PROTECTED] Fat City

HP-UX 11.0 64 bits

Hi All, I'd be interested in any experienced related to 8.1.6/8.1.7 on HP-UX 11.0 64 bits. Apart from the remarks which can be found on Metalink, has any of you experienced any performance degradation or bug related to this OS ? Christian

how can I tell if a read only tablespace is offline?

Title: how can I tell if a read only tablespace is offline? I have two tablespaces that are read only. One is online, the other is offline. Does someone know of a query that will tell them apart? There doesn't seem to be any difference in dba_tablespaces or sys.ts$. SQL alter tablespace

OT: Locally managed tablespaces - ST enque

Steve, Slightly off the LMT topic, but what is an ST enque problem? I'm at home at the moment, and don't have any references to look at - but I have a thirst for knowledge tonight, the misses is out, nothing on telly, so I'm sat at my PC trying to learn what my sales life doesn't allow.. Oracle

RE: 8.1.6 STANDBY DATABASE vs REPLICATION

i would just copy all of the datafiles and such over to the other machine and bring it up. I don't know, is that considered standby or replication? Not up on the lingo Kevin It's neither. What you described is just copying a database from one server to another. Standby and replication

Unix script question

I am looking to resolve an issue we have with a particular script. using a unix script, I need to determine if a file exists and if the size of the file is zero bytes. using ftp, we put a file a file on a server then we use get to retreive the same file back. we do this to ensure that the

RE: Index Usage Monitoring

V$access appears to be pretty unreliable. V$db_object_cache does not appear to carry indexes but does have some good information on tables. -Original Message- Sent: Wednesday, January 31, 2001 2:51 PM To: Multiple recipients of list ORACLE-L And starting with the time immemorial,

RE: METABLINK on the Fritz?

Title: METABLINK on the Fritz? There was an article posted on metalink stating that Oracle did not foresee such a large increase in the number of metalink users, and stating that upgrades to the hardware were planned. I noticed that it'sstill pretty slow today. I assume yesterday's work was

RE: POINTLESSLY, SICKENINGLY OFF TOPIC

This blank email was as far of the topic as it goes -Original Message- Sent: Wednesday, January 31, 2001 4:22 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City

A couple of questions from a lazy DBA

I could benefit from being able to "add" a new, homebrew SQL function into the database. I assume that it is possible; which might be incorrect. Can someone point me any documention that explains how I could add my own SQL function into the db? I assume that some already has a PL/SQL function

Re: Varchar2(4096) too long

Hi, yes, I noticed that too but do you have any idea what should I do and how I can keep the existing data on that column. Br and thanks, Hessu varchar2(4000) is max. joe _ Get Your Private, Free E-mail from MSN

Re: Selecting all columns

Yes, also select b.data_length Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-11-6920905 (35) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL

Re: Varchar2(4096) too long ??

varchar2(4000) is max. joe Heikki Jantunen wrote: Hi all, I have table created with a column varchar2(1000) no I need to resize it and allow data as 4096. Varchar2(4096) is not allowed. What should I do and how could I keep the existing data on that column. TIA for your advise,