After export of peoplesoft database using DataMover, one may get "Unable to retrieve current DDL space name" error while altering tables. For this check a few tools tables like PSSTATUS, PSACCESSPRFL etc. Some details may be lower case. eg . PSSTATUS . OWNERID column might have ownerid in lower case (sysadm).
In Oracle, if one checks DBA_TABLES.OWNER, sysadm would be in upper case.
Update PSSTATUS.OWNERID to upper case and you should be able to alter tables through Application Designer.
No comments:
Post a Comment