11 Replies Latest reply: Mar 27, 2014 1:09 AM by hitgon RSS

    express edition

    856913

      In express edition is it possible to create database


        • 1. Re: express edition
          Aman....

          Heard about Google, start using it.

          devtime: Creating an Oracle (XE) database manually on XP

           

          Aman....

          • 2. Re: express edition
            Moazzam

            Yes you can.

             

            Oracle Database Express Edition  Oracle Database Express Edition (Oracle Database XE) is an entry-level edition of Oracle Database that is quick to download, simple to install and manage, and is free to develop, deploy, and distribute. Oracle Database XE makes it easy to upgrade to the other editions of Oracle without costly and complex migrations. Oracle Database XE can be installed on any size machine with any number of CPUs, stores up to 11 GB of user data, using up to 1 GB of memory, and using only one CPU on the host machine. Support is provided by an online forum. The current version of Oracle Database XE is Oracle Database 11g Release 2.

            Oracle Database Editions

            • 3. Re: express edition
              856913

              when i was installing express edition automatically database created in the name XE

               

              is it possible to change the db name while installing the express edition

               

              my devloper asked me to create one more database but didn't allow me to create new one

              • 4. Re: express edition
                Hemant Shahi

                Yes XE is a light version for learning purpose.

                you can do thinkgs like - creating DB,testing backup/recovery scenarios, user administration etc.

                what u can't do is - Partitioned tables, Flashback , clustering and other advanced features.

                 

                the max size of the DB you can create is 14 GB, but for learning purpose that should be fine.

                • 5. Re: express edition
                  Aman....

                  856913 wrote:

                   

                  when i was installing express edition automatically database created in the name XE

                   

                  is it possible to change the db name while installing the express edition

                   

                  my devloper asked me to create one more database but didn't allow me to create new one

                  Let me google that for you

                   

                  Aman....

                  • 6. Re: express edition
                    Aman....

                    Hemant Shahi wrote:

                     

                    Yes XE is a light version for learning purpose.

                    you can do thinkgs like - creating DB,testing backup/recovery scenarios, user administration etc.

                    what u can't do is - Partitioned tables, Flashback , clustering and other advanced features.

                     

                    the max size of the DB you can create is 14 GB, but for learning purpose that should be fine.

                    It is 11gb not 14gb.

                    Oracle Database Express Edition 11g Release 2</title><meta name="Title" content="Oracle Database…

                     

                    Aman....

                    • 7. Re: express edition
                      856913

                      thanks for the kind response

                       

                      can we create more than one schema in the express edition

                      • 8. Re: express edition
                        Aman....

                        856913 wrote:

                         

                        thanks for the kind response

                         

                        can we create more than one schema in the express edition

                        Yes. Did you try to do so?

                         

                        Aman....

                        • 9. Re: express edition
                          onkar.nath

                          here is the list of features available in express edition:

                           

                          Oracle Database Editions

                           

                          Onkar

                          • 10. Re: express edition
                            Hemant Shahi

                            Hello Aman,

                             

                            sorry for the typo, Yes it is 11 GB.

                             

                            Hi 856913,

                             

                            Below are the steps to rename the DB in windows:

                             

                            C:\Users\Hemant_Shahi>set ORACLE_SID=BCTDB

                            SQL> select name from v$database;

                            NAME
                            ---------
                            BCTDB

                            SQL> shu immediate;
                            Database closed.
                            Database dismounted.
                            ORACLE instance shut down.

                            SQL> startup mount;
                            ORACLE instance started.

                            Total System Global Area  146472960 bytes
                            Fixed Size                  1382120 bytes
                            Variable Size              92277016 bytes
                            Database Buffers           50331648 bytes
                            Redo Buffers                2482176 bytes
                            Database mounted.

                            C:\Users\Hemant_Shahi>nid target=sys/cracker@BCTDB dbname=changedb

                            DBNEWID: Release 11.2.0.2.0 - Production on Mon Mar 24 12:48:02 2014

                            Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

                            Connected to database BCTDB (DBID=2380349579)

                            Connected to server version 11.2.0

                            Control Files in database:
                                D:\JAVADOC\CONTROL01.CTL

                            Change database ID and database name BCTDB to CHANGEDB? (Y/[N]) => y

                            Proceeding with operation
                            Changing database ID from 2380349579 to 1333698825
                            Changing database name from BCTDB to CHANGEDB
                                Control File D:\JAVADOC\CONTROL01.CTL - modified
                                Datafile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DBS1BCTDB.OR - dbid changed, wrote new name
                                Datafile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SYX1BCTDB.OR - dbid changed, wrote new name
                                Datafile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\UND1BCTDB.OR - dbid changed, wrote new name
                                Datafile D:\USERS01.DB - dbid changed, wrote new name
                                Datafile D:\BCTDB\DATAFILE\O1_MF_TEST_TBS_9LO7ZDQG_.DB - dbid changed, wrote new name
                                Datafile D:\BCTDB\DATAFILE\O1_MF_TEST_TBS_9LO7Z9N8_.DB - dbid changed, wrote new name
                                Control File D:\JAVADOC\CONTROL01.CTL - dbid changed, wrote new name
                                Instance shut down

                            Database name changed to CHANGEDB.
                            Modify parameter file and generate a new password file before restarting.
                            Database ID for database CHANGEDB changed to 1333698825.
                            All previous backups and archived redo logs for this database are unusable.
                            Database has been shutdown, open database with RESETLOGS option.
                            Succesfully changed database name and ID.
                            DBNEWID - Completed succesfully.

                            SQL> startup nomount;
                            ORACLE instance started.

                            Total System Global Area  146472960 bytes
                            Fixed Size                  1382120 bytes
                            Variable Size              92277016 bytes
                            Database Buffers           50331648 bytes
                            Redo Buffers                2482176 bytes


                            SQL> alter system set DB_NAME='CHANGEDB' scope=spfile;

                            System altered.

                            SQL> shu immediate;
                            ORA-01507: database not mounted


                            ORACLE instance shut down.

                            oradim -delete -sid BCTDB
                            oradim -new -sid CHANGEDB -startmode a -pfile C:\oraclexe\app\oracle\product\11.2.0\server\dbs\spfileCHANGEDB.ora

                            SQL> startup mount pfile='C:\oraclexe\app\oracle\product\11.2.0\server\dbs\spfileCHANGEDB.ora'
                            ORACLE instance started.

                            Total System Global Area  146472960 bytes
                            Fixed Size                  1382120 bytes
                            Variable Size              92277016 bytes
                            Database Buffers           50331648 bytes
                            Redo Buffers                2482176 bytes
                            Database mounted.
                            SQL> alter database open resetlogs;

                            Database altered.

                            SQL> select name from v$database;

                            NAME
                            ---------
                            CHANGEDB

                            • 11. Re: express edition
                              hitgon

                              by default oracle automatically creates XE Database along with installation. FYI,Oracle Express Edition not allow to create you more than 1 databases.