Re: Full export and import

Hera some hints:

Create a user ops$operator in the 8.0 database. Create a tablespace with the same name as the
default tablespace of the user ops$operator in the old database. The same for the temporary tablespace.

Don't forget to create enough rollback segments and redo logfiles which are big enough (at least 5M).

Then import with the commit=y option, otherwise you will run out of rollback-segments.

regards,

Guus van de Sande
independent Oracle-consultant

--
- remove NOSPAM from my e-mail adress -

Carlin Phillips <chao_at_cs.ubc.ca> schreef in artikel <35BE18E0.9CCC2747_at_cs.ubc.ca>...
> Just what does it take to fully import a database?
>
> I have a brand new 8.0.4 database I created manually because orainst
> script didn't work. I ran scripts like: catalog.sql, catproc.sql,and
> pupbld.sql
> to prepare for a full import from a 7.3.2 dmp file (exported by user
> ops$operator with dba role).
>
> Created a user call temp with dba role and started the import.
>
> I'm running in trouble with errors like user undefined and tablespace
> not found. Must I recreate all the users and their role/profiles.
> Isn't that what a full import is suppose to do? Can anyone tell me just
> what are the steps one needs to do for a successful import these days.
>
> Thanks in advance.
> --
> Carlin Phillips <chao_at_cs.ubc.ca>
> Dept. of Computer Science, UBC
> Tel: (604) 822-6129 Fax: (604) 822-5485
>
Received on Tue Jul 28 1998 - 14:32:04 CDT