Re: initial value on create table/index statement
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 26 Jun 2009 14:25:22 -0700 (PDT)
Message-ID: <99afaca9-ba59-48b8-ade6-83ba314b9a04_at_v4g2000vba.googlegroups.com>
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
Date: Fri, 26 Jun 2009 14:25:22 -0700 (PDT)
Message-ID: <99afaca9-ba59-48b8-ade6-83ba314b9a04_at_v4g2000vba.googlegroups.com>
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? Received on Fri Jun 26 2009 - 16:25:22 CDT