Search Again: Re: ROWID From: =?iso-8859-1?q?nihraw=20jalal?= Date: Friday, February 27, 2004 Time: 2:22:13 pm Hi William, To help me focus on your problem, can you tell me the following please: 1. Are you simply trying to migrate data to another system? 2. Or, are you managing a Replication Architecture via multiple systems? In case one above: Purging of blocks of data form a table is not possible because the system losses the track of row positions in the blocks. ROWIDs are just like memory addresses in operating systems once corrupt data gets lost, that is why you either have to export full tables or you cannot dissect them and purge parts. However, in this case the ROWID on the new system will not correspond to the original system ROWID. In case two: This is a complex architecture and purging of data is managed by the DBMS and the term purge in this case simply relate to synchronising or mirroring data on multiple but liked systems. Regards Nehro --- William Carrera <William.Carrera@DataMaxGroup.com> wrote: > 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. > > 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 > 2-Is there a way to identify this problem on each > table before executing the purging package?. > > William Carrera > SQA > > Bizware Software Solutions > > 4837 Levy Street > St-Laurent, QC Canada H4R 2P9 > > (514) 341-0101 - Phone > (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. > 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 > ---------------------------------------------------------- > > ---------------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit > http://www.digitalpoint.com/lists/oracle.html > ---------------------------------------------------------- ___________________________________________________________ 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