Configuring Scripts [message #680174] |
Sun, 26 April 2020 05:34 |
|
Premananda
Messages: 2 Registered: April 2020
|
Junior Member |
|
|
Hi,
I am trying to configure the scripts but I got the below error.
"Error starting at line : 7 in command -
GRANT UNLIMITED TABLESPACE TO INVENTORY1
Error report -
ORA-01917: user or role 'INVENTORY1' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause: There is not a user or role by that name.
*Action: Re-specify the name."
Thanks in advance
Prem
|
|
|
|
|
|
|
|
Re: Configuring Scripts [message #680376 is a reply to message #680363] |
Sat, 09 May 2020 12:33 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
Premananda wrote on Sat, 09 May 2020 05:08Hi Michel,
Thank you for your solution. But I am very new to the PL/SQL developer.
Then you also need to clarify your thinking on what is what.
"PL/SQL Developer" is a GUI database client (not the database itself) written by Allround Automations. See here.
"SQL Developer" is a GUI database client (not the database itself) written and freely distributed by Oracle Corp.
"PL/SQL" is the procedural programming language implemented within the Oracle database.
"SQL" is a declarative language for interacting with an rdbms, like oracle.
The problem you are facing has to do with use of the database itself. It doesn't matter what front-end client you might be using - PL/SQL Developer, SQL Developer, Toad, sqlplus, etc. They all are simply taking the SQL statement you provide, and submitting it to the database for processing. You'd get the same result with any client.
|
|
|