I am relatively new to oracle and I need to perform the operation mentioned above.

I am trying to create a development copy of the database.

any ideas or advice???

thanks in advance

Hi


You can simply make an export on Solaris platform and import it on Windows 2000, no problem.

Make sure that RDBMS versions are the same (or Windows 2000 database where your importing in is higher version than Solaris)

Good luck!

Remi

and how would I do that??

i have never done an import or an export before.

any ideas??

thanks for the reply btw

is its exp or something ?? i was reading it. bother versions are 8.1.7i

Hi Ken Doh,

The clue that remivisser gave you is the word exporting or export.

Bung this into Oracle's OTN or even a good search engine and you'll get loads of useful stuff back.

A little bit of self learning/teaching can go a long way.

Please only post back here if you are having REAL problems with the actual EXP command itself.....

indeed it can

created a user
created a table space owned by that user
ran the imp command


imported perfectly