Archiving the data

[orajit]

Hi

I would like to run a a script automatically everyday that removes the data from say EMP table and put into another file that is over 6 months old
. How would I go about doing this?

Is there any query or method for that?

[r035198x]

Have a look at the EXP command and it's options.

[orajit]

No that havenot work out ,, please giv me any other alternative method .