Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Creating a table with field type long. Initial storage settings?

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

From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Thu, 29 Apr 2004 16:43:45 -0500
Message-ID: <lGekc.45$2b2.34273@news.uswest.net>


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" <galkas_at_mail.ru> wrote in message
news:ecdc865.0404290150.5473ed9e_at_posting.google.com...

> 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
Received on Thu Apr 29 2004 - 16:43:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US