Hello everyone, im using oracle 21c XE
I have a user called Winesales currently with five tables and one constraint as shown below.
that's all the objects I have with this user/schema.
I am trying to create another table also called Winesales, same name of the user. According to Oracle, user and table are in two separate namespace, so having the same name should not be a problem.
So I am trying to important data from excel, in step 2 of the Data Import Wizard where I can give the table a name, I put Winesales and when I try to click next, it gives this error.
So I then try to create a table with same name using CREATE TABLE and it worked fine.
After creating the table columns and data types using CREATE TABLE, I was able to import the dataset from excel using Data Import Wizard with the Table Name field in step 2 greyed out.
Do you know why Data import wizard won't allow me to create table in the first place by giving me object already exist error when CREATE TABLE DDL statement is able to do so?