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

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