I have question about
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.
Click Here to Expand Forum to Full Width