Home -> Usenet -> comp.databases.oracle -> Import fail after 7.1.3 upgrade?

Import fail after 7.1.3 upgrade?

From: Dan Bikle <dbikle_at_rahul.net>
Date: 18 Feb 1995 07:10:24 GMT
Message-ID: <3i46h0$350_at_hustle.rahul.net> 






Hi there,



Please consider this scenario.



You have a 7.0.16 dbs.  A table named EMP which is owned by SCOTT
resides in the dbs.



You upgrade the dbs to 7.1.3.



You export SCOTT.EMP and then drop it.



Your attempt to import SCOTT.EMP fails due to an improper data
type conversion.



So what do you think?



A friend of mine swears he ran into this problem.



He says it can be avoided by running a "special" version of catexp.sql
after the 7.0.16 -> 7.1.3 upgrade.



If you have run into this problem please let me know.  If you have
a dbs which has been through the 7.0.16 -> 7.1.3 upgrade please
run the above experiment & tell me the results.



I attempted to query the rtss bug database, but their modem seems
to be on vacation (it does pick up the phone but the terminal
server is silent).  I called support.  The analyst said to keep
trying.  I think it's busted.  you try: atdt14155989450




-Dan




Daniel B. Bikle/Independent Oracle Consultant
dbikle_at_alumni.caltech.edu | 415/854-9542 | P.O. BOX 'd' MENLO PARK CA 94026


Received on Sat Feb 18 1995 - 08:10:24 CET












Original text of this message