RE: how to identify table dublicates just using rowid ?
Hi Salah , This is a sample query on how to identify the duplicate rows : Select FROM tablename WHERE rowid not in (SELECT MIN(rowid) FROM tablename GROUP BY column1, column2, column3...); Hope it helps…. --- -Original Message- From: Salaheldin Aboali [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Subject: how to identify table dublicates just using rowid ? hi all, how to identify or list table dublicates just using rowid ? Regards, Salaheldin Aboali --- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65
RE: Urgent : UTL file problem
Hi , Check If you have the write access on the directory specified in initSID.ora file . Regards Gholam - > -Original Message- > From: Vijaya Chander V.S [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 4:28 PM > To: Multiple recipients of list ORACLE-L > Subject: Urgent : UTL file problem > > my prog looks like this (utl_file_dir=* is present in initSID.ora file): > > DECLARE > fileHandler UTL_FILE.FILE_TYPE; > BEGIN > dbms_output.put_line('1'); > fileHandler := UTL_FILE.FOPEN('/users/vijay', 'myoutput.lst', > 'W'); > dbms_output.put_line('2'); > UTL_FILE.PUTF(fileHandler, 'hai vijay \n'); > UTL_FILE.FCLOSE(fileHandler); > EXCEPTION > WHEN utl_file.invalid_path THEN > raise_application_error(-2, 'ERROR: Invalid path for file.'); > END; > > and when i am running this script i am getting a message like this: > > 1 > DECLARE > * > ERROR at line 1: > ORA-06510: PL/SQL: unhandled user-defined exception > ORA-06512: at "SYS.UTL_FILE", line 101 > ORA-06512: at "SYS.UTL_FILE", line 157 > ORA-06512: at line 5 > > what can be the problem... > > regards, > vijay > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vijaya Chander V.S > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Printing a report in landscape mode
Dear listers , This may sounds a very trivial question for some of u . I am unable to print my report in landscape mode using Reports6 .. Please guide me on how to solve this issue ? Regards Gholam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Convertion from Figures to Words
Dear Listers , I need to convert Figures to Words ...EX : 123 to One Hundred Twenty Three Currently I am using a writen function to do that ..But it has limitations ... Any suggestions regarding that ? Thanks a lot in advance Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Preparation for OCP 8i Upgrade
HI Mandal , My recomendation is for this book : Oracle8 to Oraxcle8i upgrade for Robert G. Freeman , Charles A. Pack Regards Gholam --- > -Original Message- > From: Mandal, Ashoke [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 2:28 AM > To: Multiple recipients of list ORACLE-L > Subject: Preparation for OCP 8i Upgrade > > Is there any book for Oracle 8i upgrade > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Characterset problem
Hi Nirmal, What u have to do is a normal update statement on PROPS$...I remember doing that while there was a need to enter Arabic characters on our DB Be careful not to enter any spaces between the character set value "AR8MSWIN1256" ..It may crash your target DB.. I do not recall another way of doing that HTH Regards Gholam > -Original Message- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 08, 2002 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Import Characterset problem > > Hi gholam, > > Thanks for ur help, by the way let me know how to change the character set > of DB using props$? > > Just you want me to update this props$ for nls_characterset with the new > value?... is it recommanded one?... > > The exp dump file is of character set "AR8MSWIN1256", now the target db is > with characterset "US7ASCII". > > Thanks. > > Nirmal. > > > -Original Message- > > From: Ahmed Gholam Hussain [SMTP:[EMAIL PROTECTED]] > > Sent: 23 ÔæÇá, 1422 10:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Import Characterset problem > > > > Hi Nirmal , > > > > While importing u have to consider that the source and target databases > > character sets should be matching U can change the character set of your > > target database using props$ data dictionary view > > > > HTH > > > > Gholam > > > > > -Original Message- > > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, January 07, 2002 10:05 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Import Characterset problem > > > > > > Helo gurus, > > > > > > I exported on schema from the old datatabase and then > > > i created new database in my PC. Now i want to import it, > > > but it's saying that characterset is not match error. > > > > > > How can i rectify it > > > > > > Thanks. > > > > > > Nirmal. << File: ATT18366.ATT >> > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ahmed Gholam Hussain > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). << > File: ATT19805.ATT >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Characterset problem
> -Original Message- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 08, 2002 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Import Characterset problem > > Hi gholam, > > Thanks for ur help, by the way let me know how to change the character set > of DB using props$? > > Just you want me to update this props$ for nls_characterset with the new > value?... is it recommanded one?... > > The exp dump file is of character set "AR8MSWIN1256", now the target db is > with characterset "US7ASCII". > > Thanks. > > Nirmal. > > > -Original Message- > > From: Ahmed Gholam Hussain [SMTP:[EMAIL PROTECTED]] > > Sent: 23 ÔæÇá, 1422 10:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Import Characterset problem > > > > Hi Nirmal , > > > > While importing u have to consider that the source and target databases > > character sets should be matching U can change the character set of your > > target database using props$ data dictionary view > > > > HTH > > > > Gholam > > > > > -Original Message- > > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, January 07, 2002 10:05 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Import Characterset problem > > > > > > Helo gurus, > > > > > > I exported on schema from the old datatabase and then > > > i created new database in my PC. Now i want to import it, > > > but it's saying that characterset is not match error. > > > > > > How can i rectify it > > > > > > Thanks. > > > > > > Nirmal. << File: ATT18366.ATT >> > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ahmed Gholam Hussain > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). << > File: ATT19805.ATT >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Characterset problem
Hi Nirmal , While importing u have to consider that the source and target databases character sets should be matching U can change the character set of your target database using props$ data dictionary view HTH Gholam > -Original Message- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 07, 2002 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: Import Characterset problem > > Helo gurus, > > I exported on schema from the old datatabase and then > i created new database in my PC. Now i want to import it, > but it's saying that characterset is not match error. > > How can i rectify it > > Thanks. > > Nirmal. << File: ATT18366.ATT >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Too Old !!!!!!!
Hi Mr Dumas , Why not using direct path load In export specify : Direct = y Regards > -Original Message- > From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, November 17, 2001 1:30 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Rollback Segment Too Old !!! > > I think you forgot to assign a transaction to the > increased RBS > > Suppose the increased RBS is RBS2 then > > SET TRANSACTION USE ROLLBACK SEGMENT RBS2; > > After that do an export again . > > I think it will work. > > --- Jackson Dumas <[EMAIL PROTECTED]> wrote: > > > > Yeah > > > > I had a problem recently were I was exporting a > > 45Gigg database, the > > export will continue until at a end it will come up > > with a warning > > that export was completed successfully with warnings > > because rollback > > segment was too old. I increased the tablespace RBS > > where the rollback > > segments are residing and also created some more > > rollback segments. > > This did not work also, I had a problem similar to > > this but this was > > happening when the user was trying to delete some > > records with a where > > clause, it would come up with the error rollback > > segment too old. > > Can somebody give me an idea of how to go about this > > problem, I would > > appreciate you input dearly > > > > Thank you, > > > > Mtabaruka ! > > > ___ > > http://www.webmail.co.za the South-African free > > email service > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jackson Dumas > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Find the one for you at Yahoo! Personals > http://personals.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ASHRAF SALAYMEH > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Droping System User
Hi JOE, The reason I posted this question in the list some time back was that this was one of tricky questions during one of my interviews( I do not know what was the senior DBA's goal asking this type of question ) I was amazed when I came to know that it can be droped ( I mean user SYSTEM ) Any way , let us be in safe side always Regards > -Original Message- > From: JOE TESTA [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 8:30 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Droping System User > > i'm with you kimberly, but i some things, i guess just aint worth digging > too deep into. Kinda like altering user$ to change a username instead of > exp/imp. > > joe > > > >>> [EMAIL PROTECTED] 10/22/01 12:15PM >>> > Um, I have to disagree, although I must admit I will not try it. Its > a good way for people to get used to backup and recover. And that is > never a bad thing. > > -Original Message- > Sent: Monday, October 22, 2001 5:11 AM > To: Multiple recipients of list ORACLE-L > > > So - why bother? Your having problems doing it - it SHOULDN'T be done! Why > test something, and if it doesn't work try to get to the bottom of it - > when > you should NEVER put it in to practice anyway? > > Your wasting precious time that could be spent reading about > tuning/backup/recovery/new features etc. > > Give up :) > > Mark > > alter user system identified by * > > -Original Message- > Gholam Hussain > Sent: Monday, October 22, 2001 12:41 > To: Multiple recipients of list ORACLE-L > > > Hi Joe, > I am doing that on a test DB .Some guys were able to drop SYSTEM user > without any probem ...But I am facing some problem while droping it .. > > > Regards .. > > > > > -Original Message- > > From:Joe Testa [SMTP:[EMAIL PROTECTED]] > > Sent:Monday, October 22, 2001 2:15 PM > > To:Multiple recipients of list ORACLE-L > > Subject:Re: Droping System User > > > > sure dont drop system user. > > > > joe > > Ahmed Gholam Hussain wrote: > > > > > > Hi all , > > > I am unable to drop SYSTEM user in the first place ..I am getting this > > error > > > while trying to drop it : > > > > > > SQL> drop user system cascade; > > > drop user system cascade > > > * > > > ERROR at line 1: > > > ORA-00604: error occurred at recursive SQL level 1 > > > ORA-00942: table or view does not exist > > > > > > Please , can anybody explain to me why I am getting this error ? > > > > > > Regards > > > > > > > -Original Message- > > > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > > > > Sent: Saturday, October 20, 2001 12:55 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Droping System User > > > > > > > > hi > > > > > > > > I took risk in my test DB by dropping the user 'SYSTEM'. As you > > tested, > > > > the same steps i repeated in mine, all are fine, until before. > > > > > > > > Now i shutdown my database and startup again, here the problem > arises. > > > > Oracle mount the database but while opening the database, the > instance > > has > > > > been terminated by PMON. > > > > > > > > Sat Oct 20 10:57:45 2001 > > > > PMON: terminating instance due to error 470 > > > > Instance terminated by PMON, pid = 316 > > > > > > > > Oracle posted the following error continuosly in the alert log: > > > > > > > > SMON: following errors trapped and ignored: > > > > ORA-00376: file 1 cannot be read at this time > > > > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' > > > > > > > > Am crusious, come to know what type of problem you have faced? > > > > > > > > Regards, > > > > Nirmal > > > > > > > > -Original Message- > > > > From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] > > > > Sent: Friday, October 05, 2001 12:30 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject:RE: Droping System User > > > > > > > > > -Original Message- > > > > > From: [EMAIL PROTECTED] [ < < > <mailto:[EMAIL PROTECTED]
RE: Backup Strategy
Hi Kimberly , Thanks a lot for your response . Due to some resource limitation , we can not afford running our database on archive log always ... What we are doing now is daily cold backups with weekend based exports ... Most of our systems are OLTP .. Are we on good track ? Regards > -Original Message- > From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 7:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Backup Strategy > > Why export at all? As long as your database is in archive log > mode you should be ok. Do your cold backup to disk and always > have the latest on disk. That way you reduce your recover time > by not having to go to tape for your backup. I have all our OS > backups scheduled to go after the backup for Oracle and that way > I get the backup files off to tape just in case I have a really > horrible failure. > > Make sure that your archive logs are on a different disk then your > database files. You increase your chance of being able to fully > recover. > > You may also want to consider running a standby database in case > of failure during business hours. I don't run one here but I run > with ServiceGuard instead. > > -Original Message- > Sent: Monday, October 22, 2001 3:50 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > > It will depend on how much data you can afford to lose (in terms of time)? > > may be you can do > exp at 8, 9, 10, 11, 12, 13 > Cold backup at 14 > > or perhaps you want to consider RMAN > > > Sinardy > > > > -Original Message- > Gholam Hussain > Sent: Monday, 22 October 2001 6:00 PM > To: Multiple recipients of list ORACLE-L > > > Dear all, > >I want your suggestions regarding our firm's backup strategy... > > Our business starts from 7.00 AM and ends at 2.00 PM ..We can not afford > down times during our business period > > Normally , we are doing a cold backup every day using scheduled cold > backup > scripts .Is this backup good enough for any future failure ? Do we need to > change our backup strategy ? > How often do we need to make exports ? > > Any suggestions would be appreciated ... > > > > Regards > Gholam > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ahmed Gholam Hussain > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Sinard 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: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backup Strategy
Hi Rachel , Thanks a lot for your response ...Here are some details : (1)ost of our systems are of kind OLTP.There are some heavy hours of data processing transactions during the business hours ( Between 2 hours) (2) The issue is that our Dump files are some how too big and we have to care about resource utilization Normally we do a backup every weekend Regards > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 5:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Backup Strategy > > We'd need a little more information before we can give any advice > (okay, this group gives advice on no information but..) > > Some questions: > > 1) during the business hours, do you add critical data that you can't > afford to lose to your database? If so, you should be in archivelog > mode. The cold backups will suffice if you have the archived logs. > > 2) cold backups (or hot backups for that matter) allow you to recover > the whole database, but if you lose a table, or accidentally delete > data from a single table, it is difficult to use the backups to > retrieve the information. If your export dump files are not too large > and you have the disk space to store them, I'd do a full database > export daily as well. This does two things: allows you to recover a > single table or some of its data easily and documents the structure of > your database. > > Rachel > > > --- Ahmed Gholam Hussain <[EMAIL PROTECTED]> wrote: > > Dear all, > > > >I want your suggestions regarding our firm's backup strategy... > > > > Our business starts from 7.00 AM and ends at 2.00 PM ..We can not > > afford > > down times during our business period > > > > Normally , we are doing a cold backup every day using scheduled cold > > backup > > scripts .Is this backup good enough for any future failure ? Do we > > need to > > change our backup strategy ? > > How often do we need to make exports ? > > > > Any suggestions would be appreciated ... > > > > > > > > Regards > > Gholam > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ahmed Gholam Hussain > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __ > Do You Yahoo!? > Make a great connection at Yahoo! Personals. > http://personals.yahoo.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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Droping System User
Hi Joe, I am doing that on a test DB .Some guys were able to drop SYSTEM user without any probem ...But I am facing some problem while droping it .. Regards .. > -Original Message- > From: Joe Testa [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 2:15 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Droping System User > > sure dont drop system user. > > joe > Ahmed Gholam Hussain wrote: > > > > Hi all , > > I am unable to drop SYSTEM user in the first place ..I am getting this > error > > while trying to drop it : > > > > SQL> drop user system cascade; > > drop user system cascade > > * > > ERROR at line 1: > > ORA-00604: error occurred at recursive SQL level 1 > > ORA-00942: table or view does not exist > > > > Please , can anybody explain to me why I am getting this error ? > > > > Regards > > > > > -Original Message- > > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > > > Sent: Saturday, October 20, 2001 12:55 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Droping System User > > > > > > hi > > > > > > I took risk in my test DB by dropping the user 'SYSTEM'. As you > tested, > > > the same steps i repeated in mine, all are fine, until before. > > > > > > Now i shutdown my database and startup again, here the problem arises. > > > Oracle mount the database but while opening the database, the instance > has > > > been terminated by PMON. > > > > > > Sat Oct 20 10:57:45 2001 > > > PMON: terminating instance due to error 470 > > > Instance terminated by PMON, pid = 316 > > > > > > Oracle posted the following error continuosly in the alert log: > > > > > > SMON: following errors trapped and ignored: > > > ORA-00376: file 1 cannot be read at this time > > > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' > > > > > > Am crusious, come to know what type of problem you have faced? > > > > > > Regards, > > > Nirmal > > > > > > -Original Message- > > > From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] > > > Sent: Friday, October 05, 2001 12:30 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject:RE: Droping System User > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [ < <mailto:[EMAIL PROTECTED]>>] > > > > > > > > Dropping the SYSTEM user is not really all that traumatic. > > > > > > > > In most cases it's just a DBA account that may own some pieces you'd > > > > rather not lose, but dropping SYSTEM will not be noticed by the > users > > > > of the database. > > > > > > > > > That's the impression I get. When I looked at the objects owned by > SYSTEM > > > in my test database before the drop, none of them seemed vital. > > > > > > On the other hand, dropping sys would probably be bad, but I wasn't > able > > > to do that (insufficient privileges.) > > > Trying to drop sys tables like sys.user$ caused an ORA-00701. > > > So since I'm on a quest to wound this database, I tried this: > > > > > > SQL> delete from sys.user$ where name = 'SYS' ; > > > 1 ligne supprimée. > > > SQL> commit ; > > > Validation effectuée. > > > > > > So far no ill effects! > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ahmed Gholam Hussain > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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 > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > IM: n8
Backup Strategy
Dear all, I want your suggestions regarding our firm's backup strategy... Our business starts from 7.00 AM and ends at 2.00 PM ..We can not afford down times during our business period Normally , we are doing a cold backup every day using scheduled cold backup scripts .Is this backup good enough for any future failure ? Do we need to change our backup strategy ? How often do we need to make exports ? Any suggestions would be appreciated ... Regards Gholam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Droping System User
Hi all , I am unable to drop SYSTEM user in the first place ..I am getting this error while trying to drop it : SQL> drop user system cascade; drop user system cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Please , can anybody explain to me why I am getting this error ? Regards > -Original Message- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, October 20, 2001 12:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Droping System User > > hi > > I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, > the same steps i repeated in mine, all are fine, until before. > > Now i shutdown my database and startup again, here the problem arises. > Oracle mount the database but while opening the database, the instance has > been terminated by PMON. > > Sat Oct 20 10:57:45 2001 > PMON: terminating instance due to error 470 > Instance terminated by PMON, pid = 316 > > Oracle posted the following error continuosly in the alert log: > > SMON: following errors trapped and ignored: > ORA-00376: file 1 cannot be read at this time > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' > > Am crusious, come to know what type of problem you have faced? > > Regards, > Nirmal > > -Original Message- > From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 12:30 AM > To: Multiple recipients of list ORACLE-L > Subject:RE: Droping System User > > > -Original Message- > > From: [EMAIL PROTECTED] [ < <mailto:[EMAIL PROTECTED]>>] > > > > Dropping the SYSTEM user is not really all that traumatic. > > > > In most cases it's just a DBA account that may own some pieces you'd > > rather not lose, but dropping SYSTEM will not be noticed by the users > > of the database. > > > That's the impression I get. When I looked at the objects owned by SYSTEM > in my test database before the drop, none of them seemed vital. > > On the other hand, dropping sys would probably be bad, but I wasn't able > to do that (insufficient privileges.) > Trying to drop sys tables like sys.user$ caused an ORA-00701. > So since I'm on a quest to wound this database, I tried this: > > SQL> delete from sys.user$ where name = 'SYS' ; > 1 ligne supprimée. > SQL> commit ; > Validation effectuée. > > So far no ill effects! > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Droping System User
Hi list , Sorry for posting this strange question , but I am hopeful that I will get some explanation ... Question : Can we drop user SYSTEM ? How we will recover that ?( I know that nobody should do that !!! ) Any response would be appreciated TIA Gholam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: VB/Oracle question
Hi Brian , U need to install SQLNET or NET8 ( depending on your version of Oracle) to define your connection method to Oracle, configure your TNSNAMES.ORA file , then setup the requirements for the method in which u r connecting to Oracle through VB ... Example OLE Objects in case u r using it as method of connection to Oracle in VB Or Microsoft ODBC driver for Oracle in case u r using ODBC methods of connection. HTH Regards > -Original Message- > From: Brian King [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, September 26, 2001 7:20 PM > To: Multiple recipients of list ORACLE-L > Subject: VB/Oracle question > > If I was going to distribute a client VB application connecting to Oracle, > would I need to also distribute the Oracle Client tools or is there a > small > driver package to install without all the tools? > Thanks, > > Brian King > mailto:[EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brian King > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORA-12514
Hi Brian , U need to define the service name in your TNSNAMES.ORA file ...Or use NET8 Easy Config define to define that .. U can find the TNSNAMES.ORA under Oracle home It looks like the following : Service Name .WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = Server IP Address)(Port = 1521)) ) (CONNECT_DATA = (SID = Service Name )) ) Substitute the values of Service Name , Server IP Address as required Regards > -Original Message- > From: Brian King [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, September 25, 2001 7:50 PM > To: Multiple recipients of list ORACLE-L > Subject: ORA-12514 > > Hi all, > > I am new to Oracle and am having problems getting started. I have > installed > Oracle (8.1.7) on a Windows 2000 Server and have no problems connecting on > that machine (without specifying a host string). However, when I try to > connect to it remotely (on a different domain) I get and error (ORA-12514: > TNS:listener could not resolve SERVICE_NAME given in connect descriptor). > I > tested the listener and it is running. I have searched all over for help > and > cannot find any. I am simply tryin to connect remotely in order to begin > developing VB apps in the future. Thanks for any input... > > Brian King > mailto:[EMAIL PROTECTED] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brian King > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: changing the internal password
Hi , Use the Orapwd80.exe utility ..U can find it under the Oracle Home Regards Gholam > -Original Message- > From: Beatriz Martínez Jiménez [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, September 25, 2001 2:15 PM > To: Multiple recipients of list ORACLE-L > Subject: changing the internal password > > Hello, I am trying to log in the sqlplus (from command line) as the > internal user but I can´t remember its password. > Is there any way to change it? > TIA << File: Card for Beatriz Martínez Jiménez >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora-03121
Hi listers , I am getting this error while trying to connect to Oracle Designer2000(1.3.2) on Oracle 8.0.5 -Plattform NT4 : Ora-03121 : No interface driver connected-function not performed Does this thing requires the installation of some Oracle patches Any help would be appreciated ... TIA Gholam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).