Database Administration (MOSC)

MOSC Banner

Need help with an error "Invalid Rowid"

edited Feb 23, 2011 6:02PM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hi,

I did an full database export of 8.0.6 (Win 2000 server) database and imported in 10.2.0.1 (Windows 2003 server). Almost everything is working fine except few things.

1) Synonyms are not compiled.An error shows "Synonym translation is no longer valid".

2) In one very important procedure for our application, we are getting "Invalid Rowid" error. This procedure is updating records in few tables. I read in a document that export/import will change the rowid and might cause problems.

What do i need to do to overcome these errors. Do i need to rebuild indexes involved in updates?

Please suggest,

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center