Re: 6 to 7 conversion

>In article <44qmdb$rg4_at_dingo.cc.uq.oz.au> Gordon E. Hooker writes:
>Hi All,
>
>Could any of you see any problems importing a version 6 database into
>version 7 say PO7. Obviously not space problems, but combatibility
>problems.
>
>

I migrated a version 6 database into an Oracle7 database. No problems at all...but make sure that you specify that both grants=y and constraints=y, since by default they will not be exported when you do the export in Oracle 6.

Before you import into Oracle7, pre-create the tablespace shells into which the data can be loaded. Space allocation for the Oracle 7 tablespaces must be a bit more than those for 6. My platform was AT&T SVR4 & Oracle 7.1.4.

Nalini

>
>-----------------------------\ooOoo/-----------------------------------
>Gordon Hooker MACS PCP ,--_|\
>25 Clarke Street, Ripley, Queensland, 4306, Australia / \
>gordonh_at_acslink.net.au \_.--._/
>mobile: 018883835 phone: 61-7-2889716 V
>-----------------------------------------------------------------------
>It is far better to remain silent and appear a fool, than to open ones
>mouth and remove all doubt...
>>

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Capital - Global Information Solutions Miamisburg, OH 45342 Received on Tue Oct 03 1995 - 00:00:00 CET