Another wierd issue I had exporting the OTM5.0 database to OTM55 was when I used the DB user SYSTEM to do a full export of the database with direct=y the export would not export any rows in the table GLOGOWNER.USER_MENU_LAYOUT, saying
Table USER_MENU_LAYOUT will be exported in conventional path.
. . exporting table USER_MENU_LAYOUT 0 rows exported
This table does hold 16 rows that are crusial to the custom menues.
This is related to the VPD policies, but when I use the sys DB user to perform the export the data in this table is exported?
OTM suport says that I should use SYSTEM even though it doesn't work so keep this in mind if you do not want to recreate all your custom interfaces.
Cheers,
Runi
Table USER_MENU_LAYOUT will be exported in conventional path.
. . exporting table USER_MENU_LAYOUT 0 rows exported
This table does hold 16 rows that are crusial to the custom menues.
This is related to the VPD policies, but when I use the sys DB user to perform the export the data in this table is exported?
OTM suport says that I should use SYSTEM even though it doesn't work so keep this in mind if you do not want to recreate all your custom interfaces.
Cheers,
Runi