-
hi folks,
Accidentally i happened to drop a table. So
before doing incomplete recovery i took a full
database LOGICAL backup to recover the transaction on other tables that occured after the table was dropped.
Then i did incomplete recovery using UNTIL TIME.
What should be the IMP statement just to reinsert the rows that were inserted after the table was droppeed.
When i say ignore=y, the rows get duplicated...but how to just import only the rows of other tables that were added after the table was dropped.
regards
sonia
-
when you lose a table you dont recover that way, you have to do tablespace point in time recovery
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
|