-
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