Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade 8i to Express Edition 10g?!

656701Aug 31 2008 — edited Sep 1 2008

Hello,

I have a Oracle 8i database that is being used by our company. I need to set up another server. I want to download Oracle Express 10g and then import data form Oracle 8i to the express edition.

As I know Microsoft SQL Server very well, but only new to Oracle, I wanted to make sure this is possible.

1) Can data form 8i to moved to 10g Express Edition?

2) How do I move the data? In SQL Server, I would do a back up and then restore to the new server. Is that the same with Oracle.

3) Does anyone know of a good tutorial website on how to create a backup from one server and then load it into another server?

Thanks.