Re: initial value on create table/index statement
From: DEV <sdpant_at_gmail.com>
Date: Mon, 29 Jun 2009 13:53:17 -0700 (PDT)
Message-ID: <df7218e3-100f-4a8f-b7f3-9727600f2049_at_3g2000yqk.googlegroups.com>
On Jun 29, 12:14 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jun 26, 5:46 pm, DEV <sdp..._at_gmail.com> wrote:
>
> snip
>
>
>
> > > > 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
>
> You might consider uniform extent sizing in the target tablespace
> (s) ... been a while now since I played with import in that
> situation. Any reason you are staying away from impdp?
>
> Another possible approach and much more flexible is to use
> dbms_metadata to extract out schema based ddl ... I do a bunch of
> stuff that way. Then you can get individual files created per table
> if you wish and push as much as you want into some kind of offline
> editing/fixing process.
Date: Mon, 29 Jun 2009 13:53:17 -0700 (PDT)
Message-ID: <df7218e3-100f-4a8f-b7f3-9727600f2049_at_3g2000yqk.googlegroups.com>
On Jun 29, 12:14 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jun 26, 5:46 pm, DEV <sdp..._at_gmail.com> wrote:
>
> snip
>
>
>
> > > > 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
>
> You might consider uniform extent sizing in the target tablespace
> (s) ... been a while now since I played with import in that
> situation. Any reason you are staying away from impdp?
>
> Another possible approach and much more flexible is to use
> dbms_metadata to extract out schema based ddl ... I do a bunch of
> stuff that way. Then you can get individual files created per table
> if you wish and push as much as you want into some kind of offline
> editing/fixing process.
The reason I am staying away from impdp is because so far is imp working for us. I will start using impdp if I need feature in impdp and not in imp or if they deprecate it. I could you dbms_metadata but I am getting everything with exp and with the less coding. BTW Does anyone know if Oracle stopped packaging exp/expdp/imp/impdp with 11g client utility as I didn't see these utilities after the administration level installation... Received on Mon Jun 29 2009 - 15:53:17 CDT