Sponsored Content
Top Forums Shell Programming and Scripting Wrapper script to refresh test database with production data Post 302339233 by jim mcnamara on Thursday 30th of July 2009 05:41:03 AM
Old 07-30-2009
What database?

Are you on a SAN?

If the db is small you can export the db to tape or across your network, then import it. We need more information.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

2. Shell Programming and Scripting

Need Shell Script to upload data from Text file to Oracle database

Hi Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database. Requirement:- 1. Need to connect to Oracle database from Unix Shell script. 2. Need to pick Text file from some location on Unix Box. 3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies

3. UNIX for Dummies Questions & Answers

Refresh ls list on screen (auto-refresh)?

I am looking for a way to issue a command or string of commands to repeatedly display new files that are written to the directory. I usually use ls -ltr to see the newest files at the bottom of the screen. I would like to automate this command to refresh what is displayed every second or so. Can... (3 Replies)
Discussion started by: skidude
3 Replies

4. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

5. Shell Programming and Scripting

unix script for loading a data from a file into database

Hi All, I am trying to load a data from a files in a particular directory to a database.. cd $SCC isql metdb >> ${LOGDATA}/LOAD.LOG < ! load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE ! But it's showing the error "syntax error at line 46 : `<<' unmatched" Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies

6. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal. (1 Reply)
Discussion started by: royal9482
1 Replies

7. Shell Programming and Scripting

Database Connection test in unix Script

i have a unix script that gives me the sysdate from the database EDNAMID.WORLD.What i want my script to do the following 1) Establish a database connection 2) if database connection is successfull then echo the message "Connected" 3) put the o/p of the Sql query in a spool file 4) then... (3 Replies)
Discussion started by: ali560045
3 Replies

8. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

9. Shell Programming and Scripting

Need help on Insert data to phpMyAdmin mySQL database from Shell Script

Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my... (4 Replies)
Discussion started by: aoiregion
4 Replies
norewind_close_disabled(5)					File Formats Manual					norewind_close_disabled(5)

NAME
norewind_close_disabled - determine whether access to tape device special files without the no-rewind-on-close option is allowed VALUES
Default Allowed values DESCRIPTION
Note: this tunable was named in releases prior to HP-UX 11i v3. This tunable notifies the tape driver whether it should allow access to device special files without the no-rewind-on-close option. When this tunable is on, the tape driver will fail any open on a tape device special file that does not have the no-rewind-on-close option (that is, or with a status of The tunable allows the safe sharing of tape devices in SAN tape backup solution configurations. The disabling of device special files without no-rewind-on-close in a SAN tape backup solution configuration prevents the accidental sending of a rewind command on close from HP-UX systems via standard tape commands like which would corrupt a backup in process. Who Is Expected to Change This Tunable? Anyone. Restrictions on Changing Changes to this tunable take effect immediately. When Should the Tunable Be Turned On? This tunable should be turned on if the system is going to be used in a SAN tape backup solution configuration. What Are the Side Effects of Turning the Tunable On? The tape driver will fail any open to a tape device special file that does not have the no-rewind-on-close option with a status of This behavior prevents the usage of any tape device special file without the no-rewind-on-close option. When Should the Tunable Be Turned Off? This tunable should be turned off if the system is not part of a SAN tape backup solution configuration or the system utilizes will not function unless it has access to device special files without the no-rewind-on-close option. What Are the Side Effects of Turning the Tunable Off? A rewind may be issued accidentally from this system on close, possibly corrupting a backup being issued from another system on the SAN. What Other Tunables Should Be Changed at the Same Time? None. EXAMPLES
Query the current value of the tunable: Set the value of the tunable to To save the value of the tunable across reboots: WARNINGS
All HP-UX kernel tunable parameters are release specific. This parameter may be removed or have its meaning changed in future releases of HP-UX. Installation of optional kernel software, from HP or other vendors, may cause changes to tunable parameter values. After installation, some tunable parameters may no longer be at the default or recommended values. For information about the effects of installation on tun- able values, consult the documentation for the kernel software being installed. For information about optional kernel software that was factory installed on your system, see at AUTHOR
was developed by Hewlett-Packard. SEE ALSO
scsi_tape(7), scsimgr_estape(7). Tunable Kernel Parameters norewind_close_disabled(5)
All times are GMT -4. The time now is 04:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy