If you are processing a FULL export then the import will (basically) :
- Attempt to create the tablespaces based on the same file names that are
in the export file. If your directory structure has changed then you will
need to create the tablespaces prior to the import.
- Attempt to create all of the users that are in the export file. Note
that the default and temporary tablespaces for all of the users must exist,
otherwise the user will not be created.
- Attempt to create all of the objects (including grants) for all of the
users in the export file.
Alexey M. Reshetov wrote in message <6pm109$fp$1_at_home.kpbank.ru>...
>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!
>____________________________________________________
>Alexey Reshetov
>real_at_kpbank.ru
>
Received on Wed Jul 29 1998 - 07:21:12 CDT
