Tables and sizes

All,

I'm trying to get an accurate idea of how much data/how many rows I can add into a given table or for a given user before I hit any sizing problems (Index space, table space, index table space, table table space, max extents etc).

IE.

If I have the table GL_JE_LINES and I'm inserting 60,000,000 rows I want to know that given an average line length (how do I find this) whether any errors will occur before all 60,000,000 rows are loaded?

Also for a user a similar thing which looks at all tables for the user and checks a count from a db link for number of records per table, then does the same checks as above.

Any suggestions?

TIA.
Roger Stapley. Received on Wed Dec 01 1999 - 09:12:49 CST