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.

Printing a report in landscape mode

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

Convertion from Figures to Words

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

RE: Preparation for OCP 8i Upgrade

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

RE: Import Characterset problem

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

RE: Import Characterset problem

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

RE: Rollback Segment Too Old !!!!!!!

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

Backup Strategy

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

RE: Droping System User

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

RE: Backup Strategy

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

RE: Backup Strategy

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

RE: Droping System User

]] 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

RE: Droping System User

! -- 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

RE: changing the internal password

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

RE: ORA-12514

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Ora-03121

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