Hi!
When i run this query in another scheme than lims_sys i get the message "ORA-03001: unimplemented feature". When i run the same query in lims_sys scheme and then in the previous scheme than there is no message.
1. Could someone explain what is happening here?
2. How could i accomplish that this query can be run in another scheme without first have to run in lims_sys?
Greetings
WITH v1 AS
(
SELECT aliquot_id
FROM lims_sys.aliquot
),
v2 AS
(
SELECT aliquot_id
FROM v1
)
SELECT *
FROM v1,v2