Re: perl dbi dbd

HP has pretty good customer service. They have usenet discussion forums on which they readily help. I'm sure that a question like would not take HP long time to answer. On 2003.10.03 00:34, "Jesse, Rich" wrote: Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can get it. Are y

RE: perl dbi dbd

Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can get it. Are you sure you can't build it? It'll build with the icky non-ANSI cc that comes with HP/UX (I think). Or d/l a gcc binary depot from the above site and compile it with that. There is at least one major caveat wi

Re: RE: Hiding passwords

> Bob Metelsky <[EMAIL PROTECTED]> wrote: > That's very interesting... Thank you. Do you know how that can be set > in > an env variable? Or how the hidden variable can be passed around? > Eg > C:\ads>set var= Or > C:\ads>set var=more Echo %var% > C:\ads> echo is on > ??? This works in XP Pro, dun

Re: Seems odd to me....(bug?)

scott> @connect system/manager system> create table employee_role (a number); Table created. system> grant all on employee_role to scott; Grant succeeded. system> @connect scott/tiger Connected. scott> create synonym employee_role for system.employee_role; Synonym created. scott> select * fr

Translations needed into Spanish, German, French, Mandarin, Thai

Hi All I am looking for a bunch of messages, field names and labels to be translated into German, French, Spanish, Mandarin and Thai. There are about 150 values, and if you are experienced at this stuff (have developed software or codes specifically in any of the languages listed above), please e

RE: RE: Create Table..As Select: Number formats

I'm perhaps a little late replying, but have you looked at using "alter table xxx modify (column number(1,2));" for example to modify the number format after creating the partition. I'm expecting there to be limits but it sounds like you are only trying to increase the number type size not decre

Re: exam

The exam was well made. They were very keen on 1. the exact values of the various hit ratios 2. deadlocks. All in all I would say that the preparation for this exam is a lot more tougher than the exam itself. Performance tuning course is VAST. But I could be wrong about the exam, because fran

Re: exam

> Congratulations. Thanks >Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that "studying for an exam is different from studying". This principle doesn't seem to apply so much to "backup and recovery" , "adm

RE: Physical I/O and databases other than oracle

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 3:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Physical I/O and databases other than oracle > > > my email states that in oracle this isnt true. HOWEVER, what > a

Can't order XMLAGG()

Hello, I am trying to order my xmlagg function in oracle and the documented query doesn't work. SELECT XMLELEMENT("Department", XMLAGG( XMLELEMENT("Employee", e.job_id||' '||e.last_name) ORDER BY last_name)) as "Dept_list" FROM emp

Re: Seems odd to me....(bug?)

I've seen similar problems where public synonyms exist. You would think that nothing would appear in user tables though. Perhaps check all_tables and look for the owners. Also, try "desc table" and "desc owner.table" to see if the result is the same. Like I said - I hit similar problems in tes

RE: how to send mail from windows command prompt?

Title: RE: how to send mail from windows command prompt? Murali, I am using blat and it is working great. You could download necessary software from www.blat.net Thanks, Rama Ari Database Administrator [EMAIL PROTECTED] 610.964.5128 -Original Message- From: Murali_Pavuloori/[E

RE: Seems odd to me....(bug?)

Could it be that the table has a trigger and it's trying to insert into another table that does not exist? Can you read from the table? Waleed -Original Message- Sent: Thursday, October 02, 2003 6:40 PM To: Multiple recipients of list ORACLE-L Oracle EE 8.1.7.2 HP-UX 11 Can anyone exp

Deterministic Functions: am I missing something?

drop table test_det; create table test_det (c1 date); create or replace function f2 (p1 in number, p2 in number) return number deterministic is pragma autonomous_transaction; begin insert into test_det values (sysdate); commit; return(p1 * p2); end; / select f2 (1,3) from dual where f2 (1,3)

Seems odd to me....(bug?)

Oracle EE 8.1.7.2 HP-UX 11 Can anyone explain this? 1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) SQL> / INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist

