Basically the new Toad ER Diagrammer is a major subset of the Toad Data Modeler's physical database offering. You won't get things like compare and sync model...
Hi, I am trying to get the Explain Plan for a statement running Ora 8 or Ora 7 (from the Session Browser) ; but ran into Ora-01039 Insufficient privileges...
Can you please add to the data grid an option to see a "partition/subpartition column" to see where is the row physically located? Here's the SQL for querying...
Afternoon Sam, ... I suspect you don't have any privileges to the SYS.PLAN_TABLE as the SYSTEM user. What I normally do is this : on the database server...
cd $oracle_home/rdbms/admin log into sqlplus as system run SQL> @utlxplan run SQL> create public synonym plan_table for plan_table run SQL> grant all on...
Martin Gainty
mgainty@...
Feb 1, 2009 3:24 pm
46009
My apologies as I thought EVERYONE was watching the SuperBowl this afternoon As for me ..I'll be viewing Fawlty Towers.. cheers from the other side of the pond...
Martin Gainty
mgainty@...
Feb 1, 2009 3:24 pm
46010
Could we have an option of not including the PARTITIONs when selecting the Script tab for a LOCAL partitioned Index? Thanks Richard...
Yes, it will be very useful. ________________________________ From: Richard Squires <r_squires@...> To: toad@yahoogroups.com Sent: Monday, February 2,...
If you're exporting to the XLS Instance option, we detect the excel version and export up to a million records per sheet if you're on the new version, or...
... Personally, I've always had issues with supplements. To begin with they are produced by the pharmaceutical industry which - in several cases - have shown...
Simoneau, Roger
rsimonea@...
Feb 2, 2009 5:14 pm
46015
Hello TOAD group members, My name is Trina MacDonald and I'm the editor responsible for revising Addison-Wesley's Developers Library TOAD ...
Thanks to all of you, I have now received enough reviewers for the book. Should I be in need of additional reviewers, I will first contact those of you that...
Hi Paul, I just exported 1.1 million rows using the Excel instance option (select obj#, line from sys.source$) and didn't have any error. Perhaps this is data...
Hi everyone. I have been given a file named data.DAT.  How do I import the data.dat file into a table in my current schema using TOAD Freeware? If using...
A dat-file can be anything. First of all you'll have to find if there is a comprehensible structure in it. Is it comma-separated, or are fields separated by...
Anyone know where I can find a working example of Oracle's DBMS_ALERT ??? I hope everyone is having fun with all the snow we've been getting.. Cheers/ Martin ...
Martin Gainty
mgainty@...
Feb 3, 2009 2:42 pm
46021
While going through the options of the Enterprise manager in Oracle 10.2.0.1 I found something called a "SQL Profile". I've created one and can inspect it,...
Afternoon Wim, ... Should be available on the Schema Browser LHS - you might need to have the DBA module installed AND you might need to configure your LHS to ...
Not the same thing. Profiles are different from SQl Profiles - which has to do with explain plan stability. More to come on this topic in a future blog .... ...
Remember - CREATE PROFILE command (what Toad Schema Browser can show) has to do with resource limits - e.g. # connections, CPU usage, timeouts, etc SQL...
Afternoon Bert, ... Oh blast! My only excuse is that I'm not in the office today, I'm at home, unwell. I got my profiles mixed up. Thanks for correcting me. ...
Hi All, In my Toad Editor if I write a procedure/package/function name , point my cursor to it and press F4 it opens a window which has the artifact's code. ...
Thanks Norm Im running the ./rdbms/admin/dbmsalrt.sql to create the package which has been running for about 15 min..I'm Wondering when Mission Control will...
Martin Gainty
mgainty@...
Feb 3, 2009 4:42 pm
46031
View -> Options -> Toolbars/Menus -> Shortcuts. Look and see what the shortcut is defined for Edit -> Describe. Regards, Mike McAllister Principal Systems...
McAllister, Michael A...
Michael.McAllister.ct...
Feb 3, 2009 4:43 pm
46032
Sounds like your colleague might have access to the package spec but not body. Try checking: Options -> Windows -> Show spec and body in package describes...
... Not to mention ensuring the file is in text format... If the recipient of the file has never looked in it, there is the possibility it's saved in binary...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
