Re: What is Oracle made from ?

Hmm, I thought that powerpoint was the development environment for microsoft products ;-) Anjo. Abdul Aleem wrote: I don't think so, I think they just don't know Aleem -Original Message- Sent: Thursday, April 18, 2002 7:53 AM To: Multiple recipients of list ORACLE-L

Import excelfile into Oracle table

Hallo, anyone who can give me a good example of pl/sql code, which does the folllowing: Import an excelfile into a table. (I know I can use sqlloader(which I have used several times) but i would like to make a call to that pl/sql procedure from MsAccess. Thanks in advance Roland --

Re: Script for identifying objects having freelists contention

SELECT s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.state FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND s.header_block=w.p2; Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km

RE: Upgrade 8.0.5 to 8.1.7.3

Call me paranoid. I'll go for the two phase upgrade (when it's time and all tests are completed) and make end-user suffer a little more down-time (bye bye weekend) We upgraded our peoplesoft test environment already and that is being tested, sofar w/o problems Besides I've heard that there

Installing Tora on RH 6.2

Hi Gurus I have downloaded .rpm file o Tora ..the tool used to access Oracle on Linux. I want to install it on my linux box where I have oracle 8i (8.1.6) I have connected to the root user and gave following command and got the error below # rpm -ivh tora-1.2.2-1gc-glibc21.i686.rpm error:

RE: Accessing Synonym

you have to grant that user rights on that specific table grant select on inventory.table to user; -Oorspronkelijk bericht- Van: Abdul Aleem [SMTP:[EMAIL PROTECTED]] Verzonden:donderdag 18 april 2002 8:18 Aan: Multiple recipients of list ORACLE-L Onderwerp:Accessing

Re: MySQL vs. Oracle database

I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where

DBMS_SHARED_POOL.KEEP

I want to pin most run packages , I have loeded them into a table. For this I have written , create or replace procedure pin_packages_defined assql_sentence varchar2(200);cursor_name INTEGER;rows_processed INTEGER;CURSOR tab_cur IS SELECT owner,object_name FROM

Re: MySQL vs. Oracle database

By default MySQL has no transactions You have to add special component to access transactional safe tables called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and

Re:Import excelfile into Oracle table

Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH

Ang: Re:Import excelfile into Oracle table

Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia:

Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)

There appear to be a number of contradictory items in your posting; presumably due to the passage of time and the number of variations and experiments that have take place. You seem to indicate that a simple select on a single table using an IN list takes 2 seconds to complete, but the time

Re: What is Oracle made from ?

I always wondered who got the shaft, I had assumed it was customers. On 17 Apr 2002 at 9:23, Jan Pruner wrote: No, it is of the most gentle substrate of the shaft of moon light. [EMAIL PROTECTED] wrote: I believe its C++ now but it was C. -- Please see the official ORACLE-L FAQ:

Re: Archiving Data Strategies.

Council on Library and Information Resources http://www.clir.org/home.html - http://www.clir.org/pubs/issues/issues25.html#plan - -- http://www.clir.org/pubs/reports/rothenberg/contents.html Avoiding Technological Quicksand: Finding a Viable Technical Foundation for Digital

Re:Re:Import excelfile into Oracle table

Here is an example. As far as I know, utl_file package reads data from unix box. So the file path below should be on Unix and be careful about your rights writing or reading from this path. DECLARE outfile_handle UTL_FILE.FILE_TYPE; v_test VARCHAR2(1000) ; BEGIN outfile_handle :=

Re: PK field - number of char

Brian, Your figures for the number of bytest are incorrect. A 38 digit number (max Oracle can handle) takes approximately 20 bytes, a 38 character varchar2 takes 39 bytes. To answer the original question: The only difference would be in converting the external format of the data (e.g. a

Re: Security Hole

For those of you with Metalink access, there is now a patch to this bug for 9.0.1.3 Patch number is 2121935. Platforms covered are: HP 9000 series HP-UX 64-bit Sun Sparc Solaris 64-bit IBM RS/6000 64-bit Sun Sparc Solaris Digital Alpha OpenVMS LINUX Intel Compaq

RE: datafile sizing ?

Darren, It also depends on the extent sizes you use for the tables in the tablespace. Will each extent completely use the datafile or will there be wasted space in the smaller datafiles. As an example: if there is 100 M free space and the extent is 150 M it will not fit in the datafile and will

Re: RAC

Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and

RE: data cleansing question

Lisam I also would check with the end-users of the data. Marc's points are valid - but if the end-users (or programmers) accessing the data do not have experience with a relational system, they will stumble and grumble about having to learn to use the NVL function. I personally feel that this

RE: PK field - number or char

Brian Bjorn, Thanks for the replies. Sql*Net traffic, in my mind, is insignificant. If we are trying to determine query speed, most of the tests should be done with more than one table in the query, with a join against the table in question. It is not very often that we will be querying

RE: DBMS_SHARED_POOL.KEEP

Bunyamin, Either try removing the 'EXEC' or try putting a begin and end around the call? EXECUTE IMMEDIATE 'SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')'; or EXECUTE IMMEDIATE 'BEGIN SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')' ||

