Re: Export & Import PO8 ?

Hi,

Your best bet is to use SQL*Net and fetch it all from one DB to the other using SQL. I presume you want your pictures to go to the "office" database as well...

Put the PC with your "mobile" database on the network. Choose a PC to work from (any PC on that network) Setup a database alias for both your mobile and your office database Connect to the office database
Create a database link to your mobile database:

   create public database link.... (look in the manual for the exact syntax) Now use: (suppose emp is your table name)

   insert into emp select * from emp_at_mobile_database_name or

   create table temp_emp as select * from emp_at_mobile_database_name

Hope this helps,

Gerrit-Jan Linker
Author of Oraxcel, OraSQL, OraCodes and OraWeb. http://members.aol.com/gjlinker

In article <75mch6$648$1_at_news.kabelfoon.nl>,   "Evert J. Smit" <e.smit_at_caiw.nl> wrote:
> Howdi,
>
> I've got two systems, both stand alones, with Personal Oracle 8 and Windows
> 95 running. One system is the one which will be at our office and the other
> is in the back of my car each day. With the last system I'm going office to
> office to shoot pictures and make cards, like name badges with pictures, for
> the people.
> The pictures and some other objects are inserted into the Personal Oracle 8
> database. Now it comes, how can I export my database stuff from my 'moving'
> system into the database of the system at the office ?
> Because I'm not very famillar with database I've no idea how I should do
> this.
>
> Thanx,
>
> E.J. Smit
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Dec 27 1998 - 23:15:52 CET