RE: Textfile into oracle
Title: RE: Textfile into oracle save as txt first -Original Message-From: Clinton Naude [mailto:[EMAIL PROTECTED]]Sent: 06 June 2002 22:28To: Multiple recipients of list ORACLE-LSubject: RE: Textfile into oracle Yes, use Sqlloader... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Textfile into oracle Hallo, I have this excelfile. Is it possible to import this into an oracle table. This file is supposed to be located on unix machine from the beginning and the import into an oracle table would be done from unix. How should I name the fields in the oracle table. I mean should I use the 9-10 different field names in the excelfile. There is at least 100 different columns in this excelfile. Is it possible to import a file like that into oracle table, Please help me with some hints. (See attached file: try.xls) Thanks in advance Roland
RE: SQL*Loader question
Hi, Why don't you just copy and paste those 100 records to other file and load from that new file. Sinardy -Original Message- Sent: 05 June 2002 12:28 To: Multiple recipients of list ORACLE-L The parameters LOAD and SKIP determine how many records to load and skip. By default ALL records are loaded. HTH. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia * +61-412-232-056 * use mobile please Please note 17 hour time difference between Melbourne and CA -Original Message- Sent: Tuesday, 4 June 2002 8:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ferenc Mantfeld 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: Sinardy Xing 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: Rollback Segment tuning
Thanks man, I mean the minimum optimal size base on the maximum transaction size, So the HWM is the answer ? Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L Hi all,=0D =0D How to find out the smallest (minimal) transaction size from Dictionary vie= w or base tables =0D I try to set my OPTIMAL rollback segment base on smallest transaction size = to prevent ora-1555. since shrinking rollback segments may cause ora-1555.= =0D =0D =0D Thanks =0D =0D Sinardy=0D --=0D Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about OPTIMAL. As far as I am concerned I like it on databases where you may have occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount of rollback segment used, as well as the high-water mark. You can use those values to derive something looking common-sensical. Alternatively, I think that there is in the 'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL automatically (don't worry, even with this name it contains nothing illegal in Singapore :-)). Even if you do not run the script as is, looking at what it does - and possibly questioning it - may give you the answer you are looking for. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Sinardy Xing 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: Rollback Segment tuning
Hi Stephane, I run the script and I have OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* sys.ts$.blocksize / 1024 the result is 0 K for my optimal. : ) regards, Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L Hi all,=0D =0D How to find out the smallest (minimal) transaction size from Dictionary vie= w or base tables =0D I try to set my OPTIMAL rollback segment base on smallest transaction size = to prevent ora-1555. since shrinking rollback segments may cause ora-1555.= =0D =0D =0D Thanks =0D =0D Sinardy=0D --=0D Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about OPTIMAL. As far as I am concerned I like it on databases where you may have occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount of rollback segment used, as well as the high-water mark. You can use those values to derive something looking common-sensical. Alternatively, I think that there is in the 'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL automatically (don't worry, even with this name it contains nothing illegal in Singapore :-)). Even if you do not run the script as is, looking at what it does - and possibly questioning it - may give you the answer you are looking for. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Sinardy Xing 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).
Rollback Segment tuning
Hi all, How to find out the smallest (minimal) transaction size from Dictionary view or base tables I try to set my OPTIMAL rollback segment base on smallest transaction size to prevent ora-1555. since shrinking rollback segments may cause ora-1555. Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: For real Gurus only
wow, so turf -Original Message- Sent: 30 May 2002 17:23 To: Multiple recipients of list ORACLE-L Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
What makes Export slow ?
Hi guys, I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Good HR vs. Bad HR...
I wish I can work for you beside learning Oracle I can be a wiser man. -Original Message- From: Don Granaman [mailto:[EMAIL PROTECTED]] Sent: 11 May 2002 00:38 To: Multiple recipients of list ORACLE-L Subject: Re: Good HR vs. Bad HR... Actually, I don't think the company is all that bad now. In fact, I would have preferred to keep the company name out of it. Also, I should have put this into a context. At the time this was written, upper management had started an intimidation campaign. They were doing some layoffs, but rather than do it in any kind of normal fashion, they were laying off one or two people per day - and making a spectacle of it. They would come around to the victim and force them to stop whatever they were doing immediately and parade them out of the building with a security escort. They were not allowed to even log off, finish a line of code, or pick up personal items - which were instead to be shipped to their home. After about a week or two of this, I happened to be on an elevator with a VP and a director (ones I didn't really know) - just the three of us. They started talking, for my benefit obviously, about the success of their let's put the fear of God into our employees (a direct quote) strategy. It was then that I decided it wasn't someplace I wanted to stay. That night, I wrote up this resignation - as a sort of counter-attack. The next morning, I came in, packed up most of my stuff, took it to the car, and submitted the letter to about three layers of management above me, the managers whose projects I was working on, one of the owners of the company, and HR. Most were included only because I wanted them to know why I was actually leaving, not some distorted version they might get through the bureaucracy. I also sent a fairly comprehensive turnover document to one of my co-workers (Mike M.), as I knew that this wouldn't be considered as an essential part of the exit process. About three hours later I was called up to HR. The director of the division I worked for was there, as well as the HR person. The HR person said that they had chosen to terminate my employment effective immediately. I said So, you are accepting my resignation? and she turned bright red and glowered at me. She said that I wouldn't be able to return to my cube - that security would escort me out of the building directly from her office. I told them that all I had left there was one small box of books that belonged to me. This director was actually a very sensible and technical guy who had come up through the ranks. He told the HR clown that he would go back with me and escort me out. We went back to my cube, he carried the box out to my car for me, and told me Well, at least maybe this will do some good. I think they slacked up a bit after that. I still have friends who work there. About a year after I left, I saw one of my past managers at a user group meeting. He is now a VP I believe. He said that if I ever decided I could work there again, to give him call. About two years after I left, I went back out there for a visit and was greeted warmly by former co-workers and even a few managers. I think that the reason that, as Matt said, this became legendary is only because it was a sort of suicide attack against the arrogance and stupidity that existed in some upper management circles at that time. I was the first martyr, but quite a number of others also resigned within the next few months (none so flamboyantly though). Of the group (ET) of twenty that I was in, well over half had left (voluntarily) within a year. Matt was among the defectors, as was our manager and a large percentage of the other senior technical people. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 10, 2002 9:33 AM Don, And, of course, since it was a resignation letter, the company probably just filed it away. I'll give you the Brass Cajones award though, for setting the record straight. Just curious, is the company still around? Need to make sure to avoid it in the future! :) Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
Urgent !! Partner version vs Production version
Hi all, For Oracle 8.1.6.0.0 for SPARC Is there any CD so call Partner CD distributed to customer, that only allow limited number of concurrent Process (in my case 160). And if there is how can I know installed DB is Partner version. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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:
What is the OS ? -Original Message- Sent: 30 April 2002 22:38 To: Multiple recipients of list ORACLE-L I have been reading/searching the DAMN documentation like I always do before posting a question. It is frustrating enough to get this to work correctly. I do not need this type of reply so keep it to yourself. All it does is add to the frustration. I greatly appreciate the constructive help I have gotten from the others. bill thater bthater2@netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scape.net cc: Sent by: Subject: Re: root@fatcity. com 04/30/2002 09:33 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: 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 how about reading the documentation that came with the damn software? -- -- 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. A computer scientist is someone who fixes things that aren't broken. -- 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). -- 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: Sinardy Xing 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
RE: How to deinstall oracle 9i and leave 8i intact
Hi, May be those are shared component with your old 8i, btw what are those component regards Sinardy -Original Message- Sent: 30 April 2002 22:28 To: Multiple recipients of list ORACLE-L Tom, I started with using the installer. It appears it installed Oracle software. Of course this does nothing with the registry,services,etc. When I go back into installer it still shows some 9i installed. When I try to uninstall it insist on un-installing some oracle 8i software. I have been working in Oracle since the end of Oracle 5 and one thing is constant Oracle install/uninstall procedures SUCKS. Ok I feel a little better now,back to the problem. I found a Oracle document detailing removal or oracle software and a oracle home, followed it to the letter. Everything appears to work fine except the installer still shows some 9i software installed when I know there is not. It mus be stored elsewhere but do not know how to correct. This may cause problems if I attempt to re-install 9i. Any ideas? Thanks Rick Mercadante, Thomas F To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED]cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ate.ny.us Subject: RE: How to deinstall oracle 9i and leave 8i intact 04/30/2002 09:01 AM Rick, how about using the installer? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L 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). -- 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: Sinardy Xing 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).
SQL*NET VERSION
Hi all, How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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:
CALL 911 -Original Message-From: Ravindra B [mailto:[EMAIL PROTECTED]]Sent: 30 April 2002 05:39To: Multiple recipients of list ORACLE-LSubject: HELP
RE: Metalink CD Request
Hi, There was such option in my tar problem list Request for CD but now what I have is Request for patch or patch set. Sinardy -Original Message- Sent: 26 April 2002 23:09 To: Multiple recipients of list ORACLE-L What are you wanting, Oracle software? That would be technet, not metalink. (unless you are doing a shipping tar based on your CSI... I'm not sure if you can file those as iTAR's or not...) RF -Original Message- Sent: Friday, April 26, 2002 12:43 AM To: Multiple recipients of list ORACLE-L Hi all, Do you have any idea how many times we can request CD from Metalink because I requested once and now the option is gone... Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Metalink CD Request
Hi all, Do you have any idea how many times we can request CD from Metalink because I requested once and now the option is gone... Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Good SQL/PLSQL Reference Book ?
Hi, Have you try Oracle documentation ? In the end of each chapter they provide good examples. It may be to detail. perhaps you can use the search doc function. -Original Message- Sent: 26 April 2002 12:13 To: Multiple recipients of list ORACLE-L Hi folks, I'd like a recommendation for a good SQL/PLSQL *reference* book (not a how to but a good reference). Please don't tell me to go to Oracle's site (I did that already) -- I want a book! :D Thanks in advance!, JoJo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi 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: Sinardy Xing 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).
LMT bitmap question
Hi all, I'm confuse with Segment Header and Data file header. some said LMT keep the free block information (bitmap) in Segment header and some said Data file header. I have 3 questions 1. where oracle keep LMT bitmap each data file header or each segment header ? 2a. if it is store in data file header can one tell whether is LMT or DMT by view (first line) of the physical file ? 2b. if it is stored in segment header which view of base tables store these information. 3. What is ST enqueue ? Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
What is Oracle made from ?
Hi all, Just for my own info, Is Oracle written in C ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Any idea what is SESSION REC ?
Hi guys, Do you have any idea what is SESSION REC (from dba_audit_trail.action_name) Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: anyone see my DBA_AUDIT_TRAIL ??? (solved) bug or Architecture ?
Hi, Is this characteristic of a bug or is the Oracle Architecture ? SQL desc dba_audit_exists ERROR: ORA-24372: invalid object for describe SQL select count(*) from dba_audit_exists; COUNT(*) -- 0 SQL desc dba_audit_exists Name Null?Type - OS_USERNAMEVARCHAR2(255) USERNAME VARCHAR2(30) USERHOST VARCHAR2(128) TERMINAL VARCHAR2(255) TIMESTAMP NOT NULL DATE OWNER VARCHAR2(30) OBJ_NAME VARCHAR2(128) ACTION_NAMEVARCHAR2(27) NEW_OWNER VARCHAR2(30) NEW_NAME VARCHAR2(128) OBJ_PRIVILEGE VARCHAR2(16) SYS_PRIVILEGE VARCHAR2(40) GRANTEEVARCHAR2(30) SESSIONID NOT NULL NUMBER ENTRYID NOT NULL NUMBER STATEMENTID NOT NULL NUMBER RETURNCODENOT NULL NUMBER Sinardy -Original Message- From: Sinardy Xing Sent: 08 April 2002 11:41 Subject: anyone see my DBA_AUDIT_TRAIL ??? Hi guys, Please help me solved this SQL show user USER is SYS SQL select owner, object_name, object_type from all_objects where object_name = 'DBA_AUDIT_TRAIL'; OWNER OBJECT_NAMEOBJECT_TYPE -- -- -- SYSDBA_AUDIT_TRAILVIEW PUBLIC DBA_AUDIT_TRAILSYNONYM SQL desc DBA_AUDIT_TRAIL ERROR: ORA-24372: invalid object for describe Why I can not describe my DBA_AUDIT_TRAIL ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
How to Audit a table
Hi, How can I audit a table whether is selected as SELECT col1, col2 FROM tab WHERE col1 = 'condition'; and NOT all the SELECT queries I'm using Oracle 8i Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
anyone see my DBA_AUDIT_TRAIL ???
Hi guys, Please help me solved this SQL show user USER is SYS SQL select owner, object_name, object_type from all_objects where object_name = 'DBA_AUDIT_TRAIL'; OWNER OBJECT_NAMEOBJECT_TYPE -- -- -- SYSDBA_AUDIT_TRAILVIEW PUBLIC DBA_AUDIT_TRAILSYNONYM SQL desc DBA_AUDIT_TRAIL ERROR: ORA-24372: invalid object for describe Why I can not describe my DBA_AUDIT_TRAIL ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: sysdba
Hi, You have password file, and you are not register in it. either you register yourself in this password file (orapwd) or don't use that password file RE..PAS.. = none. Sinardy -Original Message- Sent: 03 April 2002 13:18 To: Multiple recipients of list ORACLE-L i cant connect as sysdba. ORA-01031 - insuffecient privileges. can anybody help me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO 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: Sinardy Xing 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).
find nologging
Hi all, If there are process of insert /*+append */ still running. how can I know if this insert is logging or nologging ? Thanks Sinardy Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Data dictionary for function
Hi all, Thank you for your answers dba_source user_source all_source Sinardy -Original Message- [EMAIL PROTECTED] Sent: Friday, 29 June 2001 1:50 PM To: Multiple recipients of list ORACLE-L dba_all_source Regards Sinardy Xing SinardyXing@bcs-aTo: Multiple recipients of list ORACLE-L ch.com.sg[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Data dictionary for function 29-Jun-2001 12:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). __ Visit us at www.singaporeair.com. __ -- 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: Sinardy Xing 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).
Testing
Testing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
FW: Testing
-Original Message- Sent: Friday, 29 June 2001 10:11 AM To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list' Testing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
test
change add -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
No Subject
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
test
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Data dictionary for function
Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Test
[EMAIL PROTECTED] Best Regards Sinardy *** CONFIDENTIALITY CAUTION This message and its attachments (Message) are intended only for the use of the individual or entity to whom it is addressed, is confidential and may also be privileged. If you are not the intended recipient, please do not distribute, use or copy any part of it. Instead, please inform us immediately by return e-mail and delete this Message from your system or destroy it if you received it otherwise than by e-mail. Any opinions or representations contained in this Message shall not bind Banking Computer Services Private Limited (BCS) unless the author is authorized by BCS to communicate such opinion or representation and the authority of the author to so bind BCS is duly verified. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Testing
Testing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Delete me
Hi, I am changing e-mail address sorry for the inconvenience Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT Hi, If I am not wrong Oracle instance on NT is a single process composed of all oracle's threads. UNIX ps -ef MTS is not supported by NT Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Tuesday, 26 June 2001 3:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Multiple Oracle Instances on NT yOU CAN RUN SEVERAL ÝNSTANCES ON nT . I DO IT NOW. NOTHING IS DIFFERENT. BUT DO NOT FORGET TO MAKE ONE INSTANCE DEFAULT . - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 11:15 PM Subject: Multiple Oracle Instances on NT Hi everyone - I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on the same NT box. I would like to know some "basics" about running Oracle on NT - can you run multiple instances of Oracle on one NT machine - if so, what do I need to look out for (ie. what things are different that a Unix installation) - are any of the processes, etc. drastically different - ie. security, networking, logging - what type of system requirements (ie. memory, CPU) are needed on NT Thanks for any help you can give me! Lisa
RE: AARRGGHH !!!
Hi, Do you want me forward to you all those mails ? Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robertson Lee - lerobeSent: Monday, 25 June 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: AARRGGHH !!! Over the weekend, (Friday to be precise) I was unsubscribed from the list. Is there away I can catch up on mails I have missed ?? I had posted a question on Friday afternoon that I needed answers to. Regards LeeThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: Use sql*loader
Hi BaoDuy, Yup I understand your problem, you can check your sqlloader control file under what Ravinder said bad file, Your table constraints reject your bad data because you use conventional path, if you use direct path bad data also will inserted into your table but your contraints will be disable and indexes will be unsued or not unique. Ravinder how are you ??? Regards Sinardy -Original Message- [EMAIL PROTECTED] Sent: Friday, 22 June 2001 4:52 PM To: Multiple recipients of list ORACLE-L Check your bad file and your error log file for sqlldr it should explain what happend. Ngo BaDu ngo_duy@fmaiTo: Multiple recipients of list ORACLE-L l.vnn.vn[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Use sql*loader com 22-Jun-2001 03:50 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Dear all, I have a text file of 70 rows. After using sql*loader to load it into my table, I select * from my table it only show 802 rows. Some people told me that's because of buffer. Who would like to show me how I ought to do? Thanks you and sorry for my bad english. BaoDuy __ Visit us at www.singaporeair.com. __ -- 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: Sinardy Xing 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: Need help getting started
Hi Keren, I was same with you, I started from 0% knowledge in computing, I stated as an office boy cleaning computer showroom Eveready, and then I started leaning how to install PC 8088 (long long time ago), monochrome monitor and then PC 80286 then PC 80386 then PC 80486 then Pentium then more Pentium then a lot more of Pentium. Then Sun SPARC, from DOS to WINDOWS to UNIX, programming C, C++, Java, Cobol others, DB, ORACLE and I don't know what will happen tomorrow. Learn from others is faster but it may just a temporary knowledge to you (If you can affordOCP or other courses) Learn by your self is slower but it can be a permanent knowledge to you (If you can affordbooks) Share your knowledge with others so that they also willingto share it with you. A STEP AT A TIME If you believe you can do it then you can do it. All the best and Good luck Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, 20 June 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: Need help getting startedThis is kind of a different Oracle question. Does anyone have any suggestions how a person can land an entry level job. I do not work in the Technology field but would very much like to. I have been going to school at night for about two and a half years and have the first two OCP developers tests behind me and am working on the third now. I have a 3.9 GPA and can't even get an interview. How do you get experience if no one will hire you? I have even offered to work for free in the evenings or on my days off. I live in Minneapolis and would really appreciate any suggestions that anyone might have. Thanks, Karen
create DBA user need help...
Hi all, I recreated DBA role that provided by Oracle8i, 1. Create New_DBA_role identified by change_me; 2. Select 'GRANT ' || privilege || ' TO new_dba_role' FROM dba_sys_privs; Create new dba user 3.Create user new_dba identified by password default tablespace userdata quota unlimited on userdata ; 4. GRANT SYSDBA TO new_dba; What other privilege or role that I need so that I am able to shutdown and startup database. I am using OS authentication method. Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: missing all control file continue...
Hi all, When I do SELECT name from v$datafile; NAME - ... /disk1/Oracle8i/dbs/MISSING7 /disk1/Oracle8i/dbs/MISSING8 Where are these files came from ? do I lost anything ? When I quickly do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Why the trace file is not generated at my udump (according to my init.ORA setting) It generated at /disk1/Oracle8i/rdbms/log/*.trc (which is not my user_dump_dest path) and this file contain CREATE CONTROLFILE ... DATAFILE '/disk1/Oracle8i/system01.dbf', ... '/disk1/Oracle8i/dbs/MISSING7', '/disk1/Oracle8i/dbs/MISSING8' ; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING7' OFFLINE; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING8' OFFLINE; Thank you, Sinardy -Original Message- Xing Sent: Thursday, 14 June 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: LazyDBA.com Discussion [EMAIL PROTECTED] cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to startup nomount 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE TDBA NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt [EMAIL PROTECTED]To: LazyDBA.com Discussion net.de [EMAIL PROTECTED] cc: 12/06/2001 Subject: Re: missing all control file 05:06 PM Hi, does CEATE CONTROLFILE works? oli On Tuesday 12 June 2001 11:20, [EMAIL PROTECTED] wrote: Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being rm Thank you, Best Regards Sinardy Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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
RE: missing all control file
Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: LazyDBA.com Discussion [EMAIL PROTECTED] cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to startup nomount 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE TDBA NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt [EMAIL PROTECTED]To: LazyDBA.com Discussion net.de [EMAIL PROTECTED] cc: 12/06/2001 Subject: Re: missing all control file 05:06 PM Hi, does CEATE CONTROLFILE works? oli On Tuesday 12 June 2001 11:20, [EMAIL PROTECTED] wrote: Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being rm Thank you, Best Regards Sinardy Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
missing all control file
Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being rm Thank you, Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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 you guys ':)
When is your last holiday ? -Original Message- Sent: Tuesday, 12 June 2001 7:31 PM To: Multiple recipients of list ORACLE-L Ladies and Gents, I'm off for a holiday in the sun for a week, in around 30 minutes, so thought I'd say see you - and you all think of me sunning it on the beach, while your slogging over a database :) Bye Bye, and I'll have a drink for ALL of you :) Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Sinardy Xing 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: missing all control file
Hi Robertson, Your procedure is work for me, When this database created, the creator kept the create database scripts, so I able to retrieve some information from there, (is in $ORACLE/assistants/dbca/jlib/SIDrun.sh) Thank you, you are really brilliant Sinardy -Original Message- Lee - lerobe Sent: Tuesday, 12 June 2001 7:40 PM To: Multiple recipients of list ORACLE-L You may well be OK. All you need to do is fetch the database up in nomount mode startup nomount from svrmgrl. SVRMGR startup nomount ORACLE instance started. Total System Global Area 6892912 bytes Fixed Size 60784 bytes Variable Size 5046272 bytes Database Buffers 1638400 bytes Redo Buffers 147456 bytes Then AS LONG AS YOU KNOW HOW YOUR DB was set up you could use the following command. I checked out where all the files were and typed this into a file, basically replicating the Oracle backup control file to trace output.Then from svrmgrl ran it CREATE CONTROLFILE REUSE DATABASE LRDB NORESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 10 MAXINSTANCES 8 MAXLOGHISTORY 907 LOGFILE GROUP 1 '/usr/app/oracle/admin/leework/LRDB/redoLRDB01.log' SIZE 1M, GROUP 2 '/usr/app/oracle/admin/leework/LRDB/redoLRDB02.log' SIZE 1M, GROUP 3 '/usr/app/oracle/admin/leework/LRDB/redoLRDB03.log' SIZE 1M DATAFILE '/usr/app/oracle/admin/leework/LRDB/system001.dbf', '/usr/app/oracle/admin/leework/LRDB/temp001.dbf', '//usr/app/oracle/admin/leework/LRDB/BRDMK_data001.dbf', '/usr/app/oracle/admin/leework/LRDB/rbs01.dbf', '/usr/app/oracle/admin/leework/LRDB/lee001.dbf'; SVRMGRL@leecrtctl Statement processed. SVRMGR alter database open; Statement processed. SVRMGR BEST OF LUCK but this did work perfectly for me. erm... start using the backup controlfile to trace on a regular basis !!!. Cheers Lee -Original Message- Sent: 12 June 2001 11:21 To: Multiple recipients of list ORACLE-L Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being rm Thank you, Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Sinardy Xing 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: missing all control file
I am the last one went home yesterday, so nobody aware of it ; ) Sinardy -Original Message- Sent: Wednesday, 13 June 2001 4:25 AM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 03:21, Sinardy Xing wrote: Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Glad to hear your database is now safe and sound. Now let's hear a little about how you managed to remove all of your control files. When you realized what happened, did you get that all over body buzz that indicates that you may be nearer to death than you ever expected? :) Maybe we can offer some tips to help prevent that kind of error in the future. More importantly, do your user and/or boss know what happened? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Sinardy Xing 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).
Sun cluster with Ultra 10
Hi all, Is anyone using 2 Ultra 10 and Sun Cluster 2.2 as test environment ? Is this achievable ? Thank you.. Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: What is Quorum device ? (not Oracle)
Hi Brian, Thank you so much for your information, you are really helpful. Sinardy -Original Message- Wisniewski Sent: Friday, 8 June 2001 8:17 PM To: Multiple recipients of list ORACLE-L Sindary, I didn't see a reply from anyone else your question so I'll take a stab at it but I have very limited knowledge about this so don't take it as doctrine. A quorum device is a disk that is shared between clustered servers to keep cluster configuration information current. I also think it is dependent upon the servers O/S as to how it is implemented and if the quorum device can be used for user data or not. From Sun. quorum device A disk shared by two or more nodes that contributes votes used to establish a quorum for the cluster to run. The cluster can operate only when a quorum of votes is available. The quorum device is used when a cluster becomes partitioned into separate sets of nodes to establish which set of nodes constitutes the new cluster. Cluster Members FAQ Is the order in which nodes are booted significant? In most cases, no. However, the boot order is important to prevent amnesia (refer to Quorum and Quorum Devices for details on amnesia). For example, if node two was the owner of the quorum device and node one is down, and then you bring node two down, you must bring up node two before bringing back node one. This prevents you from accidentally bringing up a node with out of date cluster configuration information. Take a look at this link for more in-depth information. http://docs.sun.com/ab2/coll.572.7/CLUSTCONCEPTS/@Ab2PageView/2025?DwebQuery =Quorum+OR+deviceoqt=Quorum+deviceAb2Lang=CAb2Enc=iso-8859-1 - Brian --- Sinardy Xing [EMAIL PROTECTED] wrote: Date: Thu, 07 Jun 2001 04:10:54 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] From: Sinardy Xing [EMAIL PROTECTED] Subject: What is Quorum device ? (not Oracle) Organization: Fat City Network Services, San Diego, California Hi all, Can someone explain what is Quorum device, what it is the different from disk and quorum device ? Thank you, Sinardy __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski 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: Sinardy Xing 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: urgent !!
Hi Bunyamin K. Karadeniz, I assume your init*.ora at that path (D:\oracle\ora816\admin\uybs) Since you know your parameter stuff, just create new one at other hdd and retry. If work you have to checkyour hdd might be containing some bad block (can't read but can write problem) Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Thursday, 7 June 2001 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: urgent !! Hi all gurus.. I want to create my database on NT . but svrmgrl gives error of SVRMGR startup nomount pfile=D:\oracle\ora816\admin\uybs\inituybs.oraLRM-00109: could not open parameter file 'D:\oracle\ora816\admin\uybs\inituybs.ora'ORA-01078: failure in processing system parameters How can I know which parameter causes the error? Here are my parameters Which one? db_name = UYBS instance_name = UYBS service_names = UYBS db_files = 1024 control_files = (D:\uyap_database\cf\control01.ctl, C:\uyap_database\cf\control02.ctl ) open_cursors = 200max_enabled_roles = 145 db_file_multiblock_read_count = 16db_block_buffers = 8192db_block_size = 4096 shared_pool_size = 22775808large_pool_size = 734003200java_pool_size = 0 log_checkpoint_interval = 1log_checkpoint_timeout = 1800 processes = 715 parallel_max_servers = 5 log_buffer = 32768 max_dump_file_size = 10240 # limit trace file size to 5M eachlog_archive_start = truelog_archive_dest_1 = "location=D:\uyap_database\arc"log_archive_format = %%ORACLE_SID%%T%TS%S.ARCmax_rollback_segments = 80rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14, RBS15, RBS16, RBS17, RBS18, RBS19, RBS20, RBS21, RBS22, RBS23, RBS24, RBS25, RBS26, RBS27, RBS28, RBS29, RBS30, RBS31, RBS32, RBS33, RBS34, RBS35, RBS36, RBS37, RBS38, RBS39, RBS40 )global_names = trueoracle_trace_collection_name = ""background_dump_dest = D:\uyap_database\trace\bdumpuser_dump_dest = D:\uyap_database\trace\udump remote_login_passwordfile = exclusive os_authent_prefix = "" distributed_transactions = 10mts_dispatchers = "(protocol=TCP)" compatible = 8.1.0sort_area_size = 65536sort_area_retained_size = 65536optimizer_mode=CHOOSEtimed_statistics = true
What is Quorum device ? (not Oracle)
Hi all, Can someone explain what is Quorum device, what it is the different from disk and quorum device ? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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 prevent oracle from committing a transaction?
Hi Ranganath, There are several situation for oracle to commit. one of them of course you type 'commit;' manually others can be : when checkpoint occur when switch redo log occur when LRU function need to find space in your SGA when shutdown normal (am I wrong ?, Oracle rollback or commit ? I think oracle rollback uncommited transactions) ect... Sinardy -Original Message- Sent: Tuesday, 5 June 2001 3:30 PM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Sinardy Xing 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 download
Is Oracle 9i free download ?? Sinardy -Original Message- Spence Sent: Tuesday, 5 June 2001 6:02 AM To: Multiple recipients of list ORACLE-L GetRight was only $20 to register, free if you like ad ware and a few other less features. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 4:44 PM To: Multiple recipients of list ORACLE-L Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It seems to be a similar product. Thanks, Ken Janusz, CPIM I'll second that. It's the only way to get a clean download from technet. Jared On Monday 04 June 2001 10:00, Post, Ethan wrote: Note sure if your using a download manager Chris, I used ReGet (Tucows.com) the other day to get 8.1.7.3 and it worked really great. - E -Original Message- Sent: Monday, June 04, 2001 9:22 AM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Christopher Spence 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: Sinardy Xing 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).
create temporary tablespace question
Hi all, What is the different between: CREATE TEMPORARY TABLESPACE temp bla bla ; and CREATE TABLESPACE temp bla bla TEMPORARY ; Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Solaris E4500 with Oracle and Solaris 7 - Pretty urgent : )
Hi all, I am using E4500 with Oracle 8.1.6 and Sun Cluster 2.2, Do you have any FAQ sites or failures scenario site to share? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: My Website
Hi Chris, Is that you, bellow your main page? I mean before that guy mutates to something else of course. : ) You have lot of experience and know lots of technology. Sinardy. -Original Message- Spence Sent: Saturday, 19 May 2001 4:00 PM To: Multiple recipients of list ORACLE-L Some of you already know me from Lazyda list, some of your don't (prob glad). Well I have been working on putting up yet! another dba portal site. I have articles, scripts, and forums. I been really busy lately fire fighting a huge new product of ours, so I haven't got as much content as I wanted to have by now, but i do have about 45 articles and 30 or so scripts. Most of the famous and popular (or ones I liked) articles are already up their as I always had them an arms reach away. Feel free to contact me (please use email on site) for any additions one may feel appropriate. And unlike OTHER lists, none of the information on the site I claim as my own unless it is of course, my own. Everyone who participates gets due credit and there are no royalties with the site either (go figure heh?). Now that everyone is asleep from me running on, here is the URL: www.vampired.net Aka Vampire D's Oracle Den. Christopher, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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: Sinardy Xing 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).
forget sys password ?
Hi all, What can I do, if I forget my testing server's sys account password ? I keep sys and system passwords together, and I lost that document. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
I need 1 file from you...
Hi guys, Could you please attach ora.hlp file for me (Ms version not an UNIX version) Or do you know where is this file located (unfortunately the CDs is not with me anymore). Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: I need 1 file from you...
Oh. ya... I am using Solaris 2.7 -Original Message- Sent: Tuesday, 15 May 2001 7:24 PM To: LazyDBA.com Discussion Hi guys, Could you please attach ora.hlp file for me (Ms version not an UNIX version) Or do you know where is this file located (unfortunately the CDs is not with me anymore). Thank you Sinardy Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Tomato Story
Hi all, I found my job from internet... : ) Sinardy -Original Message- [EMAIL PROTECTED] Sent: Tuesday, 15 May 2001 5:56 AM To: Multiple recipients of list ORACLE-L Dick, That's the best parable I've read in longer than I can remember... grin Thanks, Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Subject: OT:Tomato Story After all of the MicroSoft bashing, this should be fun!! An unemployed man goes to apply for a job with Microsoft as a janitor. The manager there arranges for him to take an aptitude test (Section:Floors, sweeping and cleaning). After the test, the manager says, You will be employed at minimum wage, $5.15 an hour. Let me have your e-mail address, so that I can send you a form to complete and tell you where to report for work on your first day. Taken aback, the man protests that he has neither a computer nor an e-mail address. To this the MS manager replies, Well, then, that means that you virtually don't exist and can therefore hardly expect to be employed. Stunned, the man leaves. Not knowing where to turn and having only $10 in his wallet, he decides to buy a 25 lb flat of tomatoes at the supermarket. Within less than 2 hours, he sells all the tomatoes individually at 100% profit. Repeating the process several times more that day, he ends up with almost $100 before going to sleep that night. And thus it dawns on him that he could quite easily make a living selling tomatoes. Getting up early every day and going to bed late, he multiplies his profits quickly. After a short time he acquires a cart to transport several dozen boxes of tomatoes, only to have to trade it in again so that he can buy a pick-up truck to support his expanding business. By the end of the second year, he is the owner of a fleet of pick-up trucks and manages a staff of a hundred former unemployed people, all selling tomatoes. Planning for the future of his wife and children, he decides to buy some life insurance. Consulting with an insurance adviser, he picks an insurance plan to fit his new circumstances. At the end of the telephone conversation, the adviser asks him for his e-mail address in order to send the final documents electronically. When the man replies that he has no e-mail, the adviser is stunned, What, you don't have e-mail? How on earth have you managed to amass such wealth without the Internet, e-mail and e-commerce? Just imagine where you would be now, if you had been connected to the Internet from the very start! After a moment of thought, the tomato millionaire replied, Why, of course! I would be a floor cleaner at Microsoft! Moral of this story: 1. The Internet, e-mail and e-commerce do not need to rule your life. 2. If you don't have e-mail, but work hard, you can still become a millionaire. 3. Seeing that you got this story via e-mail, you're probably closer to becoming a janitor than you are to becoming a millionaire. 4. If you do have a computer and e-mail, you have already been taken to the cleaners by Microsoft. -- 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: 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: Sinardy Xing 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
RE: I need 1 file from you...
Oh. ya... I am using Solaris 2.7 and Oracle 8.1.6 -Original Message- Sent: Tuesday, 15 May 2001 7:24 PM To: LazyDBA.com Discussion Hi guys, Could you please attach ora.hlp file for me (Ms version not an UNIX version) Or do you know where is this file located (unfortunately the CDs is not with me anymore). Thank you Sinardy Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Sinardy Xing 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: Contigency plan (Thank You fyi)
Thank You Guys, -Original Message- Xing Sent: Friday, 11 May 2001 9:46 PM To: Multiple recipients of list ORACLE-L Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Sinardy Xing 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).
Password with special character
Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Password with special character
Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by 'bear12#$'; also not working I have password_verification profile with verify_function that provided by Oracle Administrator Guide that must at least 1 special character in user password. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !#$%()'*+,-/:;+_ if I'm not mistaken. Try them anyway. --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Contigency plan
Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
OCIPasswordChange()
Hi all, Oracle8i Administrator's Guide Page 21-15 Recommend us to use OCIPasswordChange() funtion Do you know how to make use of this function ? Do we need to create trigger ? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: date+time in milliseconds
Hi Raj, I never heard such time Date can handle century + year + month + day + hour + minute + second but not milliseconds Sinardy -Original Message- Sent: Tuesday, 8 May 2001 1:14 PM To: LazyDBA mailing list can anyone help me with date + time in milliseconds. i want to inpurt the data from a user in this format. rgds raj _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
can we create our own error messages ?
Hi guys, Can I create my own error message in create profile mypasswordprofile limit failed_login_attempts 3 - if error Prompt Call ext 127, 128, 129 to unlock your account password_life_time - same as above but diffrent message ; Do I have to replace failed_login_attempts password_life_time password_reuse_time ... ... ... ... WITH password_verify_function all_in_this_function so that I can insert all if .. raise_application_error(-20002, 'You got error'); end if; Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: tech help needed
Hi, Sinha indexing = for easy searching something like building table of content in your book sorting = you know SORT hasing = using sort of formula for search particular item, there will be hashing algorithm here Have a nice day Sinardy -Original Message- Sent: Friday, 4 May 2001 12:01 PM To: LazyDBA mailing list Please tell me what is indexing, sorting, hashing Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: might be really old topic, but please take a look
I think most of us here will prefer Oracle Sinardy -Original Message- Sent: Friday, 4 May 2001 1:37 AM To: Multiple recipients of list ORACLE-L Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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: Sinardy Xing 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).
Security, Password policy
Hi all, Do you guys have any password policy knowledge to share? For Solaris 7, and Oracle 8i 8.1.6, Can anyone introduce me some good URL sites for those white paper ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: cdump, bdump, udump
Hi All, Thank you Rachel, David, Christopher and all DBAs and SAs May I know where to find documents that explain all those stuff with some information how managed them I tried ora816 document, but no much info there. It only tells the description, I also read my initSID.ora. Thank you for your time Sinardy -Original Message- Carmichael Sent: Tuesday, 24 April 2001 9:21 PM To: Multiple recipients of list ORACLE-L Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: c compiler problem Solaris not found
Hi Miller, Thank you for your help. My Solaris only having 1 cc file which is inside /usr/ucb I have Solaris CD with me now is the C compiler included in the package ? or do I have to download ? do you have the URL ? Thank You Sinardy -Original Message- Sent: Tuesday, 24 April 2001 2:56 PM To: LazyDBA mailing list At 11:44 +0800 24/4/01, Sinardy Xing wrote: $ cc test.c test /usr/ucb/cc: language optional software package not installed Change your PATH environment variable to get to your real cc before /usr/ucb (in fact take /usr/ucb out of your path completely unless absolutely required). Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: cdump, bdump, udump
Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: cdump, bdump, udump
Thank You -Original Message- Barbour Sent: Tuesday, 24 April 2001 12:40 PM To: Multiple recipients of list ORACLE-L Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: David A. Barbour 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: Sinardy Xing 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).
Test only
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Imp relationship tables
Hi all, What are the steps required to perform full imp from full export dump file. Because there are FK constraints currently my steps are: 1. perform full exp with system/manager in other machine 2. disable all constraints 3. truncate all tables 4. perform full imp with system/manager 5. enable all constraints any better way, I feel there are some leak there, help me please Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Recovery from noarchive db corrected
Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: Sinardy Xing 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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Recovery from noarchive db corrected
Hi Hallas and All DBAs Thank you for your advise. I have a question if I turn on our archive redo log do I need to copy out that archive log frequently ? -Original Message- John Sent: Friday, 6 April 2001 7:21 PM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. With no disrespect to your English, the phrase "weakly copy of dbf files" (rather than weekly) seems rather appropriate. As several other listers have stated, by far the best option is to enable archive logging. Whilst you seem to have the bases covered, have you considered how long it will take to re-apply the batch files and whilst there may not be much online input you are running the risk of losing all data that has been input after your last export and before the next one. Best advice seems to be try archive logging and identify the impact then make a considered judgement. John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 11:10 To: Multiple recipients of list ORACLE-L Subject:RE: Recovery from noarchive db corrected Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the abov
Recover from noarchive database ?
Hi, My database is noarchive mode, what should I do to prevent the lossing any transaction ? Like for example incresing the REDO buffer to ? Will this decrese the performance ? any technique to share ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Recovery from noarchive db corrected
Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Recovery from noarchive db corrected
Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Recovery from noarchive db corrected
The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: Sinardy Xing 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).
Redo log size MAX = ?
Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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 CD?
Oracle Enterprise Edition or Oracle Standard Edition. You can try custom installation to they should be sqlldr there. -Original Message- [EMAIL PROTECTED] Sent: Monday, 2 April 2001 7:15 PM To: Multiple recipients of list ORACLE-L On which installation CD can I find sqlloader setup? Roland Skldblom -- 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: Sinardy Xing 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).
*.dbf, *.ctl, redo*.log access rite
Hi guys, Can you tell me what is your access rite for those files in unix solaris 7 oracle 8.1.6, my current access rite are: rwxrwxr-x for all of them. Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: DBA_USERS view
Hi, You can try http://www.uaex.edu/srea/ This is a script for you to login as other user without using their password, basically that script change the whatever user password to something else and start login with that new password and change it back when you done what ever you do. User can not login because when you made changes you use new password. -Original Message- Jahnke Sent: Friday, 30 March 2001 5:20 PM To: Multiple recipients of list ORACLE-L Hi, what information does the PASSWORD column in the DBA_USERS view provide. I know that it's the encrypted user password, but how can I actually use it ? For example: Can I reassign a password to a user via his encrypted password ? or: Can I test a logon with another user's encrpyted user password to test the logon ? I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB, but that doesn't seem to work. TIA ... -- Regards, Stefan Jahnke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Sinardy Xing 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: Small help (To Lee)
Lee, Thanks for your advise, for me this question is just kick off to the world of ORACLE PL/SQL scripting, I don't know why you think that I would like to ask from a Great and full of experiance DBA like you Mr. Lee to spoon feeding me. Again Thank You so much for your advise Xing, -Original Message- Lee Robertson Sent: Thursday, 29 March 2001 3:16 PM To: Multiple recipients of list ORACLE-L Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: Sinardy Xing 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).
Small help
Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Small help
Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
New born DBA.....
Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Connect internal password ?
I try to restrict other user from accessing other than sqlplus, by creating new group for them and inside my /appl/Oracle8i/bin/bla bla bla rwxrw- so i can not mix those with dba group do you have any sugestion? -Original Message- Sent: Monday, 26 March 2001 6:57 PM To: [EMAIL PROTECTED]; 'lzDBA'; [EMAIL PROTECTED] Associate that second user to the 'dba' unix group. - Original Message - To: 'lzDBA' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 4:06 PM Hi guys, (WITH SOLARIS 7 and ORACLE 8.1.6) After I create a new user that can access SVRMGRL and with user .profile updated, this user cannot connect internal - SVRMGRL ask for password, the most strange is that when I create my second user there is no such problem (first one is the DBA for oracle installation). There is no proble with the .profile because I do "copyt and paste" I heard that orapwd able to solve this problem, what is the file for ? and is that all other users have that kind of file and where Oracle store it ? Thank you for your time, Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com _ 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: Sinardy Xing 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).
Solaris security ?
Hi guys, (With - Solaris 2.7) Do you have any solution how to allow "non owner" to perform backup ? with "tar command" For example: myfile.txt rw--- can you solve this puzzled ? If you think I need to write a unix script would you please teaching me and showing me the steps ? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: ===CPU, memory script(need help)
select NAME, VALUE from sys.v_$sga; vmstat (solaris command) Sinardy -Original Message- Sent: Monday, 26 March 2001 8:12 PM To: [EMAIL PROTECTED] Importance: High Hi Gurus, does anyone has a script that detects in a database where a lot CPU is being used and memories.(on Solaris) if so can someone send me this. Thanks Regis Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Tuning Matter == Parameter PCT_USED in a Table
I think We can use average column a + average column (estimating), because of VARCHAR2 in our table, then we determine can determine how many records inside our database. I think we can not ignore the overhead bit inside our tablespace, my Guru said leave 1 row space between PCT_USED and PCT_FREE I forgot to ask why. Sorry I am not good enough to help you, I have to go find my old notes sorry. Sinardy Xing -Original Message- Setiawan Sent: Friday, 23 March 2001 9:46 AM To: Multiple recipients of list ORACLE-L Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to calculate the size of 1 row in a table . is there anyone who knows to calculate it ? or any alternative formula to calculate PCT_USED ? Thanks a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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: Sinardy Xing 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).
No Subject
Hi, Can I perform a full export without using System account If I have to create a new user to perform a full export what are the roles that need to be granted ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).