Oracle 8i DB -> Oracle 10g
#1
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.
#2
Scooby Regular
Join Date: Dec 2002
Location: Dum dum de dum....
Posts: 2,617
Likes: 0
Received 0 Likes
on
0 Posts
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
EDITED TO ADD: How big is the DB and do you have enough spare disk space to do that?
Andy
#3
Scooby Regular
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 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.
#5
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
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
#7
Trending Topics
#8
Scooby Regular
Join Date: Dec 2002
Location: Dum dum de dum....
Posts: 2,617
Likes: 0
Received 0 Likes
on
0 Posts
Thread
Thread Starter
Forum
Replies
Last Post