How to export tables directly to tape device in AIX? [message #72326] |
Sat, 17 May 2003 15:15 |
Ramesh Viswanathan
Messages: 9 Registered: May 2003
|
Junior Member |
|
|
Can any one help me in exporting the oracle 8.1.7. tables to tape device in AIX 4.3 and i want to veiw the content of the tape too after taking the export.
Also the i will be keep on taking the export in the same tape, how to append the table data in the tape.
try to give the commmand with examples....
Regards
Ramesh
|
|
|
|
Re: How to export tables directly to tape device in AIX? [message #72331 is a reply to message #72329] |
Sat, 17 May 2003 17:13 |
Ramesh Viswanathan
Messages: 9 Registered: May 2003
|
Junior Member |
|
|
thanks mr.mahesh rajendran,
i am able to export the tables directly to tape device using the command said by u, but the problem is i am unable to view the content of the tape. more over if want to take export on daily basis to the same tape ...will it append the content or overwrites????
can u help me in this...or suggest some URL for this..
thanks & regards
Ramesh
|
|
|
|
|
Re: How to export tables directly to tape device in AIX? [message #72334 is a reply to message #72332] |
Sat, 17 May 2003 17:56 |
Ramesh Viswanathan
Messages: 9 Registered: May 2003
|
Junior Member |
|
|
.....since i had exported the entire schema in to the tape (directly written the content in tape.)..i was unable to use tar to read the content of the tape...when i try to give the following command from the unix
# tar -tvf /dev/rmt0
system giving the following message
tar: 0511-169 A directory checksum error on media; 16908288 not equal to 6696.
help me ....
thanks & regards
Ramesh
|
|
|