Re: recreating oracle instance

Howard, if you do the three step export import process (complete, incremental; then incremental imported as SYSTEM, the full/complete imported as whatever, and then reimport the incremental you just took right after the complete, as =RECOVER, all user id's and everything else including all internal Oracle objects will be reconstructed; whoever feels like it can look in the Oracle Utilities Reference Manual for the syntax.

A single plain old full export is fraught with all the yuck you described; the INCTYPE=SYSTEM on the first import of the incremental fixes lots of that, and the second import of it whichever way it says fixes the balance of it. That's why I keep barking at new DBA's to dog-ear / clip / mark that obscure little paragraph.

The tablespaces however will have to preexist, or else the filesystem or raw partition names will have to be identical with wherever you started from.

sigh, you'd think that "full" meant "full"....oh, noooo.

RSH. "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a6080m$se5$1_at_lust.ihug.co.nz...
> I always try and steer people away from using export/import as an upgrade
> solution, and now I remember why!
>
> Import can't create the tablespaces for you -the commands are certainly
> there in the dump file, but the paths to the data files are hard-coded, so
> unless you have a second machine with exactly the same directory layouts,
it
> simply can't do the job. You'll have to create all the necessary
> tablespaces yourself first.
>
> After that, if you are doing import with full=y, it *should* be able to
> create the user accounts for you. Failure to create the users would
explain
> why everything else went wrong. You'll have to post the error messages
you
> got before we can guess why the user creation process failed. It could
just
> be that the 'create user' statements in the dump file contain things like
> 'default tablespace DATA' and 'temporary tablespace TEMP' -and if those
> tablespaces don't exist, because of the issues mentioned earlier, you
would
> expect the create user statements to fail. If that was the case, then
> getting the tablespaces re-created manually would fix everything else up.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "John" <jriker1_at_yahoo.com> wrote in message
> news:e6bb5a8d.0203040626.2b14849a_at_posting.google.com...
> > I have an Oracle 8.0.5 server and am trying to move to 8.1.7. I did a
> > full export of the data, however when I do a full import, it gives me
> > all kinds of errors about tablespaces, tables, procedures, schema's.
> > Is there a way to import this data into a new database and have it
> > automatically recreate all the users? I would have to manually
> > recreate 30 users which would be kind of a pain. Thanks.
> >
> > JR
>
>
Received on Tue Mar 05 2002 - 01:59:57 CST