Recent content by Bruce Carson

No worries. I played with it a bit more and it seems to work now after gathering stats for both indices and tables. I thought the stats were already generated. Disregard this post.

Trying to use the compare Table Data feature within pl/sql developer. When I compare 2 tables on our old 10g environment all works fine. When I compare the same 2 tables in our 11g environment I get the error ... Column TABLENAME.COLUMNAME does not exist in target table, table removed from...

ok thanks

We are going to wrap the external sql into a package and execute from there.

We want to run an external sql script from within a sql window. We have a script we execute via f8 and then execute an external sql script at some point in the sql window. When the external script is completed return to the original sql window. Possible?

any response .... we have an import which seems to stop after 1000 rows

I installed the vcs plugin and now see the vcs menu option. When I select vcs - preferences and try to select from the drop down of available version control systems I do not see anything. I do have the client for microsoft visual studio 2005 with source control explorer installed. Any help...

We have an issue where we are developing packages in pl/sql developer against a 10.2.0.3 db and the package changes do not always seem to come back properly (although we confirmed that the compile is writing to the db). A quick flow to create the problem is as follows although does not happen...

We have a system which uses context created with the following ddl: create or replace context icmr31bdst_person_ctx using icmr31bdst.personpkg; Where in pl/sql developer would I see the context object? I can see the context list using select * from dba_context; Can I add a folder in the...

No solution yet. Haven't had much chnace to work on this and the users have learned to live without it (they are not happy but are surviving).

Debug file was sent to Allround Automations

We run cursors within our select statements all the time. Recently it stopped working and am not sure why. The following query isn't a query we are running but does demonstrate the issue. Execute the following query in a sql window: select t.table_name, cursor (select c.column_name...

Can I 'SET SQLPROMPT' in the command window in pl/sql developer like you would for sql*plus?

I would like to use the pl/sql developer export tables in batch mode to export an insert statement for a particular table. Is this possible?