-
Export / Import question
Hi all,
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
ACCOUNTS_ddmmyyyy.
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|