469,285 Members | 2,517 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,285 developers. It's quick & easy.

Creating a table with field type long. Initial storage settings?

Hello
I am trying to create a table, which includes a field type LONG. The
wizard hasn't allowed me to enter storage settings for this table. It
set the initial size is 64K and not available to change, next size 0K,
increase size by 0%.
Since I am going to copy data from an existing MS Access table into
this one, I know that the initial amount of records will be about
70000 and it will take about 7 Mb of disk space. I know it, because I
have already been through this process and copied the data into the
table and the table space usage increased by 7Mb approx.
Since I was not allowed to change storage settings in the wizard, I
took create table SQL and tried to change storage settings in SQL:
STORAGE ( INITIAL 10000K NEXT 64K
Then I executed it. Surprise, surprise, the table was created with the
same storage settings 64K initial, 0K next.
My questions are:
I know that the table can be created with the settings allowed by the
wizard and I'll be able to copy data, but wouldn't it be better to
allocate required amount of space from the beginning?
Can I change storage settings, when creating a table with one field of
type LONG?
If can, how to do so?
Any help will be greatly appreciated.
Thank you.
Galina
Jul 19 '05 #1
1 5407
Galina,

Any chance that the tablespace housing this table has locally-managed
tablespaces? If you get the same settings for INITIAL, NEXT, etc., no
matter what you specify, the tablespace may be locally managed.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Galina" <ga****@mail.ru> wrote in message
news:ec*************************@posting.google.co m...
Hello
I am trying to create a table, which includes a field type LONG. The
wizard hasn't allowed me to enter storage settings for this table. It
set the initial size is 64K and not available to change, next size 0K,
increase size by 0%.
Since I am going to copy data from an existing MS Access table into
this one, I know that the initial amount of records will be about
70000 and it will take about 7 Mb of disk space. I know it, because I
have already been through this process and copied the data into the
table and the table space usage increased by 7Mb approx.
Since I was not allowed to change storage settings in the wizard, I
took create table SQL and tried to change storage settings in SQL:
STORAGE ( INITIAL 10000K NEXT 64K
Then I executed it. Surprise, surprise, the table was created with the
same storage settings 64K initial, 0K next.
My questions are:
I know that the table can be created with the settings allowed by the
wizard and I'll be able to copy data, but wouldn't it be better to
allocate required amount of space from the beginning?
Can I change storage settings, when creating a table with one field of
type LONG?
If can, how to do so?
Any help will be greatly appreciated.
Thank you.
Galina

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Alan Cobban | last post: by
36 posts views Thread by toedipper | last post: by
1 post views Thread by LurfysMa | last post: by
6 posts views Thread by marktxx | last post: by
139 posts views Thread by ravi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.