Re: unable to extend table

From: gremlin <gremlinNO__SPAM___at_ix.netcom.com>
Date: Wed, 31 Mar 1999 23:50:46 -0500
Message-ID: <3702FB26.9E7484EE@ix.netcom.com>

Depending on how big the file will get, you can also turn autoextend on for it.

I have a related question. I have a somewhat large database that I would like to set up an initial size for of, say, 15 Gigabytes. Oracle won't allow me to enter that in the "size" storage member for an alter table (or on the create table command). How do people manage VLDB's? Especially since there is a limited number of extents one can have (related to oracle block_size)? I also would like the extents to be around 2 Gig, but it doesn't want to accomodate me there either. Any ideas? (Besides pre-installing about 50 2 Gig .dbf files).

Mike

skb wrote:

> Jim, you have to alter the tablespace and add another datafile.
>
> Jim Giza wrote:
>
> > Hello. I'm using Oracle 8 under Solaris. Have created a table with
> > default settings, when I try to add a bunch for records, I get the
> > following
> > error. How do I go about allocating add'l space for the table?
> >
> > Thanks for any help.
> >
> > ORA-01653: unable to extend table OPS$USER.FEDEX_ZONES by 210 in
> > tablespace
> > USERS
--

---

To reply to me via email, remove the "__NO_SPAM__" in the header email address.

---

Received on Wed Mar 31 1999 - 22:50:46 CST