Mixing
Only unknown data type in SQLDeveloper
I have been using SQLDeveloper a while and I made a schema in it. But now, for some reason, when I open this schema, all the data types are set to "unknown".
When I open a new schema and create an entity, I only have 'unknown' option for logical data type, nothing else.
I am not aware of changing anything, so I am lost. Has anyone encountered anything like this?
(in kubuntu, I can't take a screenshot of a dropdown menu, for some reason, but it contains only one value - unknown)
ubuntu oracle-sqldeveloper
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
add a comment |
I have been using SQLDeveloper a while and I made a schema in it. But now, for some reason, when I open this schema, all the data types are set to "unknown".
When I open a new schema and create an entity, I only have 'unknown' option for logical data type, nothing else.
I am not aware of changing anything, so I am lost. Has anyone encountered anything like this?
(in kubuntu, I can't take a screenshot of a dropdown menu, for some reason, but it contains only one value - unknown)
ubuntu oracle-sqldeveloper
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
Okay. Renaming (essentially removing)~/.sqldeveloperfolder helped, but I'd still like to know what caused this in the first place.
– Martin Melka
Nov 10 '13 at 17:46
add a comment |
I have been using SQLDeveloper a while and I made a schema in it. But now, for some reason, when I open this schema, all the data types are set to "unknown".
When I open a new schema and create an entity, I only have 'unknown' option for logical data type, nothing else.
I am not aware of changing anything, so I am lost. Has anyone encountered anything like this?
(in kubuntu, I can't take a screenshot of a dropdown menu, for some reason, but it contains only one value - unknown)
ubuntu oracle-sqldeveloper
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
I have been using SQLDeveloper a while and I made a schema in it. But now, for some reason, when I open this schema, all the data types are set to "unknown".
When I open a new schema and create an entity, I only have 'unknown' option for logical data type, nothing else.
I am not aware of changing anything, so I am lost. Has anyone encountered anything like this?
(in kubuntu, I can't take a screenshot of a dropdown menu, for some reason, but it contains only one value - unknown)
ubuntu oracle-sqldeveloper
ubuntu oracle-sqldeveloper
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
asked Nov 10 '13 at 15:29
Martin MelkaMartin Melka
2,60773783
2,60773783
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
Okay. Renaming (essentially removing)~/.sqldeveloperfolder helped, but I'd still like to know what caused this in the first place.
– Martin Melka
Nov 10 '13 at 17:46
add a comment |
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
Okay. Renaming (essentially removing)~/.sqldeveloperfolder helped, but I'd still like to know what caused this in the first place.
– Martin Melka
Nov 10 '13 at 17:46
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
Okay. Renaming (essentially removing)
~/.sqldeveloper folder helped, but I'd still like to know what caused this in the first place.– Martin Melka
Nov 10 '13 at 17:46
Okay. Renaming (essentially removing)
~/.sqldeveloper folder helped, but I'd still like to know what caused this in the first place.– Martin Melka
Nov 10 '13 at 17:46
add a comment |
4 Answers
4
active
oldest
votes
in Tools | Preferences | Data Modeler options just set the Default System Types Distionary to "(datamodeler localization on your hard drive)" & "datamodelerdatamodeltypes". Maybe this will help you like it helped me.
answered Feb 7 '17 at 11:00
AnaksAnaks
212
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
add a comment |
Removing ~/.sqldeveloper folder helped. I found no better approach.
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
add a comment |
I also just had this problem. I renamed the old preferences directory as indicated, then ran Data Modeler. When it asked if I wanted to import old preferences, I navigated to the renamed directory and had to identify a version twice-removed (system4.0.3.853, system4.1.0.881 didn't work) from the current version (system4.1.3.901) before I got my datatypes back.
Thank you. I will start including this in my backups.
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
add a comment |
Go to Tools -> perfreences -> Data modeler -> model select data types from All Logical types and drag to prefered logical data type.
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f19891527%2fonly-unknown-data-type-in-sqldeveloper%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
in Tools | Preferences | Data Modeler options just set the Default System Types Distionary to "(datamodeler localization on your hard drive)" & "datamodelerdatamodeltypes". Maybe this will help you like it helped me.
answered Feb 7 '17 at 11:00
AnaksAnaks
212
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
add a comment |
in Tools | Preferences | Data Modeler options just set the Default System Types Distionary to "(datamodeler localization on your hard drive)" & "datamodelerdatamodeltypes". Maybe this will help you like it helped me.
answered Feb 7 '17 at 11:00
AnaksAnaks
212
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
add a comment |
in Tools | Preferences | Data Modeler options just set the Default System Types Distionary to "(datamodeler localization on your hard drive)" & "datamodelerdatamodeltypes". Maybe this will help you like it helped me.
answered Feb 7 '17 at 11:00
AnaksAnaks
212
in Tools | Preferences | Data Modeler options just set the Default System Types Distionary to "(datamodeler localization on your hard drive)" & "datamodelerdatamodeltypes". Maybe this will help you like it helped me.
answered Feb 7 '17 at 11:00
AnaksAnaks
212
answered Feb 7 '17 at 11:00
AnaksAnaks
212
answered Feb 7 '17 at 11:00
AnaksAnaks
212
answered Feb 7 '17 at 11:00
AnaksAnaks
212
212
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
add a comment |
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
This one worked for me, I've lost all my custom defined domains though.
– vulkanino
Jul 10 '17 at 14:33
add a comment |
Removing ~/.sqldeveloper folder helped. I found no better approach.
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
add a comment |
Removing ~/.sqldeveloper folder helped. I found no better approach.
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
add a comment |
Removing ~/.sqldeveloper folder helped. I found no better approach.
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
Removing ~/.sqldeveloper folder helped. I found no better approach.
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
answered Dec 3 '13 at 12:18
Martin MelkaMartin Melka
2,60773783
2,60773783
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
add a comment |
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
I also had this issue and removing/renaming the preferences folder also fixed it. I'm on Windows 7, so my preferences folder was located in C:Users[USER]AppDataRoamingOracle SQL Developer Data Modeler.
– super_seabass
Jul 27 '15 at 15:15
add a comment |
I also just had this problem. I renamed the old preferences directory as indicated, then ran Data Modeler. When it asked if I wanted to import old preferences, I navigated to the renamed directory and had to identify a version twice-removed (system4.0.3.853, system4.1.0.881 didn't work) from the current version (system4.1.3.901) before I got my datatypes back.
Thank you. I will start including this in my backups.
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
add a comment |
I also just had this problem. I renamed the old preferences directory as indicated, then ran Data Modeler. When it asked if I wanted to import old preferences, I navigated to the renamed directory and had to identify a version twice-removed (system4.0.3.853, system4.1.0.881 didn't work) from the current version (system4.1.3.901) before I got my datatypes back.
Thank you. I will start including this in my backups.
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
add a comment |
I also just had this problem. I renamed the old preferences directory as indicated, then ran Data Modeler. When it asked if I wanted to import old preferences, I navigated to the renamed directory and had to identify a version twice-removed (system4.0.3.853, system4.1.0.881 didn't work) from the current version (system4.1.3.901) before I got my datatypes back.
Thank you. I will start including this in my backups.
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
I also just had this problem. I renamed the old preferences directory as indicated, then ran Data Modeler. When it asked if I wanted to import old preferences, I navigated to the renamed directory and had to identify a version twice-removed (system4.0.3.853, system4.1.0.881 didn't work) from the current version (system4.1.3.901) before I got my datatypes back.
Thank you. I will start including this in my backups.
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
answered May 17 '16 at 11:53
Bill KosterBill Koster
212
212
add a comment |
add a comment |
Go to Tools -> perfreences -> Data modeler -> model select data types from All Logical types and drag to prefered logical data type.
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
add a comment |
Go to Tools -> perfreences -> Data modeler -> model select data types from All Logical types and drag to prefered logical data type.
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
add a comment |
Go to Tools -> perfreences -> Data modeler -> model select data types from All Logical types and drag to prefered logical data type.
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
Go to Tools -> perfreences -> Data modeler -> model select data types from All Logical types and drag to prefered logical data type.
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
answered Nov 22 '18 at 7:23
Dipali BadgujarDipali Badgujar
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f19891527%2fonly-unknown-data-type-in-sqldeveloper%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you tried reinstalling it?
– Robin Green
Nov 10 '13 at 15:40
I dont have a native installation for my system, so it only comes as a zip. Yes. I have tried downloading and running it anew, but the settings are still there (connections, history).
– Martin Melka
Nov 10 '13 at 15:41
Okay. Renaming (essentially removing)
~/.sqldeveloperfolder helped, but I'd still like to know what caused this in the first place.– Martin Melka
Nov 10 '13 at 17:46