Oracle Streams reduce tablespace
edited Jun 25, 2018 2:54PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
Hi, I have a setup Oracle 10gR2 Streams between two databases on Linux, the tablespace STREAMSTS has become very large because the table APPLY_dbQTAB is 33 GB, you can truncate this table and then reduce the tablespace?
Thanks
KI1Xuof9mhuYefM2by6DVElMG3rtEVajCz+hgemMBQRAEQdAl9qgVuye0ole4/cfv453Zh3uzj/779MO9WcYP9k/v7c/en56+Pz1998+nb++c3n7y4zuPaj+vCA6a4n0q4GrvAl5qCoIgCIKjILQiMFT810ff3vvkx/u7pw92fxK8/+fT93dO3905fXfn9J1Pfrr95MC7j09++/CbObSiBzzafL3+q7DAjqg+FQmCIAiC4GAZzE5/7oqzs54JregVDv/+w71H/9x88s39J/8S3HzyzXuPv8v47uNv33n0r98+/ObF37+fQyu6zdPZWafs3ITTs845dBN6HxE64OpbypI87ZgrN7AFdhcU9RUdjeAuj8CEobPrW4C7UI9O9BXQioAvgFZ0mdCK0IpD4OpbypJE8FdNaEUH7vIITBg6u74FuAv16ERfMTatCIIWrrrNg0ZCK0IrDoGrbylLEsFfNaEVHbjLIzBh6Oz6FuAu1KMTfcWotGIHHLwfdD3mdR3i9xHlgw5w8F4ErQitOAQi+KsmtKIDd3kEJgydXd8C3IV6dKKvgFZceWTQsQnQiuAQOHgvglaEVhwCEfxVE1rRgbs8AhOGzq5vAe5CPTrRV0Arrjwy6NgEaEVwCBy8F0ErQisOgQj+qgmt6MBdHoEJQ2fXtwB3oR6d6CugFVceGXRsArQiOAQO3ougFaEVh0AEf9WEVnTgLo/AhKGz61uAu1CPTvQVwa0bExAEQRAEQRAEQRCkDG7dmPz72r+BIAiCIAiCIAiCoGCuFVf903cAAAAAAAAAAABAh7h1Y9IofakVX351YGedNCAIgiAIgiAIgqCD7EorZvmu3DxwBIQvgSDYP9HzgG0RvuRbVXhiJuz1hNCKoOuEL4Eg2D/R84BtEb7kW1V4Yibs9YTQiqDrhC+BINg/0fOAbRG+5FtVeGIm7PWEy2rFIAiyvwJ+1iPYHeFLnvL59UsXr79YeTFAX+lFz4NW1gu98CXHq6JfV/ftjsPecRPriu3zxc0LQjlfuvnxysszdPrsS/6QaTXs0F5/vNdTPr9+iTZJRMmglePrebpvZR/fvhgowCD4sgtfen79Eq3hVfdmpp9Za6EqSkvXt9lvM8P1D6aUWgUGQRAEF24/N1x9oYpd/I4vM04ZRr3uzKxlb1sjb0e2LFSeivubFfXqXXFk+2oQNL2Ke/YuqxWxrij44uYF4hB3NzBSLk1vfckf8q1mydGLHTUvrm9cLDrcVUdXoOMcWc/TUyuzH/eVbfvS3Y0ycLy7QULSFRqoKMMsZGynKuq4U2UaXSvWcdGVaMWFxyl+1OvQzFr2tjXydmRLR1pRNflC46u4Zy/WFdsi7cHJXaEzXvnc2Me3L65vP79+6eL121dzmb2xVZxCZxHKNNykmgf01Zf8oaXVrG9cJG1haz0Iisk5pZnk+YimVK5vqNOZW+v5bF/RKslii2hx+XVFPnzbXH3VgR1yXD1PX62MZp7/+/Hti0ULyoqxRS/qRePqQCvK8UBe4dK67sZWr7Wqa8XWqkJeM5RCJs3wS1fXzR27XSuSyf3n1y8FF24/N3t4d3fcME5pt7JeaTs2s5a9rEW0YFpfpI68C9tiDKdF5lL60meq1FQNrXh9++aFrGzbV4ONm4Z4gzHBXXsX14oBnlfUm4R6a9e3i579xc0LG1fXN7YOXn51dyNrG6IxbK0HF6+/oGOAaD9Kg/GMnvqSPzS1GtJvlksieWKtmUjxqCHb4sj2VRpkkATZYCauu7VeRs/8RVdddWCXHFXP01srY4+LMFFpYtkRMkTa8hwyW/el7Sz+EyuKeoX33mXRpUXTouKCVSHrJSlkqrMHVXidZQ+qNJv/8e2lF8GW1YrqOMXdyjql7djMWvayFrFakR95F7bFGk6LzJm1nIPtqxVrM3W04gvRxyr2UrdkTXDVXqwrtkSjVjzYvnrh9vOD7avr28+vX8q6LaXzIreWoPCzlZu2OnrqS/7QEsXS1pF1avWbieUIs9pPumNT8KFfdOVVB3bJUfU8vbUy/rgYB/VpmmKlcdSNqytfyhaB9VhCrCr0W6tUK7ZZFawO1LtxJhTmOnYlT5nZSsvyD9ctrxUlAw23srq0HZtZy16TRfVv5WK22Hsw5irZpolazaSeVszndKROT3FL1gRX7V1WK9LSLdtOhk3DPp9sRXHr7kY+Nbu+vbWuDpmmuQdoRU99yR9W7dz+ioti6ytD7siLmxfyPSEirtIzN2lL0A+Oq+fpq5UZjm9fDTa2imlvViuOunF16UuK5idrv713WdnSomVRccGqWEArWjp2JU+FW+uuaEVlnFqstB2bWcveSouW04pGW+y1YUxWS0HV1IrcBBy3lquY4Kq9WFdsjcZ32zy/vnEx37v84ub6xtV1dQN9/vnuRvUWbb/orS/5w8q3bry4eUF+eENrJuzuOP6RnvIqymRzXgzjiKVfFBwzR9bz9NTKxHE9amFfvlrulhxz42rZl55fv6TsPiWz0uTtiyuo1UpLO9SKhpkOtWNX8pQoHhoiAf1C67GtaMVynOJvZY3SdmxmLXtNIy9dHV1cK1pssYbTnOds5AJM2w7a9P6aZJvulqwJrtq7uFYM8LyiRvpecnLbyK3V9w2rN9K8ccI/+uxL/pBpNc+ZrRq2jRzkSJZDtv3DOHVaNMPt4snv/KUIlhGLLRI4Uo6v5+mjlSk5lJQfsClDBvKAzXgbV9u+RN9hQ1/cUr55KBDCybFaXeo3MyxaUbhi8W4bY8euZiuqkYTa+WO0JNue320j/qXhonQr65W2YzNr2WuwSHRH1SPvwrZYwmndc25eF82nsh4W1Iq6Wxruo5v2Yl0RdJfwJbCk8rA7CHZGf3ueLloZzdO/CVB/fcnXqvDETNjrCaEVQdcJXwJffnVQ7Kof4fv0QTfpZc/TVSvL32qT/Qut6DE9qQpPzIS9nhBaEXSd8CUQBPsneh6wLcKXfKsKT8yEvZ6wK6340vrSZBAEQRAEQRAEQdBlLqgVszcjgyAIgiAIgiAIgmPlguuKdty6MQmCYD6f4y/+Lvn31o3J7q9+ce7yQ/zFX/zF397+oufBX/hS639v3ZisvAy447AX9ja1t1L3UTR7XhEAlkc2tIAgCPZJ9DxgW4Qv+VYVnpgJez1hh1oxWxcCgCXhW5sEQdAFoucB2yJ8ybeq8MRM2OsDsa4IDABetUkQBB0heh6wLcKXfKsKT8yEvZ6wBa0YBAHWFYHu4FubBEHQBaLnAduib750fuPz468/vzL2qvDEzDqEvSNmO+uKQRDocrHMN43DIEcYJ+U/4mAUkWNhnJKzokRcOInKL/Ovxb+plGt+kimHMnGUyNnM0zgs/wFcAW2T5y/vPfh6Pi965/Mbnx+XCV+9ZTpCevPzd17Jp5882FAbhnpK9u/G58fz+fGjPf0ge/XjR3tyYebz4lqKFecqTnz1VpHsyqOTOU2W5SMjK6G1oubP7qy+9wFBx3nrxmSZJsZ0I1xvAPpAByPL85cPnwlnPDxkj9jTU6pj06BE1Pk7r2jTFnzrUBumRXu/82o+nz97NCQz26mr0g3KyGSg9lKnzbxaicRoYsUZdHst50q1pzmMyFkvD5uJSE+uKGJLWyM9V8PVpRzIINXaHlRFLhbriklUarEkEsqNqjLlcybv0jgMoygk0jEM5VOUbyXdGCXWHER6Sz6AM5C04sbnx1+/evZ10TCUvjsTb+YjolVkYumtQ75JG7Uid+nyw+XDZ7TFZv0ON5CoVlhPFOL2yqOTMjC9fPhMF66WS9AMzaM4CIKCWs/TsImx3ciqjQJXQgcj6fN3XmXj4PnLew++PnmwwRyxpxdfyWPT3oNDZth1tirO33mlyJ6Mbx3Ojw9fsU1YzDIPSxK3QhE+XXl0QtXI0O3NokHi5GVUdo5zBkYrGs4VzKWgFo4qOdPy8OXM05fNUESJlU240tXPXz58pqVpbV1Rl4tFvklEl/YETFpRpE/jMIyT4pskCqI4VjRdKUMVjZf9a8khlT+IMkIrOgnaJq88Ojl+tCdakRSfZS5uPZI3mHJJkGk257SoTor87rzKp2B5rShlaBpIVCusJxbfqr2PXf7ZKqowAQRBC+1asbKJ8d3Iqo0CV0KXI2lmAOLiRdO3bGRczKRkY7j0rWtV8dYhH9brq6MkcqAzRMMwsxXSW69UzqDtPa9Fg1Rrsc5gsZfVaeWFSCZszmx5uPREK+o5cE24jqub2n6be1DpZlTxvGIS0Y2hBUxaUei//GASZTtFC+0nSUM1sQA5i81B+5CrRWhFJyHaJJ3+nMs67ZyY2rQeIW1mfvz1iWkrpk0rFvNqulbMsp3Py6V/dddZ3hRVK/gTq6yw9Np8RZXlwOY3EKymRSvWaWIVe1ChG32im5F0scWaCj/1iD39OcMkCH2+g646ulYV8o67csVMnwAq/j2hz60MxcxWq6uIOmRRMWh79UU8cetNzmDTiuZpQSW0Y3Nmy8OmJ95LfNLQhGu6Ok0mytDDumKBTD
Thanks
KI1Xuof9mhuYefM2by6DVElMG3rtEVajCz+hgemMBQRAEQdAl9qgVuye0ole4/cfv453Zh3uzj/779MO9WcYP9k/v7c/en56+Pz1998+nb++c3n7y4zuPaj+vCA6a4n0q4GrvAl5qCoIgCIKjILQiMFT810ff3vvkx/u7pw92fxK8/+fT93dO3905fXfn9J1Pfrr95MC7j09++/CbObSiBzzafL3+q7DAjqg+FQmCIAiC4GAZzE5/7oqzs54JregVDv/+w71H/9x88s39J/8S3HzyzXuPv8v47uNv33n0r98+/ObF37+fQyu6zdPZWafs3ITTs845dBN6HxE64OpbypI87ZgrN7AFdhcU9RUdjeAuj8CEobPrW4C7UI9O9BXQioAvgFZ0mdCK0IpD4OpbypJE8FdNaEUH7vIITBg6u74FuAv16ERfMTatCIIWrrrNg0ZCK0IrDoGrbylLEsFfNaEVHbjLIzBh6Oz6FuAu1KMTfcWotGIHHLwfdD3mdR3i9xHlgw5w8F4ErQitOAQi+KsmtKIDd3kEJgydXd8C3IV6dKKvgFZceWTQsQnQiuAQOHgvglaEVhwCEfxVE1rRgbs8AhOGzq5vAe5CPTrRV0Arrjwy6NgEaEVwCBy8F0ErQisOgQj+qgmt6MBdHoEJQ2fXtwB3oR6d6CugFVceGXRsArQiOAQO3ougFaEVh0AEf9WEVnTgLo/AhKGz61uAu1CPTvQVwa0bExAEQRAEQRAEQRCkDG7dmPz72r+BIAiCIAiCIAiCoGCuFVf903cAAAAAAAAAAABAh7h1Y9IofakVX351YGedNCAIgiAIgiAIgqCD7EorZvmu3DxwBIQvgSDYP9HzgG0RvuRbVXhiJuz1hNCKoOuEL4Eg2D/R84BtEb7kW1V4Yibs9YTQiqDrhC+BINg/0fOAbRG+5FtVeGIm7PWEy2rFIAiyvwJ+1iPYHeFLnvL59UsXr79YeTFAX+lFz4NW1gu98CXHq6JfV/ftjsPecRPriu3zxc0LQjlfuvnxysszdPrsS/6QaTXs0F5/vNdTPr9+iTZJRMmglePrebpvZR/fvhgowCD4sgtfen79Eq3hVfdmpp9Za6EqSkvXt9lvM8P1D6aUWgUGQRAEF24/N1x9oYpd/I4vM04ZRr3uzKxlb1sjb0e2LFSeivubFfXqXXFk+2oQNL2Ke/YuqxWxrij44uYF4hB3NzBSLk1vfckf8q1mydGLHTUvrm9cLDrcVUdXoOMcWc/TUyuzH/eVbfvS3Y0ycLy7QULSFRqoKMMsZGynKuq4U2UaXSvWcdGVaMWFxyl+1OvQzFr2tjXydmRLR1pRNflC46u4Zy/WFdsi7cHJXaEzXvnc2Me3L65vP79+6eL121dzmb2xVZxCZxHKNNykmgf01Zf8oaXVrG9cJG1haz0Iisk5pZnk+YimVK5vqNOZW+v5bF/RKslii2hx+XVFPnzbXH3VgR1yXD1PX62MZp7/+/Hti0ULyoqxRS/qRePqQCvK8UBe4dK67sZWr7Wqa8XWqkJeM5RCJs3wS1fXzR27XSuSyf3n1y8FF24/N3t4d3fcME5pt7JeaTs2s5a9rEW0YFpfpI68C9tiDKdF5lL60meq1FQNrXh9++aFrGzbV4ONm4Z4gzHBXXsX14oBnlfUm4R6a9e3i579xc0LG1fXN7YOXn51dyNrG6IxbK0HF6+/oGOAaD9Kg/GMnvqSPzS1GtJvlksieWKtmUjxqCHb4sj2VRpkkATZYCauu7VeRs/8RVdddWCXHFXP01srY4+LMFFpYtkRMkTa8hwyW/el7Sz+EyuKeoX33mXRpUXTouKCVSHrJSlkqrMHVXidZQ+qNJv/8e2lF8GW1YrqOMXdyjql7djMWvayFrFakR95F7bFGk6LzJm1nIPtqxVrM3W04gvRxyr2UrdkTXDVXqwrtkSjVjzYvnrh9vOD7avr28+vX8q6LaXzIreWoPCzlZu2OnrqS/7QEsXS1pF1avWbieUIs9pPumNT8KFfdOVVB3bJUfU8vbUy/rgYB/VpmmKlcdSNqytfyhaB9VhCrCr0W6tUK7ZZFawO1LtxJhTmOnYlT5nZSsvyD9ctrxUlAw23srq0HZtZy16TRfVv5WK22Hsw5irZpolazaSeVszndKROT3FL1gRX7V1WK9LSLdtOhk3DPp9sRXHr7kY+Nbu+vbWuDpmmuQdoRU99yR9W7dz+ioti6ytD7siLmxfyPSEirtIzN2lL0A+Oq+fpq5UZjm9fDTa2imlvViuOunF16UuK5idrv713WdnSomVRccGqWEArWjp2JU+FW+uuaEVlnFqstB2bWcveSouW04pGW+y1YUxWS0HV1IrcBBy3lquY4Kq9WFdsjcZ32zy/vnEx37v84ub6xtV1dQN9/vnuRvUWbb/orS/5w8q3bry4eUF+eENrJuzuOP6RnvIqymRzXgzjiKVfFBwzR9bz9NTKxHE9amFfvlrulhxz42rZl55fv6TsPiWz0uTtiyuo1UpLO9SKhpkOtWNX8pQoHhoiAf1C67GtaMVynOJvZY3SdmxmLXtNIy9dHV1cK1pssYbTnOds5AJM2w7a9P6aZJvulqwJrtq7uFYM8LyiRvpecnLbyK3V9w2rN9K8ccI/+uxL/pBpNc+ZrRq2jRzkSJZDtv3DOHVaNMPt4snv/KUIlhGLLRI4Uo6v5+mjlSk5lJQfsClDBvKAzXgbV9u+RN9hQ1/cUr55KBDCybFaXeo3MyxaUbhi8W4bY8euZiuqkYTa+WO0JNue320j/qXhonQr65W2YzNr2WuwSHRH1SPvwrZYwmndc25eF82nsh4W1Iq6Wxruo5v2Yl0RdJfwJbCk8rA7CHZGf3ueLloZzdO/CVB/fcnXqvDETNjrCaEVQdcJXwJffnVQ7Kof4fv0QTfpZc/TVSvL32qT/Qut6DE9qQpPzIS9nhBaEXSd8CUQBPsneh6wLcKXfKsKT8yEvZ6wK6340vrSZBAEQRAEQRAEQdBlLqgVszcjgyAIgiAIgiAIgmPlguuKdty6MQmCYD6f4y/+Lvn31o3J7q9+ce7yQ/zFX/zF397+oufBX/hS639v3ZisvAy447AX9ja1t1L3UTR7XhEAlkc2tIAgCPZJ9DxgW4Qv+VYVnpgJez1hh1oxWxcCgCXhW5sEQdAFoucB2yJ8ybeq8MRM2OsDsa4IDABetUkQBB0heh6wLcKXfKsKT8yEvZ6wBa0YBAHWFYHu4FubBEHQBaLnAduib750fuPz468/vzL2qvDEzDqEvSNmO+uKQRDocrHMN43DIEcYJ+U/4mAUkWNhnJKzokRcOInKL/Ovxb+plGt+kimHMnGUyNnM0zgs/wFcAW2T5y/vPfh6Pi965/Mbnx+XCV+9ZTpCevPzd17Jp5882FAbhnpK9u/G58fz+fGjPf0ge/XjR3tyYebz4lqKFecqTnz1VpHsyqOTOU2W5SMjK6G1oubP7qy+9wFBx3nrxmSZJsZ0I1xvAPpAByPL85cPnwlnPDxkj9jTU6pj06BE1Pk7r2jTFnzrUBumRXu/82o+nz97NCQz26mr0g3KyGSg9lKnzbxaicRoYsUZdHst50q1pzmMyFkvD5uJSE+uKGJLWyM9V8PVpRzIINXaHlRFLhbriklUarEkEsqNqjLlcybv0jgMoygk0jEM5VOUbyXdGCXWHER6Sz6AM5C04sbnx1+/evZ10TCUvjsTb+YjolVkYumtQ75JG7Uid+nyw+XDZ7TFZv0ON5CoVlhPFOL2yqOTMjC9fPhMF66WS9AMzaM4CIKCWs/TsImx3ciqjQJXQgcj6fN3XmXj4PnLew++PnmwwRyxpxdfyWPT3oNDZth1tirO33mlyJ6Mbx3Ojw9fsU1YzDIPSxK3QhE+XXl0QtXI0O3NokHi5GVUdo5zBkYrGs4VzKWgFo4qOdPy8OXM05fNUESJlU240tXPXz58pqVpbV1Rl4tFvklEl/YETFpRpE/jMIyT4pskCqI4VjRdKUMVjZf9a8khlT+IMkIrOgnaJq88Ojl+tCdakRSfZS5uPZI3mHJJkGk257SoTor87rzKp2B5rShlaBpIVCusJxbfqr2PXf7ZKqowAQRBC+1asbKJ8d3Iqo0CV0KXI2lmAOLiRdO3bGRczKRkY7j0rWtV8dYhH9brq6MkcqAzRMMwsxXSW69UzqDtPa9Fg1Rrsc5gsZfVaeWFSCZszmx5uPREK+o5cE24jqub2n6be1DpZlTxvGIS0Y2hBUxaUei//GASZTtFC+0nSUM1sQA5i81B+5CrRWhFJyHaJJ3+nMs67ZyY2rQeIW1mfvz1iWkrpk0rFvNqulbMsp3Py6V/dddZ3hRVK/gTq6yw9Np8RZXlwOY3EKymRSvWaWIVe1ChG32im5F0scWaCj/1iD39OcMkCH2+g646ulYV8o67csVMnwAq/j2hz60MxcxWq6uIOmRRMWh79UU8cetNzmDTiuZpQSW0Y3Nmy8OmJ95LfNLQhGu6Ok0mytDDumKBTD
0