Skip to Main Content

SQL Developer Data Modeler

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!

Alter table add column at a certain position

User_84SZKMar 10 2021

Hey,
like I can see, it is possible to generate automatically alter/rename scripts using “Data type conversion” to copy a table to another. This is described in Jeffs blog.
https://www.thatjeffsmith.com/archive/2012/03/diffs-and-alter-scripts-via-oracle-sql-developer-data-modeler/
Is there also a possibility to add columns at a certain position afterwards?
So can data modeler generate an automated script for this or exist a workaround to generate it?

This post has been answered by Philip Stoyanov-Oracle on Mar 12 2021
Jump to Answer

Comments

vladodias

Hi mate,

I'm assuming the value of "http://host:port/tokens" is not in your configuration, i.e. it is purposely edited in the post for information security reasons... otherwise the problem is probably there...

That said, note that OAuth 2.0 is a complete rewrite of OAuth 1.0 from the ground up, sharing only overall goals and general user experience. OAuth 2.0 is not backwards compatible with OAuth 1.0 or 1.1, and should be thought of as a completely new protocol.

Now, OWSM supports single-user OAuth use case, which requires providing partial support of OAuth 1.0 protocol in OWSM to use OAuth1 type of access token and token secret to secure the request to an API. OWSM provides new OAuth1 client policy which allows applications to use Twitter API using the statically generated consumer and access tokens. Retrieval of access token is not done by OWSM policy.

Oracle A-Team blog entry is for OAuth2 and I don't think it will work for your case... You should follow the link below...

10.8.1 About OWSM Integration with Twitter OAuth server

https://docs.oracle.com/middleware/12213/owsm/security/GUID-13F43DB4-C837-42C2-B6C5-6D6E07266415.htm#GUID-04F6A9C8-3EEC-…

Cheers,

Vlad

User_9VIX3

Vlad,

We are on version 12.2.1.0.0 and do not see any OWSM policy supporting OAuth1.0

Is there a patch we need to apply for this policy to be visible

Appreciate your help in advance.

Thank you,

Deepti

vladodias

Hi Deepti,

I can see it on my JDev 12.2.1.3... I'm unaware of any specific patch just to add the policy...

You might have to follow all the steps to upgrade to 12.2.1.3... see note below...

https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/fupss/upgrading-soa-suite-12c-bam-previous-12c-release.html#GUI…

Note:

If you are upgrading from a previous 12c release (12.1.3.0, 12.2.1.0, or 12.2.1.1), you must complete all of these tasks to upgrade to 12c (12.2.1.3.0) . Do not attempt to update the existing domain by installing the 12.2.1.3.0 distributions into the same Oracle home. Moving the domain to 12.2.1.3.0 is not a patch set installation.

pastedImage_0.png

Cheers,

Vlad

1 - 3

Post Details

Added on Mar 10 2021
3 comments
2,932 views