OraFAQ Forum: Server Administration » LMT and Extents size problems

Home » RDBMS Server » Server Administration » LMT and Extents size problems (Oracle 11g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LMT and Extents size problems [message #406491]

Thu, 04 June 2009 04:26

Johnma
Messages: 2
Registered: June 2009
Location: Spain

Junior Member

Hello,

I'm a little confused about extents and how Oracle manage it.

I have to create two LMT and ASSM tablespaces, one for data "DATASPACE" and other for index "IDXSPACE". The problem requires block size for "DATASPACE" is 16K and for "IDXSPACE" is 4K.

In "DATASPACE" I have to create tables with one extension that contains given information from other tablespace and other extension with estimated size. For example:

CLIENTS: Actual Data Size: 3700K. (Extent 1)
Estimated Data Size for 1 year : 400K. (Next extent)
CALLS: Actual Data Size : 278000K (Extent 1)
Estimated Data size for 1 year : 189000K (Next extent)

How I create tablespace and tables?
I've tried with LMT Uniform, but if uniform size is 278000K all extents are of this size.
I've tried with LMT Autoallocated, but I can't specify the extent size.

I don't know how make it, and I started to think it's not possible.

The problem requires tablespace is LMT, because of mapabit management.

Thanks!

pd. It's my first post, but I read forum since time ago to learn. Thanks and sorry about my english Smile

Report message to a moderator

Re: LMT and Extents size problems [message #406494 is a reply to message #406491]

Thu, 04 June 2009 04:42

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't care about extent sizes and use autoallocate.

Regards
Michel

Report message to a moderator

Re: LMT and Extents size problems [message #406500 is a reply to message #406494]

Thu, 04 June 2009 05:04

Johnma
Messages: 2
Registered: June 2009
Location: Spain

Junior Member

Hi, thanks for your quick answer.

Yes, I think using Autoallocate is the best option, but I forget mention is a practice for University.
And the Problem require that the actual data allocate in first extension, with the estimated size for this data. And prepare a new extension for the data that can be inserted in a year.

The BD Model only have this tables:
CLIENT, CALL, TLFLINE, TARIFA, TIPTARIFA, BILL

Every table has this estimated first extent size, and the estimated next extent size.

Ah, I know that I must ask to my teacher, but He don't answer my question clarely.

Thanks in advance.

Report message to a moderator

Re: LMT and Extents size problems [message #406510 is a reply to message #406500]

Thu, 04 June 2009 06:18

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want to specify a special init extent and a special next extent you have to use the old and obsolete DMT.

Regards
Michel

Report message to a moderator

Previous Topic:	SQL ID
Next Topic:	Partition Maintenance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 22:37:19 CDT 2024