Re: Full export and import

Are the tablespace names same in the old and new databases?

The create user statement uses the tablespace definitions also. If there is a difference in tablespaces, the user will not get created in the full import. Even the Temporary or TEMP names make a difference.

Try importing one user before the full import and see if you get succesful import.

HTH Prasad Chavali
pchavali_at_assettech.com
Carlin Phillips wrote in message <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:23:30 CDT