You will indeed need to create all your own tablespaces, with the same names
as you had in your 7 database. But that should be all you need to do: the
dump file is quite happy to re-create all Users and roles for you.
Unfortunately, the lines in the dumpfile requesting the creation of
tablespaces have the old database's paths and filenames hard-coded in it, so
unless you're importing on a machine which is laid out physically exactly as
the source, those lines can't do their job.
Regards
HJR
"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
news:a3mmbr$d314$2_at_as201.hinet.hr...
> I exported complete database from Oracle 7.3.4. This database contains
> some users, roles, some tables are in their own tablespaces and so on.
> If I want to import this database dump into Oracle 8.1.7. Do I need to
> manually create all users,roles,tablespaces in Oracle 8.1.7 before
> importing old dump file in it? I tried to import old dump but import
> program said that it cannot find needed tablespaces!
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
Received on Mon Feb 04 2002 - 13:44:22 CST
