Re: exp error

You cannot use the "exp" program of a higher RDBMS version against a lower database. [You can do it the other way round, exp from a lower version against a higher database, provided you have run the appropriate catexp?.sql script].

See Note 132904.1 on MetaLink.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

RAYMOND <raymond_at_infopro.com.my> 08/01/2002 12:20 PM Sent by: root_at_fatcity.com

Please respond to ORACLE-L

                                                                                       
                        
             To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>           
                        
             cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)                
                        
             Subject: exp error                                                        
                        
                                                                                       
                        
                                                                                       
                        
                                                                                       
                        

I run exp from my local db client 8.1.7 to exp an oracle 8.1.6 db USERS to my database...
but this error come out ??

I just issue an command : exp sks/sks_at_prod1 .. ..but this error message come out for all the tables I going to export... I try in the prod1 database workstation and issue the same command..exp sks/sks_at_prod1....it go smooth .no error come out ?? Why is this happen ??

EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name

. . exporting table                       AD01MAST

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: RAYMOND
  INET: raymond_at_infopro.com.my

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.com
-- 
Author: 
  INET: hemantchitale_at_charteredsemi.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).