3 Replies Latest reply: Dec 4, 2013 6:44 AM by EdStevens RSS

    how to create a database in sql?

    entrant

      My question is how to create a database in sql?

        • 1. Re: how to create a database in sql?
          Paul M.
          how to create a database in sql?

          CREATE DATABASE

           

          Better using Database Configuration Assistant from Oracle menu (dbca command on Linux/Unix).

          • 2. Re: how to create a database in sql?
            sybrand_b

            Beginners

             

            - specify their four digit database version and their platform

            - read the online documentation, available at http://docs.oracle.com

            - or Google for the subject

             

            But they do NOT ask this kind of questions, indicating they refuse to do any effort on their own, and want to be spoon fed, in a forum of volunteers.

             

            ----------

            Sybrand Bakker

            Senior Oracle DBA

            • 3. Re: how to create a database in sql?
              EdStevens

              entrant wrote:

               

              My question is how to create a database in sql?

              as Iam a beginner

              =================================================

              Learning how to look things up in the documentation is time well spent investing in your career.  To that end, you should drop everything else you are doing and do the following:

               

              Go to  docs.oracle.com.

               

              Locate the link for your Oracle product and version, and click on it.

               

              You are now at the entire documentation set for your selected Oracle product and version.

               

              BOOKMARK THAT LOCATION

               

              Spend a few minutes just getting familiar with what is available here. Take special note of the "books" and "search" tabs. Under the "books" tab (for 10.x) or the "Master Book List" link (for 11.x) you will find the complete documentation library.

               

              Spend a few minutes just getting familiar with what kind of documentation is available there by simply browsing the titles under the "Books" tab.

               

              Open the Reference Manual and spend a few minutes looking through the table of contents to get familiar with what kind of information is available there.

               

              Do the same with the SQL Reference Manual.

               

              Do the same with the Utilities manual.

               

              You don't have to read the above in depth.  They are reference manuals.  Just get familiar with what is there to be referenced. Ninety percent of the questions asked on this forum can be answered in less than 5 minutes by simply searching one of the above manuals.

               

              Then set yourself a plan to dig deeper.

              - *Read a chapter a day from the Concepts Manual*.

              - Take a look in your alert log.  One of the first things listed at startup is the initialization parms with non-default values. Read up on each one of them (listed in your alert log) in the Reference Manual.

              - Take a look at your listener.ora, tnsnames.ora, and sqlnet.ora files. Go to the Network Administrators manual and read up on everything you see in those files.

              - *When you have finished reading the Concepts Manual, do it again*.

               

              Give a man a fish and he eats for a day. Teach a man to fish and he eats for a lifetime.

               

              =================================