Re: invoking exp

On 25 Mag, 17: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.

It depend on client installation however the dmp file is always where you launch the exp program, in this case on client machine. Bye
 Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Fri May 25 2007 - 10:28:34 CDT