How to recover a table once its dropped

Database
Enthusiast

How to recover a table once its dropped

Unfortunately i dropped one important table in teradata
is there any way to recover that table back to normal
Please help me

Thanks
Chinnababu
4 REPLIES
Enthusiast

Re: How to recover a table once its dropped

Only if your DBAs have taken a backup...
Enthusiast

Re: How to recover a table once its dropped

It is a general strategy to use fallback option for important tables.

Enthusiast

Re: How to recover a table once its dropped

Fallback doesn't help you recover a dropped table. Your only recovery options are to restore it from a previously archived copy or reload it from source data.
Enthusiast

Re: How to recover a table once its dropped

Thanks Jim. Thanks for correcting me. Yes. Fallback doesn't help recover a dropped table. Becauae when we drop the table the fallback copy is also dropped. I wonder how I could think of that post. May be I did not connect to the question properly. Sorry Cinna.