Quote Originally Posted by dbajay
It is required to retrieve data for reporting purpose. This is our reporting server.

The script is written to transfer data first from one server to another through ftp.

The data would load thorugh script. It would remain static over a period of time.

Yes, I have concern with loading of data but the script is already written for populating data. It would be populating into one of the table using my database.

How to estimate the size of this object and what actions are required to run this job smoothly over a period of time.

thanks in advance.
You need to collect performance statistics over a period of time and analyze the pattern and growth.

Another thought ......

Have you considered transportable tablespace option?


Tamil