upgrade sanity check

From: mammoth.usenet-access.com <bgt_0990_at_msn.com>
Date: Wed, 20 Feb 2002 07:38:56 -0500
Message-ID: <3c7398e8$1_2@corp-goliath.newsgroups.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 Received on Wed Feb 20 2002 - 06:38:56 CST