Re: How to create objects in specific data_files ?

That only guarantees that the extents created at the time the table/index is created will be located in the datafile of choice. Threre are three problems with the approach of taking datafiles offline.

1. Oracle can allocate any additional extents for that table/index in a different datafile
2. This can interfere with the other users of the system.
3. If Oracle finds it necessary to write to another table/index in the same tablespace while there is only one online datafile (I think) that a new extent will be created in the datafile you are attempting to reserve for your new table/index.

regards
jerry gitomer

Chetan Wagle wrote in message <7sf0le$2ma$1_at_herald.ctp.com>...
>Hi Jerry,
>
> How about taking all other "unwanted" datafiles offline so
that the
>object MUST get created in the only remaining online datafile ?
>
>HTH,
>Chetan
>
>Jerry Gitomer wrote in message

<7sdl12$7r7$1_at_winter.news.rcn.net>...
>>Excuse me, but ...
>>
>> I didn't see an ALLOCATE EXTENT option in either the CREATE
>>TABLE or CREATE INDEX statements. So, it doesn't look like
this
>>will work.
>>
>> Even if you were able to create a table or index in a
>>specific datafile there is no guarantee that Oracle will insert
>>additional rows in the same datafile (unless it is the only
>>datafile in the tablespace).
>>
>> I suspect that the best solution is to create additional
>>tablespaces, one per desired index. The only concern here is
>>that you keep the number of datafiles below the limit for your
>>platform.
>>
>>regards
>>jerry gitomer
>>
>>Kugendran Naidoo wrote in message
>><37E8B316.7A38BFDC_at_absa.co.za>...
>>>Hi
>>>
>>>Read the online doc's.
>>>There is an 'ALTER TABLE <table_name>
>>> ALLOCATE EXTENT
>>> (DATAFILE '/u01/<file_name in table's
tablespace>')
>>>
>>>Good luck
>>>Kugendran Naidoo
>>>
>>>
>>>Nemniss wrote:
>>>>
>>>> You can try to partition the indexes and tables. By doing
so
>>you can split
>>>> the load evenly across the datafiles. Just remember the
>>golden rule: Don't
>>>> put the table, and it's index on the same drive.
>>>>
>>>> Nemniss
>>>>
>>>> Mirza Mohsin Beg <mbeg_at_netearnings.com> wrote in message
>>>> news:37E8769B.3262FA8A_at_netearnings.com...
>>>> >
>>>> > Hi,
>>>> >
>>>> > I am trying to create several indexes in a single
tablespace
>>which has
>>>> > several datafiles over different several external drives.
>>>> >
>>>> > Is there any specific way to make Oracle 8.0.5 create
>>specific objects
>>>> > (ie the indexes) in specific datafiles, than having a
>>different
>>>> > tablespace per index.
>>>> >
>>>> > Thanks,
>>>> >
>>>> > -M
>>>> > ps: please email me directly also.
>>>> >
>>
>>
>
>
Received on Fri Sep 24 1999 - 11:43:40 CDT