RE: OBJECT DESING

Seema, PCTINCREASE - always 0. PCTFREE - for lookup (code) tables = 10 for others, I use 20. My theory is that lookup tables have little or no updates, so this value should be small. If you have a high-update tables (columns that are updated a 8lot* after the record was created, you may want a

System datafile corruption.

Guys, I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so

RE: RAC

I saw this here too, the 9iRAC servers are each about the size of a laptop! They did a demonstration cluster with OPS with the clustered servers sitting on a table. I asked a pointed question to one of the presenters re. iAS, whether it uses less memory than it used to when it first came out.

RE: Training for Oracle 8i

Hi Peter, A test box, documentation and time to play is what worked for me. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:53 AM To: Multiple

Re: Ang: Re:Import excelfile into Oracle table

RTFM where the Fine Manual = PL/SQL for Dummies or Teach Yourself PL/SQL in 21 Days [EMAIL PROTECTED] wrote: Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till

World's largest database...

http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED]

Re: DBMS_SHARED_POOL.KEEP

Tried and does not work .. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -

RE: What is Oracle made from ?

I thought it was BASIC...after all, their still pushing Visual Basic down our throats while the rest of the world has moved on... Everyone knows that Bill Gates invented DOS and Basic...and Steve Ballmer was jealous so he invented the Internet... My humble apologies Jared...

RE: Upgrade 8.0.5 to 8.1.7.3

Huh. 8.1.7.4. or 8.1.7.5. After what I went through with 8.1.7.3.1., I am leery of applying any more Oracle patchsets. Last I heard they planned to release 8.1.7.3.2, but I didn't hear anything about major patchsets coming out. Aren't they now developing 9i Release 2 or 3 (not sure, we are at

Re: RAC

Ron, This information is incorrect. RAC is available on there platforms without shared file systems. I have RAC running on SUN, NT and Linux. All of these platforms have shared raw devices and are concurrently accessed. RAC on shared file systems is only supported on Tru64, OpenVMS and starting

RE: RAC

I meant iFS of course, not iAS! Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: RAC I saw this here too, the 9iRAC servers are each about the

Oracle 9i Application Server

Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gagandeep Singh INET: [EMAIL PROTECTED] Fat City

Re: Accessing Synonym

Does the table inventory.company exist? Abdul Aleem dmitTo: Multiple recipients

SQLLDR core dumping

Hi I installed 9iAS 1.0.2.2.2 on Solaris 8. All went well except the Portal component failed. When I tried to re-run the opca (portal configuration assistant) it failed on a segmentation fault in SQLLDR. Oracle support seems to be stumped by this. Has anyone else run into this? Thanks, Ben

RE: World's largest database...

At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin

RE: MySQL vs. Oracle database

In our testing the Berkeley table types were hopelessly slow and bloated, taking up much more space than MyISAM or InnoDB table types. We had more success with the InnoDB table type, and will be implementing them some time in the future. InnoDB supports referential integrity. The table types

Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)

Hi Richard, Consider hiring Steve Adams (Ixora) to work for you. His rates are reasonable and he has worked problems exactly like this dozens of times. He is the most competent troubleshooter of these types of problems I have ever worked with and I highly recommend you consider retaining

RE: Ang: Re:Import excelfile into Oracle table

Or sql*loader. csv isn't the best choice of file format in my opinion (will any of your fields have commas in them?) but sql*loader will pick up the file and slam it in faster than you can blink an eye. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117

RE: RAC

I remember they mentioned that Compaq Tru64 (and perhaps VMS) has a cluster file system which runs over fiber optic line between the cluster servers. The servers use it to stay in synch and to share information. For the datafiles, they recommended using one of the Tru64 file systems instead of

RE: RAC

fwiw, I have heard that licensing for RAC is incredibly expensive. But does that really suprise anyone? Lisa Koivu Oracle Database Hormone Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002

Re: What is Oracle made from ?

