A relatively frequent cause of the error comes from the habit of using automatic programs to rebuild multiple indexes. How do I say "back in the day"? It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/ Report message to a moderator Re: ORA-01410: invalid ROWID [message #494356 is a reply to message #494353] Unfortunately, you can still have a problem even if you are using the correct ROWID in the correct update.

Related « Book Review: Oracle SQL Recipes: A Problem - SolutionApproach Reading Material OnOrder » Actions Comments RSS Trackback Information Date : June 8, 2010 Categories : General Administration 3 responses The objective of this statement is to find all candidates for which I need to generate data in additional tables. NOTNA and we said... Followup October 06, 2006 - 5:03 pm UTC with the bulk collect there cannot be any concept such as "the current row" you just fetched 100 of them - which one

Edits are subject to review by community moderators. Regards Michel Report message to a moderator Re: ORA-01410: invalid ROWID [message #494605 is a reply to message #494596] Tue, 15 February 2011 23:50 vickey_sagar1 Messages: 77Registered: August Please replace these characters in the code sections with the HTML equivalents for these characters: < < > > Blog at WordPress.com. %d bloggers like this: I will accept the reality that ORA-01410 occurs, but I need to be convinced that the posted SELECT actually produces it.

Since you are joining six different tables, and updating 5, one row of the query results represents six different ROWIDs. There is also a limit to what others can do for you, even Oracle support will not able to help in any way if you do not provide as easily reproducible SQL> SY. Second job aborting due to ORA-01410: invalid ROWID error.

Report message to a moderator Re: ORA-01410: invalid ROWID [message #494373 is a reply to message #494372] Mon, 14 February 2011 00:23 BlackSwan Messages: 24958Registered: January 2009 Location: Under the covers that is all current of does - it adds rowid to your query and adds the where rowid = to the predicate. SQL> commit; Commit complete. Any tips for formatting would be helpful too. –Wamglind Carmasaic May 21 '14 at 11:53 @Ben Sorry, It's difficult to edit a question from my mobile phone.

can phone services be affected by ddos attacks? By The Way I passed SQL' paper of OCP, And I want to thank you for that Because reading your site I got really good knowledge of SQL. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Can a person of average intelligence get a PhD in physics or math if he or she worked hard enough?

FROM one_table WHERE ROWID = :a_rowid_value_from_another_table ( or some similar UPDATE or DELETE statement ). don't know what X1 is but... How can I compute the size of my Linux install + all my applications? Please suggest me why its happening.

Diff rebuild and re-craete of index. Based on this am telling table1 rowids are coming to table2 processing Please suggest how to proceed further, thanks in advance. Except if the code is written in that way. PCMag Digital Group AdChoices unused current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list.

You can use EXCLUSIVE lock on the table and then start your work. Please take a look at the following logfile: 02:24:48 SQL> rem ___________________________________________ Artfdek suchen 02:24:48 SQL> rem ==================================================== schaun was drinnen ist 02:24:48 SQL> def fiup_leit = fdek_l&seq_num 02:24:48 SQL> def If you know the block id, you may be able to use a statement such as: delete from

Elapsed: 00:00:00.16 02:24:49 SQL> create unique index &fiup_klein._u1 on &fiup_klein(nummer ) 02:24:49 2 tablespace &&ind &&klein &&unrec ; old 1: create unique index &fiup_klein._u1 on &fiup_klein(nummer ) new 1: create unique It's a problem I've responded to a few times in newsgroups and presentations, but I realised recently that despite mentioning it casually for several years I've never written a specific note Original answer by iudith mentzel May 26, 2013 Contributors: Top 1 membervote...

Then you need to use the correct t?rid for the correct update statement. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... SQL> truncate table temp_Tbl; Table truncated. To start viewing messages, select the forum that you want to visit from the selection below. Is it possible to control two brakes from a single lever? Report message to a moderator Re: ORA-01410: invalid ROWID [message #494370 is a reply to message #494...

Based on this am telling table1 rowids are coming to table2 processing Please suggest how to proceed further, thanks in advance. for update. Also, if the under-second accuracy is not essential to your calculation, you can use CAST(SYSDATE AS TIMESTAMP) instead of SYSTIMESTAMP You should master the datetime functions and data types and play oracle plsql cursor share|improve this question edited May 21 '14 at 12:00 asked May 21 '14 at 11:42 Wamglind Carmasaic 838 Please, format the question &...