databaseoracle-databasedbca

Create a blank database with Oracle DBCA


I use Oracle Database Configuration Assistant to create database. There are 3 default templates:

However, choosing any of these 3 template would lead to creation of a database with thousands of default tables (of which I don't understand what they are).

Any method to create a blank database (no tables, no data) with this Oracle Database Configuration Assistant?


Solution

  • As Bob Jarvis noted in the comment area below the question. Those thousands of default tables appear because SYSTEM username is used when accessing the database.

    It's impossible to create a totally-blank database (when being viewed as SYSTEM). Connect as SYSDBA and these default tables won't appear.