| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Full export and import
Carlin Phillips (chao_at_cs.ubc.ca) wrote:
: 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
Exp/imp allows to create user in the new database according to his parameters in the old database. But if the new DB not contains tablespaces with the same names like in the old DB then will errors of user's creation. If you will make import from another user with DBA role, all be OK, but you'll get some warnings at import of SYSTEM objects. It's not terrible. If you prefer absolutely clear way, you should write scripts for creating user's schemas in your new database and import every user separately.
Good luck!
 |
 |