Re: invoking exp

On 25 May, 16:20, Ben <bal..._at_comcast.net> wrote:
> On May 25, 11:02 am, gazzag <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 25 May, 15:46, Ben <bal..._at_comcast.net> wrote:
>
> > > 9.2.0.5 EntEd AIX5L
> > > Is there a way to invoke export from a windows client machine and have
> > > the .dmp file stored on that client machine? I'm thinking no, but I've
> > > been wrong many times in the past.
>
> > If you have a client install at the same version as the server
> > install, you can call the exp utility if you have it installed
> > locally. Eg:
>
> > C:\Temp>exp system@<db_alias> file=test.dmp log=test.log owner=scott
>
> > Export: Release 10.2.0.1.0 - Production on Fri May 25 16:00:40 2007
>
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> > Password:
>
> > Connected to: Oracle Database 10g Enterprise Edition Release
> > 10.2.0.1.0 - Produc
> > tion
> > With the Partitioning, OLAP and Data Mining options
> > Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
> > character set
>
> > About to export specified users ...
> > . exporting pre-schema procedural objects and actions
> > . exporting foreign function library names for user SCOTT
> > . exporting PUBLIC type synonyms
> > . exporting private type synonyms
> > . exporting object type definitions for user SCOTT
> > About to export SCOTT's objects ...
> > . exporting database links
> > . exporting sequence numbers
> > . exporting cluster definitions
> > . about to export SCOTT's tables via Conventional Path ...
> > . . exporting table BONUS 0 rows
> > exported
> > . . exporting table DEPT 4 rows
> > exported
> > . . exporting table EMP 14 rows
> > exported
> > . . exporting table SALGRADE 5 rows
> > exported
> > . exporting synonyms
> > . exporting views
> > . exporting stored procedures
> > . exporting operators
> > . exporting referential integrity constraints
> > . exporting triggers
> > . exporting indextypes
> > . exporting bitmap, functional and extensible indexes
> > . exporting posttables actions
> > . exporting materialized views
> > . exporting snapshot logs
> > . exporting job queues
> > . exporting refresh groups and children
> > . exporting dimensions
> > . exporting post-schema procedural objects and actions
> > . exporting statistics
> > Export terminated successfully without warnings.
>
> > C:\Temp>
>
> > Or is that not what you're asking?
>
> > HTH
>
> > -g
>
> wow, yeah, thanks for all the info.
> When you do that, does it store the dmp file on the aix machine or on
> the local windows box?
> I figured if it was possible you'd have to have exp installed locally,
> but I didn't see it at first glance in my client install.- Hide quoted text -
>
> - Show quoted text -

It stores is wherever you invoke the exp utility from. In this case, my Windows workstation:

C:\Temp>dir test.dmp
 Volume in drive C has no label.
 Volume Serial Number is 5C2F-466B

 Directory of C:\Temp

25/05/2007  16:00            16,384 test.dmp
               1 File(s)         16,384 bytes
               0 Dir(s)  23,965,483,008 bytes free

C:\Temp>

HTH -g Received on Fri May 25 2007 - 10:35:45 CDT