Correction. Basic was invented by two college professors at Dartmouth College in the early 1960's to replace Fortran for analytical analysis. They needed a language that was quick and easy to use and throw away the code after you did your analysis. It was not meant to be efficient since you

RE: DBMS_SHARED_POOL.KEEP

Um, why can't you do this... create or replace procedure pin_packages_defined assql_sentence varchar2(200);cursor_name INTEGER;rows_processed INTEGER;CURSOR tab_cur IS SELECT owner,object_name FROM arsiv.pin_aday_objeler;tab_row tab_cur%ROWTYPE;BEGINFOR tab_row IN tab_cur LOOP

RE: World's largest database...

'fraid not, though Oracle would love it to be their RDBMS it's Objectivity/DB. Mike -Original Message- Sent: 18 April 2002 15:03 To: Multiple recipients of list ORACLE-L http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this

Re: Ang: Re:Import excelfile into Oracle table

I have found that using tilde (~) delimited flat files a safe way to go with SQL*Loader. You won't find any data using tildes. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:28 AM Or sql*loader. csv

forced code path?

One of Mr Jonathan Lewis' posts refers to 'forced code paths'. What is a 'forced code path'? regards madhu There are a number of possible anomalies in the information that you have sent to Oracle, and your init.ora has a number of strange settings which may be affecting things (possibly

RE: Re:Import excelfile into Oracle table

I heard , ( I think in the same list ) ... FILE PATH can be a path to your NT local machine too... ( even can have multiple UTL_FILE_DIR locations on NT machine ) So we should be able to read a file on NT machine to load the data to the Oracle using UTL_FILE package. --Madhu

Re: SQLLDR core dumping

I had the same problem. We're on Solaris 8, Oracle 8.1.7.2, 9iAS. I worked with Oracle support for a long time on this issue and they could never solve the problem. It has something to do with the environment variables. I ended up creating a user with only the most necessary environment

Re: PK field - number of char

Tom, If you are generating keys as you should be, they will be numeric. Jared On Wednesday 17 April 2002 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field?

RE: Accessing Synonym

Hi, Try : SQL connect inventory/invent@test_server SQL grant select on company to public; Regards, Mike Hately -Original Message- Sent: 18 April 2002 15:29 To: Multiple recipients of list ORACLE-L Does the table inventory.company exist? Abdul Aleem

RE: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)

Here we go again. The numbers make sense and I do not think there is anything wrong. Here is the thoery: When you run five jobs on four CPUs it takes five seconds. The query requires certain amount of CPU units times Seconds. Assume each query requires (x) CPU units Seconds. Running five

Re: World's largest database...

Why no ask Ian MacGregor he's the DBA at the SLA. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:03 AM http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from

Re: PK field - number of char

Tom, If you're keeping up on the other threads, you will see that we are in fact in complete agreement. As for the char vs. number , which is faster in an index debate that arises from time to time, I personally think it's a silly waste of time. No disrespect intended, maybe it's the first

RE: Upgrade 8.0.5 to 8.1.7.3

Whilst not recommending export/import as the method, I've sometimes created a migration planned that inferred unload-then-reload and then post migration used the extra time for moving objects around for io balancing, converting to lmt's, rebuilding indexes et al. Sometimes downtime is hard to

RE: initjvm and rmjvm failing

Note 159801.1 (Full JVM Removal on 8.1.7) on Metalink may help. Haven't tried it myself but I fear I'm about to. Jim -Original Message- Sent: Wednesday, April 17, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi All I am trying to add Java support to one of the databases

Re: Oracle 9i Application Server

go to technet.oracle.com and look for documentation, its time for you to start reading :) joe Gagandeep Singh wrote: Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh

RE: DBMS_SHARED_POOL.KEEP

You are calling a PL/SQL package from PL/SQL. Just get rid of all the execute immediate exec stuff and call the package directly : sys.dbms_shared_pool.keep(); -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002 4:28 AMTo:

RE: RE: World's largest database...

I can believe that - I think they are the group that offers all the geneaology services to track family histories. I'll bet that's one heck of database too! Jim Boivin, Patrice J [EMAIL PROTECTED] wrote: At the Oracle Technology Day here they mentioned that one of the largest databases

RE: MySQL vs. Oracle database

load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. Hmmm... We did some load testing here (with Perl::DBI) and MySQL was very fast with just a few concurrent users but as soon as we cranked up the number of concurrent

Re: World's largest database...

If it's the same one that Ian MacGregor spoke of some time ago, it's a distributed database in Objectivity, not Oracle. Jared On Thursday 18 April 2002 07:03, Jim Hawkins wrote: http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from

