Re: initial value on create table/index statement
From: DEV <sdpant_at_gmail.com>
Date: Fri, 26 Jun 2009 14:52:16 -0700 (PDT)
Message-ID: <ade2404f-5992-4435-a0b1-4de93c7786a5_at_d7g2000prl.googlegroups.com>
On Jun 26, 2:46 pm, DEV <sdp..._at_gmail.com> wrote:
> On Jun 26, 2:25 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
>
> > On Jun 26, 5:18 pm, DEV <sdp..._at_gmail.com> wrote:
>
> > > Is there a way to change the value of "inital" in "create table" or
> > > "create index" during imp? Pre-creating table is not an option here.
> > > I am taking a export dump with rows=n from production and importing it
> > > into dev/QA and since the production tables/indexes have larger values
> > > for "inital", it takes a lot of storage. Is there a way to create
> > > tables/indexes with smaller inital values during import?
> > > Thanks,
> > > Dev
>
> > What oracle versions are you going to/from in the export/import
> > process?
>
> > How are the relevant tablespaces defined in the to/from process?
>
> Both are on same version (10.2.0.3) and defined the same way.
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE
> BLOCKSIZE 8K
> SEGMENT SPACE MANAGEMENT AUTO
Sorry for the upper case on my last post. I wasn't shouting. It was due to copy/paste... Received on Fri Jun 26 2009 - 16:52:16 CDT
Date: Fri, 26 Jun 2009 14:52:16 -0700 (PDT)
Message-ID: <ade2404f-5992-4435-a0b1-4de93c7786a5_at_d7g2000prl.googlegroups.com>
On Jun 26, 2:46 pm, DEV <sdp..._at_gmail.com> wrote:
> On Jun 26, 2:25 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
>
> > On Jun 26, 5:18 pm, DEV <sdp..._at_gmail.com> wrote:
>
> > > Is there a way to change the value of "inital" in "create table" or
> > > "create index" during imp? Pre-creating table is not an option here.
> > > I am taking a export dump with rows=n from production and importing it
> > > into dev/QA and since the production tables/indexes have larger values
> > > for "inital", it takes a lot of storage. Is there a way to create
> > > tables/indexes with smaller inital values during import?
> > > Thanks,
> > > Dev
>
> > What oracle versions are you going to/from in the export/import
> > process?
>
> > How are the relevant tablespaces defined in the to/from process?
>
> Both are on same version (10.2.0.3) and defined the same way.
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE
> BLOCKSIZE 8K
> SEGMENT SPACE MANAGEMENT AUTO
Sorry for the upper case on my last post. I wasn't shouting. It was due to copy/paste... Received on Fri Jun 26 2009 - 16:52:16 CDT