Hi all
I'm making some experiments with table archiving and I'd like to
"replace" a full table F with an empty one E.
In order to do this I see only one way:

ALTER TABLE F RENAME TO T;
ALTER TABLE E RENAME TO F;
ALTER TABLE T RENAME TO E; -- optional

This implies there's a moment when the full table doesn't exist.
Would a transaction enclosure ensure that the table F will be always
available to all clients?
Thanks.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS