Re: Oracle Lite question

Hi Anand,

Hmmm, did you understand my question?

I'm wondering how to re-create the database in Oracle Lite from a dump file exported from Oracle 8i?

You'ar mention a text box?! What text box?

I can connect to the database with 'msql' and I can execute scripts. I can also load data from a comma separated text file with 'olload' but after the tables have been created.

Can I export a dump file from Oracle 8i and then import it into Oracle Lite (which creates the tables and loads the data)?

--
Best regards

Joacim Jarkeborn
IT Consultant - Systems Development
Gothenburg, Sweden


"Anand" <hsanand13_at_yahoo.com> wrote in message
news:8324cc14.0106180933.2779cc24_at_posting.google.com...


> Hi

> I am using Personal Oracle and my suggestion is that you donot have to


> mention the connect string in the host string- text box.

> this way you can connect to the data base!

> regards,

> anand

>

>

> ##############################################################

> "JJ" <jocke30_gbg_at_hotmail.com> wrote in message

 news:<9gc8t9$q9c$1_at_vg170.it.volvo.se>...


> > Hi,


> >

> > I need to move the data/structure from Oracle 8i to Oracle Lite.

> >

> > I have made a dump file from Oracle 8i with the export command 'exp'

 (Unix),


> > moved the file to WinNT and then tries to import the dump file into


 Oracle


> > Lite. I have tried to execute 'olload' with the dump file as parameter


 but


> > it doesn't work.


> >

> > How can I create the Oracle Lite database with data/structure from the

 dump


> > file?