Use of export from a shell script.. Post: 302449914

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help for writing shell script to export table data

Hi All, I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data). The tables list is not static, and those are selecting through dynamic sql query. Can any body help how to write this shell script. Thanks,

2. Shell Programming and Scripting

problem running shell script (for oracle export) in crontab

Hello Gurus, I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered...

3. Shell Programming and Scripting

Export to Microsoft excel using shell script

I have requirement where i have to export the data extracted from a flat file to a microsoft excel sheet. If the awk returns multiple records then all these records should go in into different rows of same column in excel. Eg. say data returned by excel is A,B,C,D then these 4 records should go...

4. Shell Programming and Scripting

Set/Export Env Vars from with Shell Script With Input Variable

I have a shell script I want to run that will set environment variables based on the value of an input variable submitted when the shell script is called. For example: $ mgenv.sh prod This would set environment variables for prod $ mgenv.sh test This would set environment variables...

5. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea .

6. Shell Programming and Scripting

When i am trying to execute export command within a shell script it is saying command not found.

I am running the export command within a view to use that value inside my build script. But while executing it it is saying "export command not found" My code is as follows: -------------------------- #!/bin/sh user="test" DIR="/bldtmp/"$user VIEW="test.view1" echo "TMPDIR before export...

7. Shell Programming and Scripting

export repository shell script

Hi Forum, I have script to export he Siebel repository. My requirment is to have a shell script in place so when placed in it in a cron it should generate the repsoitory dat file on date basis. Script for export: repimexp /a E /c UCM_ES_DEV2_DSN /u sadmin /p SADMIN /d siebel /r...

8. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig.

9. Shell Programming and Scripting

Export Error in Shell script

All, While executing the bellow commnad after the sed, awk command to export the value to, i am getting the fallowing error. line="_AABBB.EEEEEEE.LOG4JDISPLAY.PATH_=/apps/opt/abcde/pdstdsd/esapp/apadsfasdf/logadsfasdf.xml" keystring=`echo $line | awk -F"=" '{ print $1 }'`...

10. Shell Programming and Scripting

Data export UNIX shell script

Hi, I want to write a shell script which connect to my database with the following credentials : User name : user PWD : rap_user_1 Hostname : app.Unix.Gsm1900.Org Port : 7862 SID : PTNC1 Once connected to DB i want to fetch data with the help of a SQL statement and expoet...

LEARN ABOUT SUNOS

asadmin-export

asadmin-export(1AS)						   User Commands					       asadmin-export(1AS)

NAME

       asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode

SYNOPSIS

       export  [ name=value  [ name=value]*]

       Marks  a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
       as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable  name	is
       displayed.  If  the  export  command  is  used  without	any arguments, a list of all the exported variables and their values is displayed.
       Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and  set  as  exported  variables
       within asadmin. Unexported environment variables cannot be read by the asadmin utility.

OPERANDS

       name=value	       variable name and value for automatic export to the environment to be used by subsequent commands.

       Example 1: Using export to list the environment variables

       asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
       asadmin> export AS_ADMIN_PREFIX=server1.jms-service
       asadmin> export //to list the environment variables that are set
       AS_ADMIN_HOST=bluestar
       AS_ADMIN_PORT=8000
       AS_ADMIN_USER=admin
       AS_ADMIN_PASSWORD=********
       AS_ADMIN_PREFIX=server1.jms-service

       Where:  the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
       is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-unset(1AS), asadmin-multimode(1AS)

J2EE 1.4 SDK							    March 2004						       asadmin-export(1AS)