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 sql_files

LINUX> sqlplus (user = user pass = password)

SQL> @books_oracle.sql

SQL> exit