Re: Is tablespace suppose to grow automatically?
Date: 8 Oct 2002 11:40:23 -0700
Message-ID: <130ba93a.0210081040.74fd579a_at_posting.google.com>
Remember to include in your postings the version of ORACLE you are
using.
It is always nice to size your tablespaces properly at the beginning.
You can set the datafiles of the tablespace to extend automatically.
You have to decide whether or not this is appropriate for your
environment.
- Jusung Yang
mednyk_at_hotmail.com (inna) wrote in message news:<347a408b.0210071003.2286c5d5_at_posting.google.com>...
> I create tablespace with command
> CREATE TABLESPACE TEST4
> DATAFILE 'TEST4.dat' SIZE 120M REUSE;
>
> After some time of using database this error occurs:
> SQL execution error, ORA-01653: unable to extend table TEST4.EMPLOYEE
> by 5 in tablespace TEST4
> ORA-06512: at "TEST4.EMPLOYEECREATE", line 13
> ORA-06512: at line 1
> Do I have to create bigger datafile from the beginning, or specify
> some options to increase the size during using database?
> Thank you.
Received on Tue Oct 08 2002 - 20:40:23 CEST