Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

toad · Self Help List for TOAD Development Users
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Polls
  • Calendar
  • Promote

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 7641
  • Category: Oracle
  • Founded: Jul 22, 1998
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages
Message #
Search:
Advanced
 Messages Help
Messages
Topics
Hot Topics
Messages 46004 - 46033 of 58538   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Show Message Summaries Sort by Date ^  
#46004 From: Bert Scalzo <bert.scalzo@...>
Date: Sun Feb 1, 2009 12:12 pm
Subject: RE: New ERD 		bert.scalzo
Send Email Send Email
 
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 to database (we have to keep something in the Toad Data Modeler), but there's sufficient capability to make the old Toad ER Diagrammer seem worthless. The key benefits that people will notice immediately are that they can create models of any size without performance or printing issues. At least these are two of the chief complaints we've heard many times. And unlike Oracle SQL Developer's new data modeling offering - the Toad ER Diagrammer does not cost any extra money. Some people seem to think just that because the SQL Developer Data Modeler alpha/beta is free - it is not. It clearly says so on their web page. So give Toad's new ER Diagrammer a test drive in the upcoming beta - because I think you'll find it very useful; it's a major face lift at no cost to you :)
 
PS - the new Toad ER Diagrammer will be compatible with Toad Data Modeler, so for those needing those extra features - just buy the Toad DBA Bundle and you get Toad + DBA Module + Benchmark Factory + Spotlight + Toad Data Modeler all for one low price considering the amazing value offered :)

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Martin Gainty
Sent: Saturday, January 31, 2009 6:11 PM
To: TOAD Yahoogroup; toadbeta@yahoogroups.com
Subject: RE: [toad] New ERD

Good Evening Mark-

ERD is the first thing I look for any DB tool
Is there any ability to map ERD to DB schema?

Thanks,
Martin Gainty
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.




To: toad@yahoogroups.com; toadbeta@yahoogroups.com
From: Mark.Lerch@quest.com
Date: Sat, 31 Jan 2009 09:43:40 -0800
Subject: [toad] New ERD

Well I forgot to mention something significant: the ERD window is going to be completely replaced by a much more powerful one, courtesy the developers from the Toad DataModeler team. This will be released in our first public beta, so that is a "new feature" which isn't going to wait for Toad 10's first betas.

What occurred there was this: we looked at the years of constant complains about all of our "diagramming" windows (ERD, Code Roadmap, Query Builder), then looked at the product we now call Toad DataModeler and said, "well, that product is also in Delphi, why not take the diagramming experts and get them to move those windows into Toad. History has taught us to be highly cautious about splitting development efforts though, so we took a "safe" window - the ERD - and decided to use that as a test case.

We like what we see. We think you will too. There is no doubt that the most important thing will be present - your feedback.

Mark

________________________________________
From: toad@yahoogroups.com [toad@yahoogroups.com] On Behalf Of Mark Lerch [Mark.Lerch@quest.com]
Sent: Saturday, January 31, 2009 11:46 AM
To: toadbeta@yahoogroups.com
Cc: toad@yahoogroups.com
Subject: [toad] New week

We're targetting our first internal beta for Monday. Hopefully we won't have to go more than a couple of weeks before we can ask your help in looking at it.

The main thing you'll see different will be upgraded data grids. This first round of betas will be to test the conversion to Delphi 2009 and the upgrade of all our components. Round 2 will be to dig deeply into Unicode testing. Internally, we're treating this large body of changes as "Toad 9.8," and it will (mostly) exclude any new functionality. Once we have 9.8 signed off of internally, then we'll start new functionality for Toad 10, which will be the next official public release. That will be sometime in the 3rd quarter of this year. That's a long time between releases but it was necessary this time.

What say we head into next week without carrying over Friday's epic threads of food, animal rights, barefoot people, and the various other heavily opinionated topics which tend to, as Ed said, take a "oh no, left turn, off the cliff!"

Mark
------------------------------------

Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

http://docs.yahoo.com/info/terms/

Hotmail® goes where you go. On a PC, on the Web, on your phone. See how.


