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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create objects in specific data_files ?

Re: How to create objects in specific data_files ?

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 22 Sep 1999 20:43:47 GMT
Message-ID: <37e92edc.241639@news.siol.net>


On Wed, 22 Sep 1999 00:28:13 -0700, Mario Bucsics <mario.bucsicsNOfiSPAM_at_siemens.at> wrote:

>
>I donīt know it exactly in Oracle 8.X but in the earlier
>version 7.3.4 it is not possible to store objects in a
>specific datafile if the tablespace contains more datafiles.
>
> Mario Bucsics

Sure it is possible, even in 7.3.4. Check the "ALTER TABLE table_name ALLOCATE EXTENT" command. This works for allocating additional extents when the table is already created.

If you wan't the *initial* extent of the table to be in a particular datafile, you must fool the database by creating a couple of dummy tables that are large enough to fill up available space in all other datafiles prior the creation of your table. And off course, you must not forget to drop those dummy tables afterwards.

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Sep 22 1999 - 15:43:47 CDT

Original text of this message

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