3 Replies Latest reply: Jan 26, 2013 7:02 PM by Srini Chavali-Oracle RSS

    Introductory Basic Admin of 11g XE ?

    davejjj
      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
          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
            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
              11g XE documentation is here - http://docs.oracle.com/cd/E17781_01/index.htm

              Start with the "2 Day DBA" guide.

              HTH
              Srini