Recent content by Raj

Thanks Marco, you have been very helpful, I am just picking your brain ... can pl/sql developer be deployed with an authorization string that makes it read-only? I think TOAD had that option at one time, I have long since stopped using TOAD, so don't know. Raj

Thanks, I understand standard procedure, but I am trying to retrofit an app that has been evolving since 93. Any other ideas? Raj

Thanks Marco, I implemented that, but I'd like to take it a step further. A complete read-only deployment. So, a user may log in, but can not do update/delete/truncate etc from within pl/sql developer even if those privs are available through roles etc. is this possible?

Is there a way to deploy plsql developer in a read-only mode by database/instance name? We don't want to change user privs but see if we can restrict update,delete,truncate or executing procedures etc using the tool. Version 7.0.3 TIA Raj

When exporting data into insert statements, is it possible to allow user to choose specific columns to export?. Current behavior is to use all columns in the table. We are migrating our developers from TOAD and this is one feature they are missing a lot. Cheers Raj

When trying to create new index from edit table screen, Is it possible to add a checkbox to allow stats collection as part of index creation? This could be very useful. Thanks Raj

There isn't any algorithm since 8i. Just pick he first invalid object and compile. Repeat until done. Raj

Marco, I have sent you the table export by email. It is a small file. Raj

Do you have an email address to which I can send to? Raj

Following error is reported whenever I select from a specific table in my database. It is a 10g database, i am accessing using 10g client and pl/dev version is 6.0.4.906 error reported is "Access violation at address 60508AF4 in module 'oracommon10.dll'. read Of address 0261DCBE", the program...

What is the latest version of pl/sql dev? I am running 6.0.0.840. I couldnot find a place on this website (maybe I am looking in the wrong place) where you could find the latest version numbers. Also, how do you set proxy address so you can check for updates through plsql developer? TIA Raj

Thanks Scott, Outside of starting a new instance, can you switch (or toggle) between sessions in one instance of PLSD? And by sessions, I mean to different sessinos to two databases ... Raj

I am new to PLSD (but have used TOAd for many many years) so this might be a basic question. Is it possible to have multiple sessions open at the same time? So, I can have two sqlwindows open each connecting to two different sessions or databases? currently it doesn't seem so, or I don't know...

This might be a simple question, but are any one of you who have debugger issues running RAC? We had issues with debugger with RAC and using a specific type of tnsnames ... Raj

I am running it on XP-Pro. Raj