| resizing the database [message #242870] |
Tue, 05 June 2007 06:21  |
vkrmhj
Messages: 9
Registered: May 2007
|
Junior Member |
|
|
My table data is going to increase by 1 million, so i have to add tablespace space.I have run the following query for the table"select avg(nvl(vsize(col1),1))+avg(nvl(vsize(col2),1))+... from tab1" and multiplied the result(in bytes) with 1 million.I am increasing the tablespace by this result.Am i right?Is there any other better way to do it.
Thanks in advance,
Vicky
|
|
|
|
|
|
| Re: resizing the database [message #242876 is a reply to message #242873] |
Tue, 05 June 2007 06:49  |
vkrmhj
Messages: 9
Registered: May 2007
|
Junior Member |
|
|
Michael..thanx for ur suggestion..
i add space by "alter tablespace ts1 add datafile df1 size xKB" so why do i need to know the space a row occupies in a block..(i calculate the space for each row and multiply this by 1 million- as i did)
Is the method i am using erroneous in any way?
|
|
|
|
|
|
| Re: resizing the database [message #242881 is a reply to message #242879] |
Tue, 05 June 2007 07:17 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
| Quote: | Is there any other better way to do it?
|
Is there any specific reason not to use autoextend?
e.g.
ALTER TABLESPACE XXXX
ADD DATAFILE '/foo/bar_02.dbf' SIZE 40M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M
or something like that?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
