Solved

What to do with rowid after importing a DB dump?

Posted on 2004-09-22
4
1,464 Views
Last Modified: 2008-03-06

I built a testing DB box and got a dump file from the production DB.  The import went well with no issues at all.  I looked the log and saw the following message after a few tables:

Note: table contains ROWID column, values may be obsolete      xxxxx rows imported

Will this cause any issues and how to fix this?  Thanks.  
0
Comment
Question by:bxy11
  • 2
4 Comments
 
LVL 2

Expert Comment

by:LeeMiller
ID: 12123655
This is the answer Oracle gives for this situation.....
Problem Description:  

====================

When importing a table from version 7 into version 8, the following message

appears in the log file:

Table contains ROWID column; Values may be obsolete.

The table has a column defined as a ROWID datatype.

Solution Description:

=====================

Drop the table and recreate it or convert ROWID.

If the table data is not needed, the best practice is to describe the table

and recreate it in 8.0 from the description and begin logging the ROWIDs anew

in 8.0.

If the data from this table is needed, the user will need to convert the ROWIDs

to the Oracle8 extended format in order for the data to be valid (See document

reference below).

Explanation:

============

When this column is moved into Oracle 8 with its new ROWID definition there is

a conflict between the restricted (Version 7) and the extended (Version 8)

ROWID datatypes.
0
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 12124952
Anytime an import is done, whether from one Oracle version to another, or if the versions are the same, or even if the import and export are done on the same machine and the tables were deleted in between, this will happen if any of your tables has a ROWID column.  Yes, the ROWID values in that/those column(s) will be obsolete (innacurate, not valid, etc.) following an import.

Will this cause any issues?
That depends on your application.  Does it try to use these stored ROWID values to retrieve records?  If yes, you will either get errors (like: invalid rowid) or the records returned will not be the correct ones.
0
 

Author Comment

by:bxy11
ID: 12125212
I checked the several tables with the note message but do not see any ROWID column in there.  
0
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 80 total points
ID: 12129633
It is possible that the column(s) have a name other than ROWID.  You need to check the datatype.  Here is a query that can find them:
select owner, table_name, column_name from all_tab_columns
where data_type = 'ROWID';
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now