Thanks for the swift replies.
DaPi, I had used a method similar to yours to get around the problem.
ie import ACCOUNTS to different schema, create ACCOUNTS_ddmmyy in my schema as select from different schema.
ACCOUNTS is very large table so I was just trying to see I could find a quicker way of doing things.


Thanks again.