Reply | Messages in this Topic (3)
#46005 From: "Sam M. Koshy" <sam_m_koshy@...>
Date: Sun Feb 1, 2009 7:57 am
Subject: Insufficient Privs for running Explain Plan 		sam_m_koshy
Send Email Send Email
 
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 logging as the SYSTEM user.
But if I use the autotrace facility in sql prompt as the same user to perform the trace ; I can see the explain plans.

The explain (of TOAD) works fine if I connect to Oracle 9i databases though, but not for older databases. I recall a box did come up on my 9i DB's for the schema name and a plan table setting but not in these older DB's.

Please advice.


Reply | Messages in this Topic (5)
#46006 From: Meat Hook <meathook83@...>
Date: Sun Feb 1, 2009 10:45 am
Subject: Enhancement Request: row partition association 		meathook83
Send Email Send Email
 
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 it:

select subobject_name,a.* from my_table a,all_objects b where
DBMS_ROWID.ROWID_OBJECT(a.rowid) = b.data_object_id


Thanks,
Yoni


Reply | Messages in this Topic (1)
#46007 From: Norman Dunbar <toad@...>
Date: Sun Feb 1, 2009 1:46 pm
Subject: Re: Insufficient Privs for running Explain Plan 		normandunbar
Send Email Send Email
  
Afternoon Sam,

> 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 logging as the SYSTEM user.

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 itself, login as the SYS user. For 7, you'll need
to use svrmgrl rather than sqlplus and connect internal.

start ?/rdbms/admin/utlxplan

create public synonym plan_table for sys.plan_table;

grant all on plan_table to public;

(You can replace public with the names of the schemas you wish to allow
explain plan from by the way. With mine, it is always public.)

Now SYS owns a table called PLAN_TABLE, there is a synonym for all to
see with the same name and everyone has insert, update, select and
delete privs on the table.

You should be able to do explain plan's from everywhere.


The reason autotrace works, I think, is because the table is owned by
SYS plus the package doing the autotrace is also owned by SYS so the
autotrace code is able to read the sys owned PLAN_TABLE. But I might be
wrong because I'm almost certain that 7 and 8 only ran code in 'definer
rights' mode which means that SYSTEM running SYS's code would run as if
it was actually SYS that was running it.



Cheers,
Norm. [TeamT]

Reply | Messages in this Topic (5)
#46008 From: Martin Gainty <mgainty@...>
Date: Sun Feb 1, 2009 2:38 pm
Subject: RE: Insufficient Privs for running Explain Plan 		mgainty@...
Send Email Send Email
 
  • 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 plan_table to public
  • exit sqlplus and cd $oracle_home/sqlplus/admin
  • log into sqlplus as other_user
  • run SQL> @plustrce
  • run SQL> grant plustrace to public
    At this point you should have the plan table and the grants setup for any user

connect other_user/other_password
set autotrace on
select * from foo;

you should see Execution Plan for SELECT * FROM FOO

excerpted from http://asktom.oracle.com/tkyte/article1/autotrace.html

Martin 

______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.




To: toad@yahoogroups.com
From: sam_m_koshy@...
Date: Sat, 31 Jan 2009 23:57:40 -0800
Subject: [toad] Insufficient Privs for running Explain Plan

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 logging as the SYSTEM user.
But if I use the autotrace facility in sql prompt as the same user to perform the trace ; I can see the explain plans.

The explain (of TOAD) works fine if I connect to Oracle 9i databases though, but not for older databases. I recall a box did come up on my 9i DB's for the schema name and a plan table setting but not in these older DB's.

Please advice.



Windows Live™ Hotmail®:…more than just e-mail. Check it out.

Reply | Messages in this Topic (5)
#46009 From: Martin Gainty <mgainty@...>
Date: Sun Feb 1, 2009 2:42 pm
Subject: RE: Insufficient Privs for running Explain Plan 		mgainty@...
Send Email Send Email
 
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
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.




To: toad@yahoogroups.com
From: toad@...
Date: Sun, 1 Feb 2009 13:46:30 +0000
Subject: Re: [toad] Insufficient Privs for running Explain Plan

Afternoon Sam,

> 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 logging as the SYSTEM user.

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 itself, login as the SYS user. For 7, you'll need
to use svrmgrl rather than sqlplus and connect internal.

start ?/rdbms/admin/utlxplan

