Create a blank database with Oracle DBCA

Question

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?

I suspect that the "thousands of default tables" are the system tables which Oracle uses to define everything else in the database. Generally these will be in the SYS schema, and should be left very much alone. Best of luck. — Bob Jarvis - Слава Україні, Sep 09 '14 at 02:22

jondinham · Accepted Answer · 2014-09-09T02:48:22.217

1

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.

edited Sep 09 '14 at 02:48

answered Sep 09 '14 at 02:39

jondinham

8,271
17
80
137

Create a blank database with Oracle DBCA

1 Answers1