Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
failed to create a table in oracle through dss
Added on December 2, 2015 7:01PM
Likes: 0
Replies: 1
agondouin
Registered Posts: 3 ✭✭✭✭
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,
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,
Best Answer
-
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?
