Re: recreating oracle instance

Having said all that, for an upgrade, it's immaterial!

You should do a full export followed by an incremental immediately afterward with the DB in RESTRICTED mode, and perform the upgrade in situ as it were.

Upgrades can involve all sorts of PL/SQL and other stuff and usually do; if you import after an upgrade, heaven knows why, you can clobber a million things. DON'T do THAT.

If you import data after an upgrade, you WILL have a mess! Think, the software doesn't match the database, the PL/SQL is all out of whack and everything else is a problem.

If you did the procedure I previously described, the database and dictionary and user ids would all be consistent, but out of synch with your software. Bleah.

Back the whole thing up and follow Oracle's directions. This is not a time to get tricky.

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 - 02:07:20 CST