January 29, 2008 at 1:37 am
Hello, guys how are you doing?
I am familiar with SQL server 2000 database. and I am interested to learn this Oracle DB staff. do you think it is easy to learn? what is the deference between SQL and Oracle database?
Please guys i need your help and I want to know about this Oracle DB staff.
thank you very much
January 29, 2008 at 9:11 am
This link might help you start...
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
don't know too much about Oracle training material though sorry. I'm sure there's a similar range of books out there that SQL Server has.
Gethyn Elliswww.gethynellis.com
January 29, 2008 at 10:50 am
Personall, I'd start here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 30, 2008 at 12:52 am
Thank you very much guys
appreciated
January 30, 2008 at 1:59 am
Do a search for and downloads a product (there's a free version) called TOAD for Oracle. It makes Oracle a LOT easier to use and more familiar for us MS SQL folk. We've got a client where we need to read stuff from the Oracle tables. Whilst the concepts are the same, the tools aren't as nice (Java GUI controls just miss a lot of nice stuff) and things are just, well, different.... 😀
January 30, 2008 at 3:27 am
Take a look at the Oracle site. Sign up for their free magazine, it contains a lot of useful info similar to SQL Server Magazine. Look for Oracle newsgroups, and start looking at the questions and answers. Expect most things in Oracle to be much the same as SQL Server, but also be prepared for different ways of doing familiar tasks, and for a few significant differences. Download a trial copy of Oracle for Windows (or *nix if you run that) and play with it.
Eventually you will know quite a bit about Oracle, but you will have to use a lot of your time to do so. You just need to decide how much time you are prepared to spend, and hence how much you will eventually know. If you want to know Oracle as more than a hobby, then you will need to get a job where you can use it for real.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 30, 2008 at 9:57 am
The Oracle Technology Network is a great networking site for developers and DBA's. It contains tons of information on whatever you want to know about Oracle. Use this link to find out more and to join. http://www.oracle.com/technology/index.html
I also like the following book for DBA's:
Oracle Database 11g DBA Handbook by Bob Bryla and Kevin Loney.
January 30, 2008 at 3:23 pm
hi,
i agree with Ian Yates for using TOAD.its really a good interface between oracle and DB.nice to work.
cheers
sreejith
MCAD
January 31, 2008 at 12:04 am
Thanks a lot guys 😀
January 31, 2008 at 6:46 am
Use the web site http://www.toadsoft.com to download the free version of TOAD. It does not have the full version of TOAD but is good enough to do most of the work, it just does not have debugging and some fancy functions.
If you go to http://WWW.Quest.com, you will never find the free version of TOAD.
February 1, 2008 at 3:44 am
Is there any guide or site Oracle for MS SQL Proffessionals. I would like to jump in quickly in Oracle erea but doin't want to go through easy things for SQL DBA with big experience?
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 1, 2008 at 7:04 am
I haven't seen any web sites dedicated to both SQL Server and Oracle, but here is a good article that compares the two from a DBA Perspective.
http://www.wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compare.pdf
February 1, 2008 at 7:15 am
This doco I know. I'm looking for some resources about Oracle but for DBA profis. It can be even book or magazine. I saw a lot of guides like MS SQL for Oracle DBAs but never opposite 🙁
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 1, 2008 at 8:34 am
Well, maybe I can help you a bit since I was an Oracle DBA (v. 7 and up) prior to becoming an SQL Server DBA (v. 6.5 and up).
I haven't found any books on Oracle for SQL Server dba's but you can look at these articles: http://www.dba-oracle.com/oracle_tips_oracle_v_sql_server.htm and http://www.devx.com/dbzone/Article/20715
Here's a few things:
In Oracle, you have one database for one instance (two or more instance for the same database with clustering). In SQL Server one Instance includes many databases (master, msdb, model, tempdb and user databases).
The Oracle database has many tablespace. These are like filegroup in SQL Server (ex: PRIMARY), but I compare them also as a SQL Server database.
In Oracle you have Temporary tablespace (like a tempdb), System tablespace (like master, msdb, model), User tablespace (like user database). You have rollback segments for the logging of transaction (transaction log file). You must archive the redo logs to do point in time recovery (like Full recovery mode in SQL Server).
For more info on tablespace see: http://www.adp-gmbh.ch/ora/concepts/tablespaces.html
Some more good links: http://www.adp-gmbh.ch/ora/concepts/ and http://www.adp-gmbh.ch/ora/
D. Couturier
Senior DBA
February 1, 2008 at 1:53 pm
BTW, I work with Oracle and SQL Server both together. They are totally different animals. There is no BOL for Oracle so you may need to buy some reference books or find some good Oracle web sites (I haven't found any good one, so if you do, please share :))
The SQL in Oracle and SQL Server is not exactly the same, for example CAST and CONVERT in SQL Server and Oracle uses TO_CHAR and TO_NUM. Some of the data types are different too.
PL/SQL and T-SQL is different. Oracle uses CURSOR a lot. When I moved from Oracle to SQL Server, the SQL Server DBA threw my first stored procedure back to me because I used 'CURSOR'.
In my last job, there were 3 SQL Server DBAs to take care over 100 SQL Server databases, and 3 Oracle DBAs to take care of 1 Oracle database.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply