Create a blank database with Oracle DBCA

635 Views Asked by At

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

  • General purpose or transaction processing
  • Custom database
  • Data warehouse

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?

1

There are 1 best solutions below

0
On BEST ANSWER

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.