How Oracle Move Table to Another Tablespaceby Ed ChenDecember 8, 2021May 14, 2022Alter Table Move Tablespace Basically, moving an Oracle table can defragment the data and make it compact so as to gain some benefit when performing… Read More »How Oracle Move Table to Another Tablespace
How Oracle Move LOB to Another Tablespaceby Ed ChenDecember 6, 2021May 15, 2022Alter Table Move LOB Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible… Read More »How Oracle Move LOB to Another Tablespace
How Oracle Move Index to Another Tablespaceby Ed ChenDecember 3, 2021May 14, 2022Alter Index Rebuild Tablespace To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options… Read More »How Oracle Move Index to Another Tablespace
How RMAN Backup Parallellyby Ed ChenFebruary 15, 2021April 27, 2022RMAN Parallelism To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle… Read More »How RMAN Backup Parallelly
How to Gather Statistics on Database Level for Various Situationsby Ed ChenNovember 19, 2016December 14, 2021DBMS_STATS.GATHER_DATABASE_STATS We usually gather statistics of the database globally after data migration. The following examples are very practical in post-migration phase. Default You can do… Read More »How to Gather Statistics on Database Level for Various Situations