Home » SQL & PL/SQL » SQL & PL/SQL » Configuring Scripts (Windows 7)
Configuring Scripts [message #680174] Sun, 26 April 2020 05:34 Go to next message
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 #680175 is a reply to message #680174] Sun, 26 April 2020 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is not clear with the error message?

Re: Configuring Scripts [message #680176 is a reply to message #680175] Sun, 26 April 2020 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... but what is sure is that you should NEVER grant UNLIMITED TABLESPACE to any one.

Re: Configuring Scripts [message #680363 is a reply to message #680176] Sat, 09 May 2020 05:08 Go to previous messageGo to next message
Premananda
Messages: 2
Registered: April 2020
Junior Member
Hi Michel,

Thank you for your solution. But I am very new to the PL/SQL developer.

Please help me how to write that script without granting UNLIMITED TABLESPACE.

Thanks in advance

Premananda
Re: Configuring Scripts [message #680366 is a reply to message #680363] Sat, 09 May 2020 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You just have to grant the quota to the user tablespace(s):
ALTER USER ... QUOTA <xxxxx|unlimited> ON <tablespace>

Re: Configuring Scripts [message #680371 is a reply to message #680174] Sat, 09 May 2020 09:05 Go to previous messageGo to next message
EdStevens
Messages: 1248
Registered: September 2013
Senior Member
You just got lucky that the error is blindingly obvious. In the future, ask yourself, "Can I debug code that I cannot see? Should I expect others to debug my code that they cannot see?"
Re: Configuring Scripts [message #680376 is a reply to message #680363] Sat, 09 May 2020 12:33 Go to previous message
EdStevens
Messages: 1248
Registered: September 2013
Senior Member
Premananda wrote on Sat, 09 May 2020 05:08
Hi 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.
Previous Topic: Looping Chain of Synonyms
Next Topic: Date Column
Goto Forum:
  


Current Time: Sun Sep 20 19:02:04 CDT 2020