|
Re: HOW INCREASE THE SIZE OF A TABLE [message #1063 is a reply to message #1057] |
Tue, 26 March 2002 10:46 |
INTROV
Messages: 20 Registered: February 2002
|
Junior Member |
|
|
Increase the tablespace or add additional tablespace.
To increase the tablespace
ALTER DATABASE
DATAFILE '/filepath/datafile_name.dbf'
AUTOEXTEND ON NEXT 20M
MAXSIZE 1000M;
to add an additional datafile
ALTER TABLESPACE 'tablespace_name' NOLOGGING
ADD DATAFILE ’/filepath/datafile_name.dbf’
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;
|
|
|