create public synonym plan_table for sys.plan_table;

grant all on plan_table to public;

(You can replace public with the names of the schemas you wish to allow
explain plan from by the way. With mine, it is always public.)

Now SYS owns a table called PLAN_TABLE, there is a synonym for all to
see with the same name and everyone has insert, update, select and
delete privs on the table.

You should be able to do explain plan's from everywhere.

The reason autotrace works, I think, is because the table is owned by
SYS plus the package doing the autotrace is also owned by SYS so the
autotrace code is able to read the sys owned PLAN_TABLE. But I might be
wrong because I'm almost certain that 7 and 8 only ran code in 'definer
rights' mode which means that SYSTEM running SYS's code would run as if
it was actually SYS that was running it.

Cheers,
Norm. [TeamT]


Windows Live™ Hotmail®:…more than just e-mail. Check it out.

Reply | Messages in this Topic (5)
#46010 From: "Richard Squires" <r_squires@...>
Date: Mon Feb 2, 2009 12:09 am
Subject: ER: Don't include PARTITION details for LOCAL partitioned INDEXes 		r_squires
Send Email Send Email
  
Could we have an option of not including the PARTITIONs when selecting
the Script tab for a LOCAL partitioned Index?

Thanks

Richard

Reply | Messages in this Topic (3)
#46011 From: Meat Hook <meathook83@...>
Date: Mon Feb 2, 2009 7:27 am
Subject: Re: ER: Don't include PARTITION details for LOCAL partitioned INDEXes 		meathook83
Send Email Send Email
 
Yes, it will be very useful.

From: Richard Squires <r_squires@...>
To: toad@yahoogroups.com
Sent: Monday, February 2, 2009 2:09:18 AM
Subject: [toad] ER: Don't include PARTITION details for LOCAL partitioned INDEXes

Could we have an option of not including the PARTITIONs when selecting
the Script tab for a LOCAL partitioned Index?

Thanks

Richard



Reply | Messages in this Topic (3)
#46012 From: "Sam M. Koshy" <sam_m_koshy@...>
Date: Mon Feb 2, 2009 9:27 am
Subject: Re: Insufficient Privs for running Explain Plan 		sam_m_koshy
Send Email Send Email
 
Fantastic .. Thanks Norm.
Thanks Martin.

--- On Sun, 2/1/09, Norman Dunbar <toad@...> wrote:
From: Norman Dunbar <toad@...>
Subject: Re: [toad] Insufficient Privs for running Explain Plan
To: toad@yahoogroups.com
Date: Sunday, February 1, 2009, 7:16 PM

Afternoon Sam,

> 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 logging as the SYSTEM user.

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 itself, login as the SYS user. For 7, you'll need
to use svrmgrl rather than sqlplus and connect internal.

start ?/rdbms/admin/ utlxplan

create public synonym plan_table for sys.plan_table;

grant all on plan_table to public;

(You can replace public with the names of the schemas you wish to allow
explain plan from by the way. With mine, it is always public.)

Now SYS owns a table called PLAN_TABLE, there is a synonym for all to
see with the same name and everyone has insert, update, select and
delete privs on the table.

You should be able to do explain plan's from everywhere.

The reason autotrace works, I think, is because the table is owned by
SYS plus the package doing the autotrace is also owned by SYS so the
autotrace code is able to read the sys owned PLAN_TABLE. But I might be
wrong because I'm almost certain that 7 and 8 only ran code in 'definer
rights' mode which means that SYSTEM running SYS's code would run as if
it was actually SYS that was running it.

Cheers,
Norm. [TeamT]



Reply | Messages in this Topic (5)
#46013 From: John Dorlon <john.dorlon@...>
Date: Mon Feb 2, 2009 1:55 pm
Subject: RE: Re: Bug with EXCEL instance export 		jdorlon3
Send Email Send Email
 

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 65,000 records per sheet if you’re on an old version. 

 

The XLS File option just does 65,000 records per sheet.  It does not support XLSX yet but it’s on my to do list.

 

If you try to export more records than are allowed on one sheet, we’ll just start on another sheet and continue there.

 

