Oracle Running Sql Scripts

We are going to run the "Oracle Database XE Tutorial" sample_load.sql file.
With a granted user (I am going to user system) you have to open a sqlplus session:
If you also want error tracking, you might choose output spooling, so:

SQL> spool on;

An on.lst file is just created at the $HOME containing all the session activity.
Now you can launch from this session the .sql script doing:
SQL> @load_sample.sql
CREATE TABLE regions
.<rest of procedure>...
SQL>

Now you can check the file content in order to debug the sql procedure:

ocm@achtung:~$ less on.lst
SQL> @load_sample.txt
CREATE TABLE regions
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

So we log with a SYS user and:
SQL> GRANT CREATE SEQUENCE TO FACTURATOR;
Grant succeeded.
SQL>SQL> GRANT CREATE PROCEDURE TO FACTURATOR;

We launch again: