Re: upgrading to Oracle8 - couple of questions

It is not really very hard. Here is how I do such upgrades using the exp/imp method.

create the schema export using the exp program zip it (makes it 10% or original size)
write script to create tablespaces
write script to create user
write script to grants
burn the files to a CD
put CD in target server
copy files from CD to folder on server HD uzip zipped files
run tablespaces create script
run user create script
run grants script
run imp program to populate your schema

Rock

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!