| Export Database from Unix TO Other Operating System [message #71351] |
Mon, 21 October 2002 05:30  |
fred Geeves
Messages: 14
Registered: March 2002
|
Junior Member |
|
|
Well here is a poser!!!
I have a HP Unix Server running Oracle 7.3.4. I need to run a full database export. Unforunately, I do not have enough disk space to enable me to run the export. So here's the question Can i run the export util on my unix box and tell it to run the dmp file to another machine i.e an NT box or could run an export to another Unix box ?
|
|
|
|
| Re: Export Database from Unix TO Other Operating System [message #71352 is a reply to message #71351] |
Mon, 21 October 2002 06:39  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Yes U can
Mount an NFS FS.
Or export from NT...
Or Create a named pipe ( mknod export to the pipe )
Run Gzip or compress ( or other )
ex
mknod mypipe p
exp FILE=mypipe
cat mypipe |gzip > mydump.dmp.gz
And U've got an already compressed dump ( save lot of
disk space ! )
|
|
|
|
| Re: Export Database from Unix TO Other Operating System [message #71358 is a reply to message #71352] |
Tue, 22 October 2002 07:23 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
If U have another UNIX server mount another FILE SYSTEM:
edit /etc/exports
add the entry for OTHER_FS ( in Read write mode )
mount other_server:/OTHER_FS /MOUNT_POINT
And run> exp FILE=/MOUNT_POINT/MY_DUMP
or
Install Oracle on Win NT
make an entry for Ur oracle database in tnsnames.ora
run> exp user/passwd@REMOTE_DATABASE
Best way is to have a little free space .. erase some unused files
Many others ways .. no time and no place here ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
