failed to create a table in oracle through dss
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,
Tagged:
Best Answer
-
Quoted oracle names are case sensitive. Maybe you need to replace "dsa" by "DSA"?
