Re: initial value on create table/index statement
From: DEV <sdpant_at_gmail.com>
Date: Fri, 26 Jun 2009 14:46:43 -0700 (PDT)
Message-ID: <f7cda7e8-1ae5-4cf9-bcb9-9a73060a4d68_at_w31g2000prd.googlegroups.com>
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?
Date: Fri, 26 Jun 2009 14:46:43 -0700 (PDT)
Message-ID: <f7cda7e8-1ae5-4cf9-bcb9-9a73060a4d68_at_w31g2000prd.googlegroups.com>
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
Received on Fri Jun 26 2009 - 16:46:43 CDT