Retrieve Oracle export to tape Post: 2714

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

export table from oracle database

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:

2. Solaris

export oracle schemas

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.

3. UNIX for Advanced & Expert Users

full export oracle on aix

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

4. AIX

how to use tar to retrieve all tape content

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...

5. UNIX for Advanced & Expert Users

Failing to write retrieve script for tape to disk conversion

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)...

6. Shell Programming and Scripting

Oracle export

Hi Experts , Does anybody know the sheel scripts , which exports oracle tables into xls files . Thanks for your feedback. Regards Pranav

7. Shell Programming and Scripting

How to do Parallel Export in Oracle DB

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...

8. Shell Programming and Scripting

Parallel export of all oracle DB schema.

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...

9. Shell Programming and Scripting

Unable to retrieve data from shell when connected to Oracle

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;...

10. Homework & Coursework Questions

DB2 Export and Import Oracle

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...

LEARN ABOUT REDHAT

ammt

AMMT(8) 						      System Manager's Manual							   AMMT(8)

NAME

       ammt - Amanda version of mt

SYNOPSIS

       ammt [ -d ] [ -f|-t device ] command [ count ]

DESCRIPTION

       Ammt  provides just enough of the standard mt command for the needs of Amanda.  This is handy when doing a full restore and the standard mt
       program has not yet been found.

       Ammt also provides access to the Amanda output drivers that support various tape simulations.

       See the amanda(8) man page for more details about Amanda.  See the OUTPUT DRIVERS section of amanda(8) for more information on  the  Amanda
       output drivers.

OPTIONS

       -d     Turn on debugging output.

       -f device
	      Access tape device device.  If not specified, the TAPE environment variable is used.

       -t device
	      Same as -f.

       command count
	      Which command to issue, and an optional count of operations.

COMMANDS

       Each command may be abbreviated to whatever length makes it unique.

       eof|weof count
	      Write count (default: 1) end of file marks (tapemarks).

       fsf count
	      Skip forward count (default: 1) files.

       bsf count
	      Skip backward count (default: 1) files.

       asf count
	      Position to file number count (default: 0) where zero is beginning of tape.  This is the same as a rewind followed by a fsf count.

       rewind Rewind to beginning of tape.

       offline|rewoffl
	      Rewind to beginning of tape and unload the tape from the drive.

       status Report  status information about the drive.  Which data reported, and what it means, depends on the underlying operating system, and
	      may include:

	      ONLINE Indicates the drive is online and ready.

	      OFFLINE
		     Indicates the drive is offline or not ready.

	      BOT    Indicates the drive is at beginning of tape.

	      EOT    Indicates the drive is at end of tape.

	      PROTECTED
		     Indicates the tape is write protected.

	      ds     Device status.

	      er     Error register.

	      fileno Current tape file number.

	      blkno  Current tape block number file.

	      NOTE: many systems only report good data when a tape is in the drive and ready.

AUTHOR

       Marc Mengel <mengel@fnal.gov>
       John R. Jackson <jrj@purdue.edu>

SEE ALSO

       amanda(8)

																	   AMMT(8)