|
One can create a database using various methods out of which 4 are listed as below:- Manually using SQL commands It is recommended that if one is working on a previous release like Oracle 8i then one should use this method as then the DBCA was not as effective. However if the version Oracle 9i or above then the DBCA can be used as the tools have become more effective and robust from then and will help achieve a better performance. In the older period one had to run only the sql command with only 2 scripts. Using a DBCA(Database Configuration Assistant) This is the most recommended and the most easier way to create a database for the beginners. If one is using this method to create a database then one need not create a PFILE for that .Everything is done by default and is solely owned by the DBCA. A combination of SQL commands and DBCA This one is most recommended for the old timers possibly who feel its easier to execute few SQL commands to create a database. Therefore one can use both SQL or SQL and DBCA combination to create a database. Creating the database using the SQL commands leaves a better control over the creation aspects and all the other prospects of monitoring. It can also leave many loopholes and area of omitting mistakes and corrections. Cloning an existing database This is also a very important method of providing a replica of an already existing database. This involves less effort and time and is generally very easy and an already setup database is replicated. It also omits the major chances of any correction or mistakes and prevents human error . |