RE: Automatic backup on Oracle 9i -- For Jared
Even though i strongly think that there is nothing wrong in writing U instead of you, respecting your feelings towards the list, and considering the fact that we must think above such small matters, I will be careful in future. Thanks. OraCop. --- Martin Kendall <[EMAIL PROTECTED]> wrote: > Although I hate to make my first submission to The > List in 2003 as > negative one, I would still like to suggest that > "text messages" have no > place in a forum such as this. Quite apart from > being needless, such a > message format shows a total lack of respect for the > recipient and a > distinct arrogance towards technology by trying to > interchange a message > format between totally > different media. > > Even if the message in question was indeed in an > acceptable format, the > content clearly shows that no effort has been made > to do any research on > the subject matter. > > I have a deep affection and respect for this List > and how there is such > readily available help from it. So "OraCop", I > would say that you > should > try a more considered approach and you may be > pleasantly surprised. > > > > -Original Message- > WILLIAMS > Sent: 02 January 2003 15:30 > To: Multiple recipients of list ORACLE-L > > Raj - I go through episodes where I get pretty > frustrated with the > cryptic > language, but then I take a deep breath and remember > that for some > people > English isn't their first language. Also, I think > text messages on cell > phones are changing the way many people deal with > English. > I also get irritated with people who won't post > their names. It is > hard > to reply to an anonymous person. But then I recall > that I previously > worked > for a company that wouldn't let me post to > newsgroups. It would be > easier if > people would pick a nom de plume that was more > human, like "Joe Smith". > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > -Original Message- > Sent: Thursday, January 02, 2003 7:40 AM > To: Multiple recipients of list ORACLE-L > > > > As far as we know there is no bandwidth limit on > this list and problems > can > be understood better if you state them in a lucid > and clear language. I > had > to really read twice (sorry haven't had my "Great > One" yet) to > understand > the abbreviations. > > Am I the only one or is there anyone else who has > trouble with such > language? > TIA > Raj > __ > > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't > reflect that of ESPN > Inc. > > QOTD: Any clod can have facts, but having an opinion > is an art! > > > -Original Message- > Sent: Tuesday, December 31, 2002 12:34 PM > To: Multiple recipients of list ORACLE-L > > > Jared what exactly U use Veritas Netbackup fr in Ur > backup strategy. I > use > rman to take backup on disk. Please describe the > role of veritas NB in > detail and > > if u can send me example script to perform what > tasks, that would be > gr8. > OraCop > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > 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). > > > ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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: Automatic backup on Oracle 9i -- For Jared
Well, I understand that writing "you" is not much trouble compared to writing "U", but understanding "U", should not be much trouble either. Don't U think so? OraCop. --- [EMAIL PROTECTED] wrote: > I have never known what lol stood for , I > appreciated the general meaning > by looking at the context it was used in but > know I actually know. > I knew that if I perservered long enough with this > list long enough I would > find something of interest (lol) > > John > > -Original Message- > Sent: 02 January 2003 15:30 > To: Multiple recipients of list ORACLE-L > > > I have philosophical trouble with it. I dislike the > abbreviations. I > will use abbreviations to condense phrases (lol for > lots of laughs) but > I really dislike seeing "you" written as "u". It's > not that hard to > type the extra two letters. > > --- "Jamadagni, Rajendra" > <[EMAIL PROTECTED]> wrote: > > As far as we know there is no bandwidth limit on > this list and > > problems can > > be understood better if you state them in a lucid > and clear language. > > I had > > to really read twice (sorry haven't had my "Great > One" yet) to > > understand > > the abbreviations. > > > > Am I the only one or is there anyone else who has > trouble with such > > language? > > TIA > > Raj > > > __ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't > reflect that of > > ESPN Inc. > > > > QOTD: Any clod can have facts, but having an > opinion is an art! > > > > > > -Original Message- > > Sent: Tuesday, December 31, 2002 12:34 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Jared what exactly U use Veritas Netbackup fr in > Ur backup strategy. > > I use > > rman to take backup on disk. Please describe the > role of veritas NB > > in > > detail and > > if u can send me example script to perform what > tasks, that would be > > gr8. > > OraCop > > > > *This > > e-mail message is confidential, intended only for > the named > > recipient(s) above and may contain information > that is privileged, > > attorney work product or exempt from disclosure > under applicable law. > > If you have received this message in error, or are > not the named > > recipient(s), please immediately notify corporate > MIS at (860) > > 766-2000 and delete this e-mail message from your > computer, Thank > > > you.*1 > > > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Rachel Carmichael > 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: <[EMAIL PROTECTED] > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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).
Direct privs vs Acess thru a role
Hello, How does Direct grant access differs from an access thru a role? and *WHY*? Thanks. OraCop __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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: Automatic backup on Oracle 9i -- For Jared
Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still <[EMAIL PROTECTED]> wrote: > > MetaLink is Oracle's support site. > > metalink.oracle.com > > No, I don't think your explanation is complicated, I > just > don't use OEM. > > I fired it up to take a look, but the backup portion > requires > the OEM repository to be setup, so I didn't learn > anything. > > Yes, I *do* make backups, but use RMAN directly with > > Veritas NetBackup. > > Jared > > On Friday 27 December 2002 19:44, Sony kristanto > wrote: > > Jared, > > Thanks Jared for your opinion, perhaps my > explaination ain't quite right so > > it looks like complicated but I will try to give > detail explaination. By > > the way what is MetaLink ? > > > > Rgrds, > > > > Sony > > > > > -Original Message- > > > From: Jared Still [SMTP:[EMAIL PROTECTED]] > > > Sent: Saturday, December 28, 2002 9:40 AM > > > To: Sony kristanto; [EMAIL PROTECTED] > > > Subject: Re: Automatic backup on Oracle 9i > > > > > > > > > Hmm > > > > > > A lot of folks on this liststudiously avoid > OEM. I know I do, > > > and I'm not going to be much help on this. > > > > > > Have you tried MetaLink? > > > > > > Jared > > > > > > On Friday 27 December 2002 17:11, Sony kristanto > wrote: > > > > Yes, that's right Jared, by doing this we can > make schedule when we > > > > want > > > > > > to > > > > > > > backup our data onto hard disk or tape > periodicaly (weekly or daily > > > > even hour), thanks for your response and > wishing you can help me to > > > > solve it. > > > > > > > > > -Original Message- > > > > > From: Jared Still [SMTP:[EMAIL PROTECTED]] > > > > > Sent: Friday, December 27, 2002 10:06 AM > > > > > To: [EMAIL PROTECTED]; Sony kristanto > > > > > Subject: Re: Automatic backup on Oracle 9i > > > > > > > > > > > > > > > Sony, > > > > > > > > > > What is an 'automatic' backup? > > > > > > > > > > Is this something supplied by that 'Oracle > Enterprise Manager' > > > > > thingy? > > > > > > > > > > Jared > > > > > > > > > > On Thursday 26 December 2002 17:23, Sony > kristanto wrote: > > > > > > Hi Listers, > > > > > > I'm new on Oracle Database 9i after I > migrated from Oracle 8i. > > > > > > I try to use backup facility from Oracle > 9i and I already follow > > > > > > the instructions how to activate the > automatic backup but when I > > > > > > see the > > > > > > > > > > status > > > > > > > > > > > on history I get an error comment > 'Failed'. I've try again and > > > > > > again but the results are the same. Could > someone out there tell me > > > > > > why it can't runs. For your note I use > 'SYS' as my user. I will > > > > > > really appreciate > > > > > > > > > > your > > > > > > > > > > > help. > > > > > > > > > > > > Rgrds, > > > > > > > > > > > > Sony > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jared Still > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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).
Spool file output
This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off set pagesize 0 4- spool off __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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).
Spool file behavior on Solaris
hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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).
Spool output issue on solaris
This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off select * from dual; set termout on set head on set echo on set feedback on 4- spool off Spool file has expected output, which is result of sql statement ONLY! Now when i place following in a shell script and run it #!/bin/ksh $ORACLE_HOME/bin/sqlplus liserv/liserv@webny << EOF set feedback off set head off set echo off set termout off spool output.txt select * from dual; spool off set feedback on set head on set echo on set termout on exit; ___ Now question is that in later case where i use shell script along with out put of query , WHY DO I SEE THE ACTUAL SQL STATEMENT IN SPOOL FILE ALSO? Even though i have feedback, echo and termout off . Any way around. I want ONLY output of query in spool file when sql file is run using a SHELL SCRIPT!. Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop 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: Parsing Column val
output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop <[EMAIL PROTECTED]> wrote: > Yes there is primary key on the table. > > --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > > Looks to me like you have to do this in pl/sql > > unless you can say something > > about the uniqueness of col1 and col2. Is there a > > primary key on the table? > > > > Lisa Koivu > > Oracle Diaper Administrator > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > > > > > -Original Message- > > > From: OraCop [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, December 09, 2002 1:24 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Parsing Column val > > > > > > Hello, > > > One of the column in EACH row has space > saperated > > > values. > > > > > > Example > > > > > > Col1 Col2 Col3 > > > == > > > Hello Worldhe she we > > > oracle rules any doubt > > > > > > Out put should look like > > > > > > > > > Col1 Col2 Col3 > > > == > > > Hello Worldhe > > > Hello Worldshe > > > Hello Worldwe > > > Oracle rules any > > > Oracle rules doubt > > > > > > > > > > > > Please Help. > > > > > > URGENT! > > > > > > Thanks. > > > > > > > __ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > now. > > > http://mailplus.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: OraCop > > > 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!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: OraCop > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Parsing Column val
output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop <[EMAIL PROTECTED]> wrote: > Yes there is primary key on the table. > > --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > > Looks to me like you have to do this in pl/sql > > unless you can say something > > about the uniqueness of col1 and col2. Is there a > > primary key on the table? > > > > Lisa Koivu > > Oracle Diaper Administrator > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > > > > > -Original Message- > > > From: OraCop [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, December 09, 2002 1:24 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Parsing Column val > > > > > > Hello, > > > One of the column in EACH row has space > saperated > > > values. > > > > > > Example > > > > > > Col1 Col2 Col3 > > > == > > > Hello Worldhe she we > > > oracle rules any doubt > > > > > > Out put should look like > > > > > > > > > Col1 Col2 Col3 > > > == > > > Hello Worldhe > > > Hello Worldshe > > > Hello Worldwe > > > Oracle rules any > > > Oracle rules doubt > > > > > > > > > > > > Please Help. > > > > > > URGENT! > > > > > > Thanks. > > > > > > > __ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > now. > > > http://mailplus.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: OraCop > > > 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!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: OraCop > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Parsing Column val
Yes there is primary key on the table. --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > Looks to me like you have to do this in pl/sql > unless you can say something > about the uniqueness of col1 and col2. Is there a > primary key on the table? > > Lisa Koivu > Oracle Diaper Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > From: OraCop [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, December 09, 2002 1:24 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Parsing Column val > > > > Hello, > > One of the column in EACH row has space saperated > > values. > > > > Example > > > > Col1 Col2 Col3 > > == > > Hello Worldhe she we > > oracle rules any doubt > > > > Out put should look like > > > > > > Col1 Col2 Col3 > > == > > Hello Worldhe > > Hello Worldshe > > Hello Worldwe > > Oracle rules any > > Oracle rules doubt > > > > > > > > Please Help. > > > > URGENT! > > > > Thanks. > > > > __ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > > http://mailplus.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: OraCop > > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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).
Parsing Column val
Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Advanced Rep between 9.2.0 and 8.1.7?
Yes, I am replicating between 8.1.7.3 and 9iR2 without any issues. Need help? OraCop --- Michael Barger <[EMAIL PROTECTED]> wrote: > Has anyone heard of or experienced a successful > implementation of Advanced Replication between an > 8.1.7 database and a 9.2.0 db? > > > > __ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Michael Barger > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: [Q] ORACLE 9i remote export "insufficient previlege"?
Very true... But * IF * John's solution does not work then reason for mentioned error is because U probably ran "CATEXP.sql" AGAIN after running CATPROC.SQL. Anyway to correct this simply run "%oracle_home%\rdbms\admin\CATRM.SQL" script connected as SYS or INTERNAL. If CATEXP.SQL was rerun after CATPROC.SQL (this runs CATRM.SQL) the modification made to the EXP_FULL_DATABASE role by CATRM.SQL no longer exist since CATEXP.SQL drops and creates the EXP_FULL_DATABASE role.The privileges granted to the role by CATRM.SQL are necessary to export the resource manager objects. OraCop --- John Thomas <[EMAIL PROTECTED]> wrote: > I think you need a password file on the 9i server to > connect remotely > with SYSDBA privilege. > > Go to $ORACLE_HOME/dbs and use orapwd. You may need > to set an init.ora > parameter along the lines of > remote_password_exclusive or shared > depending upon whether you want multiple users (or > was it databases?) > using the same file to log in remotely as well... > > Cheers, > > John Thomas > > In message > <[EMAIL PROTECTED]>, dist > cash > <[EMAIL PROTECTED]> writes > >I am doing the ORACLE 9iR2 database test and tried > to export form a 8i > >computer to 9iR2 server. I got "ORA-01031: > insufficient privileges". > > > >my export parfile on 8i server is: > > > > > >userid='sys/passwd1@db92 as sysdba' > >file=/tmp/exp_db8i_full.dmp > >buffer=6400 > >compress=n > >grants=y > >indexes=y > >rows=y > >feedback=1 > >constraints=y > >consistent=y > >log=exp_db8i_full.log > >full=y > > > > > > > > > >I got: > > > >Export: Release 8.1.7.2.0 - Production on Tue Nov > 26 14:02:57 2002 > > > >(c) Copyright 2000 Oracle Corporation. All rights > reserved. > > > > > >EXP-00056: ORACLE error 1031 encountered > >ORA-01031: insufficient privileges > >Username: > > > > > >Does anyone know why?? > > > >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.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Thomas > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)
Hello, Are u performing any exception handeling in Ur code? Try to capture oracle err mesg using "USER DEFINED EXCEPTIONS". For more detail look into "DBMS_ERROR_CODE" and "DBMS_ERROR_TEXT " OraCOP --- Charu Joshi <[EMAIL PROTECTED]> wrote: > Hi Arup, > > Thanks for the reply. > > I have checked the trigger code thoroughly and > surely it's not a mutating > trigger. Nor is there any cascade effect or the > trace files would have shown > the statements within that trigger. > > There is some other error occurring, but we are not > able to trap it because > the front-end application just doesn't do error > trapping. > > Is there any way to see the error occurred within > another session? We are > checking trace logs but they don't show any error. > > Thanks & regards, > Charu > > -Original Message- > Sent: Thursday, November 21, 2002 3:32 PM > To: Multiple recipients of list ORACLE-L > required (Distributed transaction) > > Charu, > > I guess the error you are getting is "Table or > Trigger is mutating". and > perhaps you are using an after insert row trigger. > This is a common and > expected problem. There are ways to get around it. > You have not mentioned > the version of Oracle; I would assume 8.1.7 or > later. > > Inside an after insert row trigger, you can not > operate on the table on > which trigger is defined. for instance in your case > the trigger (say, > TRA_LT) on the table LT can't insert into LT inside > it. However if you > define the same in a BEFORE INSERT row trigger, it's > allowed. > > Caution, though, the insert through the trigger will > fire the BEFORE INSERT > trigger too, which in turn will insert a row in LT > and then the trigger > fires again..a vicious cycle. Fortuanately Oracle > breaks the cascading > trigger after 17 atetmpts. So, you need to have a > limiting condition while > defining the trigger WHEN (NEW.STATUS='OLD') or > similar to make sure you can > differentiate between the trigger inserted and the > user inserted rows. > > Finally, if you insert into the table LT using a > construct like INSERT INTO > LT VALUES (...) it works; but if you use INSERT INTO > LT SELECT .. FROM > ANOTHER_TABLE, it does not. this is not documented > anywhere; I found this by > accident. > > Hope this helps. > > Arup Nanda > www.proligence.com > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, November 21, 2002 9:18 AM > (Distributed transaction) > > > Gurus, > > > > Desperately need some ideas to solve this one. > > > > Following is the sequence of events as it happens: > > > > 1. Front-end application (VC++) queries from a > view V. V fetches data from > a > > remote database RD via a database link. > > 2. Front-end inserts a row in a local table LT. > > 3. The Insert trigger on this table queries view V > to take a final stock. > > 4a. If conditions match, the trigger inserts in > remote table RT on RD. NO > > PROBLEM in condition. > > 4b. If conditions don't match, the front-end > application tries to insert > > another row in LT. The trigger starts again and > tries to insert row in RT. > > At this point we SEEM to get the error. > > > > We can't get anybody to debug the front-end > application. We tried setting > > SQL_TRACE TRUE, and the only thing made clear was > that the trigger didn't > go > > beyond trying to insert into RT. > > > > We tried replicating the whole scenario by > executing each and every > > statement that the front-end fires through > SQL*Plus as a script, and it > > doesn't give any error. > > > > I realize that I have given only a fraction of the > whole information, but > > what is the best way to debug this situation? > > > > Are there any do's don'ts in distributed > transactions which our code may > not > > be following? > > > > Thanks in advance, > > Charu > > > > * > 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
RE: 9i Lite
Saira Ji, I never heard of any Oracle lite list/Group. But When ever U encounter an issue with Oracle Lite, U may post it here and we can try to help U out. Thanks. OraCop. --- Saira Somani <[EMAIL PROTECTED]> wrote: > No one uses 9i Lite? Gurus, help me out!!! > > Saira > > -Original Message- > Somani > Sent: November 25, 2002 10:49 AM > To: Multiple recipients of list ORACLE-L > > I wonder if there are any mailing lists out there > for Oracle 9i Lite. Or > for that matter, if any of you have used in the past > or are using it now > and would like to brainstorm once in a while on this > topic. I struggle > with its administration sometimes. > > If you can point me in a direction (other than the > Oracle forums on > their website), I would appreciate it. > > Thanks, > > Saira Somani > IT Support/Analyst > Hospital Logistics Inc. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Saira Somani > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: LONG's
Sorry I missed 2nd part of Ur question. LOB is not a datatype it self. LOB = Long Object. Oracle provides 2 kind of LOBs. CLOB and BLOB If U want to store Binary data, eg pdf files, movies, sound files, etc, use BLOB(Binary long Object). For other U can use CLOB. OraCOp. --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > > How may LONG , LON RAW be Converted to CLOB or LOB ? > Which is Better ? > > Thanks > > -Original Message- > Sent: Tuesday, November 26, 2002 9:24 PM > To: Multiple recipients of list ORACLE-L > > > > Thanks all for the suggestions. I think I'll take a > look at COPY and the > PL/SQL options since I've used them before, and C & > Perl are not in my > repertoire, I'm ashamed to say ;) To shed a little > more light on the > requirement, I'm researching the best (subjective) > way to convert > dictionsry-managed TS's to locally-managed in an > 8.1.7.3, Tru64 hosted DB > running SAP R/3. The convert-in-place procedure > [dbms_space_admin.tablespace_migrate_to_local] does > not change extent > management for the segment. > > Jared, I'd consider converting them, but SAP is a > little posessive of their > Clusters/Pools. > > Mike H. > > -Original Message- > Sent: Monday, November 25, 2002 6:39 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > > > Mike, > > Conner pointed out that you could use C. > > You can also use Perl with DBI and DBD::Oracle if > you like, and have > someone there that can use it. > > Why not just convert them to CLOB and LOB? > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:LONG's > > > OK, so you can't CTAS on tables with LONG or LONG > RAW columns, and now I > find out that the same restriction exists on Alter > Table ... Move. So, > is there any other option to move these tables from > one tablespace to > another without exp/imp or converting them to LOB? > > Thanks, > Mike > > This transmission is intended only for use by the > addressee(s) named > herein and may contain information that is > proprietary, confidential > and/or legally privileged. If you are not the > intended recipient, you are > hereby notified that any disclosure, copying, > distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY > PROHIBITED. If you received this transmission in > error, please immediately > contact the sender and destroy the material in its > entirety, whether in > electronic or hard copy format. Thank you. > > > > +**+ > This transmission is intended only for use by the > addressee(s) named herein and may contain > information that is proprietary, confidential and/or > legally privileged. If you are not the intended > recipient, you are hereby notified that any > disclosure, copying, distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. If you received > this transmission in error, please immediately > contact the sender and destroy the material in its > entirety, whether in electronic or hard copy format. > Thank you. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hand, Michael T > 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.com > -- > Author: VIVEK_SHARMA > 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 > &#
RE: LONG's
U can use To_LOB(long_col) to convert long to Clob/BLOB. OraCop --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > > How may LONG , LON RAW be Converted to CLOB or LOB ? > Which is Better ? > > Thanks > > -Original Message- > Sent: Tuesday, November 26, 2002 9:24 PM > To: Multiple recipients of list ORACLE-L > > > > Thanks all for the suggestions. I think I'll take a > look at COPY and the > PL/SQL options since I've used them before, and C & > Perl are not in my > repertoire, I'm ashamed to say ;) To shed a little > more light on the > requirement, I'm researching the best (subjective) > way to convert > dictionsry-managed TS's to locally-managed in an > 8.1.7.3, Tru64 hosted DB > running SAP R/3. The convert-in-place procedure > [dbms_space_admin.tablespace_migrate_to_local] does > not change extent > management for the segment. > > Jared, I'd consider converting them, but SAP is a > little posessive of their > Clusters/Pools. > > Mike H. > > -Original Message- > Sent: Monday, November 25, 2002 6:39 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > > > Mike, > > Conner pointed out that you could use C. > > You can also use Perl with DBI and DBD::Oracle if > you like, and have > someone there that can use it. > > Why not just convert them to CLOB and LOB? > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:LONG's > > > OK, so you can't CTAS on tables with LONG or LONG > RAW columns, and now I > find out that the same restriction exists on Alter > Table ... Move. So, > is there any other option to move these tables from > one tablespace to > another without exp/imp or converting them to LOB? > > Thanks, > Mike > > This transmission is intended only for use by the > addressee(s) named > herein and may contain information that is > proprietary, confidential > and/or legally privileged. If you are not the > intended recipient, you are > hereby notified that any disclosure, copying, > distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY > PROHIBITED. If you received this transmission in > error, please immediately > contact the sender and destroy the material in its > entirety, whether in > electronic or hard copy format. Thank you. > > > > +**+ > This transmission is intended only for use by the > addressee(s) named herein and may contain > information that is proprietary, confidential and/or > legally privileged. If you are not the intended > recipient, you are hereby notified that any > disclosure, copying, distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. If you received > this transmission in error, please immediately > contact the sender and destroy the material in its > entirety, whether in electronic or hard copy format. > Thank you. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hand, Michael T > 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.com > -- > Author: VIVEK_SHARMA > 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 comman
Re: Auto restart of Database
Set last argument for appropriate SID in oratab = Y to restart DB at boot time. --- OraCop <[EMAIL PROTECTED]> wrote: > How can I setup my server/database sothat after > reboot > of my Solaris server, database and listener start > automatically? > > Thanks. > > > __ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: OraCop > 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!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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).
Auto restart of Database
How can I setup my server/database sothat after reboot of my Solaris server, database and listener start automatically? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: SERACH FAST
U can use Oracle intermedia/"Oracle Text"/Ultra search. what kind of data Ur performing this search on. What is the datatype of the data? How exactly U r trying to search right now? U need to gather all this information? OraCop --- Seema Singh <[EMAIL PROTECTED]> wrote: > Oracle 8.1.6, > > > > > > > >From: OraCop <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >Subject: Re: SERACH FAST > >Date: Wed, 13 Nov 2002 08:15:19 -0800 > > > >Seema Ji, > >Are U using "Oracle Search" for this purpose? > > Are u using search indexes and using them > >correctly? > >What version of Oracle? > > > >Regards. > > > >OraCop > > > > > >--- Seema Singh <[EMAIL PROTECTED]> wrote: > > > Hi > > > How to make search fast? We are building some > > > application and this > > > application need to build more efficient fast > > > search. > > > WIth regards > > > -Seema > > > > > > > > > > > > > > > > > > > >_ > > > Protect your PC - get McAfee.com VirusScan > Online > > > > >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Seema Singh > > > 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!? > >U2 on LAUNCH - Exclusive greatest hits videos > >http://launch.yahoo.com/u2 > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >-- > >Author: OraCop > > 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). > > > _ > The new MSN 8: advanced junk mail protection and 2 > months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Seema Singh > 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!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Whitepapers on Triggers
We call them Journal tables. Great technique. OraCop --- "Lisa R. Clary" <[EMAIL PROTECTED]> wrote: > Since we are in the medical records business, we too > have the same > guideline. What we do, is create an exact table > replica (we call it an > archive table and it does not have constraints) to > which before every insert > and update on the primary table, sends the row data > to the archive table. It > stores the modifier and sysdate as well, so we have > a complete history of > revision. We don't allow deletes through users, only > through dbas so that we > can audit removals. Doing it this way eliminates > that possibility of the > fudge-factor on revisions/deletions. And when you > are audited---it is a > wonderful thing! > > lc > > -Original Message- > Sent: Wednesday, November 13, 2002 11:49 AM > To: Multiple recipients of list ORACLE-L > > > This is for FDA regulation compliance. The audit > records need to show every change made to the > source table in order of change. > WHile audit the table will show who changed the > record, it won't show what was changed. > > Steve > > > --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > > In my browsing of the oracle docs I came across > > a sql statement call > > AUDITING. > > Why invent triggers when oracle does the work > > for you? > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > Sent: Friday, November 08, 2002 6:59 PM > > > > > > > Listers, > > > > > > Oracle 8.1.7 > > > > > > I am looking for any whitepaper(s) that can > > > provide guidelines on the creation, use, > > > performance and limitations of triggers. > > > > > > I need to create triggers on possibly 45 > > tables > > > for auditing purposes. The first draft > > > requirements document indicates denormalizing > > > data and generating data for null columns > > using > > > the triggers (yeah, bad ideas). I prefer to > > make > > > them as simple as possible and would like to > > have > > > the best arguments against doing it the way > > the > > > requirements suggest. > > > > > > TIA, > > > > > > Steve Haas > > > > > > "Opinions, real or imagined, are mine." > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Steven Haas > > > 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.com > > -- > > Author: Yechiel Adar > > 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.com > -- > Author: Steven Haas > 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 >
Re: SERACH FAST
Seema Ji, Are U using "Oracle Search" for this purpose? Are u using search indexes and using them correctly? What version of Oracle? Regards. OraCop --- Seema Singh <[EMAIL PROTECTED]> wrote: > Hi > How to make search fast? We are building some > application and this > application need to build more efficient fast > search. > WIth regards > -Seema > > > > > > _ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Seema Singh > 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!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop 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: Backup/Restore
Stephen: Thanks a lot for Ur response.
How do U restore from the backup?
have a script?
--- Stephen Lee <[EMAIL PROTECTED]> wrote:
>
>
> You don't say if you are using catalog or not. If
> not, be sure to backup
> control files at end of backup. For what it's worth
> here is what I do for
> disk backups and no catalog. Business critical
> databases use catalog and go
> directly to tape using Networker (P.O.S. ... at
> least on Tru64). I have
> separate scripts for database and log files in case
> the archived log
> destination gets dangerously full (monitored by cron
> job).
>
> For database:
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_DATA';
> set command id to 'rman';
> backup
>tag backup_db_full
>(database include current controlfile);
> release channel ch1;
> }
>
>
> For log files (we are duplexing on this database):
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_ARCH';
> set command id to 'rman';
> change archivelog all crosscheck;
> backup
>(archivelog all delete input);
> backup
>(archivelog like
> '/oracle/app/oracle/admin/HRP1/arch2/%' delete
> input);
> release channel ch1;
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_CONTROL';
> backup current controlfile tag='backup';
> release channel ch1;
> sql "ALTER DATABASE BACKUP CONTROLFILE TO
> ''/u05/oracle/admin/HRP1/backup/CONTROL_FILE.BAK''
> REUSE";
> }
>
>
> If the database and all controlfiles got blown away,
> then the
> CONTROL_FILE.BAK is your salvation.
>
> The following "script" is kept handy as a fast
> reference for restoring. I
> run the commands by hand; but the script serves to
> jog my memory as to the
> commands. I've slept since I put this together, but
> I think some of the
> commands are for when you have a catalog.
>
> #!/bin/ksh
>
> ## Define variables for your SID
> export ORACLE_SID=ABCXYZ
> export USER=internal
> export PASS=the_password
>
> ## With Oracle 9.X you must use sqlplus.
> svrmgrl <<-XXX
>connect internal
>startup nomount
>exit
> XXX
>
> rman nocatalog <<-XXX
>connect target ${USER}/${PASS}@${ORACLE_SID}
>
>run {
>
> ### If you have control files, then you don't need
> format when allocating
> channel.
> allocate channel ch1 type disk;
>
> ### When you want to restore up to, but not
> including, a specific log
> sequence number
> ### For example, the database wants log 275, but
> all you have in rman
> catalog are 273 and 274
> #set until logseq=275 thread=1;
>
> ### When you want to restore to a specific time.
> # set until time "to_date('2001-02-09
> 02:00:00','-MM-DD HH24:MI:SS')";
>
> ### Various syntax possibilities for restoring
> control files
> #restore controlfile to
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> # restore controlfile to
> '/u02/oradata/ORACLE_SID/control_02.ctl';
> # restore controlfile to
> '/u06/oradata/ORACLE_SID/control_03.ctl';
> # replicate controlfile from
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> ### The following just restores them all.
> ### DO NOT restore controlfile when doing a point
> in time recovery.
> ### Most likely, you will not restore controlfile
> unless you have lost all
> control files.
> ### If you are not using a catalog, then you must
> copy a backup of the
> control file at the OS level.
> # restore controlfile;
>
> sql 'ALTER DATABASE MOUNT';
> restore database;
> You might or might not need restore
> archivelog.
> When doing backups to disk, you probably don't
> need it.
> # restore archivelog all;
> recover database;
> If control file was restored, then you will
> probably need resetlogs.
> # sql 'ALTER DATABASE OPEN RESETLOGS';
> sql 'ALTER DATABASE OPEN';
>
> release channel ch1;
> }
>
> XXX
>
>
> If you had to restore the controlfiles (or
> hand-copy in backup
> controfiles),
> or if you lost online redo log(s), or if you
> are missing archived
> log(s),
> then, you will likely need to recover the
> database by hand using one
> or
> more of the following commands.
>
> ## With Oracle 9.X you must use sqlplus.
> ##svrmgrl <<
RE: Backup/Restore
Stephen: Thanks a lot for Ur response.
How do U restore from the backup?
have a script?
U r not using veritas?
Thanks.
OraCop.
--- Stephen Lee <[EMAIL PROTECTED]> wrote:
>
>
> You don't say if you are using catalog or not. If
> not, be sure to backup
> control files at end of backup. For what it's worth
> here is what I do for
> disk backups and no catalog. Business critical
> databases use catalog and go
> directly to tape using Networker (P.O.S. ... at
> least on Tru64). I have
> separate scripts for database and log files in case
> the archived log
> destination gets dangerously full (monitored by cron
> job).
>
> For database:
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_DATA';
> set command id to 'rman';
> backup
>tag backup_db_full
>(database include current controlfile);
> release channel ch1;
> }
>
>
> For log files (we are duplexing on this database):
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_ARCH';
> set command id to 'rman';
> change archivelog all crosscheck;
> backup
>(archivelog all delete input);
> backup
>(archivelog like
> '/oracle/app/oracle/admin/HRP1/arch2/%' delete
> input);
> release channel ch1;
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_CONTROL';
> backup current controlfile tag='backup';
> release channel ch1;
> sql "ALTER DATABASE BACKUP CONTROLFILE TO
> ''/u05/oracle/admin/HRP1/backup/CONTROL_FILE.BAK''
> REUSE";
> }
>
>
> If the database and all controlfiles got blown away,
> then the
> CONTROL_FILE.BAK is your salvation.
>
> The following "script" is kept handy as a fast
> reference for restoring. I
> run the commands by hand; but the script serves to
> jog my memory as to the
> commands. I've slept since I put this together, but
> I think some of the
> commands are for when you have a catalog.
>
> #!/bin/ksh
>
> ## Define variables for your SID
> export ORACLE_SID=ABCXYZ
> export USER=internal
> export PASS=the_password
>
> ## With Oracle 9.X you must use sqlplus.
> svrmgrl <<-XXX
>connect internal
>startup nomount
>exit
> XXX
>
> rman nocatalog <<-XXX
>connect target ${USER}/${PASS}@${ORACLE_SID}
>
>run {
>
> ### If you have control files, then you don't need
> format when allocating
> channel.
> allocate channel ch1 type disk;
>
> ### When you want to restore up to, but not
> including, a specific log
> sequence number
> ### For example, the database wants log 275, but
> all you have in rman
> catalog are 273 and 274
> #set until logseq=275 thread=1;
>
> ### When you want to restore to a specific time.
> # set until time "to_date('2001-02-09
> 02:00:00','-MM-DD HH24:MI:SS')";
>
> ### Various syntax possibilities for restoring
> control files
> #restore controlfile to
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> # restore controlfile to
> '/u02/oradata/ORACLE_SID/control_02.ctl';
> # restore controlfile to
> '/u06/oradata/ORACLE_SID/control_03.ctl';
> # replicate controlfile from
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> ### The following just restores them all.
> ### DO NOT restore controlfile when doing a point
> in time recovery.
> ### Most likely, you will not restore controlfile
> unless you have lost all
> control files.
> ### If you are not using a catalog, then you must
> copy a backup of the
> control file at the OS level.
> # restore controlfile;
>
> sql 'ALTER DATABASE MOUNT';
> restore database;
> You might or might not need restore
> archivelog.
> When doing backups to disk, you probably don't
> need it.
> # restore archivelog all;
> recover database;
> If control file was restored, then you will
> probably need resetlogs.
> # sql 'ALTER DATABASE OPEN RESETLOGS';
> sql 'ALTER DATABASE OPEN';
>
> release channel ch1;
> }
>
> XXX
>
>
> If you had to restore the controlfiles (or
> hand-copy in backup
> controfiles),
> or if you lost online redo log(s), or if you
> are missing archived
> log(s),
> then, you will likely need to recover the
> database by hand using one
> or
> more of the following commands.
>
> ## Wi
RE: Backup/Restore
Stephen: Thanks a lot for Ur response.
How do U restore from the backup?
have a script?
--- Stephen Lee <[EMAIL PROTECTED]> wrote:
>
>
> You don't say if you are using catalog or not. If
> not, be sure to backup
> control files at end of backup. For what it's worth
> here is what I do for
> disk backups and no catalog. Business critical
> databases use catalog and go
> directly to tape using Networker (P.O.S. ... at
> least on Tru64). I have
> separate scripts for database and log files in case
> the archived log
> destination gets dangerously full (monitored by cron
> job).
>
> For database:
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_DATA';
> set command id to 'rman';
> backup
>tag backup_db_full
>(database include current controlfile);
> release channel ch1;
> }
>
>
> For log files (we are duplexing on this database):
>
> run {
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_ARCH';
> set command id to 'rman';
> change archivelog all crosscheck;
> backup
>(archivelog all delete input);
> backup
>(archivelog like
> '/oracle/app/oracle/admin/HRP1/arch2/%' delete
> input);
> release channel ch1;
> allocate channel ch1 type disk format
> '/u05/oracle/admin/HRP1/backup/%U_CONTROL';
> backup current controlfile tag='backup';
> release channel ch1;
> sql "ALTER DATABASE BACKUP CONTROLFILE TO
> ''/u05/oracle/admin/HRP1/backup/CONTROL_FILE.BAK''
> REUSE";
> }
>
>
> If the database and all controlfiles got blown away,
> then the
> CONTROL_FILE.BAK is your salvation.
>
> The following "script" is kept handy as a fast
> reference for restoring. I
> run the commands by hand; but the script serves to
> jog my memory as to the
> commands. I've slept since I put this together, but
> I think some of the
> commands are for when you have a catalog.
>
> #!/bin/ksh
>
> ## Define variables for your SID
> export ORACLE_SID=ABCXYZ
> export USER=internal
> export PASS=the_password
>
> ## With Oracle 9.X you must use sqlplus.
> svrmgrl <<-XXX
>connect internal
>startup nomount
>exit
> XXX
>
> rman nocatalog <<-XXX
>connect target ${USER}/${PASS}@${ORACLE_SID}
>
>run {
>
> ### If you have control files, then you don't need
> format when allocating
> channel.
> allocate channel ch1 type disk;
>
> ### When you want to restore up to, but not
> including, a specific log
> sequence number
> ### For example, the database wants log 275, but
> all you have in rman
> catalog are 273 and 274
> #set until logseq=275 thread=1;
>
> ### When you want to restore to a specific time.
> # set until time "to_date('2001-02-09
> 02:00:00','-MM-DD HH24:MI:SS')";
>
> ### Various syntax possibilities for restoring
> control files
> #restore controlfile to
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> # restore controlfile to
> '/u02/oradata/ORACLE_SID/control_02.ctl';
> # restore controlfile to
> '/u06/oradata/ORACLE_SID/control_03.ctl';
> # replicate controlfile from
> '/u01/oradata/ORACLE_SID/control_01.ctl';
> ### The following just restores them all.
> ### DO NOT restore controlfile when doing a point
> in time recovery.
> ### Most likely, you will not restore controlfile
> unless you have lost all
> control files.
> ### If you are not using a catalog, then you must
> copy a backup of the
> control file at the OS level.
> # restore controlfile;
>
> sql 'ALTER DATABASE MOUNT';
> restore database;
> You might or might not need restore
> archivelog.
> When doing backups to disk, you probably don't
> need it.
> # restore archivelog all;
> recover database;
> If control file was restored, then you will
> probably need resetlogs.
> # sql 'ALTER DATABASE OPEN RESETLOGS';
> sql 'ALTER DATABASE OPEN';
>
> release channel ch1;
> }
>
> XXX
>
>
> If you had to restore the controlfiles (or
> hand-copy in backup
> controfiles),
> or if you lost online redo log(s), or if you
> are missing archived
> log(s),
> then, you will likely need to recover the
> database by hand using one
> or
> more of the following commands.
>
> ## With Oracle 9.X you must use sqlplus.
> ##svrmgrl <<
Backup/Restore
Hello,
I need to comeup with backup strategy for my
production oracle systems running 9iR2 on Solaris9.
I do have veritas Netbackup installed. I would
really appreciate if someone can answer these
important questions for me.
1- Do I need to install Veritas Oracle agent for
backup?
2- What are COMPLETE steps involved to
backup/restore if I want to use Veritas for
this purpose?
3- I am using following script to create backup on
the local disk. This script does not delete the
archive log files after backing 'em up. Why
not? I am using this script at RMAN prompt.
(connect to recvcat)
run {
allocate channel c1 type disk;
backup
full
#incremental level 2 # 0 1 2 or up
skip inaccessible
tag hot_db_bk_level0
filesperset 5
# recommended format
format '/data/oraidx/backup/bk_%s_%p_%t'
(database);
sql 'alter system archive log current';
# backup all archive logs
backup
filesperset 20
format '/data/oraidx/backup/al_%s_%p_%t'
(archivelog all
delete input);
release channel c1;
}
4- What is the procedure to restore using files
created as output of above script?
5- Any ideas/links to help improve backup
strategy, using veritas and RMAN.
Thanks.
OraCop
__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraCop
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).