Re: Symbolic links for datafiles...

Generally running 'df' against a file will tell you its filesystem $ ls -l x lrwxrwxrwx 1 oracle dba 25 Apr 18 15:56 x - /export/home/oracle/admin $ df x /export/home (/dev/dsk/c0t1d0s0 ): 4491432 blocks 918387 files Maybe just dump out v$datafile and df each one hth

RE: PK field - number of char

Jared, I disagree. In some cases, I would support and use natural values for Primary keys. In the case of State Codes, County Codes, Yes/No codes and other that are too obvious, I really do not see the value of using an sequence number for the PK. I have a YES/NO table in my database. The

RE: MySQL vs. Oracle database

Hi Walt, et al. It's quite possible to use MySQL as a backend database for web hosting and get good performance and decent reliability. I haven't heard of Access being used for that sort of thing. Actually Access is used quite widely as a backend database for web servers. The usual set-up for

Re: Oracle 9i Application Server

This Oracle web site will give you all the documentation you need for 9i. You can download it in .pdf format to your PC for quick reference. http://download-west.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm Ken Janusz, CPIM - Original Message - To: Multiple recipients of list

RE: World's largest database...

http://www.slac.stanford.edu/BFROOT/www/Computing/Offline/Databases/Conditio ns/Evaluations/Report.pdf -Original Message- Sent: 18 April 2002 15:23 To: Multiple recipients of list ORACLE-L 'fraid not, though Oracle would love it to be their RDBMS it's Objectivity/DB. Mike

Reorganize table

Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to

See what happened in Naples in Palestine

Attention des images très gore. Âmes sensible s'abstenir. Est ce qu'il y a des êtres humains qui peuvent arrêter ces barbares ? !! Img2.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing

RE: System datafile corruption.

Mike: Have you upgraded versions lately? We had the same error pop up in our System tablespace, but the 'problem' wasn't real. It was an artifact left over from the upgrade of (I think) 7.x to 8.x. There are parts of the SYSTEM rollback segment that had never been touched, and these showed up

DBMS_MAIL

Has anyone used this package to send e-mails to an Exchange server? Is it possible? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch |

RE: MySQL vs. Oracle database

Thanks for clarification, all my knowledge about transactional tables are from MySQL docs. I'v used only not transactional safe tables for some web projects. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

RE: db2/udb and new skillz

Dear Lisa others ! i've been in the same situation before. I also felt (and still do) that Oracle DBA alone in the resume is not enough, and i need something more than it to feel comfortable in this recessive economy. I posted almost the same question to the list and (after receiving number of

Re: World's largest database...

500tb, guess a good reason to use Rman! Do notice its not called Rwoman :) [EMAIL PROTECTED] 04/18/02 10:53AM Why no ask Ian MacGregor he's the DBA at the SLA. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:03 AM

Re: System datafile corruption.

Why don't you verify that the corrupted block belongs to the segment you think it does, or belongs to a segment at all? select owner||'.'||segment_name, segment_type from dba_extents where file_id = file# and 67108870 between block_id and (block_id + blocks - 1); -- Jeremiah Wilton

RE: PK field - number of char

Jared, you said: As for the char vs. number , which is faster in an index debate that arises from time to time, I personally think it's a silly waste of time. I totally agree. As I said, I saw some recent positings stating that numbers were faster than chars and asked if anyone had any

ORA-00600: internal error code, arguments: [4400], [48]

I am getting an ORA-00600: internal error code, arguments: [4400], [48] in my production data warehouse database. Running on version 8.1.7.2.1 Solaris 10.20 32 bit. We are also having trouble with Packages that load data into the database reporting a normal completion but in fact it only loads

Re: forced code path?

It doesn't mean anything exciting or exotic, I was just trying to express the idea that sometimes Oracle will execute one piece of (internal) code because of an init.ora parameter, hint, visible set of table statistics etc. rather than taking another path which you might typically expect it to

RE: DBMS_MAIL

I believe it only supports SMTP mail, not MAPI. I have used it to send email to an Exchange server that was running the SMTP connector, so yes it can be used as long as your Exchange server accepts smtp mail. You do not have access to the exchange distribution lists or global address book

Number of CPUs vs. Speed of CPUs

We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what

Re: World's largest database...

It could be renamed in the next release: Recovery With Out MANagement. RWOMAN! Ron ROR mô¿ôm [EMAIL PROTECTED] 04/18/02 12:28PM 500tb, guess a good reason to use Rman! Do notice its not called Rwoman :) [EMAIL PROTECTED] 04/18/02 10:53AM Why no ask Ian MacGregor he's the DBA at the SLA.

