Re: Mac Version 5 Table Size?

From: Jack Love <jlove_at_ivrit.ra.itd.umich.edu>
Date: 9 Dec 1992 15:13:02 GMT
Message-ID: <1g52duINNiln_at_terminator.rs.itd.umich.edu>


In article <ByzwJE.AsC_at_world.std.com> gordy_at_world.std.com (Robert W Gordy) writes:
>I'm currently using Oracle version 5 on the Mac and I was
>wondering how I can tell how much room I have left
>for a given table. Is there an easy way to look at
>the data dictionary?
>
>Thanks in advance for the help.

Perhaps I'm misunderstanding your question, but if I do understand it, then there is no entirely straightforward answer. As far as I know Oracle version 5 is the same as far as internal database architecture as any other version 5 database. Therefore, you can restrict the size that a table will reach by limiting the number of extents that it will grab. As long as there is still space in the partition, if you know how big the table has gotten (and this is ascertainable through the dictionary), you can figure out how much is left. But there are many caveats associated with these notions, so without a more specific question, I think you're going to have to spend some more time with the DBA Guide.

Jack F. Love Received on Wed Dec 09 1992 - 16:13:02 CET

Original text of this message