Community Conundrum 28: News Engagement is live! Read More

failed to create a table in oracle through dss

Level 1
failed to create a table in oracle through dss
Hello,

In order to create a table in oracle, i've created a new dataset.

When I fill the filed Table and Schema, it automatically generate this sql statement:

CREATE TABLE "dsa"."piv_obj" (...)

Wich generate the following error: ORA-01918: user 'dsa' does not exist

Because of the " between the username.

Thks in advance,
0 Kudos
1 Reply
Dataiker Alumni
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?
Labels (3)
A banner prompting to get Dataiku DSS