RE: datafile sizing ?

Hello Darren,ROR and all, How about using locally managed tablespaces and allocating uniform extent size ( say 4M ) , when we create a tablespace with multiple small datafiles ( say 500 M ) I would prefer to have a standard for the size of the datafile . --Madhu -Original

Re: Ang: Re:Import excelfile into Oracle table

A simple search of Google: http://www.google.com/search?sourceid=navclientq=utl%5Ffile+example Gives the following on the first page: http://www.geocities.com/suresh_vemulapalli/utl.htm http://utplsql.sourceforge.net/Doc/admin.html

Compare (diff) Oracle DB and MS-SQLServer DB

One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB?

Re: MySQL vs. Oracle database

Gints, Tried and could not access the web-site, you point to. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:03 AM By default MySQL has no transactions You have to add special

Help with Locking Issue

I have been spending most of my morning trying to resolve a locking issue. I think I could me missing the forest for the trees. This is what happens: a user kicks off two identical jobs from two different PCs. Each of these jobs is doing the same thing, but against different rows of data

RE: DBMS_MAIL

Never mind, I found the answer: It's not possible. Instead, since 8.1.6., it's better to use the utl_smtp package. e.g. from MetaLInk: DECLARE conn UTL_SMTP.CONNECTION; crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 ); mesg VARCHAR2( 1000 ); BEGIN conn:= utl_smtp.open_connection(

Re: Reorganize table

Raghu, I think that because of your limited space you are between the rock and a hard place. Make sure you have a good BACKUP. I would even try for more than one good backup as you don't know if the backup tape was good until you try a restoral. I would try creating a table that I could load a

RE: MySQL vs. Oracle database

1000 rowdy kindergardeners. I can relate to that analogy... I can also laugh when I picture it in my mind. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/18/02 11:13AM load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. Hmmm...

RE: MySQL vs. Oracle database

What makes you think that MySQL has read consistency? For read consistency I think MySQL is actually putting locks on tables during a query and when you have some intense queries with a lot of concurrent users they have to wait in line like 1000 rowdy kindergardeners.

Re: RAC

It's true that the *best* platform for 9iRAC is Tru64, as it is the base port for that product. But 9iRAC (with reduced feature set) is currently available across most major Oracle ports already -- it just doesn't include many of the advanced clustering features that come as part of Tru64 and

RE: RE: World's largest database...

The 0.5 petabyte database at SLAC does not use Oracle; it uses Objectivity. Objectivity is a small company which makes an OODB. When the project started there was no way that Oracle could possibly handle this. It is still doubtful: Oracle does not truly support Hierarchical Storage

RE: Number of CPUs vs. Speed of CPUs

How many CPU's will the box hold? This # should be your requirement, as you can always negotiate down... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:58 AM To: Multiple recipients of

RE: Training for Oracle 8i

Peter - For 7 folks, I would bargain with a local training company to put on an in-house program customized for your needs. Unfortunately the training market is depressed so you can bargain lower rates. My manager got the rate cut in half. Oracle 8i programs are pretty mature by now. Pick and

RE: Reorganize table

If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002

Quick Question

Sorry about this RTFM question, but I need a quick answer. I have a remote database in the UTF8 character set. When I export that DB I get this message: Export done in US7ASCII character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion) What can I

Re: EXP-00010 I need help

You have to have permission to export a database or scheman which is not your own. At least dba privs.. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 12:58 PM This is a valid user in database but not to export

RE: MySQL vs. Oracle database

Here's a quote from a most definitive resource, New Riders' book MySQL by Paul DuBois, The server has two kinds of locking. It uses internal locking to keep requests from clients from interfering with each other-- for example, to keep one client's SELECT query from being interrupted by another

Re: Compare (diff) Oracle DB and MS-SQLServer DB

Oracle offers Migration Kit. Check OTN. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:28 PM One of our teams started programming in SQLServer, but now we are live in a

RE: Reorganize table

You can export and compress on the fly This unix... mknod export_pipe p compress export_pipe export_file.dmp.Z exp userid file=export_pipe log=export.log table=(big_fat_table) compress=n Try it. I hope it compress to less than 5G. -Original Message- Sent:

Re: Number of CPUs vs. Speed of CPUs

If pricing is a factor, and you're considering per-cpu pricing, then lean towards fewer, faster CPUs. I think Intel announced a 2Ghz processor this week... :-) Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for

  1   2   >