Toad World® Forums

New user


#1

hello I’m a new user in Toad world and i want someone to help me how to get started I have a database already made on the ORACLE server and i don’t know how to connect it to toad or even start an new database using Toad if that is possible
thank you


#2

Rania,

I’ve always felt that learning how to use Toad goes hand in hand in your
knowledge of Oracle. As you become more and more knowledgeable about
Oracle, using Toad becomes much more intuitive.

With that said. In order to connect to a database you will need an
Oracle Client installed on your PC and configure SQL*Net with your
database info.
http://www.oracle.com/technology/software/products/database/index.html

Once you have that done fire up Toad. It should detect your Oracle
Client. I’m guessing that you only have one Oracle Client installed so
under Installed Clients you should see oracle home you just installed.

If your SQL*Net client is configured correctly you should see your
database alias under the database drop down. Select that and enter your
username and password.

At this point it sounds like you already have a database created so I’m
not sure you want to create another one. Creating an Oracle database is
not a trivial thing. Certainly nothing like creating an access
database. In any case Toad can not create new databases. At most from
Toad you can create a Database script from an existing database if you
have a DB admin module license. Databases are generally created from a
script created by a DBA or through the DBCA Oracle utility.

Let us know if you have any more Toad questions.

Ed
[TeamT]

On 6/29/2010 4:08 AM, Rania wrote:

hello I’m a new user in Toad world and i want someone to help me how to get started I have a database already made on the ORACLE server and i don’t know how to connect it to toad or even start an new database using Toad if that is possible
thank you


#3

[ Attachment(s) from Melanie Nikdel included below]

Hi Rania,

I’m working on a New User guide for Toad, but it won’t be finished
until our next release. I have attached the chapter on creating and managing
Toad connections. It is still a work in progress, but I hope it will help you.
You can also press F1 from any window in Toad to get context-sensitive
documentation.

Regards,

Melanie


#4

Here are some toad world blogs on the topic:

http://www.toadworld.com/BLOGS/tabid/67/EntryID/460/Default.aspx

http://www.toadworld.com/BLOGS/tabid/67/EntryID/488/Default.aspx


#5

Ed,

I think you are spot on with regard to the relationship between the Oracle and
TOAD learning curves. I suspect that a great number of users, like me, were
thrown into Oracle via TOAD with virtually no experience with either.
Unquestionably, this makes it difficult for a new user to determine if their
question is related to TOAD or to Oracle - given that the user is unfamiliar
with BOTH products. I started with a self made data dictionary for Oracle
terminology pilfered from several Internet sites. That way, when I read about
how TOAD accomplished an Oracle task, I could back track to see if that was what
Oracle operation I was actually seeking to perform. I know it is backwards
learning but then again, we live in the real world where things are frequently
out of sequence!

Looking below, I am wondering if the user might be looking to create a new table
and not a new database? I know it isn’t TOAD’s responsibility to
teach Oracle, but given that there are (who knows how many???) users who are
using TOAD with a “learn as you go” approach in the meshed
“TOAD/Oracle” environment, perhaps a little basic Oracle
introduction could be considered appropriate in the new user’s guide for
TOAD?

Darlene

Darlene R. Ulmet

Financial Analyst II

Revenue Cycle

Strategic Financial Planning and Analysis

Baylor Health Care System

Phone: (214) 820-1936

Fax: (214)820-8515

Email: Darlene.Ulmet@BaylorHealth.edu


#6

Hi Darlene,

You have struck upon something I constantly debate when writing doc – how
much “Oracle knowledge” should we cover in the documentation? In
general, I try to avoid covering things that are covered in depth by Oracle,
because Oracle does a much better job than I ever could. Their information will
always be the most up-to-date and comprehensive.

I’ll keep pondering this, but maybe in the short term I could link some
free, public resources that are helpful for learning Oracle in the new user
guide. Any suggestions?

Thanks,

Melanie


#7

I think there should be a disclaimer on any Toad document which says “1)
you MUST be able to think and 2) you MUST know Oracle”


#8

I think that’s why you need a username and password to get into the
database J


#9

