Subject Re: External tables
Author davidalbiston

You need to drop the external table (this does not delete the file).


--- In, "Dorin Vasilescu"
<dorin_vas@y...> wrote:
> Hi all
> Is there a way to close a file handle of an external table file for
> embedded server?
> I've tried to speed up things by storing static and lookup data in a
> local database and to get only transactional data over the wire (DSL
> connection). Then get all that is needed for presentation in UI or
> reports with a join between an external table filled with remote data
> (ids mainly) and tables from local database, using the embedded server.
> It works well and very fast, but only first time :(
> At the second attempt to fill the external table file, it fails,
> because the file is open.
> Any ideas?
> Or another approach?
> Thanks in advance