EXPORT and IMPORT from client machine [message #567932] |
Mon, 08 October 2012 07:08 |
|
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
hello experts,
Is it also possible to use the EXPORT and IMPORT utilities from a client machine?
I want to give these utilities to one of my developers
without allowing him to sit in front of my Oracle server.
i am using oracle 11.2.0.1 and windows7 OS
thanks in advance.......
|
|
|
|
|
|
|
|
Re: EXPORT and IMPORT from client machine [message #567955 is a reply to message #567951] |
Mon, 08 October 2012 08:27 |
|
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
means sir,
in the expdp/impdp(exp/imp thrpugh the datapump utility) command we give all the parameter at a time.
like:-
Expdp devuser/password@db_name tables=test1,test2,test3 dumpfile=mydump.dmp
impdp produser/password@db_name tables=devuser.test1,devuser.test2, devuser.test3
dumpfile=mydump.dmp remap_schema=devuser:produser content=data_only
but in old utility we have to manually give the value for each parameter lik:-
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\>exp
Export: Release 11.2.0.1.0 - Production on Mon Oct 8 18:37:49 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: scott/tiger@testdb
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > sc
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > t
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > emp
. . exporting table EMP 6 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
C:\>
in 1st exp/imp command(expdp/impdp) can we EXPORT and IMPORT from a client machine or not?
thanks.....
|
|
|
|
Re: EXPORT and IMPORT from client machine [message #567958 is a reply to message #567957] |
Mon, 08 October 2012 09:05 |
|
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
ya sir, you are absolutely right that we can put all the parameters at a time in in old utility command.
and the dumpfile can be saved on client machine, even if database is on another machine.
my problem is resolved , thanks a lot sir.
my requirement was that i need to exp some tables from one server and import to the another server database ,
without login into the any server, means exp and imp both process should be accomplished on my machine(as client machine).
and also all the parameters values should be given in one go ,
but you told that dumpfile generated by expdp(new utility of exp/imp) get saved in the
directory of host machine(on server), am i right or not sir?
if yes,then i have to go for old exp/imp utility.
and sir one more question :-
if i need to exp/imp by sys then what should be the right place for 'as sysdba'.
like-
C:\exp sys/password@devdb as sysdba path='d:/dm.dmp' tables=devuser.test,devuser.test2
LRM-00108: invalid positional parameter value 'as'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
it gives the error.
thanks.....
|
|
|
|
|
|
|
|
|
|
|
|
|