Kbase P12505: How to change the foreign owner of an ORACLE table through 4GL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to change the foreign owner of an ORACLE table through the 4GL?
GOAL:
How to change the FOREIGN OWNER within the schema holder for Oracle?
GOAL:
How to assign the value of the foreign owner via the 4GL
FACT(s) (Environment):
Oracle DataServer
FIX:
Here is the code that allows you to change, through the 4GL, the existing FOREIGN OWNER, USER1, to a new FOREIGN OWNER, USER2
FOR EACH _db WHERE _db-type = "oracle".
for EACH _file OF _db.
IF _for-owner = "USER1" THEN
_for-owner = "USER2".
DISP _file-name _for-owner.
END.
END.