RE: Oracle Monitoring Tools

2001-03-14 Thread Trassens, Christian
Take a look of Precise and also Instance Monitor of Quest. If it helps you, I have several problems with Patrol. Regards. -Mensaje original- De: Zhong Hong [SMTP:[EMAIL PROTECTED]] Enviado el: martes 13 de marzo de 2001 20:17 Para: Multiple recipients of list ORACLE-L Asunto:

RE: change unix user when running external procedure

2001-03-14 Thread John Dunn
Dick...thanks...I''ll give it a go. I have a similar problem with utl_file command in PL/SQL accessing a file that is read only for another user. I can't see any way of accessing that...can you? John -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday,

Re: Oracle JDBC driver

2001-03-14 Thread Marin Dimitrov
- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 00:06 does anyone can tell me where to install Oracle JDBC driver? I looked up oracle web site, but they just let me download the zip file and instruct how to set the

RE: change unix user when running external procedure

2001-03-14 Thread John Dunn
DickI tried this but it didn't work... When I write a file using my shared libary the ownership is still oracle, not john -rwsrwxrwx 1 john john myClib.so -rw-rw-r-- 1 oracle dba testfile John -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]

Question about PL/SQL

2001-03-14 Thread Roland . Skoldblom
Hallo, all you experts Does anyone have any good example of procedure, that does a select statement from the database and afterwards automatically save this resultat to an excel file.? Sincerely Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Sonja ehovi
List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official

RE: Major upgrade

2001-03-14 Thread Mark Leith
How about DBA 101, co written by a prominent "goddess" member of the list:) -Original Message- Setiawan Sent: Wednesday, March 14, 2001 01:31 To: Multiple recipients of list ORACLE-L Hi , you can try http://oradoc.photo.net , offcourse the comprehensive one is www.oracle.com HTH,

Re: Tables and indexes on different disks

2001-03-14 Thread Michal Zaschke
Thank you all for your responses. I'll be more thoughtful for then next time. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Oracle installation

2001-03-14 Thread sinardyxing
Hi, Anyone tried install Oracle8i in Solaris with 128 Mbyte of memory ? Is a stand alone server Oracle 8.1.6, not a production, is not hang but more than 1 day to finish create a database ??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]

Re: Oracle Error!!!Help

2001-03-14 Thread Michal Zaschke
!oerr ora 6512 06512, 0, "na %sline %s" // *Cause: Backtrace message as the stack is unwound by unhandled // exceptions. // *Action: Fix the problem causing the exception or write an exception // handler for this condition. Or you may need to contact your //

RE: OEM day today?

2001-03-14 Thread Boivin, Patrice J
It just monitors Up/Down, I think. Sometimes it doesn't work very well, my SQL Server has been down for two days (I don't use it) and the green flag is still up inside the OEM. I have problems with my test server though, jre.exe is hogging the system. Do you know if the OEM can monitor MS

RE: oracle and America

2001-03-14 Thread Boivin, Patrice J
The whole c2 security thing and the POSIX compliance for NT were so they could sell their OS to the government, wasn't it? I think they may have dropped POSIX from Windows2000, I don't know if it ever worked very well. They did the same thing when OS/2 seemed a plausible alternative, NT

RE: jre.exe using up too much CPU

2001-03-14 Thread Boivin, Patrice J
I have 654M of RAM. I logged a TAR with Oracle, we'll see how it goes today. I will just monitor db up/down, listener up/down, host up/down for now, all it takes is one bad item to mess up a server. Thanks Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations |

Order of table_name resolution

2001-03-14 Thread Cale, Rick T (Richard)
Hi DBAs, Can someone clarify/confirm on how Oracle determines what table to use in select statement? For ex. If I am login as Scott and do the following: SELECT * FROM employee; Of course Oracle will use Scott.employee if it exist. If it does not exist but exist under another schema. Does

RE: Order of table_name resolution

