Hugo Estrada's House of Wonder

Answer:

grant create session to ;

I had to hunt for this one as well. Maybe the word ACCESS is used for something else.

http://thomas.eibner.dk/oracle/old/

Answer:

grant unlimited tablespace to ;

It took me a while to find this. Unfortunately I closed the window too quickly so I cannot give the link to the place where I found this entry.

Hugo

The Answer:

To see current working directory within Sql*Plus command line:
host echo %CD%

To change directories:
host cd c:\go\toyour\directory

Long story:
the command 'host' in sql*plus let's you perform calls to the shell/command line of the operating system that you are using. In this case I am using windows, so instead of using the handy pwd, I had to use the clunky echo %CD%. Style aside, it works.

Thanks, shoover at stackoverflow for the quick answer to this question :)

http://stackoverflow.com/questions/1840816/sql-plus-how-to-change-direct...