extend table question
Date: 29 Aug 2001 09:39:31 -0700
Message-ID: <fb49377c.0108290839.5807c30e_at_posting.google.com>
Hi,
I have Oracle 7.3 and got the error message (ORA-01653) about needing
to extend the tablespace. I use these commands to do it:
1) ALTER TABLESPACE tablespace OFFLINE
ADD DATAFILE 'file' [SIZE integer [K|M] ] REUSE
NEXT integer [K|M]
My question is, the .dat file that we currently have is 524288000
bytes.
I apologize for my ignorance, as I have had no formal database
training.
2) ALTER TABLESPACE tablespace
MAXSIZ UNLIMITED
3 ALTER TABLESPACE tablespace ONLINE
What size should I resize it to? When I specify in the #2 command, do
I say in the NEXT integer part, how much I want to increase it by, or
the total?
In other words, do I say:
to say increase it by 200 megs.
Or say:
NEXT 724 M
to say that should be the total size.
Does this make sense?
Thanks!
Received on Wed Aug 29 2001 - 18:39:31 CEST