Hi Yacov,
you don't have to edit the dmp file. Just create the tablespaces manually
on the destination
system with the locations of data files and storage parameters you want.
Then run the import with IGNORE=y. You
will get some error messages saying that the tablespaces already exist,but
they will be
ignored.
Hth,
--
Pavel Polcar
Yacov Wolfowicz <yacovw_at_ecitele.com> wrote in article
<35581A40.C8C844F_at_ecitele.com>...
> Hi everybody,
>
> I have a problem i can't solve by my self.
>
> We have a working Oracle Instance on one machine and need to copy it to
> another machine. So far so good.
>
> The problem is, the data is about 20GB and when i import the database (
> without the data, most of it is created while the program is running )
> the imp73 program tries to put the tablespaces files in the same
> directories as they were on the exporting database, giving them the
> initial size as those of the full database and in the same location. The
> importing machine has much less disk space and also does not have the
> same disk configuration.
>
> Is there a way i can edit the expdata.dmp file ( or whatever it's name
> is ) and custom build a new database?
>
> We are running Oracle v7.3.3.5.2 on Window NT4 and wish to import it to
> a machine running Oracle v7.3.4 on NT4.
>
> Thanks for any advice,
> Yaki
> --
> Life is hard...
> and then you die
Received on Wed May 13 1998 - 00:00:00 CDT
