Re: Export on Oracle 8 Solaris, Import on Personal Oracle 8 Win95

Hmm, that's a good though. I'm having that checked now (I didn't create the export file).

I have progressed somewhat though. I ran imp80 with INDEXFILE=blah. I then hand-edit blah.sql and changed the tablespace name to be USER_DATA which is what personal oracle sets up by default. I then ran blah.sql in SQL*Plus and it created all the tables and indexes.

I then re-ran imp80 with ignore=y and rows=y and it imported data into all the tables. I still got numerous "unrecognised statement/record in export file" errors but it seems to have worked (or at least partially).

I could prove it if I could run the app against the database, but I'm now trying to understand how to set a hostname:port:sid so this app can connect (a java JDBC app using Oracle thin driver - it insists on hostname:port:sid even for a local database). I tried 127.0.0.1:1521:ORCL but that didn't work so I'm now trying to understand tnsnames.ora and all that stuff.

Despite all the above I'm very impressed with this product. I'm a newbie and I've managed to get a lot achieved in a very short time.

jdl

Petter Hansen wrote:

> Did you set the RECORDLENGTH parameter during export?
> You got to use this between not binary-compatible systems.
> Remember to use it during import also.
>
> Just my 2c.
>
> Petter Henrik Hansen
>

<snip> Received on Fri Oct 23 1998 - 23:24:26 CDT