Ben wrote:
> 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.
>
One additional note....
If you are using Data Pump in 10g (expdp), the dump file will be created
on the database server, not where the utility was invoked.
Thanks,
Brian
--
===================================================================
Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
--
Posted via a free Usenet account from http://www.teranews.com
Received on Tue May 29 2007 - 09:50:52 CDT
