Creation of Database linkgreenspun.com : LUSENET : DBAzine : One Thread |
Does oracle support Database link between personal oracle7 on Windows-95 and oracle8i on Unix ? Can we create such a link to access data ?If not How do I Import data into personal Oracle 7 (export is taken from Oracle8i )?
Using SQL Loader While importing data into oracle 7, it gives error as ORA-02359: Field in data file exceeded maximum specified length Structure of table is as follows
AIRLINE_CODE number SERIAL_NO number AREA_CODE CHARACTER CITY_COUNTRY_AREA_INCL varchar2(2000)CITY_COUNTRY_AREA_EXCL varchar2(2000)
and the txt file fol loading is having column CITY_COUNTRY_AREA_INCL with max length 500 characters.
-- Rahul Mhatre (rahul_mhatre2000@rediffmail.com), September 06, 2002