Spooling and running simple scripts

I used to use sqlplus from a commandline to run simple scripts:

>sqlplus myuser@DBName

pwd:

Then I would just run a simple script, for instance create user script:

create user1

identified by pwd1

deafule tablespace users

temporary tablespace temp;

grant connect to user1;

grant role1 to user1;

Then I learned about spooling and since it is a bad practice to run scripts without spooling, I wanted to utilize this technique.

I am storing my spool files and my script file in /tmp directory

so I'd put

create user1

identified by pwd1

deafule tablespace users

temporary tablespace temp;

 

grant connect to user1;