Re: export Oracle7 - import Oracle8

"Jon K" <jon.dotonline_at_excitedot.com> wrote in message news:<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>
> >
> >

Recreate all the tablespaces found in the source database Michael T Ngong(Sr DBA)
> >
Received on Tue Feb 05 2002 - 17:47:06 CET