I haven’t tried to reproduce this problem yet, Paul, but I will.

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of pknowles9
Sent: Saturday, January 31, 2009 12:43 PM
To: toad@yahoogroups.com
Subject: [toad] Re: Bug with EXCEL instance export

 

If you export 300K or so records, it does export into a single 2007
spreadsheet. But when you get up to a higher number of records, it
returns this error.

Thanks. paul

--- In toad@yahoogroups.com, Jeff Smith <jeff.smith@...> wrote:
>
> Paul, I'm pretty sure that the current xls technology we're using
doesn't create xlsx files, so you're not going to get the 2007 benefit
on excel.
>
> Actually, the XLS file generation doesn't even communicate with
Office, it's done by itself.
>
> I wouldn't be surprised if Toad 10 brought support for the XLSX 2007
files and everything that goes with it, but watch for news on the Toad
Beta list to see for yourself.
> From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf
Of pknowles9
> Sent: Friday, January 30, 2009 5:21 PM
> To: toad@yahoogroups.com
> Subject: [toad] Bug with EXCEL instance export
>
>
> If you open EXCEL 2007 and export a large amount of data to an EXCEL
> instance (several hundred K records), you get "Call rejected by
> callee" every time and the spreadsheet appears with part of the data.
>
> Thanks. Paul
>


Reply | Messages in this Topic (10)
#46014 From: "Simoneau, Roger" <rsimonea@...>
Date: Mon Feb 2, 2009 5:14 pm
Subject: RE: Re: BBQ 		rsimonea@...
Send Email Send Email
  
>> ...have to take supplements of some kind or another...

Personally, I've always had issues with supplements.  To begin with they are
produced by the pharmaceutical industry which - in several cases - have shown a
very strong interest in choosing bottom line income over societal health.  It's
far more lucrative to treat any given disease then cure it.... not to mention
those medicines required to deal with the side-effects of that pill you've
taken...

>> ...my problem is cynicism (and spelling)...

I'll have to join that club!  For example, part of my cynicism with regards
supplements is raised from such questions as:

Fact: The human body easily utilizes natural Vitamin C, getting rid of any extra
that it doesn't require making it rather difficult to overdose on Vitamin C.

so....

Why can the human body so easily overdose on supplement Vitamin C?

If it can overdose so easily - thereby indicating the body must work much harder
to get rid of the excess - does the body also have to work much harder at
actually utilizing it as well?

An interesting question which I have been unable to find non-pharmaceutical data
to answer.

