Search Again: Re: ROWID From: =?iso-8859-1?q?nihraw=20jalal?= Date: Thursday, February 26, 2004 Time: 3:10:33 am 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. 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 --- 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. > > <?xml:namespace prefix = o ns = > "urn:schemas-microsoft-com:office:office" /> > > 1-Can I re-generate those ROWIDs without having to > execute that long process? > > 2- Can I identify invalid ROWIDS and how to do it? > > 3- Is there an easier process to solve this issue? > > > > Please, explain in detail, I'm just a beginner. > > Thank you. > > William Carrera > > > ___________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now 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 ----------------------------------------------------------

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