perl dbi dbd

where can I get binaries for perl DBI and DBD for hp-ux 9000 . I dont have pre requisite for building binaries from source .   Thanks, -ak  

RE: locally managed autoallocate (was: Separate Indexes and Data)

Well, sort of. If I had a 9i DB to play with, I'd try this myself... 1) Create an SMT. 2) Create 50 tables in that TS. 3) Drop every even table just created. 4) Extend one of the remaining tables until you can't. Depending on the size of the TS created and the blocksize, you could have a sit

RE: ORA-06401 NETCMN INVALID DRIVER

Problem solved, had to include the domain name in the hostname Hostname.domain:1521:orcl Tks anyway Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Thursday, October 02, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Hi list, I just installed 9IAS R2

how to send mail from windows command prompt?

Hello All: I have setup some scripts that would export the db every day. Instead of looking through the logs manually every morning, is there a way to tail (windoze equivalent?) the file and send and email (mailx equivalent on windows?) I know this can be implemented in Perl, but I don't know per

RE: locally managed autoallocate (was: Separate Indexes and Data)

> > -Original Message- > > From: Jesse, Rich > > Sent: Wednesday, October 01, 2003 9:49 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: locally managed autoallocate (was: Separate Indexes and > > Data) > > > > Theoritically, perhaps, but what if an existing table needs > >

Re: Oracle Client for Macintosh

Title: Re: Oracle Client for Macintosh There are no downloadable clients.  Only the server v9201, which is all character-mode (yay!)... on 10/1/03 8:24 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: I've searched TechNet and MetaLink but can't find a downloadable 8i, 9i, anything Oracle C

RE: SQLServer resources

Title: Message Okay,   There are some e-mail lists.  There is also books online that comes with SQL Server which goes over production support issues as you have named.  Where I work they user Veritas Backupexec which is pretty easy to use so I don't know about SQL Server's backups.  I prefer

Re: UNIX : script help/input

I would be tempted to use Java for this rather than C. Much more portable than external procedures, an important distinction in a heterogenous shop. Jared Vladimir Begun <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/02/2003 12:34 PM  Please respond to ORACLE-L                 To:  

RE: SQLServer resources

Title: Message Thanks, everybody, for the SQL Server info... -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 2:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SQLServer resources Try this site;   http:/

Re: AIX ODBC driver from Oracle

http://www.unixodbc.org/ Gene Gurevich <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/02/2003 01:04 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        AIX ODBC driver from Orac

FW: ORA-06401 NETCMN INVALID DRIVER

> Hi list, > > I just installed 9IAS R2, the J2EE and Web Cache option. Before creating a DAD I'm > trying to connect to a DB > in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get > this error. > > In metalink direct me to modify the TNSNAMES.ORA file but the

RE: AIX ODBC driver from Oracle

