I want to export a table 'ACCOUNTS on a daily basis, with export dump file name ACCOUNTS_ddmmyyyy.dmp. I may need to re-import this table at a later date so that I can compare balances between any two days.
At the moment, when I do the import I need to import the table into a different schema as I dont want to overwrite the live ACCOUNTS table.
(The import tries to 'CREATE TABLE ACCOUNTS')
I would like to import the table into the same schema with table name
Is there any option that I can specify at the export stage that can, in effect, rename the table to the same name as the dump file?