Lately, I've had to fight off a rather nasty flu.  I spent a couple days at home
away from work (worst flu I've had in over 10 years).  It didn't leave me
feeling exhausted though so I didn't feel like sleeping.  I spent the time
researching the vitamin and mineral requirements as outlined by the RDA
(recommended dietary allowances) list.  I pulled information from numerous
sources such as http://ods.od.nih.gov/factsheets/vitamina.asp.  The purpose was
to generate a list of foods which were naturally high in a vitamin or mineral.

In my research I ran into a few interesting articles such as this one:
http://www.nlm.nih.gov/medlineplus/news/fullstory_73321.html

The most interesting article I ran into was a study which had been done which
apparently found that people can only utilize a max of 20% of the vitamins and
minerals in supplements.  Of course, that's based on memory, I'll have to see if
I can find that report again.

Another interesting item I noticed was that there was actually an instance of a
mineral - I think - which had an RDA minimum identified but the maximum was
explicitly identified only for supplement sources.  I'll have to see if I can't
find that one too!  It was also quite amusing that the RDA minimum requirement
for that mineral was - if memory serves correct - 430 micrograms but the maximum
intake recommended from supplement sources was 350 micrograms.

RAS

PLEASE NOTE:
This communication, including any attached documentation,
is intended only for the person or entity to which it is addressed,
and may contain confidential, personal and/or privileged information.
Any unauthorized disclosure, copying, or taking action on the contents
is strictly prohibited. If you have received this message in error,
please contact us immediately so we may correct our records.
Please then delete or destroy the original transmission and any subsequent
reply.
Thank you.

Reply | Messages in this Topic (78)
#46015 From: Trina MacDonald <trinamf@...>
Date: Mon Feb 2, 2009 5:17 pm
Subject: New TOAD book: Request for proposal review 		trinamac7
Send Email Send Email
 
Hello TOAD group members,

My name is Trina MacDonald and I'm the editor responsible for revising Addison-Wesley's Developers Library TOAD Handbook, by Dr. Bert Scalzo and Dan Hotka.

The authors have submitted a proposal for the book and I am in need of three to four book proposal reviewers. If you are interested, you would review the proposal and chapter outline and complete a questionnaire. In return for fully completing the proposal questionnaire by the requested deadline, you will receive a $50 honorarium fee plus a free copy of the book if it approves, when it becomes available.

Interested parties should email me at trina.macdonald@.... I will respond to the first four interested parties; if you do not receive a response that means I have found four proposal reviewers. Please note that due to time constraints I will only respond to queries made to the email address noted above and not to this thread.

Thanks very much!

******

Trina MacDonald

Acquisitions Editor

Prentice Hall Professional http://www.phptr.com

Addison-Wesley Professional http://www.awprofessional.com

SAMS Publishing http://www.samspublishing.com



Reply | Messages in this Topic (2)
#46016 From: "Trina MacDonald" <trinamf@...>
Date: Mon Feb 2, 2009 5:43 pm
Subject: THANK YOU: New TOAD book: Request for proposal review 		trinamac7
Send Email Send Email
  
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 have already contacted me that did not
receive a reply, and then I will post another message to this thread.

Thanks again! It's good to know TOAD has such a vibrant online community!

Trina

--- In toad@yahoogroups.com, Trina MacDonald <trinamf@...> wrote:
>
> Hello TOAD group members,
>
> My name is Trina MacDonald and I'm the editor responsible for revising
> Addison-Wesley's Developers Library TOAD
>
Handbook<http://www.amazon.com/TOAD-Handbook-Developers-Library-Scalzo/dp/067232\
4865/ref=sr_1_2?ie=UTF8&s=books&qid=1233594713&sr=1-2>,
> by Dr. Bert Scalzo and Dan Hotka.
>
> The authors have submitted a proposal for the book and I am in need
of three
> to four book proposal reviewers. If you are interested, you would
review the
> proposal and chapter outline and complete a questionnaire. In return
for *fully
> completing* the proposal questionnaire by the requested deadline,
you will
> receive a $50 honorarium fee plus a free copy of the book if it
approves,
> when it becomes available.
>
> Interested parties should email me at trina.macdonald@... I will
> respond to the first four interested parties; if you do not receive a
> response that means I have found four proposal reviewers. Please
note that
> due to time constraints I will only respond to queries made to the email
> address noted above and not to this thread.
>
> Thanks very much!
>
> ******
>
> Trina MacDonald
>
> Acquisitions Editor
>
> Prentice Hall Professional http://www.phptr.com
>
> Addison-Wesley Professional http://www.awprofessional.com
>
> SAMS Publishing http://www.samspublishing.com
>

Reply | Messages in this Topic (2)
#46017 From: John Dorlon <john.dorlon@...>
Date: Mon Feb 2, 2009 10:08 pm
Subject: RE: Bug with EXCEL instance export 		jdorlon3
Send Email Send Email
 

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 related.  Can you send me an export (dmp file) of your table? If not, how about just the DDL?   Send it offline if you want.

 

-John

 

 

 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of pknowles9
Sent: Friday, January 30, 2009 4:20 PM
To: toad@yahoogroups.com
Subject: [toad] Bug with EXCEL instance export

 

If you open EXCEL 2007 and export a large amount of data to an EXCEL
instance (several hundred K records), you get "Call rejected by
callee" every time and the spreadsheet appears with part of the data.

Thanks. Paul


Reply | Messages in this Topic (10)
#46018 From: Angelo Anolin <angelo_anolin@...>
Date: Tue Feb 3, 2009 3:22 am
Subject: Import DAT File Using TOAD 		angelo_anolin
Send Email Send Email
 
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 full TOAD version, how do I do it?
 
I tried to load the dat file using Database | Import | Source Files and was able to select the file by clicking on Add button.
 
What should be the next steps afterwards? 
 
Thanks in advance.
 
Regards,
Angelo


Reply | Messages in this Topic (10)
#46019 From: Peter van Rijn <petervanrijn@...>
Date: Tue Feb 3, 2009 12:44 pm
Subject: Re: Import DAT File Using TOAD 		pgmvanrijn
Send Email Send Email
  
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 some other character.
Have the fields perhaps a fixed length? TOAD can do a lot, but you'll
have to tell it what to do.

regards,
Peter

BTW My mail reader thinks it is easier if you start your own
subjects/threads in stead of 'hijacking' somebody elses.


Angelo Anolin schreef:
>
>
> 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 full TOAD version, how do I do it?
>
> I tried to load the dat file using Database | Import | Source Files and
> was able to select the file by clicking on Add button.
>
> What should be the next steps afterwards?
>
> Thanks in advance.
>
> Regards,
> Angelo

Reply | Messages in this Topic (10)
#46020 From: Martin Gainty <mgainty@...>
Date: Tue Feb 3, 2009 2:36 pm
Subject: Oracle's DBMS_ALERT 		mgainty@...
Send Email Send Email
 
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
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.



Hotmail® goes where you go. On a PC, on the Web, on your phone. See how.

Reply | Messages in this Topic (7)
#46021 From: Wim de Lange <wimdelange@...>
Date: Tue Feb 3, 2009 3:14 pm
Subject: SQL Profiles 		wimdelange
Send Email Send Email
 
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, more or less, with 
SELECT * FROM DBA_SQL_PROFILES.

Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I couldn't find it.

--
Groetjes,
  Wim

Reply | Messages in this Topic (10)
#46022 From: Norman Dunbar <toad@...>
Date: Tue Feb 3, 2009 3:21 pm
Subject: Re: SQL Profiles 		normandunbar
Send Email Send Email
  
Afternoon Wim,

> 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, more or less, with
>
> SELECT * FROM DBA_SQL_PROFILES.
>
> Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I
> couldn't find it.

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
show the profiles tab/tree/etc.


Cheers,
Norm. [TeamT]

Reply | Messages in this Topic (10)
#46023 From: Jeff Smith <jeff.smith@...>
Date: Tue Feb 3, 2009 3:22 pm
Subject: RE: SQL Profiles 		toaddev
Send Email Send Email
 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Tuesday, February 03, 2009 10:21 AM
To: toad@yahoogroups.com
Subject: Re: [toad] SQL Profiles

 

Afternoon Wim,

> 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, more or less, with
>
> SELECT * FROM DBA_SQL_PROFILES.
>
> Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I
> couldn't find it.

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
show the profiles tab/tree/etc.

Cheers,
Norm. [TeamT]


Reply | Messages in this Topic (10)
#46024 From: Bert Scalzo <bert.scalzo@...>
Date: Tue Feb 3, 2009 3:24 pm
Subject: RE: SQL Profiles 		bert.scalzo
Send Email Send Email
 
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 ....

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Tuesday, February 03, 2009 9:21 AM
To: toad@yahoogroups.com
Subject: Re: [toad] SQL Profiles

Afternoon Wim,

> 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, more or less, with
>
> SELECT * FROM DBA_SQL_PROFILES.
>
> Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I
> couldn't find it.

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
show the profiles tab/tree/etc.

Cheers,
Norm. [TeamT]


Reply | Messages in this Topic (10)
#46025 From: Norman Dunbar <toad@...>
Date: Tue Feb 3, 2009 3:25 pm
Subject: Re: Oracle's DBMS_ALERT 		normandunbar
Send Email Send Email
  
Hi Martin,

> Anyone know where I can find a working example of Oracle's DBMS_ALERT ???
http://www.psoug.org/reference/dbms_alert.html
http://it.toolbox.com/blogs/oracle-guide/dbms_pipe-dbms_alert-in-enterprisedb-24\
316


> I hope everyone is having fun with all the snow we've been getting..
No, actually, I'm not. I'm at home today sick. Keeps me out of the snow! :-)