2001-03-14 Thread Kevin Kostyszyn
I am not positive, but I think that is the correct order. This had been discussed before and ofcourse, with my limited brain capacity I can't remember. Kev -Original Message- T (Richard) Sent: Wednesday, March 14, 2001 8:00 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Can

RE: AW: Script for reversing a string?

2001-03-14 Thread Adams, Matthew (GEA, 088130)
Title: RE: AW: Script for reversing a string? Jack, According to the article, Oracle has not documented it anywhere. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user friendly. It's just particular about who it makes friends with.

Re: Order of table_name resolution

2001-03-14 Thread Richard T. Vander Laan
Rick, I am looking for an Oracle DBA for our office in Des Moines, IA. Do you know of anyone that might be interested. Also, have Oracle Financial and CRM positions open in Fall Church VA. Let me know if you know of someone. Thank you in advance. Dick Vander Laan - Original Message -

Re: ORA-24371

2001-03-14 Thread Tim Sawmiller
oerr ora 24371 24371, 0, "data would not fit in current prefetch buffer" // *Cause: An internal OCI error has occurred. // *Action: Please contact Oracle customer support. [EMAIL PROTECTED] 03/13/01 05:15PM Hi Gang, One of the developers came to me with this error. There is nothing in

RE: Oracle Internals

2001-03-14 Thread Mohan, Ross
Title: RE: Oracle Internals HP, it is sleep/wake/check. it is up to the process to acquire the resource. AFAIK, there is no message-passing type of algorithm to tell waiting (whether spinning or sleeping) processes when the semaphore becomes unset ( ie the resource is available ) Sleeps are

DBA job market in Australia and Asia?

2001-03-14 Thread dana
What's the job market like for Oracle DBAs in Australia (Queensland and NSW)? Is demand being satisfied mostly with local talent? I've heard that's the case for much of the IT market there. Would it be difficult for an American Oracle DBA to secure a work visa in Australia or Asia? Any demand

Re: to insert into blob

2001-03-14 Thread chaoping
hi, gurus: i read the article of early time e and tried my self, hoping to insert a bin file into a lob column of the database.but failed. my env: win2000 prof+oracle817. SQL desc lobtable Name Null?Type

Inteligent Agent on Oracle817 for OS/390 OSDI

2001-03-14 Thread Sonja ehovi
List hi! My colleuge have problem with this configuration Does anyone have a cook book for configuring this product? If anyone have it, would you be so kind to send it directly to: [EMAIL PROTECTED] TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: new in Developer 2000

2001-03-14 Thread Dasko, Dan
Since you are using above 8.0.4, you can have multiple homes, so put it wherever you want. Dan -Original Message- Sent: Tuesday, March 13, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Dear Listers, I plan to install Oracle Developer 2000 on my NT which Oracle Database

RE: Order of table_name resolution

2001-03-14 Thread Carle, William T (Bill), NLCIO
I don't think you can have a synonym that conflicts with a name in your own schema. For example, if scott has an employee table and you try "create synonym employee for mary.employee;", Oracle will give you an error "name is already used by an existing object." Bill Carle ATT Database

RE: OEM day today?

2001-03-14 Thread Gary Weber
Event-wise, yes, only UpDown is available out of the box. However, it lets one see inside of the windows server AND inside of SQL db (buffers/logs/hits/etc.). Far as Access and Expell, for the right price I could prolly right few tcl scripts to manage those as well :) Gary Weber -Original

Re: jre.exe using up too much CPU

2001-03-14 Thread Richard T. Vander Laan
Patrice, my company is looking for an Oracle DBA with Discoverer and Express experience for our office in Des Moines, IA as well as Oracle Financial developer with experience in the latest Oracle version for our Fall Church VA office. If you know of someone, please let me know ASAP. Thank you in

Re: ORA-24371

