!!!!@ rollback drop table


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: !!!!@ rollback drop table

  1. #1
    manju Guest

    !!!!@ rollback drop table


    Hi,
    i am not able to get the recovering information for the table which i
    am dropping after doing the settings i.e. database in archive log mode.The
    output after drop table statement is

    List History File for sample

    Number of matching file entries = 0


    Seeking Help!!!!!

    Thanx a lot
    -Manju





    "kishore kolla" <kolla_kishore@yahoo.com> wrote:
    >
    >"geo" <gus.insa@terra.es> wrote:
    >>
    >>It's possible rollback a drop table in db2?

    >
    >Response:
    >Yes, if you have database in archival log mode..
    >Run following command:
    >db2 list history dropped table containing <schema.object_name> for database
    ><db-alias-name>
    >With this command you get all the details for recovering table
    >[Refer DB2 Admin guide for details], If you need help let me know.
    >
    >Thanks
    >Kishore Kolla
    >
    >



  2. #2
    Vijay Guest

    Re: !!!!@ rollback drop table


    Pls refer to following link:

    http://news.devx.com/cgi-bin/dnewswe...item=349&utag=


    "manju" <manju@premiertechnologygroup.com> wrote:
    >
    >Hi,
    > i am not able to get the recovering information for the table which i
    >am dropping after doing the settings i.e. database in archive log mode.The
    >output after drop table statement is
    >
    > List History File for sample
    >
    > Number of matching file entries = 0
    >
    >
    >Seeking Help!!!!!
    >
    >Thanx a lot
    >-Manju
    >
    >
    >
    >
    >
    >"kishore kolla" <kolla_kishore@yahoo.com> wrote:
    >>
    >>"geo" <gus.insa@terra.es> wrote:
    >>>
    >>>It's possible rollback a drop table in db2?

    >>
    >>Response:
    >>Yes, if you have database in archival log mode..
    >>Run following command:
    >>db2 list history dropped table containing <schema.object_name> for database
    >><db-alias-name>
    >>With this command you get all the details for recovering table
    >>[Refer DB2 Admin guide for details], If you need help let me know.
    >>
    >>Thanks
    >>Kishore Kolla
    >>
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center