Cheers,
Norm. [TeamT]

Reply | Messages in this Topic (7)
#46026 From: Bert Scalzo <bert.scalzo@...>
Date: Tue Feb 3, 2009 3:27 pm
Subject: RE: SQL Profiles 		bert.scalzo
Send Email Send Email
 
Remember - CREATE PROFILE command (what Toad Schema Browser can show) has to do with resource limits - e.g. # connections, CPU usage, timeouts, etc
 
SQL Profiles is part of the history described below:
 

Over the years (and major database versions), Oracle has tried to make SQL optimization more stable and reliable than simple explain plans. An excerpt from the book Oracle 11g New Features cleanly delineates this progression nicely – which has been as follows:

 

 

So we must accept and embrace this performance optimization technique progression.

 

 

I'll write a toad world blog on this shortly ....

 

 


From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert Scalzo
Sent: Tuesday, February 03, 2009 9:24 AM
To: toad@yahoogroups.com
Subject: RE: [toad] SQL Profiles

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 ....

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Tuesday, February 03, 2009 9:21 AM
To: toad@yahoogroups.com
Subject: Re: [toad] SQL Profiles

Afternoon Wim,

> 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, more or less, with
>
> SELECT * FROM DBA_SQL_PROFILES.
>
> Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I
> couldn't find it.

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
show the profiles tab/tree/etc.