2001-03-14 Thread Rocky Welch
Thanks, Tim. I checked the message and saw the same as you sent. I'm just wondering if anyone has seen this before. The front end app is accessing the data using java. Is it possible that and init.ora parameter is not set correctly? --- Tim Sawmiller [EMAIL PROTECTED] wrote: oerr ora 24371

RE: Large DB Size? Manage datafiles?

2001-03-14 Thread Joseph Testa
Well(a cohort of mine on this list and) I worked with a 3terabyte(3000 gig) db before the project was dunked. It was interesting to say the least playing with that much data. it was to be an ODS and i played the dba role and the other guy(you know who you are) played the developer role, he

RE: Oracle Internals

2001-03-14 Thread Mohan, Ross
Title: RE: Oracle Internals make that "V$LATCH" to find the SLEEP1-11 columns -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 14, 2001 9:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Internals HP, it is

RE: Oracle installation

2001-03-14 Thread Yexley Robert D SSgt AFIT/SCA
Yeah I can see that absolutely. I just completed migrating a test database that we are testing for migration from 7.3.4 to 8.1.6. The reason I migrated it was because it had originally been on an UltraSparc 1 that had 192 MB of RAM and the thing would hardly run on that hardware. We ended up

STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread dana
Will statspack ever be available, in a supported version, for Oracle 8.0.X? We'll be upgrading the machine I'm concerned about to 8.1.X eventually (next six months or so); But for now, I'd like to have access to a more sophisticated tuning-data gathering tool than bstat/estat. I find it

RE: Oracle JDBC driver

2001-03-14 Thread Dasko, Dan
Ohhh, I think I remember having to set the classpath to also point to the JRE rt.jar and I think you have to point to the actual file. Sorry I can't be more help, it's been a few months. Dan -Original Message- Sent: Tuesday, March 13, 2001 10:10 PM To: Multiple recipients of list

RE: Question about PL/SQL

2001-03-14 Thread Dasko, Dan
Select col1||'|'|| col2||'|'|| col3 From table Where condition set heading off set pause off set pages 1000 spool result.lst Easiest way I know. Then when you bring it into Excel, it's a delimited file with the | as a delimiter. Dan -Original

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Dasko, Dan
I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on

RE: Reports with Lexical Paramters

2001-03-14 Thread Dasko, Dan
Using lexical parameter in Developer Reports. Enter the query like this. Select emp_name From employee Where emp_salary 100 lx_param Then the Report Builder will create a user parameter lx_param. Next create a before form trigger and set the code something like this. IF :dept =

LONG: Re: Order of table_name resolution

2001-03-14 Thread Joseph Testa
An object name takes the following form: [schema.]name[@database] Some examples include: Emp_tab Scott.Emp_tab Scott.Emp_tab@Personnel A session is established when a user logs onto a database. Object names are resolved relative to the current user session. The username of the current

Off topic, humour, flagrant breach of the rules

2001-03-14 Thread Dave Morgan
This should make it through GE's filters but .. I think they have it backwards though. Shouldn't it be "something to protect the software from Matt" rather than "software to protect Matt from something" My apologies Jared, but it's only one rule. I usually break them 4 or 5 at a time.

RE: Oracle JDBC driver

2001-03-14 Thread Dasko, Dan
Remember, Oracle is very particular about which driver and which JDK. If you have those correct, then it usually installs in $ORACLE_HOME/jdbc in NT. For Unix, I don't have any idea. Dan -Original Message- Sent: Tuesday, March 13, 2001 5:07 PM To: Multiple recipients of list ORACLE-L

RE: 8.1.7

2001-03-14 Thread jkstill
It seems like you should just be able to modify your CLASSPATH and PATH to deal with this problem. Jared On Tue, 13 Mar 2001, Kevin Kostyszyn wrote: RE: 8.1.7Check this out, this is a known bug with Pentium 4 processors and Netware. However, after tredging through Metaslink I found

RE: 8.1.7

