Using a simple select statement and spooling out means that the spool file
will contain column headers, which makes the process of loading back the
data staright from the spool file difficult, since you'll have to strip off
the headers. If there a way of spolling without the headers??
Another thing is, the data archiving program should be able to pick up data
from all tables (or tables pre-defined in a special table setup for this
purpose), instead of specifying the tables to archive one by one
interactively or in an SQL script.
I know this is possible in PL/SQL, but the thing is i'm a newbie to this,
and i need some reference on how i go about doing 'dynamic' table
extract...
Any help??
Received on Thu May 07 1998 - 18:41:12 CDT
