Path: utzoo!censor!geac!torsqnt!jarvis.csri.toronto.edu!rutgers!cs.utexas.edu!wuarchive!texbell!ncrwic!ncrlnk!ncrprt!cirilo
Newsgroups: comp.sys.ncr
Subject: ORACLE 6 under UNIX NCR 3.00.01
Message-ID: <309@texbell.swbt.com>
Date: 1 Mar 90 10:03:59 GMT
Organization: NCR Portugal
Lines: 91
Resender: towers@texbell.swbt.com (NCR Tower Mailing List)



>Does anyone know if Oracle version 6 needs version 3 of NCR's
>Tower 32 UNIX ?
>
>i.e. will it run under 2.01.01 ?
>

	Oracle version 6 runs under NCR's Tower 32 UNIX  3.00.01
and 2.01.01.


>Also, a supplier of a third party software product based on Oracle
>has suggested that his Oracle 5 port will be easily (and quickly)
>upgradable to Oracle 6.
>
>>From what I have seen of Oracle 6 while migration isn't all that
>hard it also isn't trivial.  Comments ?
>
>Regards
>-- 

	Migration of Oracle 5.1 to Oracle 6 needs the following 
	several steps:

1. Migrating User Applications

	* The CREATE TABLE command uses new storage parameters.

	* The command "INSERT INTO tablename SELECT" will return an error
	  code if no rows are selected.

	* Illegal references to
		
				ALTER PARTITION
				CREATE PARTITION
				ALTER SPACE
				CREATE SPACE
				DROP SPACE

	* There are no Public DBA synonyms.

2. Migrating the Oracle RDBMS

	* Make a backup of Oracle Version 5.1

	* If you use the same directory, where you have V. 5.1, for
	  Version 6, you should first delete all files of 5.1 before
	  installing Oracle 6.

3. Migrating Data

	* Backup the Version 5.1 database

		1. Perform a database export of all desired data.

		2. Perform a backup using your operating system's backup
		   utility after shutting down the D.B. whith IOR SHUT.

		3. Rename objects that use Version 6 reserved words.
		   Rename tables, indexes and clusters that share the
		   same name.

	* Export the Version 5.1 Database

		1. Perform a databse export. You must logon as SYSTEM.

	* Allow for Large Indexes

		If you will import tables that create large indexes, you
		must increase the size of temporary segments.

	* Convert Tablespaces to Partitions

		Create a tablespace in Version 6 for every partition in
		your Version 5.

	* Import your data

4. Grant new user authorizations

	* You must create a new password for each user.



-- 
Cirilo Santos / SSD              Tel:    351-1-539911
NCR Portugal                     Fax:    351-1-525760
Apartado 1396                    Cems:   6347-ADMIN
P-1011 Lisbon Codex              Email:  [ncrlnk!]ncrprt!cirilo
                                         Cirilo.Santos@Lisbon.NCR.COM