Skip to Content
author's profile photo Former Member
Former Member

table deleted and new created with same name !!!

Hello friend,

We are facing a strange problem; actually we deleted the tabled and recreated with same name , now it gives some error while activating it...

something like inconsistency DD_- DB or so

Any idea what can be done to fix this issue..

Regards,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 01:32 PM

    Hello Shah,

    Have you set the technical attributes. Check it.

    Reward If useful

    -


    Sasi.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 01:33 PM

    Hi,

    Goto SE11>open ur table in change mode>menu bar>Utilities>Database utility.

    There u will find option "Delete database table" press it..

    Come back and reactivate your table..

    Thanks and Regards,

    Vikas Bittera.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2007 at 01:33 PM

    Did you try SE14 to adjust the database.

    Nevertheless the table should have been destroyed in the data base.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 01:39 PM

    Hi,

    In SE11 click on UTILITIES->DATABASE UTILITIES and adjust database and activate. Hope will solve ur issue.

    <b>reward points for helpfull answers</b>

    Thanks

    Tanweer

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2007 at 02:42 PM

    Are there any logs in transaction SM21? I am out of ideas now. Maybe running a db02 check and if this doesn't work drop the table using native sql (first delete it from r/3 though) will help you.

    Also the reconstruct button in SE14 is active?

    Transaction SE14 enter the table name and select EDIT, choose Table -> Reconstruct.

    Kostas

    Message was edited by:

    Kostas Tsioubris

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.