Imports

[Peer Jones]

Hi Everyone,

I'm planning to export and then import some dump files from not only one OS to another, but also from Oracle8 to Oracle 9 instances, say a WindowsNT Oracle 8.0.5 to Solaris with Oracle 9i Rel.2.

The server installations are OK and even comparable from the configuration setup points, but are there any nasty surprises to be expected under these circumstances?

Thanks
Peer

[Mr.Hanky]

Well there "shouldn't" be. But why not test this first, create a few dummy tables with CREATE as SELECT from.
Then import those tables, see how that goes before you try the whole enchilata.

MH

[Peer Jones]

Hi,

You're right, of course, but the new machines are just being configured for use (should be ready in a day or two), and I wanted to know if there are generally known problems especially exporting and impoting instances between two different OSs (my main concern).

The instances tend to have a lot of different DB objects, and if tables and views work, it doesn't mean there might not be any problems with other constructs anyone might have come across.

Thanks
Peer

[learning_plsql]

you won't run into any problems, just straight full export and full import to 9i since you go from the older version to the newer version, there won't be any problems.

[Mr.Hanky]

Originally posted by learning_plsql
you won't run into any problems, just straight full export and full import to 9i since you go from the older version to the newer version, there won't be any problems.

Actually no, this will not work becuase the mount points will be different, or non-existent. You will need to create the tablespaces ahead of time.

Are the tablespaces in place already?

MH

[Peer Jones]

Technically, no, but the tablespace create scripts etc. are, so those things are taken care of.

I'm happy now that my concerns seem to have been unfounded.

Thanks for the help, Guys.

Bye
Peer