Creation of Database link

greenspun.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


Moderation questions? read the FAQ