Subject | move an external table |
---|---|
Author | Rick Roen |
Post date | 2008-09-22T18:11:25Z |
FB super server v 2.1.1.17910
I have a windows server failure and had to move the FB server to a new
box. I use external tables to write logs and their disk location has
changed.
I need to tell the server where the new external tables reside, however
when I try to do this:
Alter table Log_Table
EXTERNAL 'e:\...\...\Log_Table.txt'
i get an error about not recognizing the token EXTERNAL.
How can I tell the FB server when to locate these tables now?
Rick
I have a windows server failure and had to move the FB server to a new
box. I use external tables to write logs and their disk location has
changed.
I need to tell the server where the new external tables reside, however
when I try to do this:
Alter table Log_Table
EXTERNAL 'e:\...\...\Log_Table.txt'
i get an error about not recognizing the token EXTERNAL.
How can I tell the FB server when to locate these tables now?
Rick