Hello, Is it possible to create a view on external table ? I need to replace a table of the DB by an external table. Like this I don't need to modify my stored procedures I can't use Stored procedure to do this, because index are not used with it
I tried to do this, but it's not correct : CREATE OR ALTER VIEW TEST AS EXECUTE statement 'SELECT * FROM TEST' ON EXTERNAL DATA SOURCE 'c:\mtdb.fdb' as USER 'SYSDBA' PASSWORD 'masterkey'; Thank you Eric