Cheers,
Norm. [TeamT]


Reply | Messages in this Topic (10)
#46027 From: Jeff Smith <jeff.smith@...>
Date: Tue Feb 3, 2009 3:29 pm
Subject: RE: SQL Profiles 		toaddev
Send Email Send Email
 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert Scalzo
Sent: Tuesday, February 03, 2009 10:27 AM
To: toad@yahoogroups.com
Subject: RE: [toad] SQL Profiles

 

Remember - CREATE PROFILE command (what Toad Schema Browser can show) has to do with resource limits - e.g. # connections, CPU usage, timeouts, etc

 

SQL Profiles is part of the history described below:

 

Over the years (and major database versions), Oracle has tried to make SQL optimization more stable and reliable than simple explain plans. An excerpt from the book Oracle 11g New Features cleanly delineates this progression nicely – which has been as follows:

 

 

So we must accept and embrace this performance optimization technique progression.

 

 

I'll write a toad world blog on this shortly ....

 

 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert Scalzo
Sent: Tuesday, February 03, 2009 9:24 AM
To: toad@yahoogroups.com
Subject: RE: [toad] SQL Profiles

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 ....

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Tuesday, February 03, 2009 9:21 AM
To: toad@yahoogroups.com
Subject: Re: [toad] SQL Profiles

Afternoon Wim,

> 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, more or less, with
>
> SELECT * FROM DBA_SQL_PROFILES.
>
> Has Toad 9.6 (or 9.8 the beta) more information on these sql profiles? I
> couldn't find it.

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
show the profiles tab/tree/etc.

Cheers,
Norm. [TeamT]


Reply | Messages in this Topic (10)
#46028 From: Norman Dunbar <toad@...>
Date: Tue Feb 3, 2009 3:32 pm
Subject: Re: SQL Profiles 		normandunbar
Send Email Send Email
  
Afternoon Bert,

> 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 ....
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.

Apologies to Wim.


Cheers,
Norm. [TeamT]

Reply | Messages in this Topic (10)
#46029 From: "SHIVANAND BHARTI" <SBharti@...>
Date: Tue Feb 3, 2009 4:26 pm
Subject: F4 not working 		shiva_de_novo
Send Email Send Email
 
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.
But this F4 feature is not working for one of my collegue.He get's a blank screen !!!
 
I think this is again a TOAD setting.
Could you please let me know which is that setting .
 
Thanks in Advance.
 
Regards,
Shiva.

************************************************************ NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you.


Reply | Messages in this Topic (22)
#46030 From: Martin Gainty <mgainty@...>
Date: Tue Feb 3, 2009 4:05 pm
Subject: RE: Oracle's DBMS_ALERT 		mgainty@...
Send Email Send Email
 
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 respond..
wondering if Oracle has a diags tool to determine whats going on?

Thanks
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.




To: toad@yahoogroups.com
From: toad@...
Date: Tue, 3 Feb 2009 15:25:19 +0000
Subject: Re: [toad] Oracle's DBMS_ALERT

Hi Martin,

> Anyone know where I can find a working example of Oracle's DBMS_ALERT ???
http://www.psoug.org/reference/dbms_alert.html
http://it.toolbox.com/blogs/oracle-guide/dbms_pipe-dbms_alert-in-enterprisedb-24316

