Re: Is tablespace suppose to grow automatically?

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.

Either keep track of your tablespace size and add to it periodically, ALTER TABLESPACE TEST4
ADD DATAFILE 'TEST4_2.dat' SIZE 120M REUSE;  

OR use AUTOEXTEND option,
ALTER DATABASE
DATAFILE 'TEST4.dat' AUTOEXTEND ON;

Keep in mind that on some OS's, filesize cannot exceed 2GB.

/Rauf Sarwar Received on Tue Oct 08 2002 - 19:14:42 CEST