2001-03-14 Thread Kevin Kostyszyn
Well yeah, I could have attempted to do that. But what would I have done, just remove the java_home, or remove any evidence in the path? I found it to be simpler to just uninstall the java then reinstall it when oracle was completed. kev -Original Message- [EMAIL PROTECTED] Sent:

RE: ORA-24371

2001-03-14 Thread Kimberly Smith
heas03@ehdb:../oracle$ oerr ora 24371 24371, 0, "data would not fit in current prefetch buffer" // *Cause: An internal OCI error has occurred. // *Action: Please contact Oracle customer support. -Original Message- Sent: Tuesday, March 13, 2001 2:15 PM To: Multiple recipients of list

RE: Oracle installation

2001-03-14 Thread Jesse, Rich
Remember that if you use Oracle Migrate from 7.x to 8.x, instead of export/import, you will get an icky performance hit the first time your data is hit. This is when the block-level changes will take place. So, after your migration is "complete", you will probably want to do FTSs on all tables

RE: EE on NT problem (on and off network) ???

2001-03-14 Thread Bala, Prakash
You might also need to comment out NAMES.DEFAULT_DOMAIN if any. This sets the domain name. HTH Prakash -Original Message- Sent: Tuesday, March 13, 2001 11:20 PM To: Multiple recipients of list ORACLE-L better is to set it to none sqlnet_authentication_services=(none) in sqlnet.ora

RE: AW: Script for reversing a string?

2001-03-14 Thread jkstill
My apologies for the RTFM. I guess it isn't documented, even though it has been around for several years. Jared On Tue, 13 Mar 2001, Jack C. Applewhite wrote: Jared, Well, I've RTFM for 8.1.6 and the SQL Reference doesn't mention a Reverse() function. However, there is a supplied

Re: HELP ,Oracle error.

2001-03-14 Thread jkstill
There should be another error message with this. What other messages do you see? Jared On Tue, 13 Mar 2001, Dash, Saroj (CAP,CEF) wrote: Hello All, I got an Oracle error ORA-6512. I am unable to understand this problem. No PL/SQL error . Please help me. Saroj. -- Please see the

RE: Oracle Internals

2001-03-14 Thread Henry Poras
RM, Thanks. Intuitively that seems like the way it should work. However it appears to contradict what Steve wrote in his book about a sleeping process waiting on its semaphore. I wonder if this is just a publishing error, or if I am missing something in my understanding. I usually find it a good

RE: oracle and America

2001-03-14 Thread Kimberly Smith
The sad part is the Canadian government feels compelled to follow the Americans are replacing some of their apps that ran on Unix to Windows. Actually, the app is an American one that they let us use. A lot of critical stuff is still on Unix. Then again, ours ships really don't need reliable

Note on comp.databases.oracle.server

2001-03-14 Thread Henry Poras
Just saw this note posted this morning for all that are interested. Subject: Goodbye to all that Date: Mon, 5 Mar 2001 22:20:02 +1100 From: "Howard J. Rogers" [EMAIL PROTECTED] Organization: CWO Customer - reports relating

RE: STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread Browett, Darren
Try http://www.oracle.com/oramag/oracle/00-Mar/statspack-other.html It outlines the steps to install adn run statspack within 8.0.x. I haven't run it myself as of yet, but it looks straight forward. -Original Message- Sent: March 14, 2001 6:31 AM To: Multiple recipients of list

RE: Resouce Allocation

2001-03-14 Thread Bala, Prakash
Check user_tables.avg_row_len -Original Message- Sent: Tuesday, February 13, 2001 6:35 AM To: Multiple recipients of list ORACLE-L but i did'nt find any bytes column in user_tables analyzed table in compute mode.. - Original Message - To: Multiple recipients of list ORACLE-L

Re: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Shankar Shanmugaswamy
Hi, Eventhough you have given the path as * in initora Make sure that the path where you are creating the file is access to the Unix User , who is running the script The unix user should have the access Read , Write and Execute But the User thur which Oracle is Installed will be able to run

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Gogala, Mladen
You're supposed to set the parameter to a directoryname, not an asterisk. Setting the parameter to something like /oracle/base/8.1.7/work and setting the protection of the directory to 0644 (files are written by the oracle server processes) should help. -Original Message-

