SQL Developer

Este forum é destinado a perguntas relacionadas a Oracle, mas que não se enquadram nos forums acima. Aqui serão tratadas também sobre outras tecnologias da oracle, como o Workflow, BPEL, Spatial, OCS, etc.
Post Reply
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

aí PERSONAL,
Does anyone use SQL Developer in Windows?

Do you have any scheme to run the Code Complete when it is used alias?

Here at work I'm using Linux and works, then I went to the staff to use, soon found this "defect" in Windows.

Extremely rough ...

In PLSQL Developer this works ..
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Did you unzip it to which folder? Do you have space in the folder name?

Did you try to unzip again?

Did you try to get another version?


sqldeveloper-5338-no-jre.zip
I use this here currently and already used others and always in Windows and never had to enable this functionality. . It has always been running Code Complete usually with or without alias
burga
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Thu, 26 Nov 2009 1:05 pm
Location: SP

I use version 2.1.0.63 in Vista and normal wheel with Code Complete on alias.

What the staff here complains a lot of error in the Code Complete is that they write the commands in a tab script and not in the "SQL Worksheet" (SQL Worksheet).

The Code Complete only works on the SQL worksheet and not in the Tab script.
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Version :: sqldeveloper-2.1.0.63.73-no-jre.zip

very strange,

Use in Slackware 12 x64 and works, but on XP of the developers did not want to function this functionality, it even works, but when they put alias it will not,
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

I discovered what was, the user that developers use is more limited, but what I use, sysdba, or owners of the tables, in these work,

I tried to give grant on the user_tab_columns, etc. Even so it did not work

is the tip there, if someone is more than more, put there

=]
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Diego

did you give grant and simultaneously created synonym for the table?

I think it can work .. what do you think?
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

I think there are more things, because actually if I log in with the user, and try consultations the User_, he consults all, should have some other role, access to dictionary, something like this, [99]
= /
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

and fuck .. rsrsrs

My PL SQL Developer does not work that combobox of the login screen that contains the connections all of the tnsnames

I already posted here .. Dai I created variable of environment, I reinstalled client and the kct but nothing .. it does not work ..

Sleep with this noise .. rsrsrssr
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

How so does not it work?

Non no entry from tnsnames.ora, but if you put the name it connects?

Ah looks, in preference tools, you can specify Oracle_Home, will not be pointing to Oracle_Home wrong?
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

this .. if I fill everything in the hand connects but the dropdown (combobox) does nothing that is in my tns .. my oracle_home is configured right and such .. I already saw and I already did it work a few different times, but in this project current with the current machine does not funciona

I already admitted my defeat .. rsrsrs
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

UAHaiu Caraio Strange, I had a problem similar to this when I was with Windows 7 x64, the plsql was installed in a Program Files (X32), then this parenture did not let the PLSQL find the right TNS configurations,

]sinister
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

I think it's very cool ...

Agent only speculating .. and you gave me an idea ..

My TA Here Oh
C: \ Program Files \ PLSQL Developer

and I have a folder
C: \ Products
where I like to install all my tools and by chance (these wizards of life that you click on next .. rsrs) my pl sql developer was not for the


as soon as I have a time here I will change that stop and put Here the result ... rsrsrs
: -O
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

You can copy the PLSQL folder that is in the Program Files and paste in your
C: \ Products

, run the run there, it accepts, if it works, then reinstall, clear,

: D
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Look what I'vê been through .. rsrsrs
http://en.glufke.net/oracle/viewtopic.p ... +developer
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Virgi, it may be what Alex said the tnnames.ora bugado, this makes a lot of sense, then plsql is shitting to read, could try, create a new one, and for only one entry in it,
99]: D

You can discover whether it is the file that is wrong,
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

já to using PLSQL 8 here, try to upgrade, uihauihiauhauihauia

já should have done so much that even makes more question to put away não é?
auihauihaiu
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

kkkkkkkkkk
this environmental stops and brabo ne face ... You cling and feels sorry to change
kkkkkkkkkk

but aí ... I already had scrambled on my tns but I did what you did I left a connection only ... guess ... it worked yes rsrsrs .. and then I put one to one and it's all right now ..

Any mistake in my tnsnames file was passing unnoticed

8 and? Do you have a difference? worth it?
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

ahaaaa then yes after 28348923489 days at least it solved

face, I still did not go far, to see what is of Bão,
http://dl.phazeddl.com/1919969/PL_SQL_D ... .0.0.1480/
If you want to download, you have the link above,

= P
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

My courporative proxy here blocked but at home I will download ..

Do you have the crack too?
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

It has .. =)

He generates a serial, then thou fill after the installation,
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Valeuu !!!

Thanks Diego

a hug
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 13 guests