Space issue during tables refresh
Hello,
We are trying to refresh two tables data from production to testing environment.
Actual size of the tables in production is around 300MB resp. indexes of 700MB and 10GB. Testing database setup is as same as Production database including tablespace sizes. But while refeshing data(using INSERT into <table> SELECT ... from <table>@db_link) the size in Testing database is keep on increasing above the actual production size.
For 300MB table it increased to 3.5GB in Testing and 7GB for resp. indexes. And for 10GB table loading UNDO is getting utilized like anything. Now increased to 25GB still is getting failed saying unable to extend UNDO.
We are trying to refresh two tables data from production to testing environment.
Actual size of the tables in production is around 300MB resp. indexes of 700MB and 10GB. Testing database setup is as same as Production database including tablespace sizes. But while refeshing data(using INSERT into <table> SELECT ... from <table>@db_link) the size in Testing database is keep on increasing above the actual production size.
For 300MB table it increased to 3.5GB in Testing and 7GB for resp. indexes. And for 10GB table loading UNDO is getting utilized like anything. Now increased to 25GB still is getting failed saying unable to extend UNDO.
0