RE: 3/14/01 - ORA-01653: unable to extend table ... by 2572 in t

2001-03-14 Thread Gorden-Ozgul, Patricia E
In answer to my own question, I did the following: ALTER TABLESPACE COALESCE; ALTER TABLESPACE ADD '' 100M; ...worked like a charm. __ Pat Gorden-Ozgul BNL-ISD Systems [EMAIL PROTECTED] 631-344-5159

RE: Major upgrade

2001-03-14 Thread Streeter, Lerone A LBX
thanks. crash course, must have, aggressive deadline situation. nothing unusual for me, similar pains rolling out and learning NT, Exchange, MS-SQL, RPG, VB, etc... (see a pattern?) i've toyed w/ the downloaded oracle 8.1.7 personal just to get some inceptionary idea of what it takes and how

RE: Order of table_name resolution

2001-03-14 Thread Rachel Carmichael
that's the right order From: "Kevin Kostyszyn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Order of table_name resolution Date: Wed, 14 Mar 2001 06:05:56 -0800 I am not positive, but I think that is the correct order.

RE: LONG: Re: Order of table_name resolution

2001-03-14 Thread Jacques Kilchoer
Title: RE: LONG: Re: Order of table_name resolution -Original Message- From: Joseph Testa [mailto:[EMAIL PROTECTED]] Due to the possibility of synonyms, the following rules are used to resolve a name in a context that requires an object in the table namespace: etc... That

RE: Advanced Korn Question

2001-03-14 Thread jkstill
On Tue, 13 Mar 2001, hp wrote: can you tell mne what the difference is between: $log 21 and 21 $log if tried both ways and the std err and std out go to the log both ways. Probably not, unless you have some strange variant of ksh. When you redirect STDOUT with " $log", STDOUT is

Re: STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread Ruth Gramolini
They are available, at a price, for OEM 1.6x. However, you can monitor an 8.0.x database with OEM2.x by using a small database in 8.1.7 for the OEM repository. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 9:31 AM

Re: Oracle JDBC driver

