Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

s_nq_err_msg table error messages

935778Feb 25 2015 — edited Feb 27 2015

I built a report displaying all the error messages from the column "error_msg_text" of the table "s_nq_err_msg". My question is how can we get more user friendly message. Currently it has the special characters in between the msg.

As shown below this is how the data looks like in the error_msg_text column of the s_nq_err_msg table.

s_nq_err_msg.JPG

In the job manager the error message is one continuous message but in the table it's broken into multiple rows with special characters in between.

If anyone can give some ideas that will be helpful. Thanks in advance.

Comments

John Thorton

Some, many, most Professional IT groups maintain application code, including DDL, in source code repository.

so just do the following

1) extract DDL into single text file.

2) use favorite text editor to do global Search & Replace of CHAR to BYTE

3) run changed text file against newly created Oracle database

4) save text file back into code repository

unknown-7404

expdp, by default, generated internal DDL to create table observing current NLS_LENGTH_SEMANTICS of each column.

. . .

But I want an option to force expdp to not get/inherit the CHAR_USED value from DBA_TAB_COLUMNS

Then use the right tool for the job instead of expdp.

Using Sql Developer you can set all of the options you want for the metadata of the objects you export.

pastedImage_3.png

See that 'Add BYTE keyword' checkbox at the upper right?

Just uncheck it and do your export.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details