Creating a tablespace (Place to store tables within the database)
First one must create a place (File Folder) to store the users or company data.
SQL> create tablespace ts_name;
Creating a User
Then create a user and give them access to login (create session) to Oracle and space to store data (unlimited tablespace)
SQL> create user user identified by password default tablespace ts_name;
SQL> grant create session to user;
SQL> grant create table to user;
SQL> grant unlimited tablespace to user;
SQL> exit
Importing the books database
LINUX> cd
LINUX> cd sql_files
LINUX> sqlplus (user = user pass = password)
SQL> @books_oracle.sql
SQL> exit