2001-03-14 Thread jkstill
Take a look at the JDBC manual, it's on the doc CD. Just adding d:\jdbc\lib to your classpath isn't good enough. The needed classes are not in a jar file, they are in a zip file. Include d:\jdbc\lib\classes12.zip in your CLASSPATH. Jared On Tue, 13 Mar 2001, mai huynh wrote: when I unzip

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Gogala, Mladen
Of course, with 8.1.7 you can implement your own UTL_FILE package, using external calls to C routines. -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=*

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Anderson, Brian
I believe * is valid (though I can't find the page in a book right now), though it could be dangerous, utl_file writes as oracle, make sure some duhveloper doesn't overwrite/append to your datafiles. Look at the UTL_FILE.FOPEN commands and verify the paths. lv_log_file:=

How do I migrate 7.3.4 database that supports Des/2000?

2001-03-14 Thread Cherie_Machler
I am migrating a 7.3.4 database to 8.1.5 on Sun Solaris 2.6. This database holds the repository for Des/2000. We do not want to upgrade Des/2000. I basically just want to migrate the underlying database. Can I do this? I've read through all of the documentation for Des/2000 but it all

Re: Order of table_name resolution

2001-03-14 Thread jkstill
Here's more than you wanted to know about name resolution: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/d_names.htm#3693 Jared On Wed, 14 Mar 2001, Cale, Rick T (Richard) wrote: Hi DBAs, Can someone clarify/confirm on how Oracle determines what

failover problem

2001-03-14 Thread Vulpe Cristian
Hi! I am working on an application that has many concurrent users and I would like to configure a background failover server. I am asking you if I can do that and where should I read some documentation about this... Best regards, Vulpe Cristian -- Please see the official ORACLE-L FAQ:

Informix training question

2001-03-14 Thread Gene Sais
In addition to unix admin oracle dba duties, I am now tasked with an informix db. Not that I mind, with oracle's pricing, it may become the db of choice :). Any recommendations on which informix dba course to take to get up to speed for a seasoned sys admin/oracle dba? -- Please see the

RE: Off topic, humour, flagrant breach of the rules

2001-03-14 Thread Steve Orr
Hey Dave, GREAT STUFF!! It was nice having you in the Silicon Valley neighborhood. Please don't forget that classic, "Do You Know the Way to San Jose?" :) Just had some "stout" medicine (oatmeal stout that is) at the Rock Bottom Cafe this weekend so when you're ever back in the neighborhood

RE: Off topic, humour, flagrant breach of the rules

2001-03-14 Thread Mohan, Ross
Title: RE: Off topic, humour, flagrant breach of the rules LoLDave, it was AEROSMITH who did Walk This Way !! -Original Message- From: Dave Morgan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject: Off topic,

3/14/01 - ORA-01653: unable to extend table ... by 2572 in table

2001-03-14 Thread Gorden-Ozgul, Patricia E
I've been inserting tens of thousands of records into a database. I've hit the above error message and am looking to you folks for advice about what I should do. Is this where I need to add another data file to the tablespace or what? ...and how? Thanks in advance. Pat

RE: Enterprise Manager

2001-03-14 Thread John Hindmarsh
Any thoughts? This is version 2.2. Development license per download from ORacle. -Original Message- Hindmarsh Sent: Tuesday, March 13, 2001 10:46 AM To: Multiple recipients of list ORACLE-L I downloaded EM. Trying to install in Windows 2000 environment. THe first screen starts up

RE: Script for reversing a string?

2001-03-14 Thread Miller, Jay
Hi Kirti, Huh. This function isn't even mentioned in Koch's Oracle8 The "Complete" Reference (I just double checked because I couldn't believe I'd miss something like that. Thanks! Jay -Original Message- Sent: Monday, March 12, 2001 6:40 PM To: Multiple recipients of list ORACLE-L

A question about upgrading Oracle Applications

2001-03-14 Thread William Beilstein
I am asking in this format because I want the opinion of the DBA who did the work. We are currently using Oracle Applications 10.7SC (Smart Client) with the project module and are looking to go to Oracle Applications 11i. I am looking for any opinions on the ease or headaches of performing an

SQL*Loader - error writing to bad file

2001-03-14 Thread Michelle Buyer
Hi, I am using Oracle 8.0.4 on Solaris 2.6. Trying to load data from a text file to a table using SQL*Loader. Receiving the following error during the load: SQL*Loader-523: error-2 writing to file (/mnt/voyager/ccuser/ccuser.bad) The load.shl file contains bad file parameter:

RE: Informix training question

2001-03-14 Thread Carle, William T (Bill), NLCIO
Gene, You would want to take their Online Dynamic Server Administration course or whatever they are calling it now. I do both Informix and Oracle so if you have any questions, let me know. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message-

Connecting from VAX/VMS to Remote Oracle Data Base

2001-03-14 Thread Tim Sawmiller
My client is trying to connect from an RDB database on a VAX/VMS machine to an Oracle database on an HP machine. Can this be done? How? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Gupta/centura SQLBASE

2001-03-14 Thread Malkuns, Skip
We have to convert data from an old sqlbase database into Oracle. Does anyone know if SQLBASE has views or system tables like Oracle does for getting a listing of table names, columns and column types/lengths like dba_tables, dba_views, all_tables that Oracle has? I've had no luck searching the

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Guidry, Chris
Hello, Yes you can use an asterisk which means any directory path is available for using UTL_FILE (at least in 7.3). Oracle recommends you do not do this due to security concerns. You must refer to the server directory structure not to mapped drives and you must have the proper permission to

Re: Oracle JDBC driver

2001-03-14 Thread mai huynh
Here is the code: DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection ("jdbc:oracle:oci8:@myserver", "admin", "admin"); This failed when call DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Now after

RE: oracle and America

2001-03-14 Thread Kimberly Smith
We don't want to be powerful though. Actually, I am half kidding there. I do believe that Canada can stand on its own if need be. I believe they proved it in the last war we participated in. Its that we normally choose not to join in war. We do support the USA when ever asked (as it is

Re: Oracle JDBC driver

2001-03-14 Thread jkstill
You will need to set your PATH to include the location of the required DLL's. Jared On Wed, 14 Mar 2001, mai huynh wrote: I set the classpath point to the zip file. Now, in java file, when run the following line, I get the error: the dynamic link library ORA805.dll could not be found in

Re: 3/14/01 - ORA-01653: unable to extend table ... by 2572 in table

2001-03-14 Thread Ruth Gramolini
You could either resize the existing datafile(s) or create a new datafile. To resize: alter database datafile '/full_path/datafile_name.dbf' resize M; To create another datafile: alter tablespace TBSP_NAME add datafile '/full_path/datafile_name.dbf' size M. HTH, Ruth - Original

RE: oracle and America

2001-03-14 Thread Raghu Kota
I agree with Kimberly, I don't why Canada simply following US?? I think Canada has every capacity to emerge as powerful nation. Simply following with out any backbone creates lot of problems in economy and society too. From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

RE: oracle and America

2001-03-14 Thread Jacques Kilchoer
Title: RE: oracle and America -Original Message- From: Raghu Kota [mailto:[EMAIL PROTECTED]] Sent: mercredi, 14. mars 2001 10:36 I agree with Kimberly, I don't why Canada simply following US?? I think Canada has every capacity to emerge as powerful nation. Simply following

RE: Oracle JDBC driver

2001-03-14 Thread Dasko, Dan
Which version JDK are you using? I only got the thin driver working. Try getting the thin driver working. Dan -Original Message- Sent: Wednesday, March 14, 2001 3:02 PM To: Multiple recipients of list ORACLE-L Here is the code: DriverManager.registerDriver(new

RE: STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread Leonardo Fernandez
Hi, As shipment my file report.txt, generated with statspack to www.oraperf.com? That steps should carry out ? Thanks, Leonard F. "Browett, Darren" [EMAIL PROTECTED]@fatcity.com on 14/03/2001 11:36:21 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple

RE: Oracle JDBC driver

2001-03-14 Thread Richard Ji
Try to include d:\jdbc\lib in your PATH as well. Are you using the thin driver or OCI driver? -Original Message- Sent: Wednesday, March 14, 2001 2:56 PM To: Multiple recipients of list ORACLE-L I think my question is not clear. I have Oracle database on another machine. My machine

Locally Managed Tablespace Uniform Extent

2001-03-14 Thread Jim Walski
I have to move a 7.3.4 database to 8i and I want to use the uniform extent size to reduce fragmentation. I read the article "stop defragmenting and start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M. I also read an article on Steve Adams site that indicates to keep the

RE: failover problem

2001-03-14 Thread Brian D. Silverio
This is very hardware vendor specific and rather complex. Start by asking your your hardware vendor or visiting their web site. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vulpe Cristian Sent: Wednesday, March 14, 2001 12:11 PM To: Multiple

RE: Gupta/centura SQLBASE

2001-03-14 Thread eric harrington
Hi Skip, SQLBase does have similar views. I only remember a few (I think these are correct): SYSTABLES, SYSCOLUMNS, SYSPKCONSTRAINTS, SYSFKCONSTRAINTS etc. They are listed in the back of the Administrator's guide. Hopefully you can get your hands on the hardcopy or electronic copy. I do not

RE: Informix training question

2001-03-14 Thread Steve Cawley
Informix offers a DBA course for Oracle DBA's: http://www.informix.com/informix/training/courses/educat/descrpt/level1/crsL 1-760.htm -Original Message- Sent: Wednesday, March 14, 2001 1:22 PM To: Multiple recipients of list ORACLE-L In addition to unix admin oracle dba duties, I am

RE: Oracle JDBC driver

2001-03-14 Thread Val_Gamerman/Victoria_Financial . VICTORIA_FINANCIAL
Mai, This is exactly what I was talking about when I said that you need to make sure sure that you use thin drivers. If you get an error message complaining about a missing DLL then your java program is using JDBC-OCI drivers or JDBC-ODBC drivers. Get documentation and samples for using the

RE: oracle and America

2001-03-14 Thread Kevin Kostyszyn
Yeah, but there's still some good things about Canada. They have free health care, schools are free and they invented hockey!! Besides, I wouldn't exactly say that Canada is following the us as much as they are Europe, they are more of a European type nation. They just follow us a little bit

RE: OT -- Canada and U.S. (was: oracle and America)

2001-03-14 Thread John Lewis
Bravo! Canada is wonderful place!!! What a boring little planet this would be if we all thought the same way. God save us from 'one size fits all'. As a Northwesterner, I find myself having more in common with Canada, esp. British Columbia, than those "bubba's" in Washington, DC. john f.

RE: Oracle Internals

2001-03-14 Thread Mohan, Ross
Title: RE: Oracle Internals Henry, You are welcome. I have not read Steve's book, so can't comment on the prose there, but..coupla points: 0) Semaphores usually (but not always!) protect binary resources... things requiring mutual exclusion (one at a time) or which have producer/consumer

RE: Order of table_name resolution

2001-03-14 Thread Kevin Kostyszyn
whoo hooo -Original Message- Carmichael Sent: Wednesday, March 14, 2001 12:30 PM To: Multiple recipients of list ORACLE-L that's the right order From: "Kevin Kostyszyn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

RE: OT -- Canada and U.S. (was: oracle and America)

2001-03-14 Thread Jack C. Applewhite
Yes, and even a die-hard Texan like me much prefers sentences followed by "Eh?" to the obnoxious U.S.ism "ya know?". Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED]

RE: Locally Managed Tablespace Uniform Extent

2001-03-14 Thread Jack C. Applewhite
Jim, I'm probably a bit extreme here, but, with all due respect to Steve Adams (because I really do), I wouldn't worry terribly much about numbers of extents. Our 8.1.6 production db on Win2k has 8KB block size and uniform extent size of 1MB in all tablespaces. Our largest segment stores the

RE: Script for reversing a string?

2001-03-14 Thread Deshpande, Kirti
Hi Jay.. No, you did not miss it. It's been an undocmented little nice feature..and I believe it still is undocumented as far as Oracle Docs go. Cheers ! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Miller, Jay

OT -- Canada and U.S. (was: oracle and America)

2001-03-14 Thread Boivin, Patrice J
Well, that's a bit of a flame, also coming from an anonymous Hotmail account I see. (Hotmail is always anonymous, although I believe the accounts can be traced) When I lived in Ottawa I used to know someone from Spain who talked about Canadians not being aggressive enough, people should fight

RE: Oracle JDBC driver

2001-03-14 Thread mai huynh
I think my question is not clear. I have Oracle database on another machine. My machine doesn't have Oracle on it. I just want to install Oracle JDBC driver for my java program to connect to database. I down load the JDBC driver on Oracle website. It's just a zip file, contains

Re: LONG: Re: Order of table_name resolution

2001-03-14 Thread Joseph S. Testa
My apologies to all by NOT denoting i ripped that entire piece out of the 817 docs. apps devleoper guide, chapter 2, schema maintenance. joe Jacques Kilchoer wrote: -Original Message- From: Joseph Testa [mailto:[EMAIL PROTECTED]] Due to the possibility of synonyms, the

  1   2   >