Hyphen in machine's network name causes ORA-44004
I am trying to execute the following command, copied from the 11g2 Advanced Replication API manual:
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => 'orc1.example.com',
interval => 'SYSDATE + 1/24',
next_date => SYSDATE,
stop_on_error => FALSE,
delay_seconds => 0,
parallelism => 0);
END;
Actually I can run this command as it is without problems. It does not check to see if the destination really exists on the network. But if I substitute the real destination machine name the command fails:
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_ASSERT", line 188
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2257
ORA-06512: at line 2
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => 'orc1.example.com',
interval => 'SYSDATE + 1/24',
next_date => SYSDATE,
stop_on_error => FALSE,
delay_seconds => 0,
parallelism => 0);
END;
Actually I can run this command as it is without problems. It does not check to see if the destination really exists on the network. But if I substitute the real destination machine name the command fails:
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_ASSERT", line 188
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2257
ORA-06512: at line 2
0