Re: [Q] does Redhat 8 has problem work with ORACLE 8.1.7???
What is your DISPLAY environment variable set to? -Joe --- dist cash <[EMAIL PROTECTED]> wrote: > > > I installed the RedHat 8.0 on server and plan to install the ORACLE > 8.1.7. > After I type "./runInstaller" on console, their is Nothing display. > > > > redhat::/u/CD/Disk1[37]%./runInstaller > redhat::/u/CD/Disk1[38]%Initializing Java Virtual Machine from > ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. > > Please wait... > > > is it compatible problem or anything else??? > > Thanks. > > _ > The new MSN 8: smart spam protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does the case of an Oracle query statement affect query perfo
I believe Raj is referring to the fact that Oracle will reuse SQL from the SQL Cache if the statement has been parsed already, but they must match verbatim. for example: a)SELECT column1, column2 FROM table WHERE column0 = 5; b)SELECT COLUMN1, COLUMN2 FROM TABLE WHERE COLUMN0 =5; will be stored in the sql cache with 2 different hash id's, so each will be stored separately in the cache. I have always found it recommended that a certain upper/lower case naming convention be followed to avoid this situation. -Joe --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Raj, > > Do you have any test cases or white papers to support your > statement? > Especially the part about > > "if you mix-n-match that will make Oracle do more work." > > never heard of this before and I am interested if it is true. > > Tom Mercadante > Oracle Certified Professional __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: oracle-dba.com domain auction
What are you hoping to get for it? -Joe --- JOE TESTA <[EMAIL PROTECTED]> wrote: > With as much interest as i'd seen, i'd thought it would have been > above $102.50, oh well unless you all run up the price in the last > few days, guess i'll just be holding onto it for a while. > > joe > __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference between connect internal and connect / as sysdba in sqlplus
'connect internal' is no longer supported in 9i+ 'connect / as sysdba' is the replacement. --- Mikhail Ivanov <[EMAIL PROTECTED]> wrote: > What is difference between "connect internal" and "connect / as > sysdba" in > sqlplus ? __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: stupid RMAN question
You are correct - only the log command is available in 8i, spool is available in rman in 9i. -Joe --- JOE TESTA <[EMAIL PROTECTED]> wrote: > Ok i've been thru all of the 817 docs multiple times, searched > metalstink, read the chapters in backup/recovery 101 multiple > times. > > Where in the heck is the "spool" command for rman? > > Can i only spool stuff(and its an either to a file or to the > screen, not both?) using the log parameter when starting rman. > > if I've started rman with out the log parm, there is no way to open > a spool file? > > I'm currently stuck on 817 rman if that makes a difference. > > thanks, joe > __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NO ANALYZE STATS FOR TABLE
How do you know you have no statistics? What does select table_name, num_rows, last_analyzed from user_tables; give you? Also, setting TIMED_STATISTICS and SQL_TRACE has nothing to do with running ANALYZE TABLE... -Joe --- [EMAIL PROTECTED] wrote: > Hi gurus, > > I have analyzed my table A but I get no stats for the table. What > could be > the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE > before issuing > the ANALYZE TABLE A COMPUTE STATISTICS command. > > This table has over 8 million records. > > Moses Ngati __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux
See http://otn.oracle.com/tech/linux/content.html It runs very well. Moving a database from NT to Linux is as easy as export/import. Other methods exist too. --- "Turner, Christine" <[EMAIL PROTECTED]> wrote: > Greetings ALL! > > Have a question for anyone who has infoI'm researching what it > would > take to convert a NT database platform (Oracle 81730) to Linux. I > have not > approached Metalink yet, but will soon. Does anyone have any > information on > Linux? Whether or not Oracle can run on it? Info on the steps > involved to do > so? > > Thanks, > Christine Turner > Sr. Database Administrator > Scottsdale, Arizona > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Turner, Christine > INET: [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Download Oracle 7.3.4
Oracle wasn't available for Linux until version 8.0. --- dcutrone <[EMAIL PROTECTED]> wrote: > Hi list, > > I need to do some testing in an Oracle 7.3.4 for linux (redhat), > where can I download this Oracle version from? > > it doesn't appear to be online in OTN. > > > thanks for your help. > Greetings > Diego Cutrone > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: dcutrone > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Install Oracle 8i on Windows XP?
Please end this thread and/or take it off the list... Thank you. --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > Eric, thank you for your illuminating notes on the reason they hate > us. > > > Just two points: > 1) A few days ago a bomb explode in India killing 50 people. > I did not heard ANY remarks from anybody condemning this. > 2) All the people who cry for the Palestinians and demand they > should have their own country does not give a shit about the > Curds >(for example) who are in worse condition. > > The Europe countries are basing their policy on Jew hating. > > > > Yechiel Adar > Mehish > ISRAEL __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Transfering data from DB2 to Oracle
I've done db to db transfers using either 1) Perl/DBI - db to db - select from first, insert into second 2) Perl/DBI - select from first, create file for SQL*Loader, load into Oracle using SQL*Loader I've usually found #2 to be quicker...usually... -Joe --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote: > We have an application which will require us to reload some > Oracle tables on a regular basis from a main frame DB2 database. > Management does not want to spring for the cost of any connectivity > tools. Short of the obvious dump-to-a-text-file/input-with-sqlldr > appoach, is there any other way to do this? > > thanks, > Peter Schauss __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replication - truncate not propagating
Take a look in the docs at the syntax: truncate table preserve/purge snapshot log; "The SNAPSHOT LOG clause lets you specify whether a snapshot log defined on the table is to be preserved or purged when the table is truncated. This clause allows snapshot master tables to be reorganized through export/import without affecting the ability of primary-key snapshots defined on the master to be fast refreshed. To support continued fast refresh of primary-key snapshots, the snapshot log must record primary-key information. PRESERVE Specify PRESERVE if any snapshot log should be preserved when the master table is truncated. This is the default. <<<<<<< this is why you are not seeing the truncate being replicated PURGE Specify PURGE if any snapshot log should be purged when the master table is truncated" -Joe --- Vladimir Barac <[EMAIL PROTECTED]> wrote: > Hi! > > I have noticed something... > > Deletes are propagating from master site to the snapshots. > Everything works like charm, as it is supposed. > > But... truncate of master table IS NOT seen in snapshot table. I > don't really expect snapshot to be truncated, of course, but I > expect it to be empty (trunace is essentially delete). > > So, is this bug or feature? What is logic behind it, if it is > feature? > > > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import question
>From the 8.1.7 docs: "Direct path Export extracts data much faster than a conventional path export. Direct path Export achieves this performance gain by reading data directly, bypassing the SQL command processing layer and saves on data copies whenever possible. In a direct path Export, data is read from disk into the buffer cache and rows are transferred directly to the Export client. The evaluating buffer is bypassed. The data is already in the format that Export expects, thus avoiding unnecessary data conversion. The data is transferred to the Export client, which then writes the data into the export file. " --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > Dan: > >I believe the SQL on the outbound is eliminated. With DIRECT=Y, > the > Kernel performs I/O direct to the DMP file versus generating the > SELECT > statements to retrieve the data and then write out the data. > That's why > exports take far less time with DIRECT=Y. You are correct that > Redo WILL be > generated on the import side. > > Thank You > > Stephen P. Karniotis > Product Architect > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email: [EMAIL PROTECTED] > Web:www.compuware.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Apple rack-mounted servers
Yes, FreeBSD... Since when do Oracle products work on FreeBSD? -Joe --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > It is based on some *NIX variant...was it FreeBSD? __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: gathering history v$ to predict system change
Why not issue queries against the statspack tables to get your info? (if you are using statspack that is) -Joe --- zhu chao <[EMAIL PROTECTED]> wrote: > hi, list friends: > We know statspack can gather history data and let you compare > statistics from different time snapshot.But it is something > difficult, for you must make multiple report and open them one by > one and compare data between different reports. > Now i want to gather some information about the system ,put them > in log file and draw pictures(using mrtg from log) about the > statistics change,so that i can see which statistics is changing > recent time and find problem before it became performance > bottleneck or before it stuck the system. > In fact, the most useful data i want to get is like the content in > the statspack, but i want to get them into one file from different > time snapshot.The data i want to gather is like: wait event change > trend,instance load profile change trend, the most cost sql > change.Is it possible to get these data directly from some join of > v$views? Or i can gather such valuable information from some > v$view? > Please share your experience about performance monitoring and > capacity planning:) > > > Regards > zhu chao > Eachnet DBA > 86-21-32174588-667 > [EMAIL PROTECTED] > www.happyit.net > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: news server
comp.databases.oracle.server comp.databases.oracle.tools comp.databases.oracle.misc comp.databases.oracle.marketplace I access these via groups.google.com -Joe --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > Sorry, I wish that e-mails had a way to attach what I wanted > to say. > > I meant news group on the subject of oracle. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, May 23, 2002 3:53 PM > > > > > > On 2002.05.23 07:08 Yechiel Adar wrote: > > > I am looking for the address of oracle news server. > > metalink.oracle.com > > -- > > Mladen Gogala > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You > may > > also send the HELP command for other information (like > subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL versus Oracle
I've seen MySQL truncate data on insert without warning. MySQL also does not have foreign keys. It accepts the syntax of create foreign key, but nothing is created, nothing is enforced. I recently did a migration from MySQL to Oracle, and these were the two major issues I faced. Let me know if you have any more specific questions. -Joe --- Joe Testa <[EMAIL PROTECTED]> wrote: > Anyone on the list done a comparison(or worked with both) MySQL and > > Oracle and can give me the good/bad points of My SQL? > > Doing interviewer thing and someone has My SQL who would like to > move > into the oracle world and i know nothing about mySQL and am > wondering if > the transition from one to the other is easily done. > > thanks, joe __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLServer copy table from 1 db to another
command line bcp bcp out bcp in -Joe --- Gene Sais <[EMAIL PROTECTED]> wrote: > Is there a way to copy a table in 1 sqlserver db to another, > similar to Oracle's exp/imp, or create tablle as select.., etc. It > appears the only way you can do it is thru DTS packages. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gene Sais > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN
just change
(archivelog all delete input);
to
(archivelog all);
--- Ravindra Basavaraja <[EMAIL PROTECTED]> wrote:
> I have a script to take the incremental backup
>
> run {
> allocate channel t1 type 'SBT_TAPE';
> backup
> incremental level 1
> tag Dialy_Incremental_Backup_Level1
> filesperset 5
> format 'Data_%d_%s_%p_%t'
> (database);
> sql 'alter system archive log current';
> backup
> filesperset 20
> format 'Arch_%d_%s_%p_%t'
>(archivelog all delete input);
> }
>
> This will delete the archive files after the backup.I want to
> retain the
> archive files
> for some reason(temporarily).I don't want the rman to delete the
> archive log
> files.I am
> not able to find out the right command to get that done.
>
> What change should I do in the script so that the archive log file
> are not
> deleted.
>
> Thanks
> Ravindra
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ravindra Basavaraja
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like
subscribing).
______
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Raube
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: linux
There has been some success with 8.0.5 on FreeBSD, but little to none with 8i. -Joe --- Saravana Kumar <[EMAIL PROTECTED]> wrote: > Hi Friends, > I have small clarification to be made. > Can oracle for linux software be intalled on FREE BSD. > > Thanks in advance > > Saravana > > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL anyone?
It depends on what you want to use it for. See http://www.phpbuilder.com/columns/tim2705.php3?page=1&print_mode=1 for one opinion. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 10:00 AM > Hi. > > does anyone know anything about MySQL? I was assigned > to a pilot to see whether this is something my company > would want to use. Does anyone use it? Any good/bad > opinions? > > TIA > > Gene > > = > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gene Gurevich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re:Hardware requirements when migration oracle from NT to Li
Linux (Redhat and others) can certainly use more than one processor - the Linux kernel may need to be recompiled, but I have a few machines with Oracle setup on Redhat and SuSE that make great use of multiple processors. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 07, 2001 9:00 AM > Take what you have, strip out one processor since I don't think Red Hat can use > more than one processor, and have fun. BTW: Your duhvelepors will probably see > a 100% performance boost since Linux has a lot less overhead than NT. > > Dick Goulet > > Reply Separator > Author: Schoen Volker <[EMAIL PROTECTED]> > Date: 9/7/2001 1:45 AM > > Hi list, > > I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to > Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need > for the linux machine to hit the same performance than on NT machine. > > Hardware NT machine: > 2 * PIII 500 processor > 1 GB Ram > one RAID 5 > > TIA > > Volker Schoen > E-Mail: mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.inplan.de <http://www.inplan.de> > > > > > > > > > Hardware requirements when migration oracle from NT to Linux > > > > Hi list, > > > I want to migrate our developer databases from NT 4.0 > (Oracle 8.1.5) to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which > hardware do I need for the linux machine to hit the same performance than on NT > machine. > > Hardware NT machine: > 2 * PIII 500 processor > 1 GB Ram > one RAID 5 > > > TIA > > > Volker Schoen > E-Mail: HREF="mailto:[EMAIL PROTECTED]";> FACE="Arial">mailto:[EMAIL PROTECTED] > http://www.inplan.de";> FACE="Arial">http://www.inplan.de > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Differential Backup
Take a look at the fine documentation on RMAN. It can do different levels of incremental backup. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 11, 2001 8:30 AM > Hi all, > we have oracle server version 8.1.7 on windows NT. > We take daily full backup of our data. > Now we want to take differential backup with respect to last backup > taken. > So if any help possible it will be great to me. > Thanks. > -Ketan > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ketan Patel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem Starting SQL Loader
sqlldr is not a sqlplus command - it needs to be called from the OS command line. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 5:00 PM > I am in sql*plus (8.1.7) logged in as sys. When I try running "sqlldr" at > the command prompt I get this error: > > SP2-0042: unknown command "sqlldr" - rest of line ignored. > > I'm calling it from my client PC and the DB is located on a separate server. > > How do I get this to work? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
list down?
I haven't received anything since this morning. -Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oralce 8i/9i with Pentium4
Oracle 8i is certified with Linux glibc version 2.1x Oracle 9i is certified with Linux glibc version 2.2x Which Linux distribution and version are you using? This is just one of the possible issues, but it is the most common. There are many discussion threads on this on the OTN Linux discussion boards. -Joe At 08:00 PM 12/13/01 -0800, you wrote: >Hi all, >AOA >A colleague of mine spent days getting Oracle 8i/9i installed on Pentium >4. It never opened the universal installer initially, but then through >some work arounds (dumping the un-installed Oracle8i on the hard drive and >running the setup from there) he was able to do that. But now once he has >the Oracle installed, he can't create a Database, no matter what he tried, >he couldn't do it. Operating system he is using is Linux. > >I remember some discussion about this in the LIST, but what I want to know >is whether P4 really has some problems with Oracle 8i, especially on >Windows NT4 platform, becuase this is what we are using in our >organization and we have ordered 60 new PCs (all P4s )to be setup in our >hospital. All these systems will be using Oracle 8i (9i in future) on NT4, >so I wanted to be sure before we go on with this. > >Representatives from the Intel company said that this is an Oracle problem >and "dumping the un-installed Oracle8i on the hard drive and running the >setup from there" is a solution given by the Oracle Company. > >Any body with a complete knowledge??? > >Thanks and Regards, > >Hussain Ahmed Qadri >DBA >SKMCH & RC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle text and CLOBs
See docs on Stop Words: http://download-west.oracle.com/otndoc/oracle9i/901_doc/text.901/a90122/ind4.htm#1010184 Using Stopwords and Stoplists A stopword is a word that is not to be indexed. A stopword is usually a low information word such as THIS or that in English. In other words, IS and THIS are stopwords and are not being indexed. -Joe At 12:45 PM 12/17/01 -0800, Witold Iwaniec wrote: >Hi all > >I am experimenting with Oracle Text and CLOBs in Oracle 8.1.7 and >have run into something strange. > >I have a table, LRMI_NOTE, with column NOTE_DATA that is >defined as a CLOB. > >SELECT NOTE_DATA FROM LRMI_DATA; > >NOTE_DATA >== >this is starting test > >I have built both ctxsys.context and ctxsys.ctxcat indexes. When I >run: > >select * from lrmi_note where contains(note_data, 'test') > 0 >or >select * from lrmi_note where contains(note_data, 'starting') > 0 > >I get back the record. But when I run: > >select * from lrmi_note where contains(note_data, 'is') > 0 >or >select * from lrmi_note where contains(note_data, 'this') > 0 > >I don't get anything back. The same happens when I used the >catsearch() function. > >I updated this column, set to various strings so that "this" and "is" >were in different positions in the string, but couldn't get anything >back using "is" or "this" in my queries. > >Can anyone explain this? > >Thanks > >Witold > >== >Witold Iwaniec >Sr Software Developer >NovaLIS Technologies >[EMAIL PROTECTED] >http://www.novalistech.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Witold Iwaniec > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VNI-2015 LInux server / winNT station / Linux server
I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85247/ch6.htm "Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 "authentication error." In all non-PDC environments the account must be local to the machine. " -Joe At 01:31 PM 12/20/01 -0800, you wrote: >I have a Linux server running Oracle Standart 8I, I already setup the init >file with the exclusive value to accept backup jobs, I also created a >special account with sysdba, sysoper, and dba rights and a linux account >same name password and with all rights to sysoper, sysdba and root groups. >On the nt side I have the same account local and in the domain both with >the log on as batch logs from the advance rights, same password, >administrator rights for both, I also have the same name and password unde >the OEM as a manager with superuser rights, and I have set the preferences >for default node and linux node with the same name, even the service for >the database is the same as sysdba, and still when I try to send a job, I >get this VNI-2015 and the job reports failed, I even created a file with >the orapwd with the same account name and the password. So if somebody >could give a couple of ideas, out of this, I will appreciate it, I have >read all of the messages and I tried all, I have no more ideas, I thanks >for your help and time on this one in advance. Jose > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: tomas > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move DB to Another Schema
1 - never create objects as SYS 2 - svrmgr is gone in 9i - stop using it I would drop all user objects that you created as SYS, and recreate using a DDL script. -Joe At 06:55 AM 12/21/01 -0800, you wrote: >I can't find any details of this in any of my documentation. I originally >created my DB as SYS. I have setup a new user and need to move my DB / >Tables, etc. to the new schema. How do I go about this? Can I do it via >SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to >create a new DB (DDL SQL script) as the new user? > >Thanks, >Ken Janusz >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ken Janusz > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem Setting Up User
Have you created synonyms? At 01:05 PM 1/2/02 -0800, you wrote: >I am having a problem setting up a user on my DB (W2000 / 8.1.7). > >I have my self as user KENNETH and the new user is KIMV. > >She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus >TABLE_NAME. > >Here is what I have (I am grantee KENNETH and the user I am setting up is >KIMV): > >GRANTEE GRANTED_ROLEDEFAULT_ROLE >KENNETH CONNECT YES >KENNETH DBA YES >KENNETH EXP_FULL_DATABASE YES >KENNETH IMP_FULL_DATABASE YES >KENNETH RESOURCEYES >KENNETH SELECT_CATALOG_ROLE YES >KIMVCONNECT NO >KIMVDB NO >KIMVKIMVO NO >KIMVRESOURCEYES >KIMVO CONNECT YES >KIMVO RESOURCEYES > >Also, Oracle will only allow me to have one granted role as YES at a time. >For example if I set DB to YES then RESOURCE goes to NO. > >Your help will be greatly appreciated. > >Thanks, >Ken >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ken Janusz > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Google to the rescue... just one of the many links: http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm -Joe At 02:10 PM 1/2/02 -0800, you wrote: >Arul - I would recommend reading "How to Stop Defragmenting and Start >Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an >Oracle white paper. I was going to provide a link to it, but Oracle's >website search function doesn't seem to work for me right now. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > > > >-Original Message- >Sent: Wednesday, January 02, 2002 12:10 AM >To: Multiple recipients of list ORACLE-L > > >Hi DBAs, > >I would like to know on what basis we arrive at the decision of making a >tablespace as LOCALLY Managed / DICTIONARY Managed... > >Any Suggestions / Tips > >Thank you.. > >Arul. > >* >Disclaimer > >This message (including any attachments) contains >confidential information intended for a specific >individual and purpose, and is protected by law. >If you are not the intended recipient, you should >delete this message and are hereby notified that >any disclosure, copying, or distribution of this >message, or the taking of any action based on it, >is strictly prohibited. > >* >Visit us at http://www.mahindrabt.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Arul kumar > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
See http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem8a.htm#2058616 "PARTITION | SUBPARTITION Specify the partition or subpartition on which you want statistics to be gathered. You cannot use this clause when analyzing clusters. If you specify PARTITION and table is composite-partitioned, Oracle analyzes all the subpartitions within the specified partition. " command should be something like: analyze table schema.table_name partition (p1) compute statistics; -Joe At 05:00 AM 1/3/02 -0800, you wrote: >Good morning everyone, > >Can anyone give me the command to analyze a partitioned tabled? To analyze >this table unpartitioned I use: analyze table schema.table_name compute >statistics; > >I am partitioning it into 6 partitions and want to compute statistics on >each partition. > >Thanks in advance, >Ruth > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tools that Reside on the Server Side of Oracle
Take at look at the files in $ORACLE_HOME/bin on the server.much depends on what you have installed. Then look each of them up in the fine manual. Maybe try the excellent Oracle doc engine at tahiti.oracle.com? -Joe At 12:56 PM 1/9/02 -0800, you wrote: >I would like to know what are the tools / utilities that reside on the >Oracle server? Server Mgr is one. On the client side there is SQL Loader, >SQL*Plus, Exp/Imp. etc. > >Thanks, >Ken Janusz, CPIM >Database Conversion Lead >Sufficient Systems, Inc. >Minneapolis, MN > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ken Janusz > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: The OCP bar is being raised
Of course, those of us who already have the OCP and want to be called a 'master' just need to take the 2 required courses and then the OCM exam. When looking at the details, they just split the previous 5 exam OCP into two tiers, a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite. The Oracle Master was always available, but without a test -- it just required taking ILT courses. They just added a practicum exam to make the OCM cert. I can see your point about this being a 'money grab', but the only new item here is the OCM practicum exam -- everything else existed for 8 and 8i. -Joe At 07:05 AM 1/10/02 -0800, you wrote: >I'd say the cost is being raised. Look at the requirements for each. You >can't just take the OCM exam. No we would first have to get the >OCA. Whether or not we need the entry level cert we have to have >it. Then, and only then, can we take the OCP. Then and only then, can we >take the OCM and that is after we take these REQUIRED classes from Oracle >Ed. So someone the caliber of Steve Adams or Jared Still, has to spend >money in a class that they could probably teach from memory before they >can get certification and that is after getting 2 other certs that have no >value to them. Call me a cynic, but to me, this is nothing but a money grab. > > From the website: > >--To become an Oracle Associate, you must pass the exams required >-- for the Oracle Associate level of your selected job role. Typically, >--two exams are required; the first one can be taken via the Internet, >--while subsequent exams must be taken in a proctored environment. By >--completing your Oracle Associate, you are half-way toward achieving the >-- Oracle Certified Professional credential. > >--To become an Oracle Certified Professional, you must pass all required >exams >--in your selected job role, including those at the Associate level. > >--To become an Oracle Certified Master, you must first be an Oracle >--Certified Professional. Additionally, achieving your OCM credential >--requires attending two advanced level Oracle University courses from >--the list shown on this page as well as passing the OCM Practicum exam. > >--Chris > >-Original Message- >From: [EMAIL PROTECTED] [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 10, 2002 9:16 AM >To: Multiple recipients of list ORACLE-L >Subject: The OCP bar is being raised > >Anyone care to comment on the following, IMHO it's about time: > > >--- >Introducing two new levels of Oracle Certified Professional (OCP) Achievement > >A recent *IDC report on IT Education and Training Services quoted database >professionals and network engineers as the fastest-growing areas of >Professional >Certification. And in an October survey from *crn.com on Certification, >58% of >respondents said that it is very difficult to find qualified Oracle Certified >Professionals-Database Administrators. > >To meet this demand, we have recently introduced two new levels of >professional >achievement to DBAs (and soon to be released to Application and Java >Developers >worldwide): > >The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification >requiring successful completion of two exams. >The Oracle Certified Master (OCM) -- an advanced qualification for Oracle >Certified Professionals (OCP), that requires students to take a practicum >exam >on-sitee at an Oracle University education center. >Visit ><http://www.oracle.com/education/certification/news/index.html?certlevels.html>http://www.oracle.com/education/certification/news/index.html?certlevels.html > > >for more information > >IDC, IT Education and Training, Sept 2001 >crn.com, Certification: What's Hot, What's Not, Oct 2001 > > >- >-- >Please see the official ORACLE-L FAQ: ><http://www.orafaq.com>http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://
RE: The OCP bar is being raised
>58% of >respondents said that it is very difficult to find qualified Oracle >Certified >Professionals-Database Administrators. >To meet this demand, we have recently introduced two new levels of >professional >achievement to DBAs (and soon to be released to Application and Java >Developers >worldwide): >The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification >requiring successful completion of two exams. >The Oracle Certified Master (OCM) -- an advanced qualification for Oracle >Certified Professionals (OCP), that requires students to take a practicum >exam >on-sitee at an Oracle University education center. >Visit ><http://www.oracle.com/education/certification/news/index.html?certlevels.html>http://www.oracle.com/education/certification/news/index.html?certlevels.html > > >for more information > >IDC, IT Education and Training, Sept 2001 >crn.com, Certification: What's Hot, What's Not, Oct 2001 > > >- >-- >Please see the official ORACLE-L FAQ: ><http://www.orafaq.com>http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > >___ >This email is confidential and intended solely for the use of the >individual to whom it is addressed. Any views or opinions presented are >solely those of the author and do not necessarily represent those of >SchlumbergerSema. >If you are not the intended recipient, be advised that you have received this >email in error and that any use, dissemination, forwarding, printing, or >copying of this email is strictly prohibited. > >If you have received this email in error please notify the >SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. >___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: The OCP bar is being raised
Here's the link: http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html and here's the upgrade path: http://www.oracle.com/education/certification/index.html?dba9i_track.html "Oracle 7.3 to Oracle9i Upgrade Path (3 exams) Candidates certified on Oracle 7.3 pass exam #1Z0-010 Oracle8: New Features for Administrators to upgrade to Oracle8, then #1Z0-020 Oracle8i: New Features for Administrators to upgrade to Oracle8i, and lastly exam #1Z0-030 Oracle9i: New Features for Administrators." This would bring you to 9i OCP level. -Joe At 08:25 AM 1/10/02 -0800, you wrote: >Maybe I am completely misreading this. However, I didn't see the 8 to 9 >OCP upgrade and that is why I said, you'll have to take them over >again. If I am completely out to lunch and this is just a re-org of the >Masters and OCP and those 8 OCP can get OCM with 2 classes and a test, >then I apologize for wasting your time and bandwidth, but from what I read >(and it was a quick read) even if you are 8 OCP, you still have to have >the 9 OCA and OCP before you can get the 9 OCM. > >--Chris > >-Original Message- >From: Joe Raube [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 10, 2002 10:41 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: The OCP bar is being raised > >Of course, those of us who already have the OCP and want to be called a >'master' >just need to take the 2 required courses and then the OCM exam. > >When looking at the details, they just split the previous 5 exam OCP into >two tiers, >a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite. > >The Oracle Master was always available, but without a test -- it just >required taking ILT courses. They just added a practicum exam to >make the OCM cert. > >I can see your point about this being a 'money grab', but the only new item >here is the OCM practicum exam -- everything else existed for 8 and 8i. > >-Joe > >At 07:05 AM 1/10/02 -0800, you wrote: > > >I'd say the cost is being raised. Look at the requirements for each. You > >can't just take the OCM exam. No we would first have to get the > >OCA. Whether or not we need the entry level cert we have to have > >it. Then, and only then, can we take the OCP. Then and only then, can we > >take the OCM and that is after we take these REQUIRED classes from Oracle > >Ed. So someone the caliber of Steve Adams or Jared Still, has to spend > >money in a class that they could probably teach from memory before they > >can get certification and that is after getting 2 other certs that have no > >value to them. Call me a cynic, but to me, this is nothing but a money > grab. > > > > From the website: > > > >--To become an Oracle Associate, you must pass the exams required > >-- for the Oracle Associate level of your selected job role. Typically, > >--two exams are required; the first one can be taken via the Internet, > >--while subsequent exams must be taken in a proctored environment. By > >--completing your Oracle Associate, you are half-way toward achieving the > >-- Oracle Certified Professional credential. > > > >--To become an Oracle Certified Professional, you must pass all required > >exams > >--in your selected job role, including those at the Associate level. > > > >--To become an Oracle Certified Master, you must first be an Oracle > >--Certified Professional. Additionally, achieving your OCM credential > >--requires attending two advanced level Oracle University courses from > >--the list shown on this page as well as passing the OCM Practicum exam. > > > >--Chris > > > >-Original Message- > >From: [EMAIL PROTECTED] > [<<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] > >Sent: Thursday, January 10, 2002 9:16 AM > >To: Multiple recipients of list ORACLE-L > >Subject: The OCP bar is being raised > > > >Anyone care to comment on the following, IMHO it's about time: > >- > --- > > > >--- > >Introducing two new levels of Oracle Certified Professional (OCP) > Achievement > > > >A recent *IDC report on IT Education and Training Services quoted database > >professionals and network engineers as the fastest-growing areas of > >Professional > >Certification. And in an October survey from *crn.com on Certification, > >58% of > >respondents said that it is very difficult to find qualified Oracle > Certified > >Professionals-Database Administr
RE: The OCP bar is being raised
gt;--- > > >Introducing two new levels of Oracle Certified > > Professional (OCP) > > Achievement > > > > > >A recent *IDC report on IT Education and Training > > Services quoted database > > >professionals and network engineers as the > > fastest-growing areas of > > >Professional > > >Certification. And in an October survey from > > *crn.com on Certification, > > >58% of > > >respondents said that it is very difficult to find > > qualified Oracle > > Certified > > >Professionals-Database Administrators. > > > > > >To meet this demand, we have recently introduced > > two new levels of > > >professional > > >achievement to DBAs (and soon to be released to > > Application and Java > > >Developers > > >worldwide): > > > > > >The Oracle Certified Associate (OCA) -- an > > entry-level Oracle qualification > > >requiring successful completion of two exams. > > >The Oracle Certified Master (OCM) -- an advanced > > qualification for Oracle > > >Certified Professionals (OCP), that requires > > students to take a practicum > > >exam > > >on-sitee at an Oracle University education center. > > >Visit > > > ><http://www.oracle.com/education/certification/news/index.html?certlevels.h> >tml>http://www.oracle.com/education/certification/news/index.html?certlevels > > .html > > > > > >for more information > > > > > >IDC, IT Education and Training, Sept 2001 > > >crn.com, Certification: What's Hot, What's Not, Oct > > 2001 > > > >--- > > - > > > > > >- > > >-- > > >Please see the official ORACLE-L FAQ: > > ><http://www.orafaq.com>http://www.orafaq.com > > >-- > > >Author: > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > >San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > >To REMOVE yourself from this mailing list, send an > > E-Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB > > ORACLE-L > > >(or the name of mailing list you want to be removed > > from). You may > > >also send the HELP command for other information > > (like subscribing). > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Joe Raube > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > >=== message truncated === > > >__ >Do You Yahoo!? >Send FREE video emails in Yahoo! Mail! >http://promo.yahoo.com/videomail/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Viktor > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix question
Also, either the directory needs to be in your PATH, or you need to execute it while within that directory by typing ./loadfiles.sh or, you need to specify the full path when executing the script. -Joe At 04:50 AM 1/11/02 -0800, you wrote: >Check the first line in the script so that the path to the shell is >correct. >example: >#!/bin/sh > >and maybe check the permissions on the file. > >/Patrik Malinen > >On Fri, 11 Jan 2002 [EMAIL PROTECTED] wrote: > > > Hallo, > > > > why do I get the error message "No such file or directory". > > when I try to run unix script loadfiles.sh which is located in > > the directory /konto/tmp. > > > > This file, loadfiles.sh really exists in that directory. > > > > > > Thanks in advance > > > > > > Roland > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Patrik Malinen > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using procedures instead of coding update/insert
How did you call the stored procedures from java/jdbc? -Joe At 10:55 AM 1/15/02, you wrote: >We have done some preliminary testing and found prepared statements about >20% faster than stored procedures. We inserted 200,000 records at a time >(28-50 columns in a table ) using stored procedures and then used prepared >statements for the same dataset. Both of them were called from java using >JDBC thin drivers and interestingly found prepared statements faster. >Similarly, deletes were also about 15%-20% faster using prepared >statements. For some reasons, updates to the same tables gave almost >identical performance. > >Rakesh > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rakesh Gupta > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pin object into shared pool
alter table tablename cache;
CACHE | NOCACHE
CACHE Clause
For data that is accessed frequently, this clause indicates that the blocks
retrieved for this table are placed at the most recently used end of the
least recently used (LRU) list in the buffer cache when a full table scan
is performed. This attribute is useful for small lookup tables.
-Joe
At 05:07 PM 1/15/02, you wrote:
>Hi DBAs
>
>I try on my test database to pin the table into shared pool and got error
>message. (I already pin the most used packages and procedures in to shared
>pool and it is ok ).
>
>Is there anyway we can put table into memory.
>
>Mitchell
>
>
>SVRMGR> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
>
>ORA-06564: object ARDB.SKILL_MAPPING does not exist
>ORA-06512: at "SYS.DBMS_UTILITY", line 68
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
>ORA-06512: at line 2
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Tuesday, January 15, 2002 1:50 PM
>
>
> > Hi DBAs
> >
> > It is recommend by Oracle to pin frequenly used packages into shared
>pool,
> > I had a table (read only) and mostly used,. Can I pin it into shared pool.
> > What kind of objects could I pin into shared pool area?
> >
> >
> >
> > Thanks in advance
> >
> > like this:
> >
> > execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
> >
> > Mitchell
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: mitchell
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: mitchell
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Raube
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Database Replication
Oracle 8i Replication Manual http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76959/toc.htm ;-) -Joe At 10:15 PM 1/20/02, you wrote: >Hi All > >We have got two Oracle Databases physically connected.We want to replicate >one database with the other database.We are quite new to this >subject.Kindly guide us with the procedure of replication and the >conditions to be considered for replication. > >Thanks in advance > >Regards >Systems > > > > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ang: Re: Ang: Re: PL/SQL procedure - error
s-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Searching Inside CLOBs
Read the fine docs on Technet on Intermedia text, as well as the XML development kit. -Joe On Thu, 2002-01-24 at 10:20, sundeep maini wrote: > Our developers store XML docuements inside CLOBS and > want to search the CLOB contents based on a search > string. I have lot of concern about such queries but > could benefit from someone on the list who has already > solved the performnce issues with such searches. > > Typical existing queries I have come across are: > > Select columns > FROM list of tables > WHERE join conditions >AND UPPER(tab1.varcharcol) LIKE '%:in_string%' >OR UPPER(tab2.varcharcol) LIKE '%:in_string%' >OR . >OR dbms_lob.instr(lobcol,:in_string,1,1) <> 0; > > Note: > > in_string is always upper case but the columns are > Concerns: > > 1. Poor index selection due to UPPER > 2. CLOB searches are obviously wrong. To do a mixed > case string match one needs to read chunks of the lob > in a user defined function of some sort, convert it to > upper and then do string matches. Any tips on this > one? > > > > = > > Sundeep Maini > Consultant > Currently on Assignement at Marshfield Clinic WI > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: sundeep maini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Legato backup.
RMAN will interface nicely with Legato. -Joe --- Jenner Mike <[EMAIL PROTECTED]> wrote: > Hey, just to confirm what I think is obvious... > For an oracle database to be backed up on NT with Legato: you need > to > either; > shutdown, cold backup via legato, startup, or > online backup mode and legato's "Oracle database" extension, > [or some sort of strategy involving oracle export]. > > And to verify... legato's "backup an in-use file" extension used to > backup > oracle database datafiles that have not been shutdown... will not > give a > viable backup ??? > A department that has not paid for my section's DBA services has > just phoned > up with restore problems with a database backed up in this manner! > > If someone could confirm the obvious, I would be grateful. > > Regards, > Mike. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jenner Mike > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Copy tables and indexes etc from one db to another
export/import --- [EMAIL PROTECTED] wrote: > Hallo, > > anyone whom can tellme the easiest way to copy tables etc from one > database to another. > > Thanks in advance > > Roland > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP Question
Here we go again :-) --- Duk Lee <[EMAIL PROTECTED]> wrote: > Does OCP really help? I am thinking about gettting OCP, yet still > skeptical > about it. I am a web engineer, and have very little dba "work" > experience. I > know PL/SQL and have worked with MS SQL 2000, mySQL, etc. And have > been > messing around with Oracle 9.02 on my linux box. also been studying > with > numerous oracle books. I am not really worried about getting OCP. > What I am > worrying about it that "will it really help me to get a job as > Junior-level > Oracle DBA?" > > Thanks. > __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Compare (diff) Oracle DB and MS-SQLServer DB
Diff of what? Data? Schema? Stored procs? Depends on what you need -- ERwin or another ER tool may be able to help find schema diffs... --- Ray Gordon <[EMAIL PROTECTED]> wrote: > 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? Or any suggestions. > > Ray > > > _ > Send and receive Hotmail on your mobile device: > http://mobile.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Gordon > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Donald Burleson
Google is your friend: http://www.dba-oracle.com/ -Joe --- YTTRI Lisa <[EMAIL PROTECTED]> wrote: > Hi - > > Does anyone know if Donald Burleson has a website? If so, do you > have the > url? > > Has anyone read his book 9i Unix Administration Handbook? > comments > please... > > Lisa > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: YTTRI Lisa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Renaming files on Unix via PL/SQL
HOST is a SQL*Plus command only. --- John Weatherman <[EMAIL PROTECTED]> wrote: > What about issueing a HOST command through dbms_sql? Not saying it > will > work (I haven't tried it) > but it seems like it should. > > -Original Message- > Sent: Friday, April 19, 2002 5:53 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > > no, there's no way to do that through PL/SQL. > If have the option of using java you can use the solution given by > Tom Kyte > at > http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 > 241 > <http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 > 0241> > > Regards, > Mike Hately > > -Original Message- > Sent: 19 April 2002 10:03 > To: Multiple recipients of list ORACLE-L > > > > Hi all, > Is it possible to rename files (e.g .txt files) on Unix by using > PL/SQL? Is > there a function to do that? > > > Regards > > M.Emre HANCIOGLU > Masterfoods Services GmbH > ISI Application Support > Tel : +49 2162 500-576 > Fax: +49 2162 41497 > E-Mail: [EMAIL PROTECTED] > > > > > > > > This email and any attached to it are confidential and intended > only for the > individual or > > entity to which it is addressed. If you are not the intended > recipient, > please let us know > > by telephoning or emailing the sender. You should also delete the > email and > any attachment > > from your systems and should not copy the email or any attachment > or > disclose their content > > to any other person or entity. The views expressed here are not > necessarily > those of > > Churchill Insurance Group plc or its affiliates or subsidiaries. > Thank you. > > Churchill Insurance Group plc. Company Registration Number - > 2280426. > England. > > Registered Office: Churchill Court, Westmoreland Road, Bromley, > Kent BR1 > 1DP. > > > > __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Free Open source PL/SQL Editors / DB management tools
go to freshmeat.net and do a search. Also check out Oracletool and Orasnap. -Joe --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear list! > are U aware of any free open source PL/SQL Editors or freeware/open > source > tools for database management ? > If so , would u please post an URL of a such . > Thanks a lot . > > Andre. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Execution plan optimizer Question
In general, if you set init.ora to RULE and gather statistics, unless you have hints in your SQL, the statistics will be ignored. This may or may not be different than setting to CHOOSE and having no statistics - it depends on your SQL. -Joe --- Shaw John-P55297 <[EMAIL PROTECTED]> wrote: > 8.1.6 on NT > The product that I support is still Rule based. I am planning to > bring it > over to Cost based in the near future. What I wanted to do was to > set the > init parameter to 'RULE' and then run statistics on the database. > My boss > says we can't do this because "the execution plan was different for > the "set > to rule and have statistics" vs. "set to choose and no statistics". > > I haven't heard this before - can anybody point me to the Fine > Manual to > confirm or refute this. Perhaps this is another of those fine urban > legends? > For the time being I am starting out with a small test database. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shaw John-P55297 > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any scripts to check the health of the database
Do a search on Google -- you'll find plenty. -Joe --- Praveen Sahni <[EMAIL PROTECTED]> wrote: > Hi All, > I need to write a report on the health of a database. > Please send if any of us have a scripts and any report format for > the health > of the database. > Thanks in advance > Praveen > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Praveen Sahni > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
What platform are you working on? Windows or Unix? -Joe --- [EMAIL PROTECTED] wrote: > Reposting as I forgot to include a subject line on previous post. > > I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. > How can I just remove all of Oracle 9i without touching Oracle 8i? > > > Thanks > Rick > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: migration MS SQL 6.5 to ORACLE 8i
See otn.oracle.com for Oracle Migration Workbench. -Joe --- Arslan Bahar <[EMAIL PROTECTED]> wrote: > > How !? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arslan Bahar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hardware requirements for large data sets
or processing time requirements?? I suggest Perl. ;-) -Joe --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Shouldn't there be another "goal" like "query the data"? How about > "query > the data while refresh is running"? > > If you're on UNIX, I'm guessing that "dd" and "grep" should do just > about > everything for you... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:29 PM > > > > > > 1-3 terabytes of raw data. ASCII format. Flat files. No > requirement for > > RDBMS > > > > Goal: to be able to "refresh" weekly from tapes/cds/other > sources. > > > > What kinds of software/hardware may be needed to tackle this? > > > > Gary Weber > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gary Weber > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You > may > > also send the HELP command for other information (like > subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Does any one know how to call LDAP from UNIX script ?
You need to do an LDIF export, using the LDAP export tool that came with your LDAP server -- the tools differ between servers. Or you could write your own using one of the Perl LDAP modules. -Joe --- Steven Joshua <[EMAIL PROTECTED]> wrote: > Hello: > > Hope the subject make sense. I'm new to LDAP, and > don't know how it works. > I need to use SQL Loader to load a text file into > Oracle817 Database from a unix box. The file/data > comes from LDAP server. My question is: how do I get > the file/object from LDAP site from my unix script? > > Does anyone has any examples? or know a helpful URL? > > Thanks > > From Steven > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Joshua > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: 8i OCP questions
See http://www.oracle.com/education/certification/faq/index.html?faq4.html "FAQ - Information on Time Restrictions to Finish your Certification Currently there are no time restrictions on how long you can take to complete your certification. However, if Oracle has announced the retirement of your certification track, you must pass all the retiring exams by the published retirement date. Retirement announcements are sent out in email to all who have taken exams in the retiring track and who have current email addresses on file with Prometric. The retirement announcements are also posted on the OCP web site at least 6 months in advance of the actual retirement date." You are then pointed to here http://www.oracle.com/education/certification/news/content.html for info on OCP retirement announcements. 8i OCP retirement has not been announced yet. If they announced the retirement tomorrow, you would still have 6 months. -Joe --- [EMAIL PROTECTED] wrote: > Hi, > > I cannot find any info on Oracle web site concerning time allowed > between > test and plans to retire 8i OCP. > Does anyone know or have any links that may state if there is a > time limit > betweeen test and whether Oracle > has plans to retire 8i certification. > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cannot import--URGENT
How was the export created? Do you have the output from the export, or the script that created it? -Joe --- Ravindra B <[EMAIL PROTECTED]> wrote: > I am trying to import from my production database to another > database.Table level export > was done on the production databse for 4 table.It ended w/o any > errors. > > When I am trying to import to anther user on a different datasbe > the import compltes > successfully without any warning but no table/records are imported > The tables being imported are not existing in the new user's > schema. > I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. > > These tables on the production database are protected so I can > export them > only as sys user.I am attaching the log from the import.What is the > problem. > Am i missing anything > > imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp > log=g.log > > Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - > Production > With the Partitioning option > JServer Release 9.0.1.1.1 - Production > > Export file created by EXPORT:V08.01.07 via conventional path > import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR > character set > export client uses WE8ISO8859P1 character set (possible charset > conversion) > export server uses US7ASCII NCHAR character set (possible ncharset > conversion) > Import terminated successfully without warnings. > > Ravindra > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: News.
I think that the key words in the article are "worldwide new license revenue" NOT market share... -Joe --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote: > So how big a market share does DB2 itself command? They don't say. > Big > deal, so IBM-Informix have slightly more market share than Oracle. > If > Oracle had bought Informix the shoe would be on the other foot. > Again, big > deal! > > Ken Janusz, CPIM > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, May 14, 2002 10:08 AM > > > > Gartner: IBM Steals Database Crown from Oracle > > > > IBM has dislodged Oracle Corp. from the top of the market for > database > > management software, helped along by its billion-dollar purchase > of > Informix > > Corp., according to new figures being released today by Stamford, > > Conn.-based Gartner Inc. > > > > In 2001, IBM and Westborough, Mass.-based Informix captured a > combined > 34.6% > > of worldwide new license revenue from database management > systems, besting > > Oracle's 32%, Gartner said. In 2000, the totals were 33.7% for > IBM-Informix > > and 34.1% for Oracle. > > > > The market as a whole generated $8.8 billion in revenue, growing > just 1.4% > > from the previous year. In contrast, revenue climbed a brisk 10% > from 1999 > > to 2000, Gartner said. > > > > Most database management systems vendors saw single-digit or > negative > > growth, although Microsoft Corp. was a notable exception, Gartner > said. > The > > software giant saw revenue from new database management systems > licenses > > climb 17.8%, putting it in third place behind Oracle with 16.3% > of the > > market. Sybase Inc. was a distant fourth with 2.6%. > > > > For more on this story > > > http://computerworld.com/databasetopics/data/software/story/0%2C10801%2C7090 > > 3%2C00.html?nlid=AM __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Probably stupid question about sum of SGA sizes on NT server...
You can exceed the 256Mb, if you don't mind the continual swapping to disk, and the thrashing that comes with that.;-) Usually not a good thing to do. It's usually a good idea to allow some room for the Operating System as well. just remember, Virtual Memory = disk swapping (usually).. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 8:26 AM > Hi folks, > > as the subject indicates, I feel really stupid asking this question, but > here goes... > > If I have several Oracle 8i instances running on an NT Server with, say, > 256Mb of memory available, then does this mean that the sum of the SGA sizes > for all the instances, taken together, can't exceed 256Mb? As I say, it > feels like a stupid question, but the phrase "virtual memory" keeps popping > into my head! > > Paul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vincent > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL-Server Presentation/Reality Check
What do you consider to be the 'challenges' with Oracle's new pricing? On Wednesday 27 June 2001 14:31, you wrote: > I have the privilege of being tasked to attend a SQL Server presentation to > be conducted by Microsoft at our site. Our company's current take on SQL > Server is that it's to be used only in the case where a packaged > application requires it, or when there are 'tactical' exceptions, while > Oracle is viewed as > being 'strategic'. However, given the 'challenges' with Oracle's new > pricing > methods, there is being given increased consideration to expanding SQL > Server's use. > > Now, I know next to nothing about SQL Server, and while I would appreciate > the > opportunity to learn it, I don't want to go to the presentation and let the > MS marketing droids completely have their way, some reality checks need to > be presented. > > So, what questions/issues/considerations should I raise during the > presentation? > > TIA! > > Jeff T > [EMAIL PROTECTED] Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: _____ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why are my indexes being ignored?
What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: >Hi, > >I created an index on a table. The table has about 83,000 rows. The >index is a simple index on one field, 35 different values of the index. I >analyzed the table and I analyzed the index, trying it both with a histogram >and without a histogram. No matter how I do it, it does a full table scan. >Any ideas why? I know I can use a hint, but it seems to me that it ought to >use the index. > > >Bill Carle >AT&T >Database Administrator >816-995-3922 >[EMAIL PROTECTED] > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OUTLN
stored outlines. On Mon, 04 Feb 2002 06:50:27 -0800 "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > Can anyone tell me what the OUTLN user is for? > > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: svrmgrl
It no longer exists -- all related functionality has been incorporated into sqlplus. Read the release notes and bulletins. -Joe On Wed, 06 Feb 2002 10:43:34 -0800 [EMAIL PROTECTED] wrote: > Hi, > Where can I find svrmgrl in 9i. It is not in the same place as 8i. > Thanks > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STATSPACK impact?
I have run it as frequently as once per hour, often times just 2 or 3 times per day - morning, noon, close of business. I have never seen any performance impact, and I don't believe there will be any unless you change the default level of statistics gathering. -Joe On Wed, 06 Feb 2002 12:47:48 -0800 Thomas Jeff <[EMAIL PROTECTED]> wrote: > Just curious, but if your shop uses STATSPACK, could you tell me how > frequently you run it, > particularly in your OLTP databases; and whether you've noticed any > performance issues with > generating frequent STATSPACK snapshots? > > Thanks. > > > Jeffery D Thomas > DBA > Thomson Information Services > Thomson multimedia Inc. > > Email: [EMAIL PROTECTED] > DBA Quickplace: http://gkmqp.tce.com/tis_dba > > > > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Which certification for Oracle DBA ???
It depends on which way you want your career path to go... administrator or developer? it really depends on what you want to do. Why not go for Oracle Master?? (big grin) -Joe --- Jason Rowski <[EMAIL PROTECTED]> wrote: > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jason Rowski > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RedHat Linux 7.2 & Oracle 9i Shutdown
Did you test the scripts from the command line?? /etc/init.d/dbora stop /etc/init.d/dbora start ? -Joe --- Gene Sais <[EMAIL PROTECTED]> wrote: > OS: redhat linux 7.2 > DB: oracle 9.0.1 > Issue: Databases startup but do not shutdown > > I placed the db startup and shutdown scripts in /etc/rc.d/init.d > directories and linked them to rc0.d, rc2.d, rc3.d, rc4.d, rc5.d. > The databases startup fine, however they do NOT shutdown when I > issue "shutdown -r now" command from root. Any clues, hints? > Maybe I have to put the K00* in all rc.d dirs > > Gene > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gene Sais > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle parallel server
Basically, from what I recall Reading in The Fine Manual, (also do a search on OPS and pinging): In a nutshell, If you have two nodes in your OPS setup, you should dedicated one to doing Selects, and the other to doing inserts, updates, and deletes. Disclaimer -- I am not an OPS expert. ;-) -Joe On Thu, 14 Feb 2002 06:18:31 -0800 "Sathish Tatikonda" <[EMAIL PROTECTED]> wrote: > hi all, > > we are using oracle 8i as our database server. So we have to user OPS > and not RAC version which comes with 9i. So in light of the above could > you please give me any pointers for application planning and data > partitioning. I have some documents on OPS which says this is the most > important aspect of implementation. > > thanks in advance, > Sathish. > > -Original Message- > Sent: Thursday, February 14, 2002 6:48 PM > To: Multiple recipients of list ORACLE-L > > > Sathish, > > Under Oracle's RAC in 9i you don't need to do any of this. > > Dick Goulet > > Reply Separator > Author: "Sathish Tatikonda" <[EMAIL PROTECTED]> > Date: 2/14/2002 12:33 AM > > Hi all, > > Have you implemented or worked with oracle parallel server. If yes could > you please point or me some resources about application planning and > partitioning. > > thanks in advance, > Sathish. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sathish Tatikonda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sathish Tatikonda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Personal Experiences in Oracle
> I'm doing as much research as possible in preparation for a possible career change >as an Oracle DBA/P. I would appreciate some feedback on what your personal >experience has been: What is your current background??? and why do you want to change? > i.e., > Are you happy with your career in DBA? yes. > Has the training been worth it? yes. > What skills/abilities/personality traits do you feel are important? problem solving skills, communication skils, able to plan ahead, work with little sleep at times, be able to shoulder responsibility, be on-call and carry a pager! > What is a typical "day in the life" of a DBA? depends > Is your workday isolated, or do you have opportunities to interact with others? it depends > Are positions predominately in small or large companies? both > Do you feel you have solid job security? HAH! used to - until 8/1/2001, been working part-time (10/hrs per week) since then --- many resumes sent out, many interviews -- market is flooded with Oracle DBA talent. > What is your opinion of the current and future job market? > etc.! See previous answer. -Joe _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hours to support an Oracle database per week, documented somewher
Wow, what an open question How many instances? How big of a database? How many users? Development or production? What type of application? Amount of change management required? Unix or Windows? I could go on and on. -Joe On Fri, 22 Feb 2002 07:38:31 -0800 "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > > I have received the following from one of my co-workers at a client site. > Any links, docs, thoughts, gripes, complaints, help would be appreciated. > Thanks. > > -- > I am looking for any documentation out there on Oracle support - like the > amount of effort to support an oracle database. The client insists that our > revised estimate of 6 hours per week is too high. Do you know of anything > we can use as an independent data source??? Gardner document something from > Oracle etc I have looked, but can find nothing. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert is very slow
If you care to post your perl code, or send it to me offline, I can take a few minutes to look at it. -Joe --- Mohammed Shakir <[EMAIL PROTECTED]> wrote: > We use ForAll for insert and it works fine. However, we do not use > prepare_cached or execute. We use bind variables with our static > SQL > and insert millions of records and it is fast. > > --- Gavin D'mello <[EMAIL PROTECTED]> wrote: > > MessageI'm trying to do a bulk insert using DBI and Oracle for > about > > 248 rows, > > this is proving to be pretty slow and expensive. Is there anyway > > where I can > > do a bulk insert ? I am using prepare_cached and execute with > > parameters > > . > > > > > > Thanks so much, > > > > Gavin > > > > - Original Message - > > From: Cunningham, Gerald > > To: Multiple recipients of list ORACLE-L > > Sent: Saturday, March 02, 2002 2:13 AM > > Subject: RE: Which FM??? > > > > > > > > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch3.htm > > -Original Message- > > From: Rodd Holman [mailto:[EMAIL PROTECTED]] > > Sent: Friday, March 01, 2002 1:53 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Which FM??? > > > > > > I'm looking for descriptions of the more cryptic columns in > some > > of the V$'s. Anyone know which FM those are in? > > > > TIA > > > > Rodd > > > > > > > > > = > Mohammed Shakir > CompuSoft, Inc. > 11 Heather Way > East Brunswick, NJ 08816-2825 > (732) 672-0464 (Cell) > (732) 257-6001 (Home) > > __ > Do You Yahoo!? > Yahoo! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohammed Shakir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you use RMAN?
Do you have tape software such as Legato or NetBackup? I have used it very successfully with both - makes backup and recovery a breeze. -Joe --- "Carle, William T (Bill), ALINF" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm in the process of upgrading my database to 9i and I was > trying to decide whether I wanted to change my backup strategy to > use RMAN. Do most of you use it? If you use it, what is your > opinion of it? If you don't use it, why did you decide not to? > > > Bill Carle > AT&T > Database Administrator > 816-995-3922 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Carle, William T (Bill), ALINF > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installation in Unix
Come on Ramon, ever use OTN or read documentation? See http://otn.oracle.com/docs/products/oracle8i/content.html , - scroll down until you find your platform and read the Installation Guide and Release Notes. They should also be on your CD. -Joe --- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote: > Come on list, need your help, never deal with oracle in unix > before. > > Any link, document or something to help me to install Oracle 8.1.7 > in unix. > > Ramon > > __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cost vs Rule
How much have you played with Oracle Hints??? -Joe --- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote: > I work in a dev shop - most of the sql is canned and pretty basic. > We've > been running CBO in all of our dev environments, but we have a few > long txns > that just take forever. At the request of some savvy developers, I > turned > on RBO, and it brought down execution times dramatically. > > I've been analyzing affected tables often (we do a lot of bulk > load/unload > for testing), and have played with partitioning and clustering, > particularly > on one table that's just a dog. CBO will always do a FTS where RBO > uses the > PK to retrieve data. > > Where to go next? I've been unable to alter the costs dramatically > enough > to make any real difference in execution time. > > thx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Magaliff, Bill > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions
Try Amazon Oracle 8 to 8i Upgrade Exam Cram (Exam: 1Z0-020) http://www.amazon.com/exec/obidos/ASIN/157610737X/qid=1015956097/sr=8-1/ref=sr_8_7_1/104-0428629-4654355 Also http://studyguides.cramsession.com/cramsession/oracle/Oracle8iupgrade/default.asp -Joe --- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Greetings All, > > Could you please send me the name & author of the books, or any > sample questions for Oracle 8i new features upgrade test. > > For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide > by Couchman and it was helpful. > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cost vs Rule
How much have you played with Oracle Hints??? -Joe --- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote: > I work in a dev shop - most of the sql is canned and pretty basic. > We've > been running CBO in all of our dev environments, but we have a few > long txns > that just take forever. At the request of some savvy developers, I > turned > on RBO, and it brought down execution times dramatically. > > I've been analyzing affected tables often (we do a lot of bulk > load/unload > for testing), and have played with partitioning and clustering, > particularly > on one table that's just a dog. CBO will always do a FTS where RBO > uses the > PK to retrieve data. > > Where to go next? I've been unable to alter the costs dramatically > enough > to make any real difference in execution time. > > thx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Magaliff, Bill > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). <>
Re: Snapshots VS Materiazlized Views
There is no difference -- a snapshot and a materialized view are the same thing Snapshots and snapshot logs were originally created for use with replication, then Oracle realized how useful they could be for query rewrite, so they renamed them materialized views. Take a look at the docs, and you'll see that the syntax is interchangable. -Joe --- Todd Carlson <[EMAIL PROTECTED]> wrote: > Hello All, > > Sun 5.8 Oracle 8.1.7.2 > At a client site the developers are building an application that > runs > against several data-marts. The marts have tables with many 16+ > million > record tables. I have explained to them that read-only materialized > views would help speed up some of their queries. > > The local developers are pushing the use of snapshots, I would like > to > use materialized views. I do not have much experience with either > one. I > have been unable to find a good comparison of snapshots vs. > materialized > views. When should one be used over the other? What are the > dvantages/disadvantages of either one in this situation? I know > that > query rewrite only works with MVs, but that isn't a factor in this > situation. > > Thank you for any information you can provide. > > Todd Carlson > Oracle Database Administrator > Tripos, Inc. > (314) 647-8837 Ext.3246 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Todd Carlson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). ______ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS Job vs C Daemon
Possibly a candidate for Oracle Advanced Queueing? -Joe --- Connor McDonald <[EMAIL PROTECTED]> wrote: > dbms_job is the way to do since if you rollback the > txn, then the job submission will also roll back > > hth > connor > > --- Alroy Mascranghe <[EMAIL PROTECTED]> wrote: > > > Several programs writes to a table. From that table > > a process has to be > > initiated. (Currently it is working on a trigger but > > this is causing locking > > problems). What would be the best way to do this - > > to read the table and > > start the process ? A PRO C daemon or a DBMS job ? > > What are the advantages > > and disadvantages of each ? > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Alroy Mascranghe > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > = > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the statue" > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cannot create bitmap index "feature not enabled"
It's only available in Enterprise Edition, see docs at http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76962/ch4.htm#52939 -Joe --- [EMAIL PROTECTED] wrote: > Hi All, > > Oracle 8.1.6 SE > > I tried to create a bitmap index and but get feature not enabled. > This > cannot be only available in EE. Is there some script I need to run > to > enable creation of bitmap indexes. I have searched MetaLink but see > no > restrictions. > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Use of Orastaff
I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > I am assuming that since Orastaff continues to post positions on > to this > > list that they are reputable. Is there anyone out there that is > willing > > to share their experiences with this company. Did you get > interviews? > > Did you obtain a position? etc > > > i have sent my resume to them on a couple of occasions. i have not > > received any interviews from them. > > > > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Performance is easier to add than clarity. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Direct Import of XML file
Search otn.oracle.com for the XML Developers toolkit, XDK. --- [EMAIL PROTECTED] wrote: > Hi list, > > Is there any tool in Oracle to import a xml-file direct to a > database table? > > TIA > > Volker Schoen > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.inplan.de <http://www.inplan.de> > > > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remote DB Installation
Just a few options - I'm sure there are others that I haven't listed: 1) VNC from AT&T Labs http://www.uk.research.att.com/vnc/ VNC needs to be installed on client and server. 2) (method I use for Unix/Linux remote installs) SSH w/ X11 tunneling You'll need a local X Server - either buy one that runs on Windows (not sure if any free ones still exist), or I use my Linux machine with XFree86. See ssh docs for details on ssh tunneling. -Joe --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote: > I have a possible opportunity to install an Oracle DB (8i or 9i) > for a company located in Central America. I am located in the > Minneapolis / St. Paul, MN area. What tools would I need to > install this remotely from MN? The server would probably be Sun or > HP unix. > > Thanks, > Ken Janusz, CPIM > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stand-by (Oracle9i Data Guard) vs. Replication
What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Stand-by (Oracle9i Data Guard) vs. Replication > > Folks, > > I have a mission critical system we are architectonic right now. > There is some argument of the merits of replication vs. using > Standby database going on. > > Current we have 4 sites that we will be replicating data back and > forth between. There are 3 kinds of data: > > 1. Network Critical data (must be available for entire network) > 2. Regional Critical data (only used for a given region. site = > region). > 3. Regional non-critical data (this is data that is easily > recovered from > other operational data stores). > > I can load you up with details, but for now this is the general > requirement. We want a given site to be able to work independently > of the other sites in the event of network failure (WAN). > > What I'm looking for is your experience with using replication > for HA solutions vs. stand-by databases. I've also considered using > standby databases as a possible solution to this problem, along > with > using transportable tablespaces to re-sync the databases once > everything > comes up. I'm concerned with replication in that there is allot to > break, > and I'm concerned about synchronization issues in general with > either > solution. > > Thoughts? > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's > conscience can > take his freedom away from him. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Production Oracle DBA Needed in Rochester, Minnesota
-- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > -------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to move a databse from Solaris to Llinux
Even transportable tablespaces aren't an option between different OSes >From 8.1.7 docs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76965/c03space.htm#5759 "In the current release, you can transport tablespaces only between Oracle databases that use the same data block size and character set, and that run on compatible platforms from the same hardware vendor." -Joe _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Resizing Log file
You need to add new log groups/members of the appropriate size, and drop the old ones. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 3:38 PM > hi dba's, > > In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm > having only two groups with a single member each. > > I tried with alter database command, there is only options for adding and > droping log group or member... > > How can i resize it.. to increase the size 5mb. > > Regards, > Nirmal. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nirmal Kumar Muthu Kumaran > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TUSC and Kevin Loney
See: http://www.tusc.com/oracle/news/20010222a.html WORLD-RENOWNED ORACLE EXPERT KEVIN LONEY JOINS TUSC CHICAGO (Feb. 22, 2001) -- TUSC, "the Oracle Experts," has announced a second major appointment in the past week with the hiring of world-renowned Oracle database administrator Kevin M. Loney. I found this on http://www.kevinloney.com/whatnews.htm -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 04, 2001 3:56 PM > Kevin Loney does work for TUSC and has for some time now. > > > >From: John Kanagaraj <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: TUSC and Kevin Loney > >Date: Mon, 04 Jun 2001 11:31:38 -0800 > > > > >I guess I am the last to discover this, but Kevin now works for TUSC. > > > >No Patrice - you were not the last! I thought Kevin was 'independent', so > >where did you get this info from? Anyway, TUSC is big in the Oracle area, > >and I wouldn't be surprised. > > > >John Kanagaraj > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: John Kanagaraj > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: problems when running dbstart
See http://tahiti.oracle.com/pls/tahiti/tahiti.initora for a list of all init params.. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 9:51 AM Thanks for your help, now it doesn't complain about "open_links" when i rename it. Now it's problem with the "max_transaktion_bransches". Should I rename that variable too? /Mikael > -Ursprungligt meddelande- > Från: Danisment Gazi Unal (Unal Bilisim) > [SMTP:[EMAIL PROTECTED]] > Skickat: den 6 juni 2001 15:01 > Till: Multiple recipients of list ORACLE-L > Ämne: Re: problems when running dbstart > > Hello Mikael, > > Rename open_link parameter in paremeter file init.ora or init.ora to > open_links. > > Mikael Granhed wrote: > > > Hi, > > I have oracle 8.06 installed on Sun Solaris. I have problems starting > the > > database after a system crash and I had to reboot the system. When i run > > dbstart I got the following error message: > > > > SVRMGR> connected > > SVRMGR> oracle instance shut down > > SVRMGR> > > Server manager complete > > ... > > ... > > ... > > > > SVRMGR> connected > > SVRMGR> LRM-00101: unknown parameter name 'open_link' > > ORA-01078: failure in processing system parameters > > SVRMGR> server manager complete > > > > It's probably a very simple error but I'm a newbie in this area. > > > > regards > > /Mikael > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mikael Granhed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Web: http://www.unal-bilisim.com > * > Questions and Answers: http://www.unal-bilisim.com/qa/discus/ > * > itrprof SQL Analyzer: > http://www.unal-bilisim.com/products/itrprof/itrprof.html > > itrprof SQL Analyzer is a web based tool which analyzes > SQL_TRACE/Event10046 trace files of Oracle, > finds bottlenecks and offersinformation on how to tune them. > * > iOraBugFinder: > http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html > > iOraBugFinder is a web based tool which scans Oracle's alert log files, > ORA-600 and ORA-7445 trace files; extracts relevant information from them > and generates URL links to relevant bugs, notes, forums at Metalink. > * > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Danisment Gazi Unal (Unal Bilisim) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Working from home
We only use Unix(Solaris) or Linux - no Windows NT. This makes remote administration much easier. I work closely with our System Administration team so that I always have Secure Shell access to any machine that I need to administer, as well as ssh w/ X forwarding for any machine that I need to install Oracle on. Communication is handled thru email, conference calls, instant messenger tools, and soon to be netcam conferencing. Accountability - many of the project managers that I work for ask for weekly reports - and many will send an instant message or phone call if they want a status update. I make sure that I communicate clearly, often, and as pro-actively as I can. We use newsgroups and mailing lists for much of our communication. You are correct in the fact that most of the benefits are to the employee, but I have tried to make the company benefit as well. For example, I have no desk space at the office - I need to use a guest cubicle the few times a year that I go there. I have all interested parties initiate any phone calls, so that I do not need to expense my phone bill. I have a virtual phone at the office -- no phone rings when you call my extension there, you just get my voice mail. I make sure that I am available during off-hours, to do database maintenance and production changes and releases, and I make sure that people know I am always available to do so. Some unforeseen problems? H... nothing that a fax machine, Airborne/Fedex, or other technology hasn't been able to get around. Sometimes conference calls are tough, when you can't see the whiteboard with the drawings on it, but I get faxed drawings later. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 13, 2001 6:00 PM > Hi All, > > I have a few off-topic questions for those of you who are allowed to work > from home either occasionally or on a regular basis. My department is > putting a proposal together to present to management and we're looking for > any information you could provide. How did you handle accountability? How > did you handle communication between work and home? What were some of the > unforeseen problems that you encountered? Were there any specific company > benefits? (This appears to be more a benefit to the employee than to the > company.) Thanks to all who can reply. > > Mark > > > Production: In Progress: > Oracle 7.3.4.4 Oracle 8i > Oracle Apps (Fin/Mfg) 10.7SC Oracle Apps (Fin/Mfg) 11.5.3 > Sun Solaris 2.6 Sun Solaris 8 (2.8) > > > Mark Willett > Corporate Database Administrator > - >Sunnen Products Company >7910 Manchester Ave >Maplewood, Missouri 63143 USA > Voice: 314.781.2100 x2429 > Fax: 314.951.2749 > E-mail: [EMAIL PROTECTED] > > > The statements and opinions expressed herein are my own and do not > necessarily reflect those of Sunnen Products Company. > > --- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Willett, Mark > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > _____ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i database for Linux available for download on Technet
Enjoy _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i On Linux
>From Linux release notes: http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf The following requirements must be met to perform a typical Oracle9i software installation. Memory: A minimum of 512 MB of is required to install Oracle9i Server. A minimum of 512 MB is required to install Oracle9i Management and Integration. A minimum of 128 MB is required to install Oracle9i Client. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 4:20 PM > Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? > > Thank, > > Waleed > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing oracle remotely
I use Secure Shell (ssh), with X11 tunneling/forwarding. For this to work, you need to be running an X server on your local machine. If you are running Linux or any version of Unix locally, you should be set. If you are running any version of Windows, you will need to download and install an X Server. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 18, 2001 2:17 PM > Hi > > Is it possible to install oracle 8i from remote site > say thru telnet. What i know is oracle 8i installation > is gui based. I tried a lot but was not able to > install remotely. Can anyone help me in solving this > problem. Also if it is possible to install oracle > remotely please tell me how to do it. > > Regards > > Brijesh > > __ > Do You Yahoo!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brijesh Lal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP
I work for a consulting firm that specializes in iPlanet offerings. iPlanet offers a web server, application server, and LDAPand more. See http://www.iplanet.com/ Somewhat in competition? At my firm, they are in direct competition. I am presenting Oracle 9iAS this Friday to the group, to see if they will even consider an in-house 9iAS trial. -Joe > Related to this, I seem to recall reading something the > other day that led me to believe that iPlanet is somewhat in > competition with Oracle's app server product. Does anyone > know if this is true? > > Best regards, > > Jonathan Gennick > mailto:[EMAIL PROTECTED] * 906.387.1698 > http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
