05-31-2001
Depends how large the Oracle export file is.
You could always restore the file into a filesystem on box3 and then use NFS to mount that drive on to a filesystem on box2.
NFS is simple enough to use, depending on your flavour of UNIX there will be a nfsconf file with all the the network files, in HP-UX it is in /etc/rc.config.d/. The entries in here are self explanatory - box3 will need to be a server and client. Create an exports file on this box to detail what directory you want to export, and then simply use the exportfs command to export.
Modfiy the nfsconf file on box2 to make it a client. Start the nfs sub-system on box3 by locating the start script, which will be with all the other networking start scripts, in HP-UX this is /sbin/init.d/ - if you're unsure where it is all these scripts are linked to the run level scripts in rc1.d/rc2.d/rc3/d etc.
Then start nfs on box2. Make sure you do it in this order - the server needs to be started before the client or else the client will hang while it looks for the nfs server.
The syntax on box2 then, to mount the exported filesystem is a logical extension of the normal mount syntax:
mount [nfsserver]:[exported_directory] [local_directory]
Having said all this, attention must be made to network impact, if the export is very large, exporting the directory will put a consequent strain on the network and you may become very unpopular very fast.
If this isnt an issue run man pages on nfs and exportfs to get a better picture if you're stuck at any point.
Hope this helps.
Regards.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. Solaris
Hi,
How do i export selected Oracle database schemas from HpUnix?
Is it possible to export it to a windows shared drive?
If so how do i do it?
Pls advice.
Thanks in advance. (4 Replies)
Discussion started by: nicky88
4 Replies
3. UNIX for Advanced & Expert Users
Hi
I have an oracle 7.3.4 running on an aix 4.3, I need to make a full export of the db and I haven't space on disk.
Can I export directly to a tape drive?
Has anybody a script to do so or something that can help me to?
thank you very much (1 Reply)
Discussion started by: andwhat
1 Replies
4. AIX
Hi,
I use tar to backup the following programs:
tar -cvf /dev/rmt0.1 u04/devdb/log/arch
tar -cvf /dev/rmt0.1 u01/app/oracle/product/10.2.0.2/dbs
tar -cvf /dev/rmt0 u01/app/oracle/product/10.2.0.2/network/admin
when I want to retrieve the tape content list with:
tar -tvf /dev/rmt0
it... (1 Reply)
Discussion started by: victorcheung
1 Replies
5. UNIX for Advanced & Expert Users
I have the below script which has been written to retrieve files from tape drive i.e. TSM server. Now i have to write the script using UNIX commands for retrieve operation but I am not able to proceed. The script is:
#!/usr/local/bin/expect -f
set timeout 1800
set file
spawn $env(SHELL)... (0 Replies)
Discussion started by: hrsaurav
0 Replies
6. Shell Programming and Scripting
Hi Experts ,
Does anybody know the sheel scripts , which exports oracle tables into xls files .
Thanks for your feedback.
Regards
Pranav (1 Reply)
Discussion started by: Heisonline
1 Replies
7. Shell Programming and Scripting
I intend to do parallel export of my Oracle db (i.e all the schema in my db).
Currently I'm using the below exp command in my script:
exp $uid/$pwd@$ORACLE_SID FILE=./DUMP/$today$username.dmp STATISTICS=NONE LOG=./LOG/$today$username.log
For parallel export what should I use?
Please... (1 Reply)
Discussion started by: priya001
1 Replies
8. Shell Programming and Scripting
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies
9. Shell Programming and Scripting
I am trying to get the data from oracle table to a variable I have tried the below code
#/usr/bin/sh
echo " I am in correct loop"
SPOOL_FILE=/app/scripts/alt.lst
sqlplus /nolog <<END_SQL
connect bindu/bindu@gis
whenever sqlerror exit failure rollback;... (4 Replies)
Discussion started by: Kiransagar
4 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies
TS(4) Kernel Interfaces Manual TS(4)
NAME
ts - TS-11 magtape interface
SYNOPSIS
/sys/conf/SYSTEM:
NTS ts_drives # TS11
/etc/dtab:
#Name Unit# Addr Vector Br Handler(s) # Comments
ts ? 172520 224 5 tsintr # ts11 driver
major device number(s):
raw: 8
block: 2
minor device encoding:
bits 0003 specify TS drive
bit 0004 specifies no-rewind operation
bit 0010 ignored
DESCRIPTION
The ts-11 combination provides a standard tape drive interface as described in mtio(4). The ts-11 operates only at 1600 bpi, and only one
transport is possible per controller.
FILES
/dev/MAKEDEV script to create special files
/dev/MAKEDEV.local script to localize special files
SEE ALSO
mt(1), tar(1), tp(1), mtio(4), ht(4), tm(4), dtab(5), autoconfig(8)
DIAGNOSTICS
ts%d: no write ring. An attempt was made to write on the tape drive when no write ring was present; this message is written on the termi-
nal of the user who tried to access the tape.
ts%d: not online. An attempt was made to access the tape while it was offline; this message is written on the terminal of the user who
tried to access the tape.
ts%d: hard error bn%d xs0=%b xs1=%b xs2=%b xs3=%b. A hard error occurred on the tape at block bn; status registers 0-3 are printed in
octal and symbolically decoded as bits.
ts%d: addr mod 4 != 0. The address of a TS-11 command packet was not on an even longword boundary.
BUGS
If any non-data error is encountered on non-raw tape, it refuses to do anything more until closed.
The device lives at the same address as a tm-11 tm(4).
3rd Berkeley Distribution January 28, 1988 TS(4)