Recent content by darryl_staflund

Hi there, I created 3 elementary tables this morning but find that although I was able to modify the index storage attributes of the tables earlier this morning, I am no longer able to do so -- even when I restart the application. When I edit the table and go to the index tab, I can modify...

I can indeed verify this. I tried reproducing it on v. 6.0 and was not able to. Thanks!

Hi there, I do not know if this is a bug or not but it did catch me offguard so I am posting my observations here. I am using 5.1.6 BTW. I used PL/SQL Developer yesterday to change CHAR fields to NCHAR and VARCHAR2 fields to NVARCHAR2 in a test database of mine and conversion went smoothly...

Hi there, PL/SQL Developer was a great resource when it came to comparing schema objects. However, if you are using some of Oracle's more funky indexing options or are working with partitions, you will have to go through your code and modify it in places. It will be interesting to see how...

Hi all, There are a number of issues that I am experiencing with the Explain Plan window of 5.1.4: 1. Results grid doesn't have a horizontal scrollbar to allow for left-to-right scrolling. 2. If I maximize the Explain Plan window, execute a query, and then restore the Explain Plain window...

Hi there, Would it be possible to modify the Explain Plan feature of PL/SQL Developer so that we can specify the preferred "plan_table" schema that we would like to work with? The default, at present, is to work with the plan_table of the user's schema and, if it isn't present, prompt the user...

Hi there, PL/SQL Developer doesn't support PCTFREE if you try to create an indexed table. For instance, if you attempt to create a table and check the INDEX Organization option, PCTFREE and PCTUSED are disabled. This is alright for PCTUSED but PCTFREE should still be vailable for editing (I...

Hi there, I don't know if this has been reported yet, but the "Copy Comma Separated" doesn't always work in the latest release of PL/SQL Developer. For example, if I open up the "Foreign Key References" folder for a table and then copy one or more of the constraints, nothing is placed on the...

Hi there, When I wish to export data from Table A to a SQL file, is there a way of disabling foreign key references in Tables B, C, D, etc. that refer to Table A? It sure would be nice to have this capability, especially since it complements the delete/truncate features of the same dialog box...

Hi aotte, Your posting seems to hit home with the problem we had. It only happened after our DBA had copied a schema (ddl and data) from one database to another and reset the password in doing do. I don't know what he did after I talked with him about the issue but I was able to log on...

Hi all, Thanks for your help and suggestions mkalter, and thanks for the tip aotte. Yes we are running Oracle on NT. The problem only occured briefly over the span of a couple of hours so it's not terribly intrusive. The next time it happens, I'll jump on the opportunity to search about...

Hi there, If I attempt to log onto a database and get the following error: ORA-00020: Maximum number of processes exceeded then PL/SQL Developer seems to enter an infinite loop in which it continually tries to connect before re-displaying the above message. There is no way I can end the...

Hi there, I am using Windows 2000 SP 3. Darryl

Oops. Small correction... In oder to reproduce the window I don't maximize it but just enlarge it by dragging the bottom-right corner of the window. Darryl

Hi there, I've come across a small problem with PL/SQL Developer (.1.3.704). If I am editing a procedure in the command window, and the command window is sized such that: (i) it is not maximized; (ii) the lower horizontal scrollbar is visible; (iii) the lower horizontal scrollbar is touch...