Re: export Oracle7 - import Oracle8
Date: Mon, 4 Feb 2002 15:30:13 -0800
Message-ID: <3c5f15f3$1_1_at_news.onlynews.com>
if you exported (it would be helpful to post the exp line you used) from teh
system account, and we can assume you did or you wouldn't have gotten other
users, then all you need to create are the tablespaces. Without the
tablespaces, where would all the objects go? The system user default
tablespace is system, you certainly don't want you stuff in there!
JON
"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 Tue Feb 05 2002 - 00:30:13 CET