Hi All,
I tried this script to rename a column that is empty.
UPDATE SYS.COL$ C
SET C.NAME = 'CANDIDATE_BALANCE'
WHERE
C.NAME = 'BALANCE' AND
C.OBJ# IN (SELECT O.OBJ#
FROM SYS.OBJ$ O, SYS.USER$ U
WHERE
O.OWNER# = U.USER#
AND
U.NAME = 'SCOTT'
AND O.NAME = 'ACCOUNT_ONE');
COMMIT;
When I ran this script and the feedback was 1 row updated. But when I did a desc on the account_one I do not see the column name change. Can someone tell me what I did wrong here?
Thanks
mkey
I tried this script to rename a column that is empty.
UPDATE SYS.COL$ C
SET C.NAME = 'CANDIDATE_BALANCE'
WHERE
C.NAME = 'BALANCE' AND
C.OBJ# IN (SELECT O.OBJ#
FROM SYS.OBJ$ O, SYS.USER$ U
WHERE
O.OWNER# = U.USER#
AND
U.NAME = 'SCOTT'
AND O.NAME = 'ACCOUNT_ONE');
COMMIT;
When I ran this script and the feedback was 1 row updated. But when I did a desc on the account_one I do not see the column name change. Can someone tell me what I did wrong here?
Thanks
mkey