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