Hi !
I have created some migrations in Oracle database succesfully, using Oracle Data Provider for .NET (ODP) 64 bits, but when i tried to query some object, i'm getting an "ORA-00972 identifier is too long" :shock: , after some research over internet and forums, it is caused because Oracle has a limitation of 30 characters in object names. Right now i just have one custom table called "noticias" as seen below on picture
So one possible solution it's make my table names shorter, to avoid, indexes, foreign keys, secuences or any object, have more than 30 characters.
It's possible to change default asp.net boilerplate table names names by shorter ones, and how ? really i can't find other solution, since i just have a single and short custom table name, my last change its test if default tables with shorter names could work.
Or do you know other possible solution to this problem ?
Thanks a lot
7 Answer(s)
-
0
Url for image <a class="postlink" href="https://www.dropbox.com/s/bkmntfzgojuzc61/Captura.PNG?dl=0">https://www.dropbox.com/s/bkmntfzgojuzc ... a.PNG?dl=0</a>
-
0
I'm also using abp with odp.net.
I can confirm you that all tables in your picture could be reached without problem.
I've no problem on my side.
Could you paste the full detailed exception ? (with the specific identifier)
-
0
Sure ! thank you so much for your time
I'm have uploaded tree images with the important stuff.
This is the detailed exception (just let me know if you need more details, i've been stucked on that :cry: , so any extra info, i'll reply, as soon as possible) <a class="postlink" href="https://www.dropbox.com/s/vzas0r5aqmvlz47/1.jpg?dl=0">https://www.dropbox.com/s/vzas0r5aqmvlz47/1.jpg?dl=0</a>
Caused by getAll query <a class="postlink" href="https://www.dropbox.com/s/6ntu9t8irh8kw59/2.jpg?dl=0">https://www.dropbox.com/s/6ntu9t8irh8kw59/2.jpg?dl=0</a>
And this is my model <a class="postlink" href="https://www.dropbox.com/s/x3bazvhi5rlr8i4/3.jpg?dl=0">https://www.dropbox.com/s/x3bazvhi5rlr8i4/3.jpg?dl=0</a>
I'm using entity framework 6, and ODP 12.1.022 ... could you tell me please which versions are u using ? x86 or x64 ?
Thanks a lot :D
-
0
Hi there.
i'm using nuget package : <a class="postlink" href="https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/">https://www.nuget.org/packages/Oracle.M ... Framework/</a> \packages\Oracle.ManagedDataAccess.EntityFramework.12.1.022\lib\net45\Oracle.ManagedDataAccess.EntityFramework.dll
my target (any cpu) is x64, but nuget package automatically choose the version for you. My oracle version : Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
I don't see anything wrong with your screenshot.
In one of my previous posts #124@38ccb987-2803-4dd5-ae63-c383ec88317b you can see the correct .config file.
Could you verify if your config file is ok (even if ti's not relevant to the name too long), and using the nuget instead the downloadable sources ?
If it still not work, i'll provide you an example running on my oracle with your domain.
-
0
problem solved.
(I recreated a sample console project for stevenmunoz, it solved his solution)
If needed, ask the sample :)
-
0
<cite>daws: </cite> problem solved.
(I recreated a sample console project for stevenmunoz, it solved his solution)
If needed, ask the sample :)
Please share for me, I think this is my problem.
[http://forum.aspnetboilerplate.com/viewtopic.php?f=5&t=5389&p=13486#p13486])
Thanks!
-
0
Hi,
I think the problem in related topic is solved as well.
