Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Shell script for oracle export/imp
Name: sureshht Date: June 5, 2007 at 07:01:17 Pacific OS: AIX 5L CPU/Ram: 4 CPU/8GB RAM Product: P595
Comment:
Hi,
I need to write a script for export/import job in oracle. I should be able to give instance name as a parameter while performing export. I also be able to give par file as parameter. Can anyone help me?
Name: LukeChi Date: June 7, 2007 at 12:36:03 Pacific
Reply:
#!/bin/ksh # I assume that no other environment variables # depend on ORACLE_SID # I also assume that ORACLE_SID is used # instead of TWO_TASKS # # Example: <programname> <instancename> <parfilename>
ORACLE_SID=$1 PARFILE=$2
exp <username>/<password> ... parfile=$PARFILE
Luke Chi
0
Response Number 2
Name: pops9131 Date: June 11, 2007 at 07:58:02 Pacific
Summary: Hi. I am a beginner on scripting. I will write a shell script for string encryption/decryption. the script will take 3 parameters. First one will be a flag telling whether to do encryption or decrypti...
Summary: Hi All, as a newby to unix I ask you this: I need to build a shell script that puts data from a csv file into an Oracle 8i databasethe width of the data in the csv file is filled with spaces where nec...
0 
