Re: recreating oracle instance

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