Hi,
We have a very large database (around 13GB) and need to migrate it across to a new server.
I know that there are a lot of tables in the DB that are redundant and therefore, to reduce size, I wanted to drop some of them.
I seem to remember that I was able to (in Enterprise Manager) view the list of tables with certain statistics against them. The one in particular is the physical disk space required to store the table and its data so that I can tackle the larger one first.
Does anyone know how I can get this data (preferably ordered by size in descending order).
Cheers (and Merry Christmas!)
Woody.
We have a very large database (around 13GB) and need to migrate it across to a new server.
I know that there are a lot of tables in the DB that are redundant and therefore, to reduce size, I wanted to drop some of them.
I seem to remember that I was able to (in Enterprise Manager) view the list of tables with certain statistics against them. The one in particular is the physical disk space required to store the table and its data so that I can tackle the larger one first.
Does anyone know how I can get this data (preferably ordered by size in descending order).
Cheers (and Merry Christmas!)
Woody.