View previous topic :: View next topic
|
Author |
Message |
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 |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
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, |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
amitcvrce
Dont you have the DCLGEN of the table in some library? |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
|