Oracle starter

Posted on 2011-10-27
Last Modified: 2012-05-12
I am SQL DBA and have to start maintaining Oracle databases.  I need to install development oracle 10g(I am not sure if that is free like in SQl) ..create an Oracle database in  my development environment and start playing around with it to get familiar with Oracle.   Can an Oracle guru  get me started with some how to instructions?......did research online..too much info..need to get straight to the point.  Any inputs appreciated.
Question by:Nana Hemaa
    LVL 73

    Accepted Solution

    you can download multiple versions for free from OTN for development and study

    you can download them here

    11g will be at the top, scroll down to get to 10g
    LVL 73

    Expert Comment

    also note  Oracle XE (express edition) is totally free (even for production use)

    it has limitations, but is still pretty good to learn with

    again 11g is at the top,  10g is lower.

    Unless you "must" use 10g,  I recommend starting with the most recent 11g  11gR2
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>SQL DBA

    Can I assume SQL Server?

    I would suggest a crossover guide that can bridge the gaps between the two systems.

    There are a few out there:

    Author Comment

    by:Nana Hemaa
    After the installation ..where do I go to create test databases etc  and manage them.. can someone share more light?
    LVL 73

    Expert Comment

    you'll create them on some server,  your own pc if you want.

    if you don't have much space/memory/cpu  then use XE, it's lighter weight
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    A 'database' in Oracle doesn't mean the same thing as a database in SQL Server.

    This is why a good crossover book will help.  It will cover the terminology differences.

    The install will ask you if you want to create a database.

    You can create them after with the Configuration Assistants.

    A database in Oracle has schemas which are basically users that own objects like tables.

    There are 'sample' schemas that can be installed when you build the database.  Most documentation examples are based on these sample schemas.

    LVL 23

    Assisted Solution

    - the earlier experts have provide sufficient detail on downloading and install the Oracle database. going forward, you can either use command prompt - 'sqlplus' tool that comes with the database to do DML operations such as insert update delete tables, index, query, create tables and etc or use the following free SQL Developer GUI-based to do the same:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now