Oracle 8i DB -> Oracle 10g
 

I'm using 10g to develop on, and I need to get the schema and data out of a fairly large Oracle 8i DB. What's the easiest way of going about this? Can I backup to a file? I'd rather not have to script it all.

I'm no expert (currently studying for 10g OCA) but I'd have thought you'd have to export the schema from 8 and import it into 10 :)

EDITED TO ADD: How big is the DB and do you have enough spare disk space to do that?

Andy

I'm no expert, but I've always used Oracle "exp"ort to get a full database backup.

You need to re-create the original tablespace names and datafiles first if you try a full "imp"ort.

I've done this for DB's from 30-60Gb.

You can go 8 > 10 , but not the other way though.... ( 10 > 9 doesn't work easily either ... )

Yes, export from 8i, make sure they have the same/compatible char sets, make sure you get a list of the tablespaces and pre create them in the target db along with the appropriate schema/user. Do a fromuser/touser import so you don't end up with a lot of objects owned by sys.

Set the buffer size as you get daft errors otherwise.

Alternatively, you can do an upgrade from 8.1.7.4 to 10G in situ and just upgrade your 8i database.

You cant go backwards, as has been said, do some research on the "compatible" parameter which can be useful in these situations.

An export isn't a real backup, never use it as such, unless it is to augment your real backup regime, RMAN being the preferred choice for most eventualities with a good old fashioned cold backup for a warm and fuzzy feeling if you arent sure.

J4CKO, Oracle 8i, 9i, 10G OCP

You HAD to put that in there :D

Yes, need to do the 11g one to complete the set.

PM me if you need any tips, the exams aren't to bad as long as you prepare fully, do the self tests, do every possible item on an actual db, read the books etc.

J4CKO - YHPM :thumb: