Re: Using Export/Import - On Client Side

When I enter EXP at the system prompt on our AS 1200, I get the following:

$ exp
%DCL-W-ACTIMAGE, error activating image ORA_UTIL:EXP -CLI-E-IMAGEFNF, image file not found $1$DKB0:[ORACLE.][UTIL]EXP.EXE;

My guess, as stated earlier, the utility was not installed.

Does this mean a the 7.3 Client has to be reinstalled or can the EXP/IMP utlity be loaded from
the 7.3 CD ?

Richard Senior wrote:

> 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 Mon Aug 09 1999 - 07:35:53 CDT