# New user **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 29, 2010, 3:08am UTC](https://forums.toadworld.com/t/new-user/9645 "2010-06-29T03:08:17Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 29, 2010, 3:08am UTC](https://forums.toadworld.com/t/new-user/9645/1 "2010-06-29T03:08:17Z")
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 ---
**Author:** ![eklinger](https://avatars.discourse-cdn.com/v4/letter/e/bbe5ce/32.png) [@eklinger](https://forums.toadworld.com/u/eklinger)\ **Post date:** [June 29, 2010, 8:45am UTC](https://forums.toadworld.com/t/new-user/9645/2 "2010-06-29T08:45:54Z")
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. > **[Database Software Downloads | Oracle](https://www.oracle.com/database/technologies/oracle-database-software-downloads.html)** > > Download the latest Database Software 19c or all previous versions 18c, 12c and 11g for Windows, Linux Oracle Solaris, IBM AIX, HP-UX and more. 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 ---
**Author:** ![melanienikdel](https://avatars.discourse-cdn.com/v4/letter/m/9dc877/32.png) [@melanienikdel](https://forums.toadworld.com/u/melanienikdel)\ **Post date:** [June 29, 2010, 10:22am UTC](https://forums.toadworld.com/t/new-user/9645/3 "2010-06-29T10:22:51Z")
[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 ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [June 29, 2010, 11:42am UTC](https://forums.toadworld.com/t/new-user/9645/4 "2010-06-29T11:42:57Z")
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/460/Default.aspx) [http://www.toadworld.com/BLOGS/tabid/67/EntryID/488/Default.aspx](http://www.toadworld.com/BLOGS/tabid/67/EntryID/488/Default.aspx) ---
**Author:** ![Darlene.Ulmet](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@Darlene.Ulmet](https://forums.toadworld.com/u/Darlene.Ulmet)\ **Post date:** [June 29, 2010, 2:04pm UTC](https://forums.toadworld.com/t/new-user/9645/5 "2010-06-29T14:04:15Z")
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 ---
**Author:** ![melanienikdel](https://avatars.discourse-cdn.com/v4/letter/m/9dc877/32.png) [@melanienikdel](https://forums.toadworld.com/u/melanienikdel)\ **Post date:** [June 29, 2010, 2:29pm UTC](https://forums.toadworld.com/t/new-user/9645/6 "2010-06-29T14:29:18Z")
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 ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [June 29, 2010, 2:49pm UTC](https://forums.toadworld.com/t/new-user/9645/7 "2010-06-29T14:49:49Z")
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” ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [June 29, 2010, 2:52pm UTC](https://forums.toadworld.com/t/new-user/9645/8 "2010-06-29T14:52:12Z")
I think that’s why you need a username and password to get into the database J ---
**Author:** ![Darlene.Ulmet](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@Darlene.Ulmet](https://forums.toadworld.com/u/Darlene.Ulmet)\ **Post date:** [June 29, 2010, 2:52pm UTC](https://forums.toadworld.com/t/new-user/9645/9 "2010-06-29T14:52:57Z")
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 ---
**Author:** ![Darlene.Ulmet](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@Darlene.Ulmet](https://forums.toadworld.com/u/Darlene.Ulmet)\ **Post date:** [June 29, 2010, 2:57pm UTC](https://forums.toadworld.com/t/new-user/9645/10 "2010-06-29T14:57:01Z")
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 ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 29, 2010, 3:02pm UTC](https://forums.toadworld.com/t/new-user/9645/11 "2010-06-29T15:02:36Z")
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](mailto:toad@yahoogroups.com) 2010/06/29 15:49 Please respond to [toad@yahoogroups.com](mailto: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](https://global.discourse-cdn.com/quest/original/1X/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.dat) (43 Bytes) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 29, 2010, 4:13pm UTC](https://forums.toadworld.com/t/new-user/9645/12 "2010-06-29T16:13:06Z")
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](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 29, 2010, 4:38pm UTC](https://forums.toadworld.com/t/new-user/9645/13 "2010-06-29T16:38:49Z")
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](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 30, 2010, 2:19am UTC](https://forums.toadworld.com/t/new-user/9645/14 "2010-06-30T02:19:01Z")
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](http://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](http://www.environment-agency.gov.uk) ---
**Author:** ![melanienikdel](https://avatars.discourse-cdn.com/v4/letter/m/9dc877/32.png) [@melanienikdel](https://forums.toadworld.com/u/melanienikdel)\ **Post date:** [June 30, 2010, 11:50am UTC](https://forums.toadworld.com/t/new-user/9645/15 "2010-06-30T11:50:39Z")
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.