From: "mammoth.usenet-access.com" Newsgroups: comp.databases.oracle.server Subject: upgrade sanity check Date: Wed, 20 Feb 2002 07:38:56 -0500 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 127.0.0.1 Message-ID: <3c7398e8$1_2@corp-goliath.newsgroups.com> X-Authenticated-User: 668178974 X-Comments: This message was posted through Binaries.net X-Comments2: IMPORTANT: Binaries.net does not condone, nor support, spam or any illegal or copyrighted postings. X-Report: Please report abuse to Organization: Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!news.maxwell.syr.edu!newsfeed.online.be!ams.uu.net!newsfeed.song.fi!nntp.inet.fi!inet.fi!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!corp-goliath.newsgroups.com!not-for-mail Xref: easynews comp.databases.oracle.server:136015 X-Received-Date: Thu, 21 Feb 2002 13:01:25 MST (news.easynews.com) To upgrade an existing database from 8.0.5 to 8.1.7 do I have to do anything different than: 1. Cold backup existing DB 2. Export user/passwd file=somethin.dmp owner=schema_to_migrate 3. Use oracle uninstaller to remove 8.0.5 4. Install 8.1.7 5. Recreate tablespaces for schema_to_migrate 6. Import user/passwd file=somethin.dmp fromuser=schema_to_migrate touser=schema_to_migrate ignore=y 7. Validate triggers, procedures, views etc. ______________________________________________________________________________ Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net