failed to create a table in oracle through dss

Highlighted
agondouin
Level 1
failed to create a table in oracle through dss
Jump to solution
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

Accepted Solutions
jrouquie Dataiker
Dataiker
Re: failed to create a table in oracle through dss
Jump to solution
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?

View solution in original post

1 Reply
jrouquie Dataiker
Dataiker
Re: failed to create a table in oracle through dss
Jump to solution
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?

View solution in original post

Labels (3)