> I hope everyone is having fun with all the snow we've been getting..
No, actually, I'm not. I'm at home today sick. Keeps me out of the snow! :-)

Cheers,
Norm. [TeamT]


Hotmail® goes where you go. On a PC, on the Web, on your phone. See how.

Reply | Messages in this Topic (7)
#46031 From: "McAllister, Michael AU CTR Contractor AETC AETC/A3IS" <Michael.McAllister.ctr.AU@...>
Date: Tue Feb 3, 2009 4:39 pm
Subject: RE: F4 not working 		Michael.McAllister.ctr.AU@...
Send Email Send Email
  
View -> Options -> Toolbars/Menus -> Shortcuts. Look and see what the
shortcut is defined for Edit -> Describe.

Regards,

Mike McAllister
Principal Systems Engineer
TKC Global, LLC
Phone: 210 652 9229
Cell: 512 423 7447
Email: michael@...


-----Original Message-----
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of
SHIVANAND BHARTI
Sent: Tuesday, February 03, 2009 10:27 AM
To: toad@yahoogroups.com
Subject: [toad] F4 not working

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.
But this F4 feature is not working for one of my collegue.He get's a
blank screen !!!

I think this is again a TOAD setting.
Could you please let me know which is that setting .

Thanks in Advance.

Regards,
Shiva.

________________________________

************************************************************ NOTE: This
e-mail message contains PRIVILEGED and CONFIDENTIAL information and is
intended only for the use of the specific individual or individuals to
which it is addressed. If you are not an intended recipient of this
e-mail, you are hereby notified that any unauthorized use, dissemination
or copying of this e-mail or the information contained herein or
attached hereto is strictly prohibited. If you receive this e-mail in
error, notify the person named above by reply e-mail and please delete
it. Thank you.

Reply | Messages in this Topic (22)
#46032 From: John Dorlon <john.dorlon@...>
Date: Tue Feb 3, 2009 4:43 pm
Subject: RE: F4 not working 		jdorlon3
Send Email Send Email
 

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  (this will give spec and body in the tree)

 

 

 

 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of SHIVANAND BHARTI
Sent: Tuesday, February 03, 2009 10:27 AM
To: toad@yahoogroups.com
Subject: [toad] F4 not working

 

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.

But this F4 feature is not working for one of my collegue.He get's a blank screen !!!

 

I think this is again a TOAD setting.

Could you please let me know which is that setting .

 

Thanks in Advance.

 

Regards,

Shiva.

************************************************************ NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you.


Reply | Messages in this Topic (22)
#46033 From: "Simoneau, Roger" <rsimonea@...>
Date: Tue Feb 3, 2009 4:45 pm
Subject: RE: Import DAT File Using TOAD 		rsimonea@...
Send Email Send Email
  
>> A dat-file can be anything.
>> ...
>> Is it comma-separated, or are fields separated
>> by some other character.  Have the fields
>> perhaps a fixed length?

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 format.

Possibilities of how to use Toad:
a) With SQL Loader installed in your Oracle client, Toad can use it.  However, I
don't know if Toad Freeware has that option or if SQL Loader was installed with
the client (our tech group tends to not install it - silly buggers)

b) Depending on your version of the Oracle database, perhaps you can attach the
file as an external table.

c) I think Toad might be able to import data from various formats, such as
Excel, into a table, however I've never played with this functionality so I
don't know how it's done or if the freeware version has the capability - or even
if the Freeware has the capability what the limitations of it are.  I do recall
others discussing such a topic on the list however so it shouldn't be too hard
to search the archives and get some idea.

Personally, I'm simply inclined to use sqlloader myself.

Roger S.

PLEASE NOTE:
This communication, including any attached documentation,
is intended only for the person or entity to which it is addressed,
and may contain confidential, personal and/or privileged information.
Any unauthorized disclosure, copying, or taking action on the contents
is strictly prohibited. If you have received this message in error,
please contact us immediately so we may correct our records.
Please then delete or destroy the original transmission and any subsequent
reply.
Thank you.

Reply | Messages in this Topic (10)
Messages 46004 - 46033 of 58538   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?
Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help