In this article, we demonstrate the first method in 11g database, which is a very basic way to create a database, we can learn a lot of knowledge of database structure from this method. On the other side, we want the new database is small and compact enough to avoid affecting the performance of current running database.
There are three major parts to achieve this goal in our demonstration:
- Prepare three files for creating a new database.
- Create and check the new database.
- Configure local naming and password file for outside users.