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.

dblink between 9i and 12.2

User_M8BYZMay 7 2018 — edited May 8 2018

Is it possible to create a DBLink between a database on Oracle9i (9.2.0.6.0) and Oracle Database 12c (12.2.0.1.0) - 64bit?

I'm creating a new database using 12c and I want to be able to get my data from the current 9i database to the 12c database.

They are on 2 different servers.

1. Do I need to create an entry in the tnsnames.ora on either server or both?

2. Using oracle client 11.2.0.4 lets me connect to both databases and I can select from tables in both.  Do I need to install it on either server or both?

Thank you
This post has been answered by Hans Steijntjes on May 8 2018
Jump to Answer

Comments

843807
I don't know the exact cause of the problem, but as a -not so nice but it works- solution, I propose to add the following line right before the first c.repaint() call:
c.add(new JLabel());
843807
This may sound silly but are you using a layout manager? If not, why not? Setting positions is difficult and keeping the controls in the right place will be difficult. When you use a layout manager, you can programmatically "lock" the labels. Using BorderLayouts and GridBagLayouts are terrific. Check out this link, it helped me a lot.

http://developer.java.sun.com/developer/onlineTraining/GUI/AWTLayoutMgr/shortcourse.html

Just remember that you should decide how you want the labels to behave (should they resize and move or be fixed) and pick the layout that matches that behavior. Create a JPanel, set that layout and then add the JLabels...
843807
I added a null layout manager and everything stuck. One line of code. Ha ha that article on layout managers was good thanks.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 5 2018
Added on May 7 2018
#9i, #general-database-discussions
10 comments
2,131 views