Home » RDBMS Server » Server Utilities » Migration from 8i to 9i:Export of Message Queue Data of 8i version to 9i version
icon9.gif  Migration from 8i to 9i:Export of Message Queue Data of 8i version to 9i version [message #127353] Mon, 11 July 2005 06:11
vivek_203
Messages: 1
Registered: July 2005
Junior Member
While migrating the Oracle version from 8i to 9i->the data is exported, the 9i version installed and the data is imported into the new version. During export of Multi_Message_Table, the error occurred -
importing <Schema-Name>'s objects into <Schema-Name>
IMP-00060: Warning: Skipping table
"<Schema-Name>"."MULTI_MESSAGE_TABLE" because object type "SYS"."AQ$_JMS_OBJECT_MESSAGE" does not exist or has different identifier

Question :
1) Why does this error occur?
2) Is it necessary that Tables containing queues should be empty before exporting/importing tables?
Previous Topic: imp error
Next Topic: External Table
Goto Forum:
  


Current Time: Wed Dec 25 20:09:17 CST 2024