To create the Smart Materials specific tablespaces (MARIAN, M_INDEX, M_TEMP) and to change the size of SYSTEM and USERS tablespaces up to 250MB, use this sample script that is provided with the software:
In case of a fresh install, for smooth functioning, it is necessary to change the size of the tablespace MARIAN and M_INDEX as following.
-
Create tablespace MARIAN datafile size 4096M auto extend on next 10240K.
-
Create tablespace M_INDEX datafile size 4096M auto extend on next 10240K.
%SMAT_DB_InstallFolder%\samples\SMat\create_tablespace_sample.sql
Proceed as follows:
-
Open a Command Prompt as administrator.
-
Set oracle_home=C:\oracle\19c_sta\db
-
Navigate to the directory where the modified sample script is stored.
-
sqlplus /nolog
-
To check if the PDB instance is running, execute:
-
conn sys/<sys_password>@<SID of CDB> as sysdba
-
select con_id, name, open_mode from v$pdbs;
The status of PDB instance should be 'Read Write'.
-
If status is not 'Read Write', execute:
alter pluggable database <your pdb instance name> open;
-
Check again:
select con_id, name, open_mode from v$pdbs;
-
-
conn sys/<sys_password>@<CDB instance> as sysdba
for example:
conn sys/manager@CDB as sysdba
-
alter session set container = <PDB instance>;
for example:
alter session set container = smat;
Ensure that you are connected to PDB (SMat) and not to CDB.
-
@create_tablespace_sample.sql
-
Check the logfile create-smat-tablespace.log.