19.3 - Hard Coded Schema Names Issue
From: Dave Morgan <oracle_at_1001111.com>
Date: Thu, 18 Mar 2021 13:06:22 -0600
Message-ID: <6db49a56-299a-3396-9715-9e7dc2bc43fc_at_1001111.com>
Hello all,
Dave
Date: Thu, 18 Mar 2021 13:06:22 -0600
Message-ID: <6db49a56-299a-3396-9715-9e7dc2bc43fc_at_1001111.com>
Hello all,
connect schemaname
CREATE VIEW TEST_VW AS SELECT * FROM schemaname.TEST;
will result in
ERROR at line 1:
ORA-02000: missing VIEW keyword
Removing the hard coded schema name removes the issue. I have long had a policy of no hard coded schema names so this did not affect us much, however, this seems a rather large change.
Or am I missing something, a configuration setting, documentation? That is usually the case.
TIA
Dave
--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited
dave.morgan_at_1001111.com
403 399 2442
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 18 2021 - 20:06:22 CET