I`ve used Merant ODBC driver on Sun. It worked pretty well. I'm surprised that you have problem with it. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]

RE: AIX ODBC driver from Oracle

Gene No, oracle does not have an ODBC driver for AIX. However, I have set up several database connections to SQL Server using the Merant Driver. It works very well and is more than fast enough for our application. My first piece of advice is to watch your case. The Oracle and the Merant driver se

Re: AIX ODBC driver from Oracle

http://www.unixodbc.org/ On Thu, 2003-10-02 at 16:04, Gene Gurevich wrote: > Hi all: > > A developer has installed some software from IBM, > which is using an ODBC driver from Merant to connect > to a remote database. And it also doesn't seem to > work. > So they are asking whether there is a Ora

Re: UNIX : script help/input

This database is 8i. I would probably still use the package, as it does octal, hex and binary as well as base 36 and 64.   Jared Vladimir Begun <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/02/2003 12:24 PM  Please respond to ORACLE-L                 To:        Multiple recipients

Re: Help with procedure.

Here's one way: define delete_date_format = 'dd/mm/yy' col old_nls_date_format noprint new_value old_nls_date_format select value old_nls_date_format from nls_session_parameters where parameter = 'NLS_DATE_FORMAT' / alter session set nls_date_format = '&&delete_date_format'; accept delete_dat

ORA-06401 NETCMN INVALID DRIVER

Hi list, I just installed 9IAS R2, the J2EE and Web Cache option. Before creating a DAD I'm trying to connect to a DB in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get this error. In metalink direct me to modify the TNSNAMES.ORA file but the installation did

RE: ORA-03120

Remove Ora817 and go back to 816 client. The OCI is probaly different between them. Or you need to recompile your application with 8.1.7 client in place. Brad -Original Message- Sent: Thursday, October 02, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Hi, I have been running DB

AIX ODBC driver from Oracle

Hi all: A developer has installed some software from IBM, which is using an ODBC driver from Merant to connect to a remote database. And it also doesn't seem to work. So they are asking whether there is a Oracle ODBC driver for AIX which they can try instead. Does anyone know where do I start to l

RE: UNIX : script help/input

Title: RE: UNIX : script help/input it was actually "C" code ... but because data is going on a modem, the pl/sql speed is acceptable (in fact we have to _wait_ after sending out each message). Had fun doing that though ... it is critical, tied to our SLA ... so must be up all the time. I'd r

Re: Steps to convert a RAC to a single instance.

Murali: Other than init parameter changes, you need to turn the RAC components off from the oracle binaries. Otherwise RAC will be still running in the oracle irrespective of init parameter. TO Disable RAC.. follow these steps; 1. Shutdown ALL instances on that oracle home 2. Go to $OH/rdbms/li

Re: Locally managed tablespaces and raw devices

At my previous company, I managed an OPS database ver. 8.1.7.1 with ALL tablespaces locally managed (auto allocate) and on the raw devices.There were no problems, if we disregard the famous "Philamae comparison". On Thu, 2003-10-02 at 15:14, Louis Avrami wrote: > Hi all, > > I just inherited an 8

Re: ORACLE CLIENT V816

AFAIK in Solaris V8.1.6, the client is part of EE download itself. When you invoke OUI just choose the Client option and install it in a different Oracle Home. May it is same in Linux. Just check.   HTH GovindanK <-Original Message->     From: Seema SinghSent: 10/2/2003 12:00:38 PMTo:

Relink Error 9.2.0.4 Patch HP/UX

Is anyone running 9.2.0.4 on HP/UX? 11.0 HP9000 I had 9.2.0.2 running and downoaded and installed the 9.2.0.4 patch and now I can't relink. Unsatisfied symbol in "kkxfcab" in file /usr/oracle/9.2.0/lib//libserver9.a[kwqa.o] I have a tar in process but wondering if anyone else has 9.2.0.4 runni

RE: Steps to convert a RAC to a single instance.

Raj, we have a java application that connects to the datawarehouse that is currently setup on RAC but if for some reason one node fails, then we need to recycle the whole application server as the connection pool goes staleOracle product development stated that db links can't be failed over.

Re: UNIX : script help/input

Jamadagni, Rajendra wrote: unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted feed that we send out to our clients ... it is decoded by a chip. Oh well I am back to array of references ... I'd suggest to consider external C function -- it's faster, it's easier to writ

Re: UNIX : script help/input

[EMAIL PROTECTED] wrote: Left pad with zeroes, take a substring, feed it to the handy-dandy hex/oct/bin/dec converter package - much easier. Jared, what Oracle edition do you use? I'm asking because you might want to consider not to use 'handy-dandy' hex/oct/bin/dec converter package, but TO_CHAR/T

RE: Steps to convert a RAC to a single instance.

Title: RE: Steps to convert a RAC to a single instance. our (forms) application doesn't fail over, but then we look at RAC for HA ... the logic is like this ... if once instance goes down, then instead of making all 1000 users unhappy, I just make 500 (estimate) of them unhappy, and they can l

RE: blocksize on AIX

We use 8192 on AIX and have no problems. The AIX block size is 512 so I know it is advisable to have a multiple of 512, other than that I know of no other caveat. Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hans de Git Sent: Wednesday, Octob

Locally managed tablespaces and raw devices

Hi all, I just inherited an 8.1.7.4 database running on Solaris 2.8, 16 k block size, using raw devices for database datafiles. The raw slices all appear to be a uniform size, 200 meg each. As part of my initial site survey, I noticed that the tablespaces are all dictionary managed. Would it b

RE: Describe privilege on procedures & packages

Here we go:   http://www.geocities.com/dba_assist/scripts/show_procedure.html   HTH GovindanK <-Original Message->     From: Jamadagni, Rajendra;Jamadagni, RajendraSent: 10/1/2003 1:25:33 PMTo: [EMAIL PROTECTED]Subject: RE: Describe privilege on procedures & packages  all_arguments  

RE: UNIX : script help/input

unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted feed that we send out to our clients ... it is decoded by a chip.   Oh well I am back to array of references ...   Raj -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday

ORACLE CLIENT V816

Hi Does any one know exact URL from where I can download Linux oracle client V8.1.6 ? thx -seema _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broa

Re: OT: SQLServer resources

here u go http://vyaskn.tripod.com From: "Cunningham, Gerald" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: OT: SQLServer resources Date: Thu, 02 Oct 2003 10:09:40 -0800 Hi all, Can anybody point me to a mailing list such as

RE: SQLServer resources

Title: Message I use the sites below when necessary.  You can search Google ("sql server" +list) for mailing lists.   http://www.sqlservercentral.com/ http://www.sqlsecurity.com/ http://www.sql-server-performance.com/   -Original Message-From: Cunningham, Gerald [mailto:[EMAIL

Re: Huge optimization costs with 9.2

Hi Govind, I tested it. no luck. I killed the session. SQL> alter session set sql_trace=true 2 ; Session altered. SQL> alter session set "_UNNEST_SUBQUERY" = FALSE; Session altered. SQL> alter session set "_ORDERED_NESTED_LOOP" = FALSE; Session altered. SQL> alter session set "_ALWAYS_SEMI

RE: SQLServer resources

Title: Message Try this site;   http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english   And pick which listserver you want.  The sql2k is a very good list to use as a resource.   Dave -Original Message-From: Cunningham, Gerald [mail

Steps to convert a RAC to a single instance.

Hello All: We had purchased RAC to provide high availability of datawarehouse to our customers. We later discovered that the way our application is designed, and because database links are not failed over in the RAC environment, we have decided to abondon RAC - atleast temporarily. Could you ple

Re: Sun/Oracle harware sizing tool

Please visit orapub.com, download the 'Ratio Modeling' paper for capacity planning. It's a quick and dirty method for estimating system capacity, be it CPU, RAM, disk, whatever. Keep in mind that 'quick and dirty' is a relative term. In addition, I highly recommend Craig's Capacity Planning cou

Re: Questiuon about unix

Another useless use of cat. Where's Randal Schwartz when you need him. Don Yu <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/02/2003 07:59 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Su

RE: Oracle and nfs mounted devices.

Thank you guys. I was finally able to create the tablespace on the mapped drive. I do realize that placing datafiles on network devices is not the right thing and is not supported by oracle. Thanks again for the help. You are the best! Murali. |-+> |

RE: UNIX : script help/input

Raj, I did consider doing it this way, but the thought of writing stuff to the bit level for a prototype was just too painful. Left pad with zeroes, take a substring, feed it to the handy-dandy hex/oct/bin/dec converter package - much easier. Jared "Jamadagni, Rajendra" <[EMAIL PROTECTE

OT: SQLServer resources

Title: Message Hi all,   Can anybody point me to a mailing list such as this for SQLServer? (I would be suprised if there's something of ORACLE-L's quality, but you never know!). Or, any other resources on the web? I'm particularly interested in production support (performance tuning, secur

Re: Re: Physical I/O and databases other than oracle

i guess my question wasnt clear. What Im getting at is do other databases have wait interfaces? Is there architecture such that Physical I/Os are a serious concern. Far more than other bottlenecks. Or is this book just garbage... > > From: Daniel Fink <[EMAIL PROTECTED]> > Date: 2003/10/02 Thu

Re[2]: Physical I/O and databases other than oracle

Mladen, Thursday, October 2, 2003, 12:39:32 PM, you wrote: M> I do accept your suggestion but I've just received Cary's book M> and I'm enjoying myself very much. I do humbly apologize for any M> confusion. To make is perfectly clear to anyone, BCHR is no longer M> very relevant indicator. My las

Re: Oracle Client for Macintosh

You might try this:  http://www.oracle.com/start/apple/intro.html?src=""> [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]  10/01/2003 08:24 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:

RE: Physical I/O and databases other than oracle

Title: RE: Physical I/O and databases other than oracle So to look good, I should unplug all the CPU boards except one or two to end up with CPU limitation :)   Regards,   Waleed -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 12

ORA-03120

Hi, I have been running DB v8.1.6.0.0 on sun box and applictaion on netra without any error.recently I installed linux client with 8.1.7.0.0 . I have been noticing following error when linux client is trying to connect to DB.I'm assuming its net8 layer problem.let me suggest what to do to fix th

RE: STAT from trace

No little minds at this place, maybe just hobgoblins. Certainly no consistency. I tried again this morning and everything worked. (of course I don't know what has changed behind the scenes:Oracle patches, OS patches???). Jane, stop this crazy thing. Thanks for the suggestions. Next time I'll spool

RE: logg error line in unix

A separated semi-colon sounds like a quarter to me. Unfortunately Oracle docs cost more than a quarter so I would check the free version on-line. The information isn't too tough to digest. Henry -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:35 AM To: Multiple re

Re: Physical I/O and databases other than oracle

I do accept your suggestion but I've just received Cary's book and I'm enjoying myself very much. I do humbly apologize for any confusion. To make is perfectly clear to anyone, BCHR is no longer very relevant indicator. My last sentence ("database with BCHR 99.9% must be OK") was formulated in that

RE: Hiding passwords

That's very interesting... Thank you. Do you know how that can be set in an env variable? Or how the hidden variable can be passed around? Eg C:\ads>set var=set var=more echo is on ??? Thanks Bob >In Windows2000 you can encrypt a file... Not sure how well that would work >though, since if you

Re: AW: UNIX : script help/input

A search on 'cygwin perl dbi oracle' revealed a number of URL's that may be helpful. This one looked promising: http://sources.redhat.com/ml/cygwin/2002-08/msg00923.html Jared Stefan Jahnke <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/02/2003 03:49 AM  Please respond to ORACLE-L  

Re: Oracle and nfs mounted devices.

IIRC, you will also need to change who is the running owner of the oracle process. In WinNT/2k, this defaults to SYSTEM. You need to create an ORACLE user on each system and change the instance owner to ORACLE. Then deal with the normal permissions stuff. There should be a note on metalink on how t

Re: Re: Physical I/O and databases other than oracle

my email states that in oracle this isnt true. HOWEVER, what about other databases? > > From: Mladen Gogala <[EMAIL PROTECTED]> > Date: 2003/10/02 Thu PM 12:34:33 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Physical I/O and databases other than oracle > > On

Re: Physical I/O and databases other than oracle

This is not an issue of answering the question, but pointing out that the question is not correct. Why do databases exist (aside to make Larry money)? To 'permanently' store data. As this storage must survive a system failure, we choose to place the data on a non-volatile medium (disk, paper, s

RE: Oracle Client for Macintosh

Matt, As far as I'm concerned all that a MAC is good for is as a paper weight. And that's pretty bad since I was an Apple fan for many a year. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 02, 2003 12:40 PM To: Multiple recipie

What is the best way to download the Metalink Notes

Hi All, I need to add some Metalink notes to one of my project document. When I copy the text of the metalink note and paste it in a word document the formatting gets messed up. Is there any other way to download this metalink note without messing the formatting. Thanks, Ashoke -- Please see

Re: Physical I/O and databases other than oracle

How about a tongue-in-cheek smiley (>) to indicate that the following advice is offered ironically and is not to be followed. Sort of like the hidden parameter _SET_RUN_FASTER=TRUE. We are always getting new members and they may not be aware of previous threads.

RE: Oracle Client for Macintosh

And actually, at oracleworld there was a huge booth from Apple showing Oracle database, 9iAS, and applications running on Oracle. I've got on my computer here the developer release of 9i for OS X...haven't installed it yet as I'm waiting for my new mac laptop. Thanks, Matt -- Matthew Zito GridA

RE: Oracle and nfs mounted devices.

> > I have been asked to create datafiles (create tablespace) on > disk drives > that are mapped ( internal disk - attached to remote servers) > > When I tried creating tablespace...I get the following error message: > > > ERROR at line 1: > ORA-01119: error in creating database file > 'd:\

Re: Physical I/O and databases other than oracle

On Thu, 2003-10-02 at 11:44, Garry Gillies wrote: > > Im reading an academic book on databases and it states that Physical I/O > Eh? > What IS the primary bottleneck in tuning Oracle? Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job is done. Database with 99.9% BCHR must

RE: Physical I/O and databases other than oracle

Title: RE: Physical I/O and databases other than oracle According to one recently published source*, in a well-tuned database system, the server should be CPU-limited.  The reasoning here is that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. have been eliminated, so

Re: Oracle and nfs mounted devices.

On Thu, 2003-10-02 at 11:44, Murali_Pavuloori/[EMAIL PROTECTED] wrote: > Hello Gurus: > > I have been asked to create datafiles (create tablespace) on disk drives > that are mapped ( internal disk - attached to remote servers) > > When I tried creating tablespace...I get the following error mess

Books on Oracle Workflow????

Title: Mensagem Hi, guys I'm trying to find some good readings in Oracle Workflow. Something like Osborne, Oracle press. Can someone give some hints?? Thanks in advance Regards PG

Re: Oracle and nfs mounted devices.

I think that you need to check the sharing options on the remote computer. Make sure that the user that run the create database has full control on oracle in the remote server. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Th

RE: Oracle and nfs mounted devices.[Scanned]

I am not a guru (as any one here can attest... but The last line tell you what the problem is " O/S-Error: (OS 3) The system cannot find the path specified." Oracle cant find the path, you probably need to pass it something like \\server_name\d$\oracle\oradata\mmstest\test.dbf providing the ora

RE: Questiuon about unix

Cary Millsap <[EMAIL PROTECTED]> wrote : > /;;[^;] That has to be the strangest smiley I've ever seen :) Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED

RE: logg error line in unix

Title: RE: logg error line in unix Log=/log/file/name -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 02, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: logg error line in unix Please give me an example on this.

Re: logg error line in unix

I prefer to tell BAD data to go sit in the corner and think about why it is BAD. After a suitable time, I'll let the BAD data out of the corner and it can rejoin the rest of the data, as long as it agrees to play nice and not upset the other data. Yechiel Adar wrote: > Have you tried to run sqll

Oracle and nfs mounted devices.

Hello Gurus: I have been asked to create datafiles (create tablespace) on disk drives that are mapped ( internal disk - attached to remote servers) When I tried creating tablespace...I get the following error message: ERROR at line 1: ORA-01119: error in creating database file 'd:\oracle\orad

RE: Table not reusing deleted space

What is the block size of the database. Also, is the AVG_ROW_LEN of almost 5000 bytes evenly distributed, i.e. are ALL rows more or less 5000 bytes long, or are there many rows that are a lot smaller and then some that are really big? At 11:49 PM 10/1/2003, you wrote: Here are the stats if you'

Re: Physical I/O and databases other than oracle

> Im reading an academic book on databases and it states that Physical I/O is often the > primary bottleneck in tuning. Its not the case in Oracle. Is this statement correct > with sybase, sql server, or DB2? or maybe mysql? Eh? What IS the primary bottleneck in tuning Oracle? I go along with J

Re: logg error line in unix

Have you tried to run sqlldr with BAD data? Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 02, 2003 4:44 PM > > Please give me an example on this. > > > Roland > > > > > > > Jack van Za

RE: logg error line in unix

Sqlldr help=y from the command line. or D:\oracle\ora92\rdbms\demo Lookup the ulcase*.ctl files jack -Original Message- Sent: Thursday, October 02, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Please give me an example on this. Roland Jack van

RE: Sql query : select max timestamp value from table

Title: Message select ip, max(timestamp) from table group by ip; -Original Message-From: Johan Muller [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: Sql query : select max timestamp value from table I

Trace File cursor waits

I have a logon trigger set up for a user. In examining the trace file, I see the expected logon pl/sql action at the beginning along with the normal NLS parm set ups. The next action is a select with the usual parse/bind/exec/wait/fetch/wait/stat emissions. After the stat for Cursor #1, there are 2

RE: Oracle Client for Macintosh

Erm, that's the Motorola 68K CPUs. They are as dead as my beloved Amiga (well almost: http://www.freiburg.linux.de/~uae/). As far as Gx Apples, I've been trying OTN, but all I get is "Error: Timeout occurred while retrieving page meta data." Rich Rich Jesse System/D

RE: Sql query : select max timestamp value from table

Johann,   Take the timestamp out of your group by.   Cheers, Melanie   *** Melanie Caffrey Proximo Consulting Services, Inc. [EMAIL PROTECTED] (212) 686-6004 Ext. 32 -Original Message- From: [EMAIL PROTE

RE: Sql query : select max timestamp value from table

Title: RE: Sql query : select max timestamp value from table   select ip, max(timestamp) from table   group by ip; Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:   Johan Muller [SMTP:[EMAIL PROTECTED] I have

RE: Sql query : select max timestamp value from table

select ip, max(timestamp) from table group by ip; -Original Message-From: Johan Muller [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: Sql query : select max timestamp value from table I have multiple times

Re: Questiuon about unix

Try this as following: cat yourfile | awk -F; ' ( $4 == "") { print $0 }' # $4 means your field number from beginning; $0 means whole line. Good luck! Don [EMAIL PROTECTED] wrote: > Hallo everybody, > > anyone whom can tell me what the command is to search for an empty field in a unix >

Re: Sql query : select max timestamp value from table

Johan, First, you don't need the distinct. The proper query will return 1 row per ip. Second, take the max(timestamp) out of the group by. That is causing the problem. Daniel Johan Muller wrote: > I have multiple timestamps values for single ip in a table, I > need the max(timestamp) for eac

RE: Oracle Client for Macintosh

MAC's are DEAD from Oracle's point of view.  See  Note:61797.1   Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003 11:24 PMTo: Multiple recipients of list ORACLE-LSu

Oracle 9i Rac scripts

Hi All Since I'm new to 9iRAC (as are a lot of people I guess) I need some help. I'm working my way through the (tuning) docs and have compiled this set of sql's for monitoring the Cluster. Could the people that have experience with the 9i RAC cluster look at it and tell me what is missing or what

  1   2   >