Help Shape the Future of Dataiku Join our User Research Program

failed to create a table in oracle through dss

Solved!
agondouin
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 Solution
jrouquie
Dataiker Alumni
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?

View solution in original post

1 Reply
jrouquie
Dataiker Alumni
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?

View solution in original post

Labels (3)
A banner prompting to get Dataiku DSS