Search Results

Hi,

the sqlldr errors are normally logged in the file you specified for the parameter "log" of the sqlldr command.

For instance:

sqlldr userid=$APPS_USR/$1 control=$FICH_CTL log=$LOG_FILE...

Hi,

there must be a field in your text or csv file that contains a too large value for the specified column.

Hi,

the error you mention suggests that your proc uses the UTL_FILE package.
Does the new user's unix id use the same Oracle user to connect? Does this id have proper writes, etc.?

Hi,

thanks for your replies guys.

The script proposed by fpmurphy worked very well for me too. All the occurences were replaced except the ones that were on the lines containing either "PRAGMA"...

Hi,

sorry to bother again, but it still doesn't work. I'm using SunOS 5.8 and when I run the command you suggested I get an errors

% sed --version

gives "ksh: %: not found"

man sed ...

Hi,

I need to compile Oracle packages for a certain list of schemas. It needs to be done automatically, so doing it through a shell is the most convenient way for our DBA.
I won't provide as many...

Hi fpmurphy,

I tried your suggestion but it didn't work, the substitution occured for the lines containing either of these words.

Thanks anyway

I think I inverted the sums. It should be like this:

SELECT SUM(CASE WHEN x<Q THEN 1 ELSE 0 END) / SUM(1)
FROM data

Hi,

I'm using the SED instruction for substitution in a shell script. I'd like to improve it a bit. The instruction looks like this right now:

sed '/PRAGMA/!s/package/apps.package/g' $fich_src ...

Hi Figaro,

the condition "D1.x<Q" of your query will prevent all the lines to be counted, that's why you don't get what you expect.

I suppose the SQL engine you dispose of is very basic,...