Re: Upgrade v6.37 to 7.1 on HP-UX 9.0

On 17 Jun 1995, Joe Nardone wrote:

>
> ... import will convert CHAR to VARCHAR2; you'll have
> to recreate objects only if you want to move them to new tablespaces
> or allocations...
>

	A -real- import probably does, but I discovered that 
	an import with the indexfile parameter to just get
	a listing of 'create index' statements, with REMd
	'create table' statements -doesn't- do the conversion.

	I had gotten such a listing during my Oracle7 upgrade
	so I could shuffle tables and indexes into new 
	tablespaces, and adjust storage parameters to a set
	of standard-sized chunks.  The 'create table'
	statements still had all CHAR() instead of VARCHAR2,
	which I didn't catch during my first test upgrade.
	Oh, and be careful you don't edit it to change CHAR
	to VARCHAR2 ... I got bit when some field names 
	included the string CHAR ... try CHAR( to VARCHAR2( .

	helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                               Oracle 7.1.3.2/Banner Finance 2.0.3 :>
<:                          Oracle 7.1.3.2/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>