Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP80/IMP80 - problem with users
Hi Christoph,
Here's the general gotcha in importing to a fresh instance:
- create the database
- VERY important: create the second rollback segment in the SYSTEM
tablespace. This command is in the export, however after the create
tablespace command series
- Precreate all tablespaces because the files may have moved.
If you didn't make this provisions, the create user statement will fail.
Try rerunning the import, with LOG=<any filename> and make sure you address
ALL errors.
Apart from the rollback segment issue, the import IS in the correct
sequence.
Hth,
Sybrand Bakker, Oracle DBA
Christoph Kukulies <kuku_at_gil.physik.rwth-aachen.de> wrote in message
news:7pj7n9$934$1_at_nets3.rz.RWTH-Aachen.DE...
> Env.: Oracle 8.0.5/NT 4.0
>
> I'm trying to find a way to save a database and restore it
> identically into a freshly created instance.
>
> I'm doing EXP80 full=y and IMP80 full=y but during import
> all user related info is spit out as error. GRANTs to certain
> user created tables are not processed because the specified user
> doesn't seem to exist at the time the import is done.
>
> Is there a problem with the order things are done?
>
> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de
Received on Fri Aug 20 1999 - 12:20:06 CDT