how to recover table which i already drop?

amitcvrce · New User Joined: 04 Jul 2007 Posts: 3 Location: bangalore

How to recover table or tablespace which i accidentaaly dropped.plz ans,thanks in advance

dick scherrer · Posted: Wed Dec 03, 2008 12:41 am

Hello and welcome to the forum,

You recreate and reload the table from a backup. Both the source to create the table, any permissions granted to that table, and the data that was in the table should have a backup.

If there is no backup, it will have to be re-entered.

anil.csk · New User Joined: 22 Oct 2007 Posts: 16 Location: Noida

you can not recover the data if you have not backup of data.

amitcvrce · New User Joined: 04 Jul 2007 Posts: 3 Location: bangalore

thanks for repling...but i dont have the structure of the table,,i have deleted it,
from back up how can i reload,

Arun Raj · Posted: Wed Dec 03, 2008 9:12 pm

amitcvrce

Dont you have the DCLGEN of the table in some library?

amitcvrce · New User Joined: 04 Jul 2007 Posts: 3 Location: bangalore

Ya dclgen is there..but what about the index?3 indexes were there for the table.

dick scherrer · Posted: Thu Dec 04, 2008 8:31 pm

Hello,

You will need to re-create them (and anything else that was dropped - like permissions).

Is the sql source for administration not kept in some pds or other library? If not, it should be - now

All of your administrative sql should be stored outside the database. This not only provides a backup but also provides an easier way to clone entities as the majority of the source is already available and is (should be) known to work.