Re: initial value on create table/index statement
Date: Fri, 26 Jun 2009 17:08:03 -0700 (PDT)
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.