Sponsored Content
Full Discussion: Oracle and Unix
Top Forums UNIX for Advanced & Expert Users Oracle and Unix Post 10782 by truma1 on Wednesday 21st of November 2001 02:30:26 AM
Old 11-21-2001
Data Oracle and Unix

Hi I am having trouble with a script to export individual schemas to tape from an oracle database. Basicaly I need to export each shema through a pipe with compression and store each shema name in a file with the relevant tape marker.
 

9 More Discussions You Might Find Interesting

1. Programming

Oracle 9i on Unix

i am upgrading my Oracle 8i database to 9i that runs on Unix platform. Does this require me to make any changes in Unix so as to run the upgrade successfully? Regards, Gerald. (2 Replies)
Discussion started by: gerald_agoi
2 Replies

2. UNIX for Dummies Questions & Answers

Oracle to MySQL through Unix

Hello All, I'm a complete Unix newbie, and I have been asked to provide a solution for the following opportunity: Currently there is an Oracle database residing on a Unix box that I need to connect to on a regular basis from another Unix box. Upon connecting I need to hit multiple tables and... (6 Replies)
Discussion started by: Z24_2000
6 Replies

3. HP-UX

Restore of oracle 8i from hp unix 11.0 to HP unix 11i

Hi, We are planning to migrate oracle 8.1.7.2 (8i) currently installed on a host with HP unix 11.0 to a host with HP Unix 11i. The method we are adopting is backup and restore of all file systems. Could this be a problem, apart from linking libraries on the target system. Thanks for the... (1 Reply)
Discussion started by: amitb
1 Replies

4. Shell Programming and Scripting

Unix + Oracle

Hello people, at the moment, I have a database server running HP-UX and Oracle. From time to time, I need to extract data from oracle, and then do some data management (Awk, sed) within unix. At the moment, what I do is to copy the output from my oracle query and then paste into a file on another... (1 Reply)
Discussion started by: Khoomfire
1 Replies

5. Shell Programming and Scripting

Unix Oracle

Through a shell script ... I am invoking sql plus.. Code is as follows... echo " set feedback off verify off pagesize 0 select column from table " | sqlplus -s/@dbname | read var_col Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
Discussion started by: dhananjaysk
15 Replies

6. UNIX for Dummies Questions & Answers

unix for oracle

Hi unixers, :) Anyone have any links or online tutorials for Shell Scripting with respect to Oracle . Any example of script calling any Oracle procedure or function or passing parameters is highly appreciated. (6 Replies)
Discussion started by: ravi raj kumar
6 Replies

7. UNIX for Advanced & Expert Users

oracle to unix

how can i safely transfer a oracle database to a unix system thanks (1 Reply)
Discussion started by: djbilly
1 Replies

8. Shell Programming and Scripting

unix-oracle

Hallo Friends, My script looks like this: #!/bin/ksh set -x ######################################################################### # # Name: # statistics.ksh # # Details: # Performs a series of queries on the database to analyse application performance; # reports on backlog of... (2 Replies)
Discussion started by: kekanap
2 Replies

9. Programming

Oracle/UNIX

How do you combine the two language. (1 Reply)
Discussion started by: zbest1966
1 Replies
MTIO(4) 						   BSD Kernel Interfaces Manual 						   MTIO(4)

NAME
mtio -- generic magnetic tape I/O interface SYNOPSIS
#include <sys/ioctl.h> #include <sys/types.h> #include <sys/mtio.h> DESCRIPTION
Magnetic tape has been the computer system backup and data transfer medium of choice for decades, because it has historically been cheaper in cost per bit stored, and the formats have been designed for portability and storage. However, tape drives have generally been the slowest mass storage devices attached to any computer system. Magnetic tape comes in a wide variety of formats, from classic 9-track, through various Quarter Inch Cartridge (QIC) variants, to more modern systems using 8mm video tape, and Digital Audio Tape (DAT). There have also been a variety of proprietary tape systems, including DECtape, and IBM 3480. UNIX TAPE I/O Regardless of the specific characteristics of the particular tape transport mechanism (tape drive), UNIX tape I/O has two interfaces: "block" and "raw". I/O through the block interface of a tape device is similar to I/O through the block special device for a disk driver: the indi- vidual read(2) and write(2) calls can be done in any amount of bytes, but all data is buffered through the system buffer cache, and I/O to the device is done in 1024 byte sized blocks. This limitation is sufficiently restrictive that the block interface to tape devices is rarely used. The "raw" interface differs in that all I/O can be done in arbitrary sized blocks, within the limitations for the specific device and device driver, and all I/O is synchronous. This is the most flexible interface, but since there is very little that is handled automatically by the kernel, user programs must implement specific magnetic tape handling routines, which puts the onus of correctness on the application program- mer. DEVICE NAME CONVENTIONS Each magnetic tape subsystem has a couple of special devices associated with it. The block device is usually named for the driver, e.g. /dev/st0 for unit zero of a st(4) SCSI tape drive. The raw device name is the block device name with an "r" prepended, e.g. /dev/rst0. By default, the tape driver will rewind the tape drive when the device is closed. To make it possible for multiple program invocations to sequentially write multiple files on the same tape, a "no rewind on close" device is provided, denoted by the letter "n" prepended to the name of the device, e.g. /dev/nst0, /dev/nrst0. The mt(1) command can be used to explicitly rewind, or otherwise position a tape at a particular point with the no-rewind device. FILE MARK HANDLING Two end-of-file (EOF) markers mark the end of a tape (EOT), and one end-of-file marker marks the end of a tape file. By default, the tape driver will write two End Of File (EOF) marks and rewind the tape when the device is closed after the last write. If the tape is not to be rewound it is positioned with the head in between the two tape marks, where the next write will over write the sec- ond end-of-file marker. All of the magnetic tape devices may be manipulated with the mt(1) command. A number of ioctl(2) operations are available on raw magnetic tape. Please see <sys/mtio.h> for their definitions. The manual pages for specific tape device drivers should list their particular capabilities and limitations. SEE ALSO
dd(1), mt(1), pax(1), tar(1), st(4), wt(4) HISTORY
The mtio manual appeared in 4.2BSD. BUGS
The status should be returned in a device independent format. If and when NetBSD is updated to deal with non-512 byte per sector disk media through the system buffer cache, perhaps a more sane tape interface can be implemented. BSD
January 14, 1999 BSD
All times are GMT -4. The time now is 01:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy