Re: space for table

"tim" <zimzo_at_gmx.net> wrote in message news:<9fqf3f$m7e$00$1_at_news.t-online.com>...
> I know that this question might be a 'newbie'-one but my oracle-knowledge is
> not so wide-spread yet that i can anser it by myself.
>
> I am working through an Oracle book as user 'practice/practice' (on my
> personal computer) and i have got the impression that if a table gets too
> big, that is when it has more data in it than the smaller ones, Oracle
> doesn't store the data when i close the program, so i have to fill the
> tables again every time.
> This is espescially annoying when it comes to a table like the LEDGER-table
> of the course which has many pages of data in it that i have to copy and
> paste and error-corrigate.
> My guess is that there is a certain space which is allowed and if i get
> beyond that, data is not stored anymore. Is this true and how can i set this
> value up a bit so that i dont have to type in everything again?
>
> Thanks for help in advance
> ;-)
> zimzo

If you are running out of space while loading the table then an error message that you were unable to extend the object should appear in the alert log. If so then take a look at the storeage parameters for the table. See the dictionary views sys.dba_tables or sys.dba_segments. See the SQL manual alter table statement for changing these parameters.

example: alter table emp storage ( next 512K maxextents 121 pctincrease 0);

If the table is empty you should truncate it before you alter it to free any extents so that when the load requires the object to extend it takes the new bigger extent size. The parameters above are described in the SQL manual and in the Concepts manual.

Good luck.

• Mark D Powell --