Dataprix

In order to be able to make all the steps you must initiate the session in the database with a user with administration permissions, you can use the SYSTEM user, for example

• Creation of tablespace for data, and another one for index.

These tablespaces are the location where Oracle will save the objects of the scheme which we are going to create.

Tablespace for data, with initial size of 1024 Mb, and autoextensive

CREATE TABLESPACE "APPDAT" LOGGING DATAFILE '/export/home/oracle/oradata/datafiles/APPDAT.dbf' SIZE 1024M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

• Tablespace for indices, with initial size of 512 Mb, and autoextensive

CREATE TABLESPACE "APPIDX" LOGGING DATAFILE '/export/home/oracle/oradata/datafiles/APPIDX.dbf' SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

• Creation of the user who is going to work on these tablespaces, and who will be the owner of the objects that are created in them

CREATE USER “APP” PROFILE “DEFAULT” IDENTIFIED BY “APPPWD”

DEFAULT TABLESPACE “APPDAT” TEMPORARY TABLESPACE “TEMP” ACCOUNT UNLOCK;