I am testing Import after doing upgrade from 8.0.5 to 8i on NT.
I exported owner GL and now importing back.
During the import, it gives warning
'GL_BC_PACKETS table contains ROWID column, value may be obsolete'
It is Oracle apps database and there are many tables which have ROWID column.
Is it a serious warning?
What should I do?
Thanks in Adv...
05-20-2002, 03:42 PM
Are you importing data or schema only?
05-20-2002, 03:44 PM
Only data. Schema (owner) was not dropped.
05-20-2002, 04:03 PM
Prior to 8i, you can create a table with ROWID as a column name. This is not supported in 8i.
For example, in 7.3.4,
CREATE TABLE TEST ("ROWID" VARCHAR2(30)); will work, but not in 8i.
Check the old database.
05-20-2002, 04:43 PM
I think you have understood it wrongly.
I have a column called 'ABC' having a data type as ROWID and not the column name as ROWID.
After upgrading the database from 805 to 8i, I am getting above warning during import of a particular table, which as a column with ROWID datatype.
05-20-2002, 06:05 PM
Oracle is warning you that the content of the imported values of type ROWID are probably totaly meaningless after the import. It is only a warning, nothing else.
When you have column of type ROWID, you usually have it to store actual rowids for some purpose. Now if you export that table and import it again (for example in another database), those rowids are now probably totaly meaningless, because the location they are pointing to are occupied by something totaly different or might not even exist at all. So imp utility is warning you about that fact.
05-21-2002, 01:41 PM
I opened the TAR with Oracle for this problem and they say that I cannot use Export/Import for these tables. Even though it is a warning, it might give problem in the application after Import.
So, how do I remove free space fragmentation for schema, which has this type of table?
Also, what do I do if someone drops the table and I have to import it back.
Pl. give some idea.
05-21-2002, 05:29 PM
After import, update the column with rowid value.
It is not a good idea to use rowid data type in a table, because physical rowid changes when the table is moved from one tablespace to another tablespace or even you do reorg on the table.