By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.