Skip to main content
eZabel
Login
0 online
Forum / Just starting Oracle 10g View full thread →
theremin Nov 2, 2006

How to use storage... I'm using the following command: CREATE TABLE CH07NEW_ADDRESSES OF CUSTOMER_ADDRESS_TYPE because I'm creating an object table, but next I want the table to have 10MB...

theremin Nov 2, 2006

Thanks. You know what you're talking about more than me, but it wouldn't read as: CREATE TABLE CH07NEW_ADDRESSES OF CUSTOMER_ADDRESS_TYPE TABLESPACE USER_DTAB STORAGE (INITIAL 10M NEXT 10M P...

gizmo Nov 2, 2006

PCTINCREASE determines how fast the size of the next extent to be added gets increased. So in your example, the initial extent would be 10M, the second would be 10M, the third would be 30M, the fo...

theremin thereminOG 2002

Oh gotcha. So if I do:

STORAGE (INITIAL 10M NEXT 10M PCTINCREASE 0)

The initial extent is 10M, second 20M, third 40M, fourth 80M ??

I want to double each time.

G
gizmoEst. 2006

For that you would want

STORAGE (INITIAL 10M NEXT 20M PCTINCREASE 100)

theremin thereminOG 2002

Ahhh so confusing. Thanks a lot.

← View full thread

Welcome Back to eZabel

It's been a while. Here's what's new.

eZabel Lore

A complete history of our community — stats, Hall of Fame, legendary threads, and more.

View the Lore →

Everything Preserved

All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.

💎

Gems

Spot something you love — a legendary comment, a classic thread, a great photo? Log in and click the diamond icon to mark it as a Gem. Add a note about why it's special. The best stuff surfaces on the Gems page.