prem,
Desc the tables in question on both servers to display the difference
in column names. Is one of the columns a LONG or BLOB?
Ron
>>> [EMAIL PROTECTED] 03/25/03 05:03AM >>>
Guys,
i am importing a schema ( exported from 8.1.6 ) into 9.0.1.1.
i am doing it on a test server where 9.0.1 DB resides.
what i did was ...
c: > IMP file=test.dmp indexes=n indexfile=test.sql full=y
then i created the tables with TEST.SQL . then ..
c: > IMP file=test.dmp indexes=n rows=y ignore=y
of 30 tables , all get imported except 2.
in case of both the tables , the error is :
....importing table "MEMLOG"
IMP-00058: Oracle error 904 occured
ORA-00904: invalid column name
what may be the reason ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
