Re: Importing tables w/large initial extents into a small database

Joel Garry wrote:  

< cut, cut, cut>  

> If you are brave and careful, you can edit the ffff.dmp to have whatever
> storage characteristics you want. You have to be careful because there are
> special characters that imp uses in there. I often just strip out the
> creation statements to another file and convert them to sql with some
> judicious global replacing in my favorite editor.
>
> An alternative is to get one of the various collections of scripts that
> makes sql create statements from your dictionary. See the tools links off my
> homepage, or use dejanews to find stuff that's been posted (search for
> "jared still" for one recent one).
>
>
> --
> These opinions are my own and not necessarily those of Information Quest
> jgarry@eiq.com http://www.informationquest.com
> http://ourworld.compuserve.com/homepages/joel_garry
> "See your DBA?" I AM the @#%*& DBA!

Try:
$ imp user/pwd file=exportfile show=y log=yourfile

This should give you a file (yourfile) with all the create statements. Change the values , run it prior the import and used the ignore=y during the actual import. In this case you don't have to change the orig exportfile. Received on Mon May 11 1998 - 08:58:14 CDT