Home » SQL & PL/SQL » SQL & PL/SQL » HOW INCREASE THE SIZE OF A TABLE
HOW INCREASE THE SIZE OF A TABLE [message #1057] Tue, 26 March 2002 01:48 Go to next message
fred Geeves
Messages: 14
Registered: March 2002
Junior Member
I have a table which is full. I need to increase the size of this table so that users can add data to this table. How do I do this ?

Report message to a moderator

Re: HOW INCREASE THE SIZE OF A TABLE [message #1063 is a reply to message #1057] Tue, 26 March 2002 10:46 Go to previous message
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;

Report message to a moderator

Previous Topic: Updating Tables
Next Topic: Order of INDEXES
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 03:25:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.