On May 25, 11:35 am, gazzag <gar..._at_jamms.org> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
it does help extremely, thanks for all the info to those that posted.
Received on Tue May 29 2007 - 08:53:04 CDT
