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@xxxxxxxxxxx
403 399 2442
--
//www.freelists.org/webpage/oracle-l