Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tables and sizes

Re: Tables and sizes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 01 Dec 1999 20:11:03 +0800
Message-ID: <38451057.509A@yahoo.com>


Roger Stapley wrote:
>
> 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.

Some starting points:

hth
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 01 1999 - 06:11:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US