Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

For more information about MavenAGI, please go to: https://support.quest.com/essentials/MavenAGI

5.8.1 HF a db script error out (4239959)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

5.8.1 HF a db script error out
Description

After upgraded STAT database to 5.8.1, I then applied the 5.8.1 HF-a db script (fix_lob_tablespace.sql). The script error out after section A.
BEGIN
*
ERROR at line 1:
ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "STLOB"
ORA-06512: at "STAT.STAT_MOVE_LOB_TS", line 15
ORA-06512: at line 2
Resolution

RESOLUTION:

1. Look at the fix_lob_tablespace.sql script, search for "STORE AS SECUREFILE"

2. Remove the word SECUREFILE

3. There should be two occurance.

Optional, you can see the attached fix_lob_tablespace-modify2.sql with the corrected syntax (word SECUREFILE removed)
Attachments

fix_lob_tablespace-modify2

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Leave a Comment

Recommended Content

Product(s):: Stat

Topic(s):: Troubleshooting

Article History:: Created on: 11/30/2016
Last Update on: 5/7/2023

Search All Articles