drop column checkpoint, rollback ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: drop column checkpoint, rollback ?

  1. #1
    Join Date
    May 2001
    Posts
    16

    Question

    I have question about
    ALTER TABLE
    DROP COLUMN CHECKPOINT xxx ;

    Oracle says, specifying checkpoint will minimize the use of rollback space.

    Please clarify this, because as I understand checkpoint is a database event which synchronizes the modified data blocks in memory with the datafiles on disk. It offers Oracle the means for ensuring the consistency of data modified by transactions.
    checkpoint does not have any relation to rollback, it has a link with redo log.

    But I have tested this with a big table, it works as written.

    May be I have wrongly understood, please explain.

    Thanks
  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    dear sir/madam

    I will try to explain with my perception

    1. Oracle create Rollback/Undo with DDL statement.
    2. Drop columns is single Oracle command which has to work complete at statement level.Meaning whenever this command will be completed successfully then only changes shud perist with Data Dictionary.
    3. When u mention Checkpoint say for 1000 rows with every 1000 rows Oracle commit the transaction.
    4.So lesser Rollback/Undo.
    5. That is one of reason why they suggest marked column unused before dropping it.

    Experts Correct me I am deviating.

    Viraj
    -------------------
    9i OCA


    A Wise Man Knows How much he doesn't know !!!

  3. #3
    Join Date
    May 2001
    Posts
    16
    I understand.

    but point no. 5 is not right, because it will generate the same amount of redo even if marked unused.

    Only checkpoint keyword makes difference on rollback.

    Thanks

  4. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  



    Click Here to Expand Forum to Full Width