Re: How do I check for full tablespaces?

Mike,

    As soon as the bookstores open up for the day go and pick up a copy of the DBA Handbook by Kevin Loney. You will find the information you need in the book.

    Now as to your immediate problem ... check both the dba_tablespaces and dba_data_files tables. Between them you should be able to determine the size of the datafile and how much space in the datafile is actually in use. You will then be able to derive the free space. (Sorry, I can't be more specific -- I am at home and my scripts and books are at work and since I just upgraded my home system and haven't installed Oracle yet I am working from my unreliable memory.

But don't worry if I screwed up tens (perhaps hundreds) of people will rush to tell the world what a dumb jerk I am.

regards

Jerry Gitomer

gremlin wrote in message <36F9D3DE.E93E5A0B_at_ix.netcom.com>...
>Hi:
>
>I have a database that I used sqlldr to successfully load about 17
>million records total (7 M in each of 2 tables), using a script to load
>about a million at a time. This perl script writes .dat files and when
>they get to be over a certain size (pic a number) I invoke sqlldr and
>then truncate the file and keep going through that process. This works
>up to a point and then I start getting "Non data related sqlldr error".
>I am guessing I need to add another .dbf file somewhere. It will let me
>add a record or two at a time with "update table ..." but if I run
>sqlldr with even 20 records I get this error. What is the best way to
>check something like this (I'm a n.b. to the DBA aspect of this).
>
>The .dbf files always have the size I allocated since I guess they are
>cleared or just allocated when I create the database, so how do I tell
>how much space in the tablespaces actually gets used?
>
>P.S. Oracle 8.0.4.1 (?) on SGI Origin.
>
>Thanks,
> Mike
>
>--
>-----------------------------------------------------
>To reply to me via email, remove the "__NO_SPAM__" in
>the header email address.
>-----------------------------------------------------
Received on Thu Mar 25 1999 - 06:36:32 CST