10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Trying to run the Oracle Proc in parallel, but not working.. below code runs each call of the procedure and its coming out of the loop before its completion and printing the last statement! not waiting for the sqlplus to complete.
for name in `cat abc.txt`
do
(sqlplus -s ... (3 Replies)
Discussion started by: ATWC
3 Replies
2. UNIX for Beginners Questions & Answers
i have say x number of procedure to run, ie i have one procedure which accepts variable and i need that to run in parallel and capture the error code if in case if it fails through the unix.
sqlplus <EOF> exec test_t (abc,124); </EOF>
sqlplus <EOF> exec test_t (abc,125); </EOF>
sqlplus <EOF>... (2 Replies)
Discussion started by: ATWC
2 Replies
3. Homework & Coursework Questions
Hi Guys,
I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle.
db2 connect to Tablename user id using psswrd
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA"
db2 "EXPORT TO... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
4. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: priya001
1 Replies
5. Shell Programming and Scripting
Hi Experts ,
Does anybody know the sheel scripts , which exports oracle tables into xls files .
Thanks for your feedback.
Regards
Pranav (1 Reply)
Discussion started by: Heisonline
1 Replies
6. UNIX for Advanced & Expert Users
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 (1 Reply)
Discussion started by: andwhat
1 Replies
7. Solaris
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. (4 Replies)
Discussion started by: nicky88
4 Replies
8. Shell Programming and Scripting
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: (1 Reply)
Discussion started by: inquirer
1 Replies
9. UNIX for Dummies Questions & Answers
Hi guys:
I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through... (1 Reply)
Discussion started by: oracle8
1 Replies
10. UNIX for Dummies Questions & Answers
Hi!
We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1
The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
Discussion started by: sdharmap
1 Replies
