Re: Using Export/Import - On Client Side

In article <37A9D42E.54E0303_at_jhuapl.edu>,

        Stan Novinsky <stan_novinsky_at_jhuapl.edu> writes:
> Is it possible to perform an Export from the Client Side ?

You can run export over SQL*Net: exp scott/tiger_at_remote_db

> Our AS 8400 is running Digital UNIX 4.0e and Oracle 8.0.1.1 Server with
> a 1.5 GB DB.
> We installed Oracle 7.3.2.3.2 Server on our AS 1200 but only selected
> the components that allow us to run it as a client. As a result, the
> Export/Import Utility was not built.

Presumably it has just created the tables and stuff that goes in the 'server' for import/export (CATEXP.SQL)

> We developed Export/Import procedures on an AS 8400 running Alpha
> OpenVMS 6.2 and Oracle 7.1 last year. The DB and Export/Import
> procedures both resided on the AS 8400.

I assume these are o/s scripts that run export/import with your chosen parameters rather than stored procedures?

> Question ?
>
> Is it possible for us to setup/install Export/Import on our AS 1200
> running Oracle 7.3 so that we can use our own procedures to export
> tables from our DB on the AS 8400 via SQL Net 2.0 ?

I'm not considering version issues here, but it should already be working? If you can get a SQL*Net connection from the machine where you have the import/export utilities, it should work now?

The thing that may throw a spanner in the works is version compatibility between import/export, SQL*Net and Oracle 7.3.x, but I would think you would be OK.

--
Regards,

Richard Senior
London, England Received on Fri Aug 06 1999 - 03:02:19 CDT