Skip to Main Content
Forums

Oracle Database Discussions

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.

Turn Non Unique Index into a Unique Index

sql_coderApr 25 2014 — edited Apr 30 2014

Hello,

Version: 11.2.0.4.0 Enterprise Edition

We got a non unique Index for a primary key constraint. I would like to change that into a unique index. I know you cannot alter the index to change it. Is the only way to disable the primary key, drop the index and enable the constraint again or is there a better solution? It is a 24/7 platform.

sql_colder
This post has been answered by unknown-698157 on Apr 25 2014
Jump to Answer

Comments

843834
It doesn't itself, but since you can feed jaxb a DOM document from any source, you can always use a processor that does support xinclude and feed the result to the unmarshaller. Try this:

(1) Get the XInclude Engine at http://xincluder.sourceforge.net/

(2) build the xinclude document with something like:


DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
factory.setNamespaceAware( true );
factory.setCoalescing( true );
DocumentBuilder parser = factory.newDocumentBuilder();
InputSource input = new InputSource();
input.setByteStream( new FileInputStream( fname ) );
Document masterDoc = parser.parse( input );
Document doc = DOMXIncluder.merge( masterDoc, input.getSystemId() );

(3) then unmarshal the document with:

JAXBContext jc = JAXBContext.newInstance( "my.context" );
Unmarshaller u = jc.createUnmarshaller();
MyClass x = (MyClass) u.unmarshal( doc );

there's probably a faster Sax equivalent of this. Also works (better) with Castor.

hope this helps,

Graham
843834
Oops! sorry: looking at it again, I see I misread your question. I thought you meant using xinclude in a datafile (which I'd just worked out how to do) rather than in a schema (which I haven't worked out). Apologies.

Graham
843834
Yes. JAXB 1.0 supports included and imported schemas.
Can you please attach the COS.xsd too

Regards,
Bhakti Mehta
Sun Microsystems
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 28 2014
Added on Apr 25 2014
#general-database-discussions
8 comments
14,226 views