If I were to make any suggestions for a “dummies guide” to
TOAD/Oracle, I would try and cover what things a “very lower end”
user might need to accomplish. I am a little more advanced now (Thanks to the
great TOAD staff and all of the awesome non-TOAD volunteer Toadies out there)
but at first connect, all I really needed to do was to connect (duh), import,
and then select my data. I recall I was a little confused about the Query
Builder vs. Editor and I got lost several times switching back and forth. I had
swiped some sql out of access and was looking to move the queries and the
existing data to oracle as we were out of access limited space. I didn’t
know where to go and it was a very big POND! When I say low end tasks, I am
thinking along the line of:

Import from Excel

Import from Access

Create a Query

Run Query

Export to Excel

Export to Access

Since those days (was it only last year??? WOW), I have learnt a ton. I am now
at the point where I can ask a single direct question using somewhat correct
terminology. But at the beginning…it was rough. Maybe something along the
line of a little tutorial for a basic run through of the above type scenario?
Say, create a mail list table, import data from excel, create and run a query
(all one zip code), export the results. That type tutorial would give a lower
end user a “from the ground up” viewpoint. I distinctly recall that
in all of the examples I was looking to follow, everything was already created
and in place. Don’t know if this helps, but there it is. New user, hang in
there! It gets easier with time!

D

Darlene R. Ulmet

Financial Analyst II

Revenue Cycle

Strategic Financial Planning and Analysis

Baylor Health Care System

Phone: (214) 820-1936

Fax: (214)820-8515

Email: Darlene.Ulmet@BaylorHealth.edu


#10

But then what would the four dozen users left do…talk like pirates to each
other on Monday through Friday? I don’t have any stats but I would love to
know what the skill level is of the “average” toad user? Some of you
would miss me and others like me and I know that Quest would miss the sales!
Aye, aye?

Darlene R. Ulmet

Financial Analyst II

Revenue Cycle

Strategic Financial Planning and Analysis

Baylor Health Care System

Phone: (214) 820-1936

Fax: (214)820-8515

Email: Darlene.Ulmet@BaylorHealth.edu


#11

Anything that Toad does that is non-standard, that is, you won’t find it in the
standard documentation sets, should, I think, be documented.

Some examples…

Toad uses dbms_ijob for the schema browser Jobs tab instead of the documented
dbms_job

The session browser allows you to use dbms_system to turn on tracing, which
isn’t documented in the “official” docs,
so, even though it’s well documented in metalink and other sites. I think it
should be covered in toad’s docs.
Also, I suggest dbms_system tab should be disabled if the user has access to the
officially documented and supported tracing packages.

Toad’s versions of the pl/sql profiler tables are different than the standard
files. So, if you have followed the Oracle instructions to use dbms_profiler
and try to use Toad to profile it won’t work. This is especially tricky since
Toad’s versions are “nearly” identical to the standard versions, so it’s not
obvious why there is an error.

There are probably others but those are three I encounter and have to explain to
others most often.

Erwin Rollauer
Sent by: toad@yahoogroups.com

2010/06/29 15:49

Please respond to
toad@yahoogroups.com

To

"toad@yahoogroups.com"

cc

Subject

RE: [toad] New user

I think there should be a disclaimer on any Toad document which says “1)
you MUST be able to think and 2) you MUST know Oracle”
att1.dat (43 Bytes)


#12

That perfectly describes me and three of my colleagues. We were experts in
Informix. No GUI tools at the time, at least none that we knew of†. We are
truly grateful to have learned what little we know of Oracle so far with Toad
shielding us from SQL*Plus.

The more we learn of Toad, the more we learn of Oracle, and vice versa. J

† Toad for Data Analysts now talks to Informix databases using ODBC
connections.

Thanks much, Quest.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#13

P.S. I’m also very thankful for the many professors on this listserv.

dbm

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#14

Morning Melanie,

… I have attached the chapter
on creating and managing Toad connections. It is still a
work in progress, but I hope it will help you.

I had a look! If the rest of your manual is as good as that chapter, you
have a winner on your hands!

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#15

Thank you, Norm! The first release of the guide may be a little hit-or-miss due
to time restrictions, but I’ll keep improving it for future releases.