Import warning: contains ROWID column...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Import warning: contains ROWID column...

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Unhappy

    Hi,

    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...

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Are you importing data or schema only?

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Only data. Schema (owner) was not dropped.

    Thanks
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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.

  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    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.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    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.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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.

    Oracle App from Oracle is a bad software.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width