CODEWITHSUNDEEP
sqloracle-database
randy white
randy white

Reputation: 101

If you accidentally drop your table where does the table structure go to?

If you accidentally drop your table where does the table structure go to? So if I accidentally deleted a table where does the structure go?

Upvotes: 2

Views: 642

Answers (4)

Diego Scaravaggi
Diego Scaravaggi

Reputation: 371

If you are running at least 9i version and if your dbms does not make a lot of transaction. Hurry Up ! Digg into flashback area and recover it. I think that also the standard SqlDeveloper tool should have a gui for such operation.

Flashback 9i Howto

If you are running 10g or 11g then you have optimal chances.

Flashback 11g

Upvotes: 1

Toomai
Toomai

Reputation: 4234

The table structure is part of the table, so you can't really get rid of one without getting rid of the other.

So to answer the question, the structure gets launched into a black hole with the rest of the table.

Upvotes: 1

Derek Prior
Derek Prior

Reputation: 3517

Dropping and deleting are not the same thing. Generally, when people say they deleted (or truncated) a table, they mean that they removed the rows from the table. When a table is dropped, the schema for that table, along with all data, associated indexes, etc, is erased. Without a backup to restore from you are out of luck.

Upvotes: 4

Greg Hewgill
Greg Hewgill

Reputation: 994171

Dropping a table drops the table structure definition (since that's part of the table).

You do have a backup, right?

Upvotes: 2

Related Questions