This discussion is archived
3 Replies Latest reply: Jan 26, 2013 5:02 PM by Srini Chavali-Oracle RSS

Introductory Basic Admin of 11g XE ?

davejjj Newbie
Currently Being Moderated
Hi,

I am just getting started with Oracle XE and I am having trouble with the confusing collection of pdf documents that are available. What document(s) will show me the basic admin commands for SQL*Plus and SQL*Developer so that I can manage users and databases ? I am coming from Microsoft SQL Server so I don't understand the idea of apparently not having databases as the top level of the hierarchy. When I log in to Oracle XE I have a folder of tables at the top level.

I would like to be able to create and delete users and databases (schemas?) and understand the default users.

I would also like to understand the basic collection of tools. I keep seeing references to "Application Express" but I don't even know what that is, or what it is for.

Thanks,

Dave
  • 1. Re: Introductory Basic Admin of 11g XE ?
    sb92075 Guru
    Currently Being Moderated
    984330 wrote:
    Hi,

    I am just getting started with Oracle XE and I am having trouble with the confusing collection of pdf documents that are available. What document(s) will show me the basic admin commands for SQL*Plus and SQL*Developer so that I can manage users and databases ? I am coming from Microsoft SQL Server so I don't understand the idea of apparently not having databases as the top level of the hierarchy. When I log in to Oracle XE I have a folder of tables at the top level.

    I would like to be able to create and delete users and databases (schemas?) and understand the default users.

    I would also like to understand the basic collection of tools. I keep seeing references to "Application Express" but I don't even know what that is, or what it is for.

    Thanks,

    Dave
    http://docs.oracle.com

    http://docs.oracle.com/cd/B28359_01/server.111/b28318/toc.htm
  • 2. Re: Introductory Basic Admin of 11g XE ?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Refer to
    http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25610/toc.htm --posted by sb
    Or
    http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/getstart.htm
  • 3. Re: Introductory Basic Admin of 11g XE ?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    11g XE documentation is here - http://docs.oracle.com/cd/E17781_01/index.htm

    Start with the "2 Day DBA" guide.

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points