oracleoracle10goracle-sqldeveloper
Create Empty database using Oracle Database configuration Assistant
I am using Oracle's Database Configuration Assistant tool to create a new database but once the database is created, I open it in Oracle SQL Developer, I see a lot of tables already created. Why is that? How can I create an empty database?
P.S: This is how my database tables look like after creating it
Solution
I think there is some confusion between schema and databases.
You can never create an empty database in Oracle, since when you create a database in Oracle with DBCA tool, it creates some pre-seeded sample schemas and some System schemas with system tables.
You can create an empty schema using the CREATE SCHEMA command, after the database is installed.
- Filtering Croatian Plate Numbers on Oracle SQL
- Oracle own aggregation function in package
- How to fetch records having difference of 5 minutes or less | Oracle
- How to SQL Filter for Timestamp Differences in Toad for Oracle?
- Oracle Connection in C# - connection string
- how to use index when searched column is not indexed but has the same ordering as the indexed primary key
- Oracle SQL Grouping same value records in particular order
- ORACLE - String to number
- Insert multiple rows in ORACLE by referring 2 tables
- Haw can I make a sub procedure inside a parent function in a Package in PL/SQL?
- Is there any performance difference between IN and NOT IN Operators?
- In Oracle, does a DDL script need commit statements when run with sqlplus?
- Oracle Scheduler Job Failing
- Event read by other session causing blocks
- Create date periods based on two tables
- Oracle SQL query using regexp_substr to get string between 2 strings
- Missing expression in Oracle Function
- Examine all REF CURSOR outputs from stored procedure called in a loop
- PLS-00382: "expression is of wrong type" when opening REF CURSOR on stored procedure called in a loop
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PowerShell Script Failing at insert records
- How to resolve the following AWS Glue error while writing to Redshift using Spark: "ORA-01722: invalid number"?
- How to create an oracle.sql.ARRAY object?
- Select rows with same item code but different value in another column
- SQL select distinct with condition
- How to pretty format the printing of SQL queries in SQLAlchemy
- JetBrains PhpStorm / DataGrip introspecting Oracle database error
- Is there any way to maintain large scale data rules efficiently in SQL?
- How to check if input parameter of timestamp type in oracle stored procedure is null?
- How can I number the instance of a duplicate record?