Skip to Main Content
Forums

SQL Developer

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using Dimensions with SQL Developer 3.1

867504May 24 2012
After much effort I have been able to install the Dimensions plug-in to SQL Developer. I had to take a round about way due to proxy issues and manually installed it. Manually copied the zip file and extracted under jdev/extensions. But now I am having problems with understanding the navigation of using the Dimensions plug-in. I tried to read the help from the menu but it seems to be geared towards JDeveloper and I could not get much out of it.

I was assuming that the menu items under Versioning would be enabled once I am connected to Dimensions. For e.g. I was expecting the Check Out and Check In items to be enabled in the menu. But they are greyed out. I am definitely connected to our dimensions application because I am able to see the repository and its contents in Versioning Navigator.

I am wondering if it is a problem with the way I installed the dimensions plug-in OR just some navigation understanding that I am missing? Any help appreciated.

Comments

unknown-951199

>Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';

Above renders null & void any support contract between you & Oracle.


I hope you have a good backup that was completed before your fatal modification.


jgarry

Tom says it best: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1224836384599#16453523492091

Hemant K Chitale

See the strongly worded warning in Oracle Support Note "Changing Or Choosing the Database Character Set ( NLS_CHARACTERSET ) (Doc ID 225912.1)"

Hemant K Chitale

Srini Chavali-Oracle 
To update Character set in Oracle.


Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';

As stated, this is not supported - it will corrupt your database beyond repair. You will have to restore from a good backup taken before this statement was issued.

The supported methods are documented -

http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#NLSPG467

Database Migration Assistant for Unicode - Overview

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

Post Details

Locked on Jun 21 2012
Added on May 24 2012
#control, #sql-developer, #sqldeveloper
0 comments
124 views