Jp,
Could you run this import command and send us the log file?
imp file=test.dmp show=Y log=show.log tables=MEMLOG
fromuser=tableownername touser=tableownername
Thanks!
>>> [EMAIL PROTECTED] 03/25/03 04: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: Darrell Landrum
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).
