Try something like:
a) in PL/SQL as dynamic SQL:
CREATE TABLE ACCOUNTS_ddmmyyyy AS SELECT * FROM ACCOUNTS;
(you will need some code to generate the tablename)
b) the export job should select this table - again you'll need to generate the names to use in the parameter file (how? - will depend on OS).
c) DROP TABLE ACCOUNTS_ddmmyyyy; when you are done.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote