Search Again: Re: ROWID From: William Carrera Date: Thursday, February 26, 2004 Time: 6:22:34 am Nehro, Thank you for you answer, I appreciate. My database is too big and it = can contain tables with a lot of records from many years of data, that's = why I'm looking for a better or faster solution to satisfy my customer = needs.=20 Questions: Can you explain to me if you may: 1-What is it exactly the issue with ROWIDs that doesn't let me execute = my purging package, unless I do Export/Truncate/Import? and=20 2-Is there a way to identify this problem on each table before executing = the purging package?. =20 William Carrera=20 SQA =20 Bizware Software Solutions 4837 Levy Street=20 St-Laurent, QC Canada H4R 2P9 (514) 341-0101 - Phone=20 (514) 341-8999 - Fax -----Original Message----- From: oracle-list@digitalpoint.com [mailto:oracle-list@digitalpoint.com]On Behalf Of nihraw jalal Sent: Thursday, February 26, 2004 6:10 AM To: Oracle List Subject: Re: [Oracle] ROWID Hi William, I don't know how big is your database but even with tables of upto 50 million rercords exports should not take more than several hours.=20 Rowids are system generated and can not be changed and should not be attemted. There can not be be invalid rowids in an Oracle managed database. You will get new rowids differant from your originals generated on the new system when you export your data. You must always have self generated URNs to link your data accross systems. Regards Nehro=20 --- William Carrera <William.Carrera@DataMaxGroup.com> wrote: > I'm trying to purge blocks of data from different > tables in the database. But the purge package > doesn't purge the data selected. The only solution > to this problem is to Export/Truncate/Import the > data on that table. The problem with this solution > is that I have too many tables and this process is > too long to execute. It looks to me that the main > issue here is the ROwID. >=20 > <?xml:namespace prefix =3D o ns =3D > "urn:schemas-microsoft-com:office:office" /> >=20 > 1-Can I re-generate those ROWIDs without having to > execute that long process? >=20 > 2- Can I identify invalid ROWIDS and how to do it? >=20 > 3- Is there an easier process to solve this issue? >=20 > =20 >=20 > Please, explain in detail, I'm just a beginner. >=20 > Thank you. =20 >=20 > William Carrera=20 >=20 >=20 > =20 =09 =09 =09 ___________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping"=20 your friends today! Download Messenger Now=20 http://uk.messenger.yahoo.com/download/index.html ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ---------------------------------------------------------- ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: ROWID by William Carrera on Feb 24, 2004 at 1:17:46 pm Re: ROWID by =?iso-8859-1?q?nihraw=20jalal?= on Feb 26, 2004 at 3:10:33 am Re: ROWID by William Carrera on Feb 26, 2004 at 6:22:34 am Re: ROWID by =?iso-8859-1?q?nihraw=20jalal?= on Feb 27, 2004 at 2:22:13 pm