Post reply

How to delete temp log information

  • May 8, 2012 at 9:21 pm

    #268624

    Hi,

    I have 200 millions of records in one table .I want to load it into set of tables based on the year.

    So while loading the data from one table to set of tables how to remove/delete temporary log information.

  • May 8, 2012 at 10:10 pm

    #1484854

    What is "temporary log information"?

    Never heard of it.

  • May 9, 2012 at 12:07 am

    #1484879

    Suresh B. (5/8/2012)

    What is "temporary log information"?

    Never heard of it.

    Please use universal Names. Search Google what you are looking for, find what it is Universally called and then post.

    Otherwise, we didn't understand what you mean by "Temporary log Information". Please explain and be precise about what it is that you mean by it.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • May 10, 2012 at 3:24 pm

    #1486013

    sudha.kotapati (5/8/2012)

    Hi,

    I have 200 millions of records in one table .I want to load it into set of tables based on the year.

    So while loading the data from one table to set of tables how to remove/delete temporary log information.

    If by remove/delete temporary log information you mean to say that your Transaction Log file grew as you eexecuted your DML statements and now you want that space to be freed on disk then you may want to read this article:

    Managing Transaction Logs[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply