Unanswered: Restoring Table from last nights backup
I have a table in Oracle 8.1 that was accidentally truncated and need sto be populated back form last nights backup.
Can I do it without dropping that table,
also if I have to drop the table, if I import it back will alll the constraints be recovered too.
Here is the command I am planning to use.
imp user(where data is imported)/pwd (where data is imported) TABLES=tablename rows=y