Skip to Main Content

Database 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!

Compress For OLTP x Row Store Ccompress Advanced

Brad OziApr 3 2017

We migrated 11g database to 12c.

The compressed tables where created with "COMPRESS FOR OLTP" in 12c.

The database is already in production.

I understand that 12c has a new syntax "ROW STORE COMPRESS ADVANCED".

Is there any need in recreating the tables with 12c syntax "ROW STORE COMPRESS ADVANCED"?

If not, are both syntaxes equivalent?

Thanks in advance, Mike.

Comments

jwells_nl

Hey Jeff,
Where can I put in (or upvote) enhancement requests for ORDS? I need its CLI to be enhanced to support adding modifications to the web.xml file embedded in the ords.war file.
See my post at AskTom for my use case and reasoning:
Customizing the ORDS web.xml file in ords.war - Ask TOM (oracle.com)
Thanks,
Jack

create a Service Request with My Oracle Support, then have them submit this as an Enhancement Request on the ORDS product.

jwells_nl

ok, did that (SR 3-24705516991).
Thanks, Jack

jwells_nl

FYI, the SR was completed with a new enhancement raised as follows:
Enh 32281114 - ADD COMMAND LINE FUNCTION TO UPDATE THE EMBEDDED WEB.XML FILE.
Jack

Jozef Demovic SVK

Not working on tomcat 10 due to java jakarta.servlet.Servlet vs javax.servlet library.
will there be some patch for it ?
Regards
J

thatJeffSmith-Oracle

eventually support for tomcat 10 will come, but it's not a simple thing

R Hachem

Thank you thank you for fixing this
BUG:31883509 - ORDS: Support trusted origins for PL/SQL Gateway calls
It was driving me nuts trying to make my apex app work. We have some users that connect through an intermediary website before coming to our server and it seems that this bug fix has finally allowed this to work!

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

Post Details

Locked on May 1 2017
Added on Apr 3 2017
0 comments
928 views