Is shell's next line character '\' the cause of this issue ?
Oracle version: 11.2.0.1 /Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Hi,
impdp is a command line utility in oracle to import data into a DB schema.
Typically impdp command along with its parameters is run in a single line like
For better readability , I thought of putting each parameter on a separate line by using ' \ ' character as the next line indictor (not sure what is this called in Shell scripting terminology ). Is it New line indicator/separator or Next line separator ?
When I run the below shellscript which has three impdp commands , the second impdp fails with below error (error message is misleading, I think) but the 1st and 3rd impdp commands were succesfull. I have faced this wierd issue several times.
error I received for the second import:
I don't understand why I get "unable to open dump file" because the dumpfile is present and moreover the two other impdp commands which uses the same dumpfile (1st and 3rd) were succesfull.
Additional Info
===================
Info on very similair issue I had last week
Last week , I had very similair issue. I put 5 impdp commands in a similair script. I don't know if it is a co-incidence , but then also , it was the second impdp that failed with the same error. This is why I am suspecting that something has between the 1st sucessfull impdp and the second impdp command. Anything wrong with the new line indicator shown in red above ?
if impdp can be executed in multiple lines then i really dont think you need \ at the end of each line. You definately dont need \ at the end of impdp command or else it will join next line to current line..
This User Gave Thanks to vidyadhar85 For This Post:
Thank you Vidhyadhar. But I have had similar scripts with 5 impdp commands. But only the second one failed. If ' \ ' character at the last parameter is causing the issue , then all the remaining 4 commands would have errored out. Right ?
ORA-31640: unable to open dump file "/u07/wmsdata/expdat.dmp" for read
check below
Check the permissions on this file & owned user.
Check is file exact location.
If not Might dumpfile could have corrupted.
Are you performing export & import in same versions?
what is the word for ' \ ' (which I call 'next line indicator' ) in shell scripting terminology ? I need to do some googling on how this character behaves within a shell script.
what is the word for ' \ ' (which I call 'next line indicator' ) in shell scripting terminology ? I need to do some googling on how this character behaves within a shell script.
Its just instruct the shell that commands will be continued in the next line..
Hope below will explain it more clearly for you
This User Gave Thanks to vidyadhar85 For This Post:
I don't have so much to say about using "\" more than it's an escape for the following newline character, like esacping e.g. "$" with "\$". So perhaps it's important that there is no character (space etc.) after the "\".
This line:
Perhaps the spaces surrounding "=" is causing problems, and if you should use "\", don't have it at this last line.
Don't know if this is helpful...
I am still learning shell scripting. Recently I see a function for read configuration. But some of special character make me confused. I checked online to find answer. It was not successful. I post the code here to consult with expert or guru to get better understanding on these special characters... (3 Replies)
Greetings Experts,
I do have some basic knowledge of Unix. The task I am trying to do through shell script is to generate the view script for all of the tables which is in YYYYMMDD format (I assume I am on Ksh).
I have certain tables that ends in YYYYMMDD format (eg: tbl_20150630)
For each... (1 Reply)
Hi friend,
I have one file , and i want to read that file character by character.
I need this script in ksh.
while using read option with -n1 am getting error.
while read -n1 c read has bad option
And if i am using below script, then if in a line has space like this ( Pallvi mahajan)... (10 Replies)
Hi ,
I am doing some enhancements in an existing shell script. There it used the awk command in a function as below :
float_expr() {
IFS=" " command eval 'awk "
BEGIN {
result = $*
print result
exit(result == 0)
}"'
}
It calls the function float_expr to evaluate two values ,... (1 Reply)
I get a file which has all its content in a single row.
The file contains xml data containing 3000 records, but all in a single row, making it difficult for Unix to Process the file.
I decided to insert a new line character at all occurrences of a particular string in this file (say replacing... (4 Replies)
Hi Experts,
I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line.
File is comma (,) seperated.
Eg:
ID,Client ,SNo,Rank
37,Airtel \n... (8 Replies)
Hi guys , i need help so bad on this issue..
Basically i have to delete the line continuation symbol of first column variable and add the truncated part of that word in next line to first line.
here i written sample 3 lines but originally i have bunch of lines in that file.
client1_day- ... (3 Replies)
Hi,
I am reading data from file and storing it in a multiline variable. Every line is seperated with "\n" character.
globalstrval="${globalstrval}""${line}""\n"
If the value of globalstrval is like:
1234
ABCD
EFGH
WXYZ
....
If I do,
YLvar=`echo $globalstrval | grep "ABC"`
then... (1 Reply)
Hello.
I have a file (old.txt) that I need to copy into another file (new.txt).
Each line on old.txt ends with CR/LF but the position of CR/LF varies from one record to another.
I need to copy each line of record to new.txt and move CR/LF in pos 165.
Can I use awk to achieve this? How?... (8 Replies)
Good day ladies and gents,
I'm trying to write shell code that can give ignore everything else in a line bar the last character but not having much luck.
Any ideas? I have been looking at cut and sed but not making any progress. (3 Replies)