Re: initial value on create table/index statement
From: Phil Herring <phil_herring_at_yahoo.com.au>
Date: Fri, 26 Jun 2009 17:08:03 -0700 (PDT)
Message-ID: <5048340a-e006-4c9b-8d13-1f6d546c7519_at_a37g2000prf.googlegroups.com>
On Jun 27, 7:18 am, DEV <sdp..._at_gmail.com> wrote:
> Is there a way to change the value of "inital" in "create table" or
> "create index" during imp?
Date: Fri, 26 Jun 2009 17:08:03 -0700 (PDT)
Message-ID: <5048340a-e006-4c9b-8d13-1f6d546c7519_at_a37g2000prf.googlegroups.com>
On Jun 27, 7:18 am, DEV <sdp..._at_gmail.com> wrote:
> Is there a way to change the value of "inital" in "create table" or
> "create index" during imp?
Yes, but it isn't particularly convenient.
Running imp with indexfile=y will create a file listing the table and index DDL. You can edit this manually, and run it to create the objects.
I'd also have a word with the people who ran exp without setting compress=n.
- Phil