oracle-databaseoracle11gdrop-table

by mistake i have dropped a table in oracle sql developer, how can I get the table back

i am working on oracle sqldeveloper, i am supposed to drop the table emp12. But i have dropped the table emp1 by mistake. Is there a way, so that i can get the table emp1 again. drop table emp1; can we get back dropped table using flasback query.

Solution

  • Contact your